Repository Creation failed. Repos User already exists.. Installation hangs at OMS configuration while installing Oracle Grid Control 10.2.0.3

Visit the Below Website to access unlimited exam questions for all IT vendors and Get Oracle Certifications for FREE
http://www.free-online-exams.com

Problem:    Repository Creation failed. Repos User already exists.. Installation hangs at OMS configuration while installing Oracle Grid Control 10.2.0.3

Symptoms:

Installation hangs at OMS configuration while installing Oracle Grid Control 10.2.0.3

"Failed. Repository Creation failed. Failed to create repository schema...."

Log files:

Installation has failed at repository configuration stage with the following error.

*************
INFO: oracle.sysman.top.oms:Failed to connect to Database for s_reposUser=sysman, s_reposPwd=******, connectString=pcrudb01.dubaiworld.ae:1899:gridem. ConnectException=ORA-01017: invalid username/password; logon denied
Repository Creation failed. Repos User already exists..

INFO: oracle.sysman.top.oms:Internal PlugIn for {Micro Step state:step:2:configuration in CfmAggregateInstance: oracle.sysman.top.oms:10.2.0.3.0:common:family=CFM:oh=/u01/app/oms_home/oms10g:label=1} failed with an unhandled exception:
java.lang.Exception: RepManager Create Repository Error = 11. Please check the log file at /u01/app/oms_home/oms10g/sysman/log/emca_repos_create13_01_53.log
at oracle.sysman.emcp.util.EmcpPlug.startProcessing(EmcpPlug.java:389)

From installActions2010-03-22_12-33-58-PM.log
---------------------------------------------
Command = oracle.sysman.emcp.oms.OmsPlugIn has failed 
Exception : java.lang.Exception: RepManager Create Repository Error = 14. Please check the log file at /u01/app/oms_home/oms10g/sysman/log/emca_repos_create12_59_04.log

INFO: Configuration assistant "OMS Configuration" failed 

Command = oracle.sysman.emcp.oms.OmsPlugIn has failed 
Exception : java.lang.Exception: RepManager Create Repository Error = 11. Please check the log file at /u01/app/oms_home/oms10g/sysman/log/emca_repos_create13_01_53.log

INFO: Configuration assistant "OMS Configuration" failed 




From CfmLogger_2010-03-22_12-41-45-PM.log
---------------------------------
INFO: oracle.sysman.top.oms:Failed to connect to Database for s_reposUser=sysman, s_reposPwd=******, connectString=pcrudb01.dubaiworld.ae:1899:gridem. ConnectException=ORA-01017: invalid username/password; logon denied

Will retry as SYS user...
INFO: oracle.sysman.top.oms:Result Set from Database for nodes and sids is processed for dbUser=SYS, s_reposPwd=******, connectString=pcrudb01.dubaiworld.ae:1899:gridem
INFO: oracle.sysman.top.oms:fixNodeNames:From Template=pcrudb01.dubaiworld.ae:Domain extracted=.dubaiworld.ae
INFO: oracle.sysman.top.oms:fixNodeNames:Host Name=pcrudb01:Would be augmented with .dubaiworld.ae
INFO: oracle.sysman.top.oms:mkDescriptor:Connect Descriptor created=(DESCRIPTION=(ADDRESS_LIST=(ADDRESS=(PROTOCOL=TCP)(HOST=pcrudb01.dubaiworld.ae)(PORT=1899)))(CONNECT_DATA=(SID=gridem)))
INFO: oracle.sysman.top.oms:OmsPlugIn:perform:Performing Action=configuration with options = Specified: -configureOms in OracleHome=/u01/app/oms_home/oms10g
INFO: oracle.sysman.top.oms:PerformSecureCommand:runCmd:Performing Command=/u01/app/oms_home/oms10g/opmn/bin/opmnctl stopall 
INFO: oracle.sysman.top.oms:PerformSecureCommand:runCmd:/u01/app/oms_home/oms10g/opmn/bin/opmnctl stopall have completed with exitCode=0


INFO: oracle.sysman.top.oms:Internal PlugIn for {Micro Step state:step:2:configuration in CfmAggregateInstance: oracle.sysman.top.oms:10.2.0.3.0:common:family=CFM:oh=/u01/app/oms_home/oms10g:label=0} failed with an unhandled exception:
java.lang.Exception: RepManager Create Repository Error = 14. Please check the log file at /u01/app/oms_home/oms10g/sysman/log/emca_repos_create12_59_04.log
at oracle.sysman.emcp.util.EmcpPlug.startProcessing(EmcpPlug.java:389)
at oracle.sysman.emcp.util.EmcpPlug.invoke(EmcpPlug.java:360)
at oracle.sysman.emCfg.core.PerformMicroStep.runJavaClass(PerformMicroStep.java:509)
at oracle.sysman.emCfg.core.PerformMicroStep.executeMicroStep(PerformMicroStep.java:121)


Repository Creation failed. Repos User already exists..

INFO: oracle.sysman.top.oms:Internal PlugIn for {Micro Step state:step:2:configuration in CfmAggregateInstance: oracle.sysman.top.oms:10.2.0.3.0:common:family=CFM:oh=/u01/app/oms_home/oms10g:label=1} failed with an unhandled exception:
java.lang.Exception: RepManager Create Repository Error = 11. Please check the log file at /u01/app/oms_home/oms10g/sysman/log/emca_repos_create13_01_53.log
at oracle.sysman.emcp.util.EmcpPlug.startProcessing(EmcpPlug.java:389)

Solution:

Execute manual drop and config OMS :


a1) Drop and reconfig OMS manaully.

1. Stop OMS and OPMN

2. Set init parameters as per mentioned in the following doc :
http://download.oracle.com/docs/cd/B16240_01/doc/install.102/e10953/installing_em.htm#CJGHCABB

like 
processes=200 (or higher)
job_queue_process=10

3. Ensure that Rep DB and Listener are UP and running.

4. Drop Repository manually:



$export ORACLE_HOME=<OMS_HOME>
$<OMS_HOME>/sysman/admin/emdrep/bin/RepManager <hostname> <repository_db_listener_port> 
<repository_db_sid> -action drop


- Ensure the users SYSMAN and MGMT_VIEW are no longer users in the database, otherwise, drop them.

SQL>select USERNAME,ACCOUNT_STATUS from dba_users;

5. Run the failed configuration assistants for the OMS home using the following command:

$export ORACLE_HOME=<OMS_HOME>
$<OMS_HOME>/oui/bin/runConfig.sh ORACLE_HOME=<OMS_HOME> ACTION=configure MODE=perform

6. Start OMS and opmn 
$<OMS_HOME>/bin/emctl start oms
$<OMS_HOME>/bin/emctl status oms
$<OMS_HOME>/opmn/bin/opmnctl startall
$<OMS_HOME>/opmn/bin/opmnctl status 


7. run agentca as well:

$export ORACLE_HOME=<AGENT_HOME>
$<AGENT_HOME>/oui/bin/runConfig.sh ORACLE_HOME=<OMS_HOME> ACTION=configure MODE=perform
$<AGENT_HOME>/bin/emctl start agent
$<AGENT_HOME>/bin/emctl upload agent
$<AGENT_HOME>/bin/emctl status agent


References:

Ref doc:
http://download.oracle.com/docs/cd/B16240_01/doc/install.102/e10953/app_troubleshooting.htm#CHDEFGIF

Search : repManager

Get Oracle Certifications for all Exams
Free Online Exams.com