PLS-00201: identifier 'MGMT_TIME_SYNC.STARTUPSYNC' must be declared

tolywang發表於2011-08-03
Oracle 10.2.0.4 ,  Linux as 5.3  64bit   



安裝grid control ( Oracle 10.2.0.3.0) 到配置OMS Configuration 的時候報錯 OUI-25031 ,  需要打補丁Patch 8430622 ,
在打補丁的過程中又發現有報錯  PLS-00201: identifier 'MGMT_TIME_SYNC.STARTUPSYNC' must be declared  




OUI-25031錯誤具體參考文件: How to Recover From Enterprise Manager Grid Control 10g Base Releases (10.2.0.x.0) Installation Errors after 31-Dec-2010 [ID 1228103.1]



a.
不要關閉出現錯誤的session
b.
下載 Patch 8430622中描述的ORACLE_HOME ( $ORACLE_HOME/bin/emctl stop oms)
在這裡指的是$OMS_HOME, 不是Oracle RDBMSORACLE_HOME.
c.
先設定$ORACLE_HOME並停止oms
ipadtest$export
ORACLE_HOME=/u01/product/OracleHomes/oms10g/

ipadtest$echo $ORACLE_HOME
/u01/product/OracleHomes/oms10g/
ipadtest$cd /u01/product/OracleHomes/oms10g/
ipadtest$cd bin/
ipadtest$./emctl stop oms
Oracle Enterprise Manager 10g Release 3 Grid Control

Copyright (c) 1996, 2007 Oracle Corporation.
All rights reserved.

Oracle Management Server is Down.


d.
按照文件, apply patch後,
ipadtest$opmnctl
stopall

opmnctl: stopping opmn and all managed processes...
ipadtest$


e.
Re-secure Oracle Management Service with the following command:


ipadtest$./emctl secure oms -reset

Oracle Enterprise Manager 10g Release 3 Grid Control

Copyright (c) 1996, 2007 Oracle Corporation.
All rights reserved.

Enter Enterprise Manager Root Password :
Enter Agent Registration password :
OPMN processes already stopped...
Done.

Securing central oms...
Started.

Checking Repository...
Done.

Checking Em Key...
ORA-06550: line 1, column 13:

PLS-00201: identifier 'MGMT_TIME_SYNC.STARTUPSYNC' must be declared
ORA-06550: line 1, column 7:
PL/SQL: Statement ignored

java.sql.SQLException: ORA-06550: line 1, column 13:
PLS-00201: identifier 'MGMT_TIME_SYNC.STARTUPSYNC' must be declared
ORA-06550: line 1, column 7:
PL/SQL: Statement ignored


at oracle.jdbc.driver.DatabaseError.throwSqlException(DatabaseError.java:125)


at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:305)


at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:272)


at oracle.jdbc.driver.T4C8Oall.receive(T4C8Oall.java:626)


at oracle.jdbc.driver.T4CCallableStatement.doOall8(T4CCallableStatement.java:184)


at oracle.jdbc.driver.T4CCallableStatement.execute_for_rows(T4CCallableStatement.java:873)


at oracle.jdbc.driver.OracleStatement.doExecuteWithTimeout(OracleStatement.java:1090)


at oracle.jdbc.driver.OraclePreparedStatement.executeInternal(OraclePreparedStatement.java:2916)


at oracle.jdbc.driver.OraclePreparedStatement.execute(OraclePreparedStatement.java:3007)


at oracle.jdbc.driver.OracleCallableStatement.execute(OracleCallableStatement.java:4120)


at oracle.sysman.emSDK.conf.ConfigManager.startupEmKey(ConfigManager.java:495)


at oracle.sysman.emSDK.conf.ConfigManager.statusEmKeyInRepos(ConfigManager.java:753)



at oracle.sysman.eml.sec.rep.EmKeyUtil.statusEmKey(EmKeyUtil.java:264)


at oracle.sysman.eml.sec.rep.EmKeyUtil.main(EmKeyUtil.java:572)

Failed.
The Em Key is not Configured properly.Run "emctl status emkey" for details
ipadtest$

來自 “ ITPUB部落格 ” ,連結:http://blog.itpub.net/35489/viewspace-703983/,如需轉載,請註明出處,否則將追究法律責任。

相關文章