OEM出错，提示找不到资源

ighack

执行emca -config dbcontrol db以后有提示说
警告: 启动 Database Control 时出错。请执行以下命令。

1) 将环境变量 ORACLE_UNQNAME 设置为 数据库的唯一名称
2) /opt/oracle/product/11.2.0/dbhome_1/bin/emctl start dbconsole
但是我设置过.bash_profile

set ORACLE_UNQNAME=igorcl
export ORACLE_UNQNAME
手动也不行啊

emctl start dbconsole 提示失败
下面是一些日志信息
2013-07-31 10:13:18,987 Thread-1573947136 Starting Agent 10.2.0.4.2 from /opt/oracle/product/11.2.0/dbhome_1 (00701)
2013-07-31 10:13:19,312 Thread-1573947136 [Oracle Exadata Storage Server] InstanceProperty (MgmtIPAddr2) is marked OPTIONAL but is being used (00506)
2013-07-31 10:13:19,732 Thread-1573947136 [Load Balancer Switch] InstanceProperty (snmpTimeout) is marked OPTIONAL but is being used (00506)
2013-07-31 10:13:23,326 Thread-1573947136 EMAgent started successfully (00702)



aq_msgs_persistentq_per_subscriber
2013-07-31 10:13:23,237 Thread-1573947136 WARN  collector: the column name first_message_age in this condition does not exist in metric aq_msgs_persistentq_per_subscriber
2013-07-31 10:13:23,342 Thread-1436780288 WARN  http: nmehl_connect_internal: connect failed to (localhost:115: 拒绝连接 (error = 111)
2013-07-31 10:13:23,342 Thread-1436780288 ERROR pingManager: nmepm_pingReposURL: Cannot connect to https://localhost:1158/em/upload/: retStatus=-1
2013-07-31 10:13:23,342 Thread-1436780288 WARN  http: nmehl_connect_internal: connect failed to (localhost:115: 拒绝连接 (error = 111)
2013-07-31 10:13:23,342 Thread-1436780288 ERROR pingManager: nmepm_pingReposURL: Cannot connect to https://localhost:1158/em/upload/: retStatus=-1


maxRowCount.pl: Wed Jul 31 10:13:20 2013: ERROR:  Max Count Value not set properly in file /opt/oracle/product/11.2.0/dbhome_1/sysman/config/esa/instance.properties line no. 69
maxRowCount.pl: Wed Jul 31 10:13:20 2013: ERROR:  Max Count Value not set properly in file /opt/oracle/product/11.2.0/dbhome_1/sysman/config/esa/database.properties line no. 2

----- Wed Jul 31 10:13:27 2013:: Checking status of DBConsole : 10099 -----
----- Wed Jul 31 10:13:27 2013:: DBConsole exited at Wed Jul 31 10:13:27 2013 with return value 7. -----
----- Wed Jul 31 10:13:27 2013:: Restarting DBConsole. -----
----- Wed Jul 31 10:13:27 2013:: Console Launched with PID 10296 at time Wed Jul 31 10:13:27 2013 -----
----- Wed Jul 31 10:13:27 2013:: osname is linux -----
----- Wed Jul 31 10:13:27 2013:: heap size used is 384M -----
----- Wed Jul 31 10:13:27 2013:: perm size used is 400M -----
----- Wed Jul 31 10:13:27 2013:: joptions used are -server -Xmx384M -XX:MaxPermSize=400M -XX:MinHeapFreeRatio=20 -XX:MaxHeapFreeRatio=40  -----
13/07/31 10:13:37 启动 ORMI 服务器 localhost.ighack 端口 5,520: 地址已在使用 时出错
13/07/31 10:13:37 Shutting down OC4J...

5520这个端口好像是ORACLE的java进程

www_xylove

碰到这种情况，一般是重建EM

ighack

我重建了数据库，还是这样

www_xylove

重建数据库的时候，SID的值设置为大写，看看。

ighack

我重建了数据库，SID我也改为了大写，还是报错

2013-07-31 10:13:23,237 Thread-1573947136 WARN  collector: the column name first_message_age in this condition does not exist in metric aq_msgs_persistentq_per_subscriber


maxRowCount.pl: Wed Jul 31 10:13:20 2013: ERROR:  Max Count Value not set properly in file /opt/oracle/product/11.2.0/dbhome_1/sysman/config/esa/instance.properties line no. 69

ighack

解决了，不要随便更改$ORACLE_HOME/bin中的emctl等文件，不要因为中乱码的问题去改成自己安装的$JAVA_HOME，虽然可以解决中文问题但是会出现别的问题，还是用$ORACLE_HOME中的jdk这个路径
中文问题这样解决

复制 zysong.ttf 到 $ORACLE_HOME/jdk/jre/lib/fonts/fallback/
感觉可以用任何一个中文字体