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
http://www.free-online-exams.com
Problem: Configuration Assistant “Repository Upgrade" Failed while Upgrade my existent EMGC 10.2.0.4 to R5 10.2.0.5
Upgrade my existent EMGC 10.2.0.4 to R5 10.2.0.5
while Patching the OMS home, and on the configuration menu, the following error occured
Configuration Assistant " Repository Upgrade" Failed
while Patching the OMS home, and on the configuration menu, the following error occured
Configuration Assistant " Repository Upgrade" Failed
Symptoms:
Sysman password has been changed from the sql plus.
Log files:
CfmLogger_2009-06-05_12-37-19-AM.log
Running setSchemaStatus: BEGIN EMD_MAINTENANCE.SET_VERSION('_UPGRADE_','0','0','SYSTEM',EMD_MAINTENANCE.G_STATUS_UPGRADING);END;
Could not connect to SYSMAN/(DESCRIPTION=(ADDRESS_LIST=(ADDRESS=(PROTOCOL=TCP)(HOST=jgrpem01.dubaiworld.ae)(PORT=1521)))(CONNECT_DATA=(SID=emprod))): ORA-01017: invalid username/password; logon denied (DBD ERROR: OCISessionBegin)
INFO: oracle.sysman.top.oms: Command Error:----------
INFO: oracle.sysman.top.oms:
SEVERE: oracle.sysman.top.oms:CfwException in Run OS Command:Command: /u01/app/oracle/product/emgrid/oms10g/sysman/admin/emdrep/bin/RepManager -connect (DESCRIPTION=(ADDRESS_LIST=(ADDRESS=(PROTOCOL=TCP)(HOST=jgrpem01.dubaiworld.ae)(PORT=1521)))(CONNECT_DATA=(SID=emprod))) -action upgrade -no_transx -no_verify -verbose -repos_user sysman -output_file /u01/app/oracle/product/emgrid/oms10g/sysman/log/emrepmgr.log.10.2.0.5.0 failed. Exit code: expected [0 ], but got 50
Running setSchemaStatus: BEGIN EMD_MAINTENANCE.SET_VERSION('_UPGRADE_','0','0','SYSTEM',EMD_MAINTENANCE.G_STATUS_UPGRADING);END;
Could not connect to SYSMAN/(DESCRIPTION=(ADDRESS_LIST=(ADDRESS=(PROTOCOL=TCP)(HOST=jgrpem01.dubaiworld.ae)(PORT=1521)))(CONNECT_DATA=(SID=emprod))): ORA-01017: invalid username/password; logon denied (DBD ERROR: OCISessionBegin)
INFO: oracle.sysman.top.oms: Command Error:----------
INFO: oracle.sysman.top.oms:
SEVERE: oracle.sysman.top.oms:CfwException in Run OS Command:Command: /u01/app/oracle/product/emgrid/oms10g/sysman/admin/emdrep/bin/RepManager -connect (DESCRIPTION=(ADDRESS_LIST=(ADDRESS=(PROTOCOL=TCP)(HOST=jgrpem01.dubaiworld.ae)(PORT=1521)))(CONNECT_DATA=(SID=emprod))) -action upgrade -no_transx -no_verify -verbose -repos_user sysman -output_file /u01/app/oracle/product/emgrid/oms10g/sysman/log/emrepmgr.log.10.2.0.5.0 failed. Exit code: expected [0 ], but got 50
emrepmgr.log.10.2.0.5.0.*
-------------------------------
(DESCRIPTION=(ADDRESS_LIST=(ADDRESS=(PROTOCOL=TCP)(HOST=jgrpem01.dubaiworld.ae)(PORT=1521)))(CONNECT_DATA=(SID=emprod)))
[05-06-2009 00:40:55] Validating for Repos User ...
SQL*Plus: Release 10.1.0.5.0 - Production on Fri Jun 5 00:40:56 2009
Copyright (c) 1982, 2005, Oracle. All rights reserved.
Enter user-name: ERROR:
ORA-01017: invalid username/password; logon denied
Enter user-name: SP2-0306: Invalid option.
Usage: CONN[ECT] [logon] [AS {SYSDBA|SYSOPER}]
where <logon> ::= <username>[/<password>][@<connect_identifier>] | /
Enter user-name: SP2-0306: Invalid option.
Usage: CONN[ECT] [logon] [AS {SYSDBA|SYSOPER}]
where <logon> ::= <username>[/<password>][@<connect_identifier>] | /
SP2-0157: unable to CONNECT to ORACLE after 3 attempts, exiting SQL*Plus
[05-06-2009 00:40:56] Return code = 1.
[05-06-2009 00:40:56] Failed
[05-06-2009 00:40:56] Repos User does not exist..
SQL>
SQL> Disconnected from Oracle Database 10g Enterprise Edition Release 10.2.0.3.0 - 64bit Production
With the Partitioning, OLAP and Data Mining options
[05-06-2009 00:40:57] Checking repository version..
[05-06-2009 00:40:57] Running setSchemaStatus: BEGIN EMD_MAINTENANCE.SET_VERSION('_UPGRADE_','0','0','SYSTEM',EMD_MAINTENANCE.G_STATUS_UPGRADING);END;
[05-06-2009 00:40:57] Could not connect to SYSMAN/(DESCRIPTION=(ADDRESS_LIST=(ADDRESS=(PROTOCOL=TCP)(HOST=jgrpem01.dubaiworld.ae)(PORT=1521)))(CONNECT_DATA=(SID=emprod))): ORA-01017: invalid username/password; logon denied (DBD ERROR: OCISessionBegin)
emoms.trc
2009-06-04 21:40:53,962 [AJPRequestHandler-ApplicationServerThread-11] ERROR conn.ConnectionService verifyRepositoryEx.878 - Invalid Connection Pool. ERROR = Listener refused the connection with the following error:
ORA-12505, TNS:listener does not currently know of SID given in connect descriptor
The Connection descriptor used by the client was:
(DESCRIPTION=(ADDRESS_LIST=(ADDRESS=(PROTOCOL=TCP)(HOST=jgrpem01.dubaiworld.ae)(PORT=1521)))(CONNECT_DATA=(SID=emprod)))
CfmLogger_2009-06-05_12-37-19-AM.log
Running setSchemaStatus: BEGIN EMD_MAINTENANCE.SET_VERSION('_UPGRADE_','0','0','SYSTEM',EMD_MAINTENANCE.G_STATUS_UPGRADING);END;
Could not connect to SYSMAN/(DESCRIPTION=(ADDRESS_LIST=(ADDRESS=(PROTOCOL=TCP)(HOST=jgrpem01.dubaiworld.ae)(PORT=1521)))(CONNECT_DATA=(SID=emprod))): ORA-01017: invalid username/password; logon denied (DBD ERROR: OCISessionBegin)
INFO: oracle.sysman.top.oms: Command Error:----------
INFO: oracle.sysman.top.oms:
SEVERE: oracle.sysman.top.oms:CfwException in Run OS Command:Command: /u01/app/oracle/product/emgrid/oms10g/sysman/admin/emdrep/bin/RepManager -connect (DESCRIPTION=(ADDRESS_LIST=(ADDRESS=(PROTOCOL=TCP)(HOST=jgrpem01.dubaiworld.ae)(PORT=1521)))(CONNECT_DATA=(SID=emprod))) -action upgrade -no_transx -no_verify -verbose -repos_user sysman -output_file /u01/app/oracle/product/emgrid/oms10g/sysman/log/emrepmgr.log.10.2.0.5.0 failed. Exit code: expected [0 ], but got 50
SEVERE: oracle.sysman.top.oms:Schema Upgrade Failed. Installation Terminated! Exception: Command: /u01/app/oracle/product/emgrid/oms10g/sysman/admin/emdrep/bin/RepManager -connect (DESCRIPTION=(ADDRESS_LIST=(ADDRESS=(PROTOCOL=TCP)(HOST=jgrpem01.dubaiworld.ae)(PORT=1521)))(CONNECT_DATA=(SID=emprod))) -action upgrade -no_transx -no_verify -verbose -repos_user sysman -output_file /u01/app/oracle/product/emgrid/oms10g/sysman/log/emrepmgr.log.10.2.0.5.0 failed. Exit code: expected [0 ], but got 50
WARNING: oracle.sysman.top.oms:EmcpPlug:startProcessing:Exception in runner=Command: /u01/app/oracle/product/emgrid/oms10g/sysman/admin/emdrep/bin/RepManager -connect (DESCRIPTION=(ADDRESS_LIST=(ADDRESS=(PROTOCOL=TCP)(HOST=jgrpem01.dubaiworld.ae)(PORT=1521)))(CONNECT_DATA=(SID=emprod))) -action upgrade -no_transx -no_verify -verbose -repos_user sysman -output_file /u01/app/oracle/product/emgrid/oms10g/sysman/log/emrepmgr.log.10.2.0.5.0 failed. Exit code: expected [0 ], but got 50
INFO: oracle.sysman.top.oms:EmcpPlug:invoke:Completed EmcpPlug invoke method on an aggregate=oracle.sysman.top.oms for Action=patchsetConfiguration in step=1:microstep=0
INFO: oracle.sysman.top.oms:Internal PlugIn for {Micro Step state:step:1:patchsetConfiguration in CfmAggregateInstance: oracle.sysman.top.oms:10.2.0.5.0:common:family=CFM:oh=/u01/app/oracle/product/emgrid/oms10g:label=3} failed with an unhandled exception:
java.lang.Exception: Command: /u01/app/oracle/product/emgrid/oms10g/sysman/admin/emdrep/bin/RepManager -connect (DESCRIPTION=(ADDRESS_LIST=(ADDRESS=(PROTOCOL=TCP)(HOST=jgrpem01.dubaiworld.ae)(PORT=1521)))(CONNECT_DATA=(SID=emprod))) -action upgrade -no_transx -no_verify -verbose -repos_user sysman -output_file /u01/app/oracle/product/emgrid/oms10g/sysman/log/emrepmgr.log.10.2.0.5.0 failed. Exit code: expected [0 ], but got 50
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:540)
at oracle.sysman.emCfg.core.PerformMicroStep.executeMicroStep(PerformMicroStep.java:120)
-------------------------------
(DESCRIPTION=(ADDRESS_LIST=(ADDRESS=(PROTOCOL=TCP)(HOST=jgrpem01.dubaiworld.ae)(PORT=1521)))(CONNECT_DATA=(SID=emprod)))
[05-06-2009 00:40:55] Validating for Repos User ...
SQL*Plus: Release 10.1.0.5.0 - Production on Fri Jun 5 00:40:56 2009
Copyright (c) 1982, 2005, Oracle. All rights reserved.
Enter user-name: ERROR:
ORA-01017: invalid username/password; logon denied
Enter user-name: SP2-0306: Invalid option.
Usage: CONN[ECT] [logon] [AS {SYSDBA|SYSOPER}]
where <logon> ::= <username>[/<password>][@<connect_identifier>] | /
Enter user-name: SP2-0306: Invalid option.
Usage: CONN[ECT] [logon] [AS {SYSDBA|SYSOPER}]
where <logon> ::= <username>[/<password>][@<connect_identifier>] | /
SP2-0157: unable to CONNECT to ORACLE after 3 attempts, exiting SQL*Plus
[05-06-2009 00:40:56] Return code = 1.
[05-06-2009 00:40:56] Failed
[05-06-2009 00:40:56] Repos User does not exist..
SQL>
SQL> Disconnected from Oracle Database 10g Enterprise Edition Release 10.2.0.3.0 - 64bit Production
With the Partitioning, OLAP and Data Mining options
[05-06-2009 00:40:57] Checking repository version..
[05-06-2009 00:40:57] Running setSchemaStatus: BEGIN EMD_MAINTENANCE.SET_VERSION('_UPGRADE_','0','0','SYSTEM',EMD_MAINTENANCE.G_STATUS_UPGRADING);END;
[05-06-2009 00:40:57] Could not connect to SYSMAN/(DESCRIPTION=(ADDRESS_LIST=(ADDRESS=(PROTOCOL=TCP)(HOST=jgrpem01.dubaiworld.ae)(PORT=1521)))(CONNECT_DATA=(SID=emprod))): ORA-01017: invalid username/password; logon denied (DBD ERROR: OCISessionBegin)
emoms.trc
2009-06-04 21:40:53,962 [AJPRequestHandler-ApplicationServerThread-11] ERROR conn.ConnectionService verifyRepositoryEx.878 - Invalid Connection Pool. ERROR = Listener refused the connection with the following error:
ORA-12505, TNS:listener does not currently know of SID given in connect descriptor
The Connection descriptor used by the client was:
(DESCRIPTION=(ADDRESS_LIST=(ADDRESS=(PROTOCOL=TCP)(HOST=jgrpem01.dubaiworld.ae)(PORT=1521)))(CONNECT_DATA=(SID=emprod)))
CfmLogger_2009-06-05_12-37-19-AM.log
Running setSchemaStatus: BEGIN EMD_MAINTENANCE.SET_VERSION('_UPGRADE_','0','0','SYSTEM',EMD_MAINTENANCE.G_STATUS_UPGRADING);END;
Could not connect to SYSMAN/(DESCRIPTION=(ADDRESS_LIST=(ADDRESS=(PROTOCOL=TCP)(HOST=jgrpem01.dubaiworld.ae)(PORT=1521)))(CONNECT_DATA=(SID=emprod))): ORA-01017: invalid username/password; logon denied (DBD ERROR: OCISessionBegin)
INFO: oracle.sysman.top.oms: Command Error:----------
INFO: oracle.sysman.top.oms:
SEVERE: oracle.sysman.top.oms:CfwException in Run OS Command:Command: /u01/app/oracle/product/emgrid/oms10g/sysman/admin/emdrep/bin/RepManager -connect (DESCRIPTION=(ADDRESS_LIST=(ADDRESS=(PROTOCOL=TCP)(HOST=jgrpem01.dubaiworld.ae)(PORT=1521)))(CONNECT_DATA=(SID=emprod))) -action upgrade -no_transx -no_verify -verbose -repos_user sysman -output_file /u01/app/oracle/product/emgrid/oms10g/sysman/log/emrepmgr.log.10.2.0.5.0 failed. Exit code: expected [0 ], but got 50
SEVERE: oracle.sysman.top.oms:Schema Upgrade Failed. Installation Terminated! Exception: Command: /u01/app/oracle/product/emgrid/oms10g/sysman/admin/emdrep/bin/RepManager -connect (DESCRIPTION=(ADDRESS_LIST=(ADDRESS=(PROTOCOL=TCP)(HOST=jgrpem01.dubaiworld.ae)(PORT=1521)))(CONNECT_DATA=(SID=emprod))) -action upgrade -no_transx -no_verify -verbose -repos_user sysman -output_file /u01/app/oracle/product/emgrid/oms10g/sysman/log/emrepmgr.log.10.2.0.5.0 failed. Exit code: expected [0 ], but got 50
WARNING: oracle.sysman.top.oms:EmcpPlug:startProcessing:Exception in runner=Command: /u01/app/oracle/product/emgrid/oms10g/sysman/admin/emdrep/bin/RepManager -connect (DESCRIPTION=(ADDRESS_LIST=(ADDRESS=(PROTOCOL=TCP)(HOST=jgrpem01.dubaiworld.ae)(PORT=1521)))(CONNECT_DATA=(SID=emprod))) -action upgrade -no_transx -no_verify -verbose -repos_user sysman -output_file /u01/app/oracle/product/emgrid/oms10g/sysman/log/emrepmgr.log.10.2.0.5.0 failed. Exit code: expected [0 ], but got 50
INFO: oracle.sysman.top.oms:EmcpPlug:invoke:Completed EmcpPlug invoke method on an aggregate=oracle.sysman.top.oms for Action=patchsetConfiguration in step=1:microstep=0
INFO: oracle.sysman.top.oms:Internal PlugIn for {Micro Step state:step:1:patchsetConfiguration in CfmAggregateInstance: oracle.sysman.top.oms:10.2.0.5.0:common:family=CFM:oh=/u01/app/oracle/product/emgrid/oms10g:label=3} failed with an unhandled exception:
java.lang.Exception: Command: /u01/app/oracle/product/emgrid/oms10g/sysman/admin/emdrep/bin/RepManager -connect (DESCRIPTION=(ADDRESS_LIST=(ADDRESS=(PROTOCOL=TCP)(HOST=jgrpem01.dubaiworld.ae)(PORT=1521)))(CONNECT_DATA=(SID=emprod))) -action upgrade -no_transx -no_verify -verbose -repos_user sysman -output_file /u01/app/oracle/product/emgrid/oms10g/sysman/log/emrepmgr.log.10.2.0.5.0 failed. Exit code: expected [0 ], but got 50
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:540)
at oracle.sysman.emCfg.core.PerformMicroStep.executeMicroStep(PerformMicroStep.java:120)
Solution:
Use the right procedure to change the sysman password
References:
Note 803063.1
book E14646-01
No comments:
Post a Comment