My Oracle Support Banner

Error creating DB Control on a cluster with emkey configuration failure (Doc ID 1581323.1)

Last updated on MARCH 05, 2019

Applies to:

Enterprise Manager for Oracle Database - Version 11.2.0.1 to 11.2.0.4 [Release 11.2]
Information in this document applies to any platform.

Symptoms

Attempting to configure dbconsole for a RAC setup.
After providing all the necessary details correctly, emca fails with the below errors

INFO: Securing Database Control (this may take a while) ...
Aug 8, 2013 2:42:05 PM oracle.sysman.emcp.util.PlatformInterface executeCommand
WARNING: Error executing <DB Home>/bin/emctl config emkey -repos -host <NODENAME1> -sid <SID1>
Aug 8, 2013 2:42:05 PM oracle.sysman.emcp.util.DBControlUtil secureDBConsole
WARNING: Configuring EM-Key failed for node <NODENAME1>.
Aug 8, 2013 2:42:58 PM oracle.sysman.emcp.util.PlatformInterface executeCommand
WARNING: Error executing <DB Home>/bin/emctl config emkey -repos -host <NODENAME2> -sid <SID2>
Aug 8, 2013 2:42:58 PM oracle.sysman.emcp.util.DBControlUtil secureDBConsole
WARNING: Configuring EM-Key failed for node <NODENAME2>.
Aug 8, 2013 2:42:58 PM oracle.sysman.emcp.EMDBPostConfig setRACWarnMsg
INFO: Error securing Database Control, Database Control has not been brought up on nodes <NODENAME1>, <NODENAME2> . Please execute the following command(s) on nodes: orcl1 orcl2 .

1) Set the environment variable ORACLE_UNQNAME to Database unique name
2) <DB HOME>/bin/emctl config emkey -repos -sysman_pwd < Password for SYSMAN user > -host <node> -sid < Database unique name >
3) <DB HOME>/bin/emctl secure dbconsole -sysman_pwd < Password for SYSMAN user > -host <node> -sid < Database unique name >
4) <DB HOME>/bin/emctl start dbconsole

To secure Em Key, run <DB HOME>/bin/emctl config emkey -remove_from_repos -sysman_pwd < Password for SYSMAN user >
Aug 8, 2013 2:42:58 PM oracle.sysman.emcp.EMDBPostConfig performConfiguration
INFO: >>>>>>>>>>> The Database Control URL is http://<NODENAME1>:1158/em <<<<<<<<<<<
Aug 8, 2013 2:43:05 PM oracle.sysman.emcp.EMDBPostConfig showClusterDBCAgentMessage
INFO:
**************** Current Configuration ****************
INSTANCE NODE DBCONTROL_UPLOAD_HOST
---------- ---------- ---------------------

<DB name> <nodename1> <nodename1.domain>
<DB name> <nodename2> <nodename2.domain>

-  Attempting to execute the "emctl config emkey.." command also fails:

$emctl config emkey -repos -sysman_pwd <password> -host <nodename1> -sid <SID>
EM Configuration issue. <DB HOME>/<nodename1.domain>_<SID> not found.

Similar error occurs on the other node as well.
The <HOSTNAME_SID> directory has actually got created with the short hostname - <DB HOME>/<nodename1>_<SID>

 

Changes

The GRID Infrastructure for RAC was upgraded from 11.2.0.1 to 11.2.0.3 / 12c.  This upgrade is out of place, so it is upgraded into a new home.

Cause

To view full details, sign in with your My Oracle Support account.

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


In this Document
Symptoms
Changes
Cause
Solution
References


My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.