oracle EM 管理以及诊断 总结

周五在客户在给客户装了一套 ORACLE ，平台 AIX 5309 64 BIT ， DB 10.2.0.4 DBCA 的时候，在 88 %左右的时候就报 EM 有问题，这个之前遇到过很多次，都是 DBCA 完了处理一般没什么大问题。 DBCA 后，用一下方法去重新安装 EM ，
 
 
drop user sysman cascade ;
drop role MGMT_USER ;
drop user MGMT_VIEW cascade ;
drop public synonym MGMT_TARGET_BLACKOUTS ;
drop public synonym SETEMVIEWUSERCONTEXT ;
在安装 EM
 
emca - config dbcontrol db - repos create
可是还不 OK ，启动的时候有如下报错提示：
ps : 0509 - 048 Flag - o was used with invalid list .
ps : Not a recognized flag : -
Usage : ps [- ANPaedfklmMZ ] [- n namelist ] [- F Format ] [- o specifier [= header ],...]
                [- p proclist ][- G |- g grouplist ] [- t termlist ] [- U |- u userlist ] [- c classlist ] [ - T pid ] [ - L pidlist ]
Usage : ps [ aceglnsuvwxU ] [ t tty ] [ processnumber ]
 
最后还是启动失败，一开始并没有太在意以上错误，后来重新搞了几次还是不行，看来必须先解决上面问题
 
在 METALINK 发现如下文档：文档 ID ： 758568.1
Applies to :
Enterprise Manager Grid Control - Version : 10.2.0.3 to 10.2.0.4
IBM AIX Based Systems ( 64 - bit )
 
Symptoms
 
' emctl start dbconsole ' command shows ps command error as below :
 
$ ORACLE_HOME / bin / emctl start dbconsole
Oracle Enterprise Manager 10 g Database Control Release 10.2.0.3.0
Copyright ( c ) 1996 , 2006 Oracle Corporation . All rights reserved .
http ://< host >:< port >/ em / console / aboutApplication
ps : 0509 - 048 Flag - o was used with invalid list .
ps : Not a recognized flag : -
Usage : ps [- ANPaedfklmMZ ] [- n namelist ] [- F Format ] [- o specifier [= header ],...]
[- p proclist ][- G |- g grouplist ] [- t termlist ] [- U |- u userlist ] [- c classlist ] [ - T
pid ] [ - L pidlist ]
Usage : ps [ aceglnsuvwxU ] [ t tty ] [ processnumber ]
Starting Oracle Enterprise Manager 10 g Database Control .............. started .
---------------------------------------------------------------- --
Cause
In emctl . pl we have a command as below :
ps - p $ PID - o cmd -- cols 1000 | grep DEMDROOT
 
In AIX platforms for some OS kernels , this command doesn ' t work. The correct command is:
ps -p $PID -o args | grep DEMDROOT
 
Solution
If you get these errors while starting DBConsole, follow below action plan:
 
Follow below action plan.
 
a) Stop DBConsole - ' emctl stop dbconsole '
b) Take backup of ' emctl . pl ' from $ORACLE_HOME/bin
c) Edit emctl.pl and goto line number 1249, which is:
my $ps=`ps -p $PID -o cmd --cols 1000 |grep DEMDROOT`;
Modify above line as below:
my $ps=`ps -p $PID -o args | grep DEMDROOT`;
d) Save the file.
e) Start DBConsole - ' emctl start dbconsole ' from $ORACLE_HOME/bin
 
安装上边处理完后，停止EM的时候有如下报错：
$ emctl stop dbconsole
 
Oracle Enterprise Manager 10g Database Control Release 10.2.0.4.0 
 
Copyright (c) 1996, 2007 Oracle Corporation.  All rights reserved.
 
https://host:1158/em/console/aboutApplication
 
Stopping Oracle Enterprise Manager 10g Database Control ...
 
--- Failed to shutdown DBConsole Gracefully ---
 
 failed.
 
处理方法：
 
KILL 掉oc4j和dbconsole相关进程，然后停止em agent 和dbconsole就好了
 
在重新启动的时候还是没有启动起来，
emctl.trc有如下报错
 
009-08-14 19:20:15 Thread-1958 ERROR http: 11: Unable to initialize ssl connection with server, aborting connection attempt
2009-08-14 19:20:15 Thread-1958 ERROR pingManager: nmepm_pingReposURL: Cannot connect to https://host:1158/em/upload/: retStatus=-1
2009-08-14 19:20:15 Thread-1958 ERROR ssl: Open wallet failed, ret = 28750
2009-08-14 19:20:15 Thread-1958 ERROR ssl: nmehlenv_openWallet failed
2009-08-14 19:20:15 Thread-1958 ERROR http: 11: Unable to initialize ssl connection with server, aborting connection attempt
2009-08-14 19:20:15 Thread-1958 ERROR pingManager: nmepm_pingReposURL: Cannot connect to https://host:1158/em/upload/: retStatus=-1
2009-08-14 19:20:23 Thread-1960 ERROR upload: Error in uploadXMLFiles.  Trying again in 300.00 seconds.
2009-08-14 19:20:45 Thread-1966 ERROR ssl: Open wallet failed, ret = 28750
2009-08-14 19:20:45 Thread-1966 ERROR ssl: nmehlenv_openWallet failed
2009-08-14 19:20:45 Thread-1966 ERROR http: 12: Unable to initialize ssl connection with server, aborting connection attempt
2009-08-14 19:20:45 Thread-1966 ERROR pingManager: nmepm_pingReposURL: Cannot connect to https://host:1158/em/upload/: retStatus=-1
2009-08-14 19:20:45 Thread-1966 ERROR ssl: Open wallet failed, ret = 28750
2009-08-14 19:20:45 Thread-1966 ERROR ssl: nmehlenv_openWallet failed
2009-08-14 19:20:45 Thread-1966 ERROR http: 12: Unable to initialize ssl connection with server, aborting connection attempt
2009-08-14 19:20:45 Thread-1966 ERROR pingManager: nmepm_pingReposURL: Cannot connect to https://host:1158/em/upload/: retStatus=-1
2009-08-14 19:20:45 Thread-1967 ERROR ssl: Open wallet failed, ret = 28750
2009-08-14 19:20:45 Thread-1967 ERROR ssl: nmehlenv_openWallet failed
2009-08-14 19:20:45 Thread-1967 ERROR http: 12: Error initializing SSL connection for incoming request, aborting request. ret=-1
2009-08-14 19:20:52 Thread-1969 ERROR upload: Error in uploadXMLFiles.  Trying again in 300.00 seconds.
2009-08-14 19:21:14 Thread-1029 ERROR ssl: Open wallet failed, ret = 28750
2009-08-14 19:21:14 Thread-1029 ERROR ssl: nmehlenv_openWallet failed
 
在文档：749243.1 有如下解决方法：
Applies to:
Enterprise Manager Grid Control - Version: 10.2.0.1
This problem can occur on any platform.
 
Symptoms
Database Console fails to start with:
 
emctl start dbconsole
 
TZ set to Europe/Madrid
Oracle Enterprise Manager 10g Database Control Release 10.2.0.3.0
Copyright (c) 1996, 2006 Oracle Corporation. All rights reserved.
https://myserver.mydomain:5503/em/console/aboutApplication
Starting Oracle Enterprise Manager 10g Database Control
.............................................................................................
failed.
 
emdctl.trc
-----------
2008-09-15 10:58:20 Thread-4136126688 ERROR http: 8: Unable to initialize ssl connection with
server, aborting connection attempt
2008-09-15 10:59:52 Thread-4136126688 ERROR ssl: nzos_Handshake failed, ret=29024.
 
Cause
The Dbconsole certificate life time has expired.
Solution
Run the commands:
 
1. Unsecure the Dbconsole
- Unsecure database control using
$ORACLE_HOME/bin>emctl unsecure dbconsole
 
2. Force an upload:
 
$ORACLE_HOME/bin> emctl upload
 
3. Also consider Resecuring the Dbconsole
- Secure database control using
$ORACLE_HOME/bin>emctl secure dbconsole
 
 Starting with 10.2.0.4, HTTPS is used by default.
 
经过以上处理后就OK了，途中来来回回搞了不少次。
 
总结就是EM有问题了，一定要去$ORACLE_HOME/类似主机名的目录sysman/log看agent和emctl.trc emdb.nohup里报错，解决了那些报错。我想你的EM也不会有什么问题了

 

如果不想使用https，可以emctl unsecure dbconsole取消，反之emctl secure dbconsole可配置em通过ssl访问。