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)

Last updated on FEBRUARY 19, 2014

Applies to:

Enterprise Manager for Oracle Database - Version 11.2.0.4 and later
Information in this document applies to any platform.

Symptoms

Enterprise manager RAC Database Control 11.2.0.4
Configuring Database Control fails using this command:

emca -config dbcontrol db -repos create -cluster


The following error stack is observed in the emca_repos_config_<date>.log:

INFO: jdbcUrl = jdbc:oracle:oci:@<host>:<port>/<service_name>
30.01.2014 11:33:57 oracle.sysman.emdrep.util.TransxWrapper perform
SCHWERWIEGEND: Error Loading TransX:I/O-Fehler: Invalid connection string format, a valid format is: "host:port:sid"
30.01.2014 11:33:57 oracle.sysman.emdrep.config.EMSchemaConfiguration$ConfigInstance run
SCHWERWIEGEND: null
java.lang.reflect.InvocationTargetException
at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39)
at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
at java.lang.reflect.Method.invoke(Method.java:592)
at oracle.sysman.emdrep.config.EMSchemaConfiguration$ConfigInstance.run(EMSchemaConfiguration.java:480)
at java.lang.Thread.run(Thread.java:637)
Caused by: 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"
at oracle.jdbc.driver.T4CConnection.logon(T4CConnection.java:489)
at oracle.jdbc.driver.PhysicalConnection.<init>(PhysicalConnection.java:553)
at oracle.jdbc.driver.T4CConnection.<init>(T4CConnection.java:254)
at oracle.jdbc.driver.T4CDriverExtension.getConnection(T4CDriverExtension.java:32)
at oracle.jdbc.driver.OracleDriver.connect(OracleDriver.java:528)
at java.sql.DriverManager.getConnection(DriverManager.java:525)
at java.sql.DriverManager.getConnection(DriverManager.java:171)
at oracle.xml.transx.ConnectionHelper.getConnection(ConnectionHelper.java:59)
at oracle.xml.transx.TransXImpl.open(TransXImpl.java:79)
at oracle.sysman.emdrep.util.TransxWrapper.perform(TransxWrapper.java:67)
at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39)
at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
at java.lang.reflect.Method.invoke(Method.java:592)
at oracle.sysman.emdrep.config.EMSchemaConfiguration$ConfigInstance.run(EMSchemaConfiguration.java:480)
at java.lang.Thread.run(Thread.java:637)
Caused by: oracle.net.ns.NetException: Invalid connection string format, a valid format is: "host:port:sid"
at oracle.net.resolver.AddrResolution.resolveSimple(AddrResolution.java:498)
at oracle.net.resolver.AddrResolution.resolveAndExecute(AddrResolution.java:437)dAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)

 

Cause

Sign In with your My Oracle Support account

Don't have a My Oracle Support account? Click to get started

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms