浏览器输入地址http://******:5500/em打不开网页版的oem,但是isqlplus可以打开,登陆到服务器上emctl status dbconsole, 显示***is not running. 后emctl status dbconsole, 半天没有反应,不得已ctrl+c停止之。后又尝试多种办法,始终无效。最后只能选择recreate em 资料库(遇到一次,插上网线即恢复正常,不知何故?):
重建em资料库:
oracle@localhost ~]$ emctl status dbconsole
TZ set to PRC
OC4J Configuration issue. /oracle/10gR2/oc4j/j2ee/OC4J_DBConsole_localhost.localdomain_ora7p not found.
[oracle@localhost ~]$ emca -repos recreate
STARTED EMCA at Apr 22, 2008 1:44:54 PM
EM Configuration Assistant, Version 10.2.0.1.0 Production
Copyright (c) 2003, 2005, Oracle. All rights reserved.
Enter the following information:
Database SID: oratest
Listener port number: 1521
Password for SYS user:
Password for SYSMAN user:
Do you wish to continue? [yes(Y)/no(N)]: yes
Apr 22, 2008 1:45:15 PM oracle.sysman.emcp.EMConfig perform
INFO: This operation is being logged at /oracle/10gR2/cfgtoollogs/emca/oratest/emca_2008-04-22_01-44-54-PM.log.
Apr 22, 2008 1:45:15 PM oracle.sysman.emcp.EMReposConfig dropRepository
INFO: Dropping the EM repository (this may take a while) ...
Apr 22, 2008 1:46:37 PM oracle.sysman.emcp.EMReposConfig invoke
INFO: Repository successfully dropped
Apr 22, 2008 1:46:37 PM oracle.sysman.emcp.EMReposConfig createRepository
INFO: Creating the EM repository (this may take a while) ...
Apr 22, 2008 1:49:42 PM oracle.sysman.emcp.EMReposConfig invoke
INFO: Repository successfully created
Enterprise Manager configuration completed successfully
FINISHED EMCA at Apr 22, 2008 1:49:42 PM
[oracle@localhost ~]$ emca -config dbcontrol db
STARTED EMCA at Apr 22, 2008 1:52:21 PM
EM Configuration Assistant, Version 10.2.0.1.0 Production
Copyright (c) 2003, 2005, Oracle. All rights reserved.
Enter the following information:
Database SID: oratest
Listener port number: oratest
Invalid port.
Listener port number: 1521
Password for SYS user:
Password for DBSNMP user:
Password for SYSMAN user:
Email address for notifications (optional): terrychen@topfounder.com
Outgoing Mail (SMTP) server for notifications (optional): email.topfounder.com
------------------------------------------------------------------
之后再输入地址后就可以登陆了。[
You have specified the following settings
Database ORACLE_HOME ................ /oracle/10gR2
Database hostname ................ localhost.localdomain
Listener port number ................ 1521
Database SID ................ oratest
Email address for notifications ............... terry@com
Outgoing Mail (SMTP) server for notifications ............... email.top.com
-----------------------------------------------------------------
Do you wish to continue? [yes(Y)/no(N)]: y
Apr 22, 2008 1:53:29 PM oracle.sysman.emcp.EMConfig perform
INFO: This operation is being logged at /oracle/10gR2/cfgtoollogs/emca/oratest/emca_2008-04-22_01-52-21-PM.log.
Apr 22, 2008 1:53:36 PM oracle.sysman.emcp.util.DBControlUtil startOMS
INFO: Starting Database Control (this may take a while) ...
Apr 22, 2008 1:55:13 PM oracle.sysman.emcp.EMDBPostConfig performConfiguration
INFO: Database Control started successfully
Apr 22, 2008 1:55:13 PM oracle.sysman.emcp.EMDBPostConfig performConfiguration
INFO: >>>>>>>>>>> The Database Control URL is http://localhost.localdomain:1158/em <<<<<<<<<<<
Enterprise Manager configuration completed successfully
FINISHED EMCA at Apr 22, 2008 1:55:13 PM
---------------------------------------------------------
PS1:
Oracle10G的EM采用了web方式,并且分成了2个产品,database control和grid control。Grid control需要下载单独的光盘安装。在用DBCA建库的时候,可以选择是否启用dbcontrol,启用的话需要在数据库中建立一个sysman的schema,用于保存EM的一些数据,这个就是EM的资料库(repository)。使用命令行工具emca可以创建,修改,重建或者删除dbcontrol的配置。
由于要在数据库中建EM资料库,数据库和监听都必须已经启动并正常工作。
emca -repos create 创建一个EM资料库
emca -repos recreate 重建一个EM资料库
emca -repos drop 删除一个EM资料库
emca -config dbcontrol db
配置数据库的 Database Control
emca -deconfig dbcontrol db
删除数据库的 Database Control配置
emca -reconfig ports
重新配置db control和agent的端口
emctl start console
启动EM console服务,使用前需要先
设置ORACLE_SID环境变量
emctl stop console 停止EM console服务,
使用前需要先设置ORACLE_SID环境变量
注:通过查看$ORACLE_HOME/install/portlist.ini
文件可以知道当前dbcontrol正在使用的端口,
默认dbcontrol http端口1158,agent端口3938。
如果要重新配置端口,可以使用如下命令:
emca -reconfig ports -dbcontrol_http_port 1159
emca -reconfig ports -agent_port 3939 月落网
使用命令行工具emctl可以启动/停止console服务,察看服务状态等。
PS2:
eygle的几篇关于oem的文章:
如何在Oracle10g中启动和关闭OEM--->http://www.eygle.com/archives/2005/10/howto_control_10goem.html
oracle 10g em乱码之快速解决--->http://hi.baidu.com/terry%5Fsky/blog/item/79d6d7881ea0a491a5c2725c.html
PS3:
在linux 下
$ lsnrctl start; $ emctl start dbconsole ; $ isqlplusctl start ; startup 数据库Oracle10g OEM , isqlplus 管理默认端口等一些信息放在$ORACLE_HOME/install/portlist.ini
[oracle@localhost install]$ more portlist.ini
Enterprise Manager Console HTTP Port (whitney) = 1158
Enterprise Manager Agent Port (whitney) = 3938
Enterprise Manager Console HTTP Port (whitney) = 1158
Enterprise Manager Agent Port (whitney) = 3938
windows下找了一下没找到,下次找到了放到ps3中:)
重建em资料库:
oracle@localhost ~]$ emctl status dbconsole
TZ set to PRC
OC4J Configuration issue. /oracle/10gR2/oc4j/j2ee/OC4J_DBConsole_localhost.localdomain_ora7p not found.
[oracle@localhost ~]$ emca -repos recreate
STARTED EMCA at Apr 22, 2008 1:44:54 PM
EM Configuration Assistant, Version 10.2.0.1.0 Production
Copyright (c) 2003, 2005, Oracle. All rights reserved.
Enter the following information:
Database SID: oratest
Listener port number: 1521
Password for SYS user:
Password for SYSMAN user:
Do you wish to continue? [yes(Y)/no(N)]: yes
Apr 22, 2008 1:45:15 PM oracle.sysman.emcp.EMConfig perform
INFO: This operation is being logged at /oracle/10gR2/cfgtoollogs/emca/oratest/emca_2008-04-22_01-44-54-PM.log.
Apr 22, 2008 1:45:15 PM oracle.sysman.emcp.EMReposConfig dropRepository
INFO: Dropping the EM repository (this may take a while) ...
Apr 22, 2008 1:46:37 PM oracle.sysman.emcp.EMReposConfig invoke
INFO: Repository successfully dropped
Apr 22, 2008 1:46:37 PM oracle.sysman.emcp.EMReposConfig createRepository
INFO: Creating the EM repository (this may take a while) ...
Apr 22, 2008 1:49:42 PM oracle.sysman.emcp.EMReposConfig invoke
INFO: Repository successfully created
Enterprise Manager configuration completed successfully
FINISHED EMCA at Apr 22, 2008 1:49:42 PM
[oracle@localhost ~]$ emca -config dbcontrol db
STARTED EMCA at Apr 22, 2008 1:52:21 PM
EM Configuration Assistant, Version 10.2.0.1.0 Production
Copyright (c) 2003, 2005, Oracle. All rights reserved.
Enter the following information:
Database SID: oratest
Listener port number: oratest
Invalid port.
Listener port number: 1521
Password for SYS user:
Password for DBSNMP user:
Password for SYSMAN user:
Email address for notifications (optional): terrychen@topfounder.com
Outgoing Mail (SMTP) server for notifications (optional): email.topfounder.com
------------------------------------------------------------------
之后再输入地址后就可以登陆了。[
You have specified the following settings
Database ORACLE_HOME ................ /oracle/10gR2
Database hostname ................ localhost.localdomain
Listener port number ................ 1521
Database SID ................ oratest
Email address for notifications ............... terry@com
Outgoing Mail (SMTP) server for notifications ............... email.top.com
-----------------------------------------------------------------
Do you wish to continue? [yes(Y)/no(N)]: y
Apr 22, 2008 1:53:29 PM oracle.sysman.emcp.EMConfig perform
INFO: This operation is being logged at /oracle/10gR2/cfgtoollogs/emca/oratest/emca_2008-04-22_01-52-21-PM.log.
Apr 22, 2008 1:53:36 PM oracle.sysman.emcp.util.DBControlUtil startOMS
INFO: Starting Database Control (this may take a while) ...
Apr 22, 2008 1:55:13 PM oracle.sysman.emcp.EMDBPostConfig performConfiguration
INFO: Database Control started successfully
Apr 22, 2008 1:55:13 PM oracle.sysman.emcp.EMDBPostConfig performConfiguration
INFO: >>>>>>>>>>> The Database Control URL is http://localhost.localdomain:1158/em <<<<<<<<<<<
Enterprise Manager configuration completed successfully
FINISHED EMCA at Apr 22, 2008 1:55:13 PM
---------------------------------------------------------
PS1:
Oracle10G的EM采用了web方式,并且分成了2个产品,database control和grid control。Grid control需要下载单独的光盘安装。在用DBCA建库的时候,可以选择是否启用dbcontrol,启用的话需要在数据库中建立一个sysman的schema,用于保存EM的一些数据,这个就是EM的资料库(repository)。使用命令行工具emca可以创建,修改,重建或者删除dbcontrol的配置。
由于要在数据库中建EM资料库,数据库和监听都必须已经启动并正常工作。
emca -repos create 创建一个EM资料库
emca -repos recreate 重建一个EM资料库
emca -repos drop 删除一个EM资料库
emca -config dbcontrol db
配置数据库的 Database Control
emca -deconfig dbcontrol db
删除数据库的 Database Control配置
emca -reconfig ports
重新配置db control和agent的端口
emctl start console
启动EM console服务,使用前需要先
设置ORACLE_SID环境变量
emctl stop console 停止EM console服务,
使用前需要先设置ORACLE_SID环境变量
注:通过查看$ORACLE_HOME/install/portlist.ini
文件可以知道当前dbcontrol正在使用的端口,
默认dbcontrol http端口1158,agent端口3938。
如果要重新配置端口,可以使用如下命令:
emca -reconfig ports -dbcontrol_http_port 1159
emca -reconfig ports -agent_port 3939 月落网
使用命令行工具emctl可以启动/停止console服务,察看服务状态等。
PS2:
eygle的几篇关于oem的文章:
如何在Oracle10g中启动和关闭OEM--->http://www.eygle.com/archives/2005/10/howto_control_10goem.html
oracle 10g em乱码之快速解决--->http://hi.baidu.com/terry%5Fsky/blog/item/79d6d7881ea0a491a5c2725c.html
PS3:
在linux 下
$ lsnrctl start; $ emctl start dbconsole ; $ isqlplusctl start ; startup 数据库Oracle10g OEM , isqlplus 管理默认端口等一些信息放在$ORACLE_HOME/install/portlist.ini
[oracle@localhost install]$ more portlist.ini
Enterprise Manager Console HTTP Port (whitney) = 1158
Enterprise Manager Agent Port (whitney) = 3938
Enterprise Manager Console HTTP Port (whitney) = 1158
Enterprise Manager Agent Port (whitney) = 3938
windows下找了一下没找到,下次找到了放到ps3中:)