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)

Popular posts from this blog

OracleRemExecService available Windows only

-
OracleRemExecService is a service which is only used temporarily by the OUI It gets removed when OUI is finished with it, therefore, it will have a value of 'DISABLED' until a reboot - then it will simply be gone, ignore and leave this service untouched. The Oracle Windows service "OracleRemExecService" to execute various commands from Oracle applications like DBCA and GUI. The service itself relies on a named pipe to receive the commands.
Read more

Dynamic listener registration (instance registration) - Connections via the Listener to the Database [TNS-12526 - TNS-12527 - TNS-12528 ]

-
If you are using dynamic listener registration (instance registration). The instance does not register with the listener until you mount the controlfile.  Without sysdba, Net service name using SID or Net service name using SERVICE_NAME with UR=A . RMAN requires a static listener entry and the tnsnames.ora should not contain FAIL_OVER=ON or LOAD_BALANCING. Just a plain vanilla dedicated server connection. RMAN-00554: initialization of internal recovery manager package failed RMAN-04005: error from target database: ORA-12528: TNS:listener: all appropriate instances are blocking new connections
Read more

Implementation of a GoldenGate Replicate Hub: GoldenGate Remote Capture and Deliver Goldengate processes

-
Image
Oracle GoldenGate can run on a machine separate from the source and/or target database server. The setup is called GoldenGate remote capturing and delivery . A creation of a GoldenGate Replicate Hub . On Oracle Databases the remote capture can be a remote integrated capture or downstream capture. For remote delivery can be an integrated delivery, a coordinated delivery or classic delivery. Architect overview GoldenGate Replicatie Hub - Remote Capture and Delivery
Read more