ITPub博客

首页 > Linux操作系统 > Linux操作系统 > 安装Grid Control: PLS-00201 'MGMT_TIME_SYNC.STARTUPSYNC' must be declared

安装Grid Control: PLS-00201 'MGMT_TIME_SYNC.STARTUPSYNC' must be declared

原创 Linux操作系统 作者:tolywang 时间:2011-08-04 08:37:04 0 删除 编辑
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 。Patch 8430622中描述的ORACLE_HOME ( $ORACLE_HOME/bin/emctl stop oms)
在这里指的是$OMS_HOME, 不是Oracle RDBMS的ORACLE_HOME.
c.
先设置$ORACLE_HOME并停止oms
ipadtest<*ipadtest*>$export
ORACLE_HOME=/u01/product/OracleHomes/oms10g/
ipadtest<*ipadtest*>$echo $ORACLE_HOME
/u01/product/OracleHomes/oms10g/
ipadtest<*ipadtest*>$cd /u01/product/OracleHomes/oms10g/
ipadtest<*ipadtest*>$cd bin/
ipadtest<*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<*ipadtest*>$opmnctl stopall
opmnctl: stopping opmn and all managed processes...
ipadtest<*ipadtest*>$

e.
Re-secure Oracle Management Service with the following command:
ipadtest<*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<*ipadtest*>$

来自 “ ITPUB博客 ” ,链接:http://blog.itpub.net/35489/viewspace-704033/,如需转载,请注明出处,否则将追究法律责任。

请登录后发表评论 登录
全部评论
Oracle , MySQL, SAP IQ, SAP HANA, PostgreSQL, Tableau 技术讨论,希望在这里一起分享知识,讨论技术,畅谈人生 。

注册时间:2007-12-10

  • 博文量
    5595
  • 访问量
    13474922