oracle EM 管理以及诊断 总结

转载 2011年01月08日 08:04:00
周五在客户在给客户装了一套ORACLE,平台AIX 5309 64BITDB 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发现如下文档:文档ID758568.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 10g 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 10g 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访问。

EM 无法启动&amp;&amp;重新完全配置EM

公司的电脑改了IP ,于是EM无法启动了环境:ORACLE 10G OS:WINXP SP2D:/Documents and Settings/guanhao>emctl start dbconsol...
  • managergh
  • managergh
  • 2007年11月19日 15:12
  • 17667

oracle EM 监控邮件提醒

   一、配置系统参数   1、查看自动任务相关参数,是否有值。   SQL> show parameter job_queue_processes;   NAME     ...
  • zhengwei125
  • zhengwei125
  • 2015年06月16日 17:18
  • 1184

Oracle11g使用sql_monitor实时监控sql

Oracle11g提供了对sql的实时监控,使sql优化诊断更容易。
  • Dream19881003
  • Dream19881003
  • 2014年01月12日 10:56
  • 17274

关于emca创建EM时的DBSNMP用户与SYSMAN用户问题

手工建库完成后,数据库中默认只有以下账户:手工建库步骤参考:http://blog.csdn.net/q947817003/article/details/16337611 SQL> show use...
  • q947817003
  • q947817003
  • 2013年11月18日 17:38
  • 3825

Oracle 13C Cloud Control 安装配置图解(三)

Oracle 12 C 的Cloud Control(本文简称CC) 即 11g的Grid Control,也就是我们常说的GC,GC在管理数据库非常方便,本次就将整个Colud control 的安...
  • moscot_wu
  • moscot_wu
  • 2016年09月26日 17:49
  • 3324

利用 Oracle EM 企业管理器 进行oracle SQL的优化(自动生成索引)

应用情景 项目中有大量的SQL,尤其是涉及到统计报表时,表关联比较多,当初开发建表时也没搞好索引关联的,上线后发现查询很低。Oracle自带的EM控制台带有自动优化功能,能给出优化方案,本人主要利用...
  • binyao02123202
  • binyao02123202
  • 2014年02月17日 07:21
  • 4542

ORACLE 企业管理器 EM 新建/修复完全解决方案!

2009年01月15日 星期四 15:47原题:使用emca创建 Database Control 资料档案库(ORACLE企业管理器 EM)来源:oracle86中文网原创 作者:鸽子简要流程:1、...
  • litepos
  • litepos
  • 2011年05月05日 14:55
  • 4465

Oracle学习笔记:图形管理工具 EM 的使用

Oracle学习笔记只常用工具的使用-EM 图形管理工具 em 服务器端 1 保证侦听启动----->grid lsnrctl status 或者 netstat -tunlp |gr...
  • pzasdq
  • pzasdq
  • 2016年01月11日 00:06
  • 338

EM12c_Oracle数据中心数据库管理方案

  • 2015年06月13日 20:24
  • 4.92MB
  • 下载

oracle 手动配置EM(web数据库管理端)

  • 2014年12月16日 13:44
  • 296KB
  • 下载
内容举报
返回顶部
收藏助手
不良信息举报
您举报文章:oracle EM 管理以及诊断 总结
举报原因:
原因补充:

(最多只允许输入30个字)