When using "emca -config dbcontrol db -repos create -cluster" on a RAC Database the installation of EM database Control fails.
Investigation of the logs will see an error in the emca_repos_config_
.log
INFO: jdbcUrl = jdbc:oracle:oci:@:/
...
oracle.sysman.emdrep.config.ConfigurationException: Loading DLF Exception
I/O-Fehler: Invalid connection string format, a valid format is: "host:port:sid"
java.sql.SQLException: I/O-Fehler: Invalid connection string format, a valid format is: "host:port:sid"
...
oracle.net.resolver.AddrResolution.resolveAndExecute(AddrResolution.java:437)dAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
It seems a bug and is registerd by oracle "Bug 18160537 - 11.2.0.4 DBCONSOLE - CONFIG REPOSITORY FAILS WHEN SERVICE NAME CONTAINS HYPHEN "
Solution
Login to DB as user SYS
show parameter service;
alter system set service_names='old_services,new_service_without_hyphen';
Reconfigure dbconsole using this command:
$ORACLE_HOME/bin/emca -config dbcontrol db -repos recreate -cluster
Documentation
EM Database Control 11.2.0.4: Using EMCA to Configure the Database Control Web Site Fails when the Service Name Contains a Hyphen Character (Doc ID 1625782.1)
No comments:
Post a Comment