PLS-00201: identifier 'MGMT_TIME_SYNC.STARTUPSYNC' must be declared
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 RDBMS的ORACLE_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$
安裝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 RDBMS的ORACLE_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/,如需轉載,請註明出處,否則將追究法律責任。
相關文章
- Error: PLS-00201: identifier 'DBMS_AQ'must be declaredErrorIDE
- 安裝Grid Control: PLS-00201 'MGMT_TIME_SYNC.STARTUPSYNC' must be declared
- Uncaught SyntaxError: Identifier 'Geometry' has already been declaredErrorIDE
- Rman Backup Fails: PLS-00302: component 'GETREQUIREDSCN' must be declaredAIUI
- Caused by: org.hibernate.MappingException: must specify an identifier type:APPExceptionIDE
- 【故障處理】imp PLS-00302: component 'SET_NO_OUTLINES' must be declared
- vue專案啟動報錯(SyntaxError: Identifier ‘__vite__injectQuery’ has already been declared (at ${mod.id}:55030:1))VueErrorIDEVite
- The entity "nbsp" was referenced, but not declared
- goldengate目的端應用序列出錯:[ORA-06550: line 1, column 8: PLS-00201: identifierGoIDE
- error:declared inside parameter listErrorIDE
- How to change the implementation (detour) of an externally declared functionFunction
- Fatal error: Cannot redeclare printerror() (previously declared in …Error
- It's a must to ghd
- 【PL/SQL 學習】PLS-00201SQL
- XX must be built with ARCUI
- but no encoding declared;問題的解決方法Encoding
- WPF Add ResourceDictionary file and declared in app.xamlAPP
- find: paths must precede expression:Express
- Flutter:VM snapshot must be valid. Check failed: vm. Must be able to initializeFlutterAI
- PostgreSQL DBA(80) - Object Identifier TypesSQLObjectIDE
- Oracle Custom Support Identifier(CSI)OracleIDE
- Mount: you must specify the filesystem type
- error C2248: cannot access protected member declared in class '****'Error
- Oracle identifiers :SID (System Identifier)OracleIDE
- ORA-00904: invalid identifierIDE
- Service異常:Service Intent must be explicitIntent
- mongodb報錯:the limit must be specified as a number。MongoDBMIT
- rman duplicate出現PLS-00201錯誤解決
- PLS-00201: 必須宣告識別符號 'VARTABLETYPE'符號
- 【Redis】錯誤:failed: Hostname must not be empty or nullRedisAINull
- Page directive must not have multiple occurrences of pageencodingEncoding
- Python 錯誤 SyntaxError: invalid character in identifierPythonErrorIDE
- 關於hibernate的 No row with the given identifier existsIDE
- .NET Core Runtime IDentifier (RID) catalogIDE
- 【DataGuard】 TNS:could not resolve the connect identifier specifiedIDE
- stm32 use of undeclared identifier GPIO_InitTypeDefIDE
- 編譯包的時候發生pls-00201錯誤編譯
- 如何解決 case expressions must be constant expressionsExpress