Error creating DB Control on a cluster with emkey configuration failure

(Doc ID 1581323.1)

Last updated on DECEMBER 14, 2017

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 /usr/local/app/oracle/product/db/11.2.0.1.0/bin/emctl config emkey -repos -host orcl1 -sid orcl
Aug 8, 2013 2:42:05 PM oracle.sysman.emcp.util.DBControlUtil secureDBConsole
WARNING: Configuring EM-Key failed for node orcl1.
Aug 8, 2013 2:42:58 PM oracle.sysman.emcp.util.PlatformInterface executeCommand
WARNING: Error executing /usr/local/app/oracle/product/db/11.2.0.1.0/bin/emctl config emkey -repos -host orcl2 -sid orcl
Aug 8, 2013 2:42:58 PM oracle.sysman.emcp.util.DBControlUtil secureDBConsole
WARNING: Configuring EM-Key failed for node orcl2.
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 orcl1 orcl2 . Please execute the following command(s) on nodes: orcl1 orcl2 .

1) Set the environment variable ORACLE_UNQNAME to Database unique name
2) /usr/local/app/oracle/product/db/11.2.0.1.0/bin/emctl config emkey -repos -sysman_pwd < Password for SYSMAN user > -host <node> -sid < Database unique name >
3) /usr/local/app/oracle/product/db/11.2.0.1.0/bin/emctl secure dbconsole -sysman_pwd < Password for SYSMAN user > -host <node> -sid < Database unique name >
4) /usr/local/app/oracle/product/db/11.2.0.1.0/bin/emctl start dbconsole

To secure Em Key, run /usr/local/app/oracle/product/db/11.2.0.1.0/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://orcl1.domain:1158/em <<<<<<<<<<<
Aug 8, 2013 2:43:05 PM oracle.sysman.emcp.EMDBPostConfig showClusterDBCAgentMessage
INFO:
**************** Current Configuration ****************
INSTANCE NODE DBCONTROL_UPLOAD_HOST
---------- ---------- ---------------------

orcl orcl1 orcl1.domain
orcl orcl2 orcl1.domain

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

$emctl config emkey -repos -sysman_pwd <password> -host orcl1 -sid orcl
EM Configuration issue. /usr/local/app/oracle/product/db/11.2.0.1.0/orcl1.domain_orcl not found.

Similar error occurs on the other node as well.
The <HOSTNAME_SID> directory has actually got created with the short hostname - /usr/local/app/oracle/product/db/11.2.0.1.0/orcl1_orcl

 

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

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