My Oracle Support Banner

Installing OCM Into an EBS Home Fails at "Installccrsql.sh ebs_collectconfig" (Doc ID 1159673.1)

Last updated on OCTOBER 31, 2019

Applies to:

Oracle Configuration Manager - Version 10.3.0 to 10.3.3.1.0
Information in this document applies to any platform.

Symptoms

After the installation of OCM and run of the setupCCR configuration script, while trying to run the ebs_collectconfig script the following error may trigger : 

./installCCRSQL.sh ebs_collectconfig -u APPS -w MYPASSWORD
An error had occured.
For details, check the log file at
/u01/app/oracle/product/11.1.0/ccr/hosts/myhost.oracle.com/log/ebs_collectconfigMYSID.log

ebs_collectconfigMYSID.log =>>
SQL> execute MGMT_EBS_CONFIG.run_now;
BEGIN MGMT_EBS_CONFIG.run_now; END;
*
ERROR at line 1:
ORA-12011: execution of 1 jobs failed
ORA-06512: at "SYS.DBMS_IJOB", line 542
ORA-06512: at "SYS.DBMS_JOB", line 278
ORA-06512: at "APPS.MGMT_EBS_CONFIG", line 97
ORA-06512: at line 1

 

There may also be similar errors in the Database Alert.log.  For example :

Errors in file
/u01/app/oracle/product/11.1.0/ccr/hosts/myhost.oracle.com/trace/MYSID_ora_10919.trc:
ORA-12012: error on auto execute of job 97
ORA-20000: SQLERRM: ORA-01422: exact fetch returns more than requested
number of rows SQLCODE: -1422
ORA-06512: at "APPS.MGMT_EBS_LL_METRICS", line 1747
ORA-06512: at line 1
Tue Mar 30 09:51:06 2010
Beginning log switch checkpoint up to RBA [0x9b3.2.10], SCN: 3701447181168
Thread 1 advanced to log sequence 2483 (LGWR switch)
Current log# 3 seq# 2483 mem# 0: /x01/oradata/MYSID/redo03.log

Changes

New Installation of OCM and trying to run the ebs_collectconfig collection script.

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

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