EM将配置数据上载到资料档案库出错
1. 默认OEM 连接:https://主机名:1158/em
启动:emctl start dbconsole
停止:emctl stop 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没有配置
解决:ORACLE_SID =orcl,ORACLE_HOME=D:\app\lgswork\product\11.2.0\dbhome_1
然后在cmd下设置
set ORACLE_SID=sid名称
然后
emctl stop dbconsole
emctl start dbconsole
drop user sysman cascade;
重启机器,并断开网络,关闭杀毒软件、防火墙,并删除失败记录,run -cmd-> emca -deconfig dbcontrol db -repos drop,一路输入密码后,显示成功删除。
2. 如果连接失败需要做以下配置:
重新配置dbconsole的步骤
emca -deconfig dbcontrol db -repos drop
emca -config dbcontrol db -repos create
emctl start dbconsole
如果过程中报错:
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
解决方案:
1. 关闭防火墙服务(在控制面板/系统工具/服务);
2. 配置HOSTS文件
127.0.0.1 localhost
172.16.1.37 主机名
3. 重新配置EM