重建OEM过程以及遇到的一些问题

OEM打不开

问题描述：早上就有客户说OEM打不开，但是数据库运行正常。

环境：主机是HP-unix环境，oracle 10.2.0.3 RAC

首先检查agent的状态

$ emctl status agent
Oracle Enterprise Manager 10g Database Control Release 10.2.0.3.0
Copyright (c) 1996, 2006 Oracle Corporation. All rights reserved.
---------------------------------------------------------------
Agent Version : 10.1.0.5.1
OMS Version : 10.1.0.5.0
Proto Version : 10.1.0.2.0
Agent Home : /oracle/dbs10g/10.2/asterix_BOSSPNGP1
Agent binaries : /oracle/dbs10g/10.2
Agent Process ID : 1409190
Parent Process ID : 1265676
Agent URL : http://asterix.pngmail.com:3938/emd/main
Started at : 2008-07-07 10:02:01
Started by user : oracle
Last Reload : 2008-07-07 10:02:01
Last successful upload : (none)
Last attempted upload : 2008-07-07 11:32:09
Total Megabytes of XML files uploaded so far : 0.00
Number of XML files pending upload : 265
Size of XML files pending upload(MB) : 54.77
Available disk space on upload filesystem : 6.37%
---------------------------------------------------------------
Agent is Running and Ready

 

$ emctl upload agent
Oracle Enterprise Manager 10g Database Control Release 10.2.0.3.0
Copyright (c) 1996, 2006 Oracle Corporation. All rights reserved.
upload failed with ret=-10

 

upload的时候报错,上metalink查找解决方案

metalink上有个相似的案例：Note:396238.1,并且有solution.

Solution

There are two solutions for this:
1) Either modify the value(s) of the following parameters :
UploadMaxBytesXML
UploadMaxNumberXML
Then, restart the agent

Or,

2) Execute the following steps:

(i) Stop the agent

/bin/emctl stop agent

(ii) Delete any pending upload files from the agent home

If non RAC agent :

rm -r /sysman/emd/state/*
rm -r /sysman/emd/upload/*
rm /sysman/emd/lastupld.xml
rm /sysman/emd/agntstmp.txt
rm /sysman/emd/protocol.ini

If RAC agent :

rm -r //sysman/emd/state/*
rm -r /nodeNN>/sysman/emd/upload/*
rm /nodeNN>/sysman/emd/lastupld.xml
rm /nodeNN>/sysman/emd/agntstmp.txt
rm /nodeNN>/sysman/emd/protocol.ini

(iii) Start the agent

/bin/emctl start agent

(iv) Force an upload to the OMS

/bin/emctl upload

但是 按照metalink的方法没用，所以尝试先删除再重建。

$emca -deconfig dbcontrol db -repos drop –cluster
Jul 14, 2008 2:45:37 AM oracle.sysman.emcp.EMConfig perform
INFO: This operation is being logged at
/oracle/dbs10g/10.2/cfgtoollogs/emca/BOSSPNGP/emca_2008-07-14_02-45-03-AM.log.
Jul 14, 2008 2:45:40 AM oracle.sysman.emcp.EMDBPreConfig
performDeconfiguration
WARNING: EM is not configured for this database. No EM-specific actions can be performed.
Jul 14, 2008 2:45:40 AM oracle.sysman.emcp.EMReposConfig dropRepository
INFO: Dropping the EM repository (this may take a while) ...

但是到这一步就hang住了没反应了。有可能什么进程将资源锁住了，没办法只好中断。

Solution
1.Stop the dbconsole and agent on rac1 and rac2
2.kill the dbconsole processes on rac1 and rac2

ps -ef|grep oc4j|grep oracle
ps -df|grep agent|grep oracle
ps -ef|grep java|grep oracle
ps -ef|grep dbconsole|grep oracle

将这些相关的进程全部 kill掉

然后再运行

$ emca -deconfig dbcontrol db -repos drop -cluster
Enter the following information:
Database unique name: EM102
Listener port number: 1521
Password for SYS user:
Password for SYSMAN user:

This emca command does the following:

这一次成功的删除了。

然后就是重新配置

 

$ emca -config dbcontrol db -repos create -cluster
Enter the following information:
- Database unique name -- If you're not sure of the values for Database unique name
                          and service name, execute the following statement
                          connected as a DBA user to any instance of the RAC database:
                          SQL> show parameter db_unique_name
- Listener port
- SYS password
- SYSMAN password

然后检查：

$emca -displayConfig dbcontrol –cluster

一切正常可以进入dbconsole了，但是进入后又碰到问题了：

显示: Dbconsole java.lang.Exception: Can't get Query Descriptor or Execution Descriptor

metalink给出了一个解决文档ID：352479.1

Solution

To implement the solution, please execute the following steps

on Both Nodes :

1. Stop the DBConsole

2. Change /sysman/admin/default_collection/rac_database.xml.
lines (59-62) from





to






3. Start the DBconsole and try again

 

至此问题全部解决。还真的感谢metalink.

 

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

转载于:http://blog.itpub.net/92530/viewspace-402627/