Oracle EM 无法打开

如下，还未知什么原因造成，探索中。。。

[oradm@szdb ~]$ emctl status dbconsole;
Oracle Enterprise Manager 11g Database Control Release 11.2.0.2.0 
Copyright (c) 1996, 2010 Oracle Corporation.  All rights reserved.

Oracle Enterprise Manager 11g is running. 
------------------------------------------------------------------
Logs are generated in directory /oradm/11.2.0/dm_DM/sysman/log 
[oradm@szdb ~]$ emctl stop dbconsole
Oracle Enterprise Manager 11g Database Control Release 11.2.0.2.0 
Copyright (c) 1996, 2010 Oracle Corporation.  All rights reserved.

Stopping Oracle Enterprise Manager 11g Database Control ... 
 ...  Stopped. 
[oradm@szdb ~]$ emctl start dbconsole
Oracle Enterprise Manager 11g Database Control Release 11.2.0.2.0 
Copyright (c) 1996, 2010 Oracle Corporation.  All rights reserved.

Starting Oracle Enterprise Manager 11g Database Control ....... started. 
------------------------------------------------------------------
Logs are generated in directory /oradm/11.2.0/dm_DM/sysman/log 
[oradm@szdb ~]$ cd /oradm/11.2.0/dm_DM/sysman/log/
[oradm@szdb log]$ ls
emagentfetchlet.log  emagent.trc    emagent.trc.4  emdctl.log   emoms.trc     emoms.trc.3  emoms.trc.7       pafLogs
emagentfetchlet.trc  emagent.trc.1  emctl.log      emdctl.trc   emoms.trc.1   emoms.trc.4  emoms.trc.8       patchAgtStPlugin.log
emagent.log          emagent.trc.2  emctl.msg      emoms.log    emoms.trc.10  emoms.trc.5  emoms.trc.9       secure.log
emagent_perl.trc     emagent.trc.3  emdb.nohup     emoms.log.1  emoms.trc.2   emoms.trc.6  nfsPatchPlug.log

[oradm@szdb log]$ tail emagent.log 
             (00104)
2013-07-04 14:14:20,003 Thread-362192112 Undefined column name __intervalinterval in expression ((msg_recv_act < _msg_recv_act) ? 0 : (msg_recv_act - _msg_recv_act))/__intervalinterval=%SID%)))
             (00104)
2013-07-04 14:14:20,677 Thread-362192112 [Load Balancer Switch] InstanceProperty (snmpTimeout) is marked OPTIONAL but is being used (00506)
2013-07-04 14:14:22,491 Thread-362192112 EMAgent started successfully (00702)
2013-07-04 14:14:22,535 Thread-1109002848 Exceeded Max allowed Upload data - No of files: 865, Size of upload data: 554.625534MB, Pct(%) of Disk used: 24.87%, Disabling collections (00852)
2013-07-04 14:14:22,552 Thread-1109002848 Disable collector (00406)
2013-07-04 14:16:25,965 Thread-1109002848 enable collector (00407)
2013-07-04 14:16:27,086 Thread-1098930784 Exceeded Max allowed Upload data - No of files: 871, Size of upload data: 563.198381MB, Pct(%) of Disk used: 24.87%, Disabling collections (00852)
2013-07-04 14:16:27,086 Thread-1098930784 Disable collector (00406)
[oradm@szdb log]$ tail emdctl.trc
2013-07-04 13:15:58,378 Thread-2464836896 WARN  http: nmehl_connect_internal: connect failed to (dm:5500): Connection refused (error = 111)
2013-07-04 13:16:00,459 Thread-2643774752 WARN  http: nmehl_connect_internal: connect failed to (dm:5500): Connection refused (error = 111)
2013-07-04 13:16:02,490 Thread-787029280 WARN  http: nmehl_connect_internal: connect failed to (dm:5500): Connection refused (error = 111)
2013-07-04 14:11:11,797 Thread-1439599904 WARN  http: nmehl_connect_internal: connect failed to (dm:5500): Connection refused (error = 111)
2013-07-04 14:11:14,057 Thread-2042371360 WARN  http: nmehl_connect_internal: connect failed to (dm:5500): Connection refused (error = 111)
2013-07-04 14:11:15,827 Thread-14814496 WARN  http: nmehl_connect_internal: connect failed to (dm:1830): Connection refused (error = 111)
2013-07-04 14:11:15,827 Thread-14814496 ERROR main: nmectla_agentctl: Error connecting to Returning status code 1
2013-07-04 14:14:22,008 Thread-2785684768 WARN  http: nmehl_connect_internal: connect failed to (dm:5500): Connection refused (error = 111)
2013-07-04 14:14:24,049 Thread-1133100320 WARN  http: nmehl_connect_internal: connect failed to (dm:5500): Connection refused (error = 111)
2013-07-04 14:14:26,090 Thread-4225588512 WARN  http: nmehl_connect_internal: connect failed to (dm:5500): Connection refused (error = 111)

-----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------

20130706 今天竟然发现用IE无法打开，用Firefox就可以了，真是奇怪了。

[oradm@szdb config]$ emctl stop dbconsole
[orames@szdb log]$ sqlplus "/ as sysdba"
SQL> select username,lock_date,account_status from dba_users;

USERNAME                       LOCK_DATE ACCOUNT_STATUS
------------------------------ --------- --------------------------------
MGMT_VIEW                                OPEN
SYS                                      OPEN
SYSTEM                                   OPEN
SYSMAN                                   OPEN
DM                                       OPEN
LCMDM                                    OPEN
DBSNMP                         06-JUL-13 LOCKED(TIMED)

SQL> alter user dbsnmp identified by oradm;
SQL> alter user SYSMAN identified by oradm;
SQL> alter user dbsnmp account unlock;

[oradm@szdb collection]$ emctl setpasswd dbconsole
Oracle Enterprise Manager 11g Database Control Release 11.2.0.2.0 
Copyright (c) 1996, 2010 Oracle Corporation.  All rights reserved.

Please enter new repository password:  <---输入oradm
Repository password successfully updated.

[oradm@szdb emd]$ cd /oradm/11.2.0/dm_DM/sysman/emd

[oradm@szdb emd]$ cp targets.xml targets.xml.20130706

[oradm@szdb emd]$ vi targets.xml

修改些列代码中：



用新的dbsnmp的密码代替上列password的Value值，ENCRYPTED的值修改成FALSE。

[oradm@szdb emd]$ emctl start dbconsole