ORACLE OEM

默认OEM 连接：https://主机名:1158/em

启动：emctl start dbconsole

停止：emctl stop dbconsole

check: emctl status dbconsole

启动时报错：

TZ set to America/New_york
OC4J Configuration issue ./u01/app/oracle/product/10.1.0/db_1/oc4j/j2ee/OC4J_DBConsole_orcl.us.oracle.com not found

原因：环境变量ORACLE_SID / ORACLE_HOME没有配置

错误二：因为修改操作系统的时区

解决方案：

emctl stop agent
emctl status agent
emctl resetTZ agent

Login via sqlplus as sysman

exec mgmt_target.set_agent_tzrgn( oracle-ga:39382, Europe/Ljubljana )

commit;

restart EM

Pasted from: <http://www.experts-exchange.com/Database/Oracle/Q_24364706.html>

重新配置dbconsole的步骤

1. restart server;

2. unlock account sysmansql>alter user sysman account unlock;

3. delete the settingemca -deconfig dbcontrol db -repos drop

4. rebuild the setting emca -config dbcontrol db -repos create

Check the log file during the rebuild: C:\oracle\cfgtoollogs\emca\<sid>

如果过程中报错：

1. ORA-20001: SYSMAN already exists..

需先执行：
SQL> drop user sysman cascade;
SQL> drop role MGMT_USER;
SQL> drop user MGMT_VIEW cascade;
SQL> drop public synonym MGMT_TARGET_BLACKOUTS;
SQL> drop public synonym SETEMVIEWUSERCONTEXT;
再执行：重新配置dbconsole的步骤

2. 如果连接进入OEM界面后，显示无法连接数据库实例。

需要修改hosts文件。

设置要查询的实例：set oracle_sid=demo
启动：      emctl start dbconsole
停止：      emctl stop dbconsole
查看状态：    emctl status dbconsole

日志：      $ORACLE_HOME/SERVER_NAME_$ORACLE_SID/sysman/log

3. 配置: 将配置数据上载到资料档案库时出错

日志内容：
oracle.sysman.emdrep.config.ConfigurationException: FATAL Configuration Exceptions

 at oracle.sysman.emdrep.config.EMSchemaConfiguration.perform(EMSchemaConfiguration.java:232)
 at oracle.sysman.emcp.EMReposConfig.uploadConfigDataToRepository(EMReposConfig.java:699)
 at oracle.sysman.emcp.EMReposConfig.invoke(EMReposConfig.java:385)
 at oracle.sysman.emcp.EMReposConfig.invoke(EMReposConfig.java:158)
 at oracle.sysman.emcp.EMConfig.perform(EMConfig.java:253)
 at oracle.sysman.emcp.EMConfigAssistant.invokeEMCA(EMConfigAssistant.java:590)
 at oracle.sysman.emcp.EMConfigAssistant.performConfiguration(EMConfigAssistant.java:1453)
 at oracle.sysman.emcp.EMConfigAssistant.statusMain(EMConfigAssistant.java:574)
 at oracle.sysman.emcp.EMConfigAssistant.main(EMConfigAssistant.java:522)

出现问题系统：windows 2008 standard server r2 x64

解决方案：

a. 关闭防火墙服务（在控制面板/系统工具/服务）；

b. 配置HOSTS文件

127.0.0.1       localhost

172.16.1.37   主机名

c. 重新配置EM

4. job_queue_processes oracle.sysman.emcp.exception.EMConfigException: 'job_queue_processes' must be greater than or equal to 1.  Fix the error(s) and run EM Configuration Assistant again in standalone mode.
at oracle.sysman.emcp.DatabaseChecks.performReposChecks(DatabaseChecks.java:456)
at oracle.sysman.emcp.EMDBPreConfig.checkRepositoryConfiguration(EMDBPreConfig.java:3207)
at oracle.sysman.emcp.EMDBPreConfig.invoke(EMDBPreConfig.java:220)
at oracle.sysman.emcp.EMDBPreConfig.invoke(EMDBPreConfig.java:198)
at oracle.sysman.emcp.EMConfig.perform(EMConfig.java:250)
at oracle.sysman.emcp.EMConfigAssistant.invokeEMCA(EMConfigAssistant.java:599)
at oracle.sysman.emcp.EMConfigAssistant.performConfiguration(EMConfigAssistant.java:1482)
at oracle.sysman.emcp.EMConfigAssistant.statusMain(EMConfigAssistant.java:583)

at oracle.sysman.emcp.EMConfigAssistant.main(EMConfigAssistant.java:529)

solution: change the value of parameter job_queue_processes (default value is 0)

alter system set job_queue_processes=10;

5. Time zone issue

If the operation system is windows server 2003, it may have time zone issue, which may impact the OEM.

The time of operation system and database is different.

oracle check time zone: emctl config agent getTZ / emctl resetTZ agent / emctl config agent updateTZ

1. Therefore You need to check about the time zone of operation system and database. Make sure they are the same.

2. Install windows update KB 933360 to solve the daylight time zone issue of operation system.

将数据库监控从grid control搬迁到database control

 

1. 将数据库从Grid control中去掉
a. 在数据库服务器上停止Agent服务； 
b. 在Grid control网页中去掉数据库.

2. 配置Database control:
a. 输入命令启动，停止database control 
start：emctl start dbconsole
stop：emctl stop dbconsole

b. 报错，就只能重建database control：
emca -deconfig dbcontrol db -repos drop 
emca -config dbcontrol db -repos create 
emctl start dbconsole

 

OEM创建正常，但是无法启动：

ORACLE VERSION: 10.2.0.4.0

OS VERSION: windows 2003 server / windows 2008 server

 

解决方案：打ORACLE补丁 8350262

cd $ORACLE_HOME\opatch\

opatch apply h:\temp\8350262

OEM performance tab unavailable

Solution:

Try logging into your OEM again.
Then go to 'setup' in your upper right corner.
Once in the setup screen, go to the left border menu and select "Management Pack Access".
Take a look if you have a check in the box for 'Database Diagnostic', and one for 'Database Tuning'

Pasted from: <https://community.oracle.com/thread/1020435?tstart=0>