Friday, March 7, 2014

EM database Control Using EMCA fails when Service Name contains Hyphen.

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)