oracle 10g enterprise manager無法連線到資料庫例項

從登入後，就會報‘Enterprise Manager 無法連線到資料庫例項。下面列出了元件的狀態.’，dbconsole重啟也不管用。

資料庫是正常的，並且安裝的時候也沒有報一個錯誤。

資料庫正常
[root@oracle ~]# ps -ef | grep ora
root 3565 3533 0 21:17 pts/0 00:00:00 su - oracle
oracle 3566 3565 0 21:17 pts/0 00:00:00 -bash
oracle 3595 1 0 21:17 ? 00:00:01 ora_pmon_orcl
oracle 3597 1 0 21:17 ? 00:00:01 ora_psp0_orcl
oracle 3599 1 0 21:17 ? 00:00:01 ora_mman_orcl
oracle 3601 1 0 21:17 ? 00:00:01 ora_dbw0_orcl
oracle 3603 1 0 21:17 ? 00:00:02 ora_lgwr_orcl
oracle 3605 1 0 21:17 ? 00:00:04 ora_ckpt_orcl
oracle 3607 1 0 21:17 ? 00:00:09 ora_smon_orcl
oracle 3609 1 0 21:17 ? 00:00:00 ora_reco_orcl
oracle 3611 1 0 21:17 ? 00:00:02 ora_cjq0_orcl
oracle 3613 1 0 21:17 ? 00:00:05 ora_mmon_orcl
oracle 3615 1 0 21:17 ? 00:00:03 ora_mmnl_orcl
oracle 3617 1 0 21:17 ? 00:00:00 ora_d000_orcl
oracle 3619 1 0 21:17 ? 00:00:00 ora_s000_orcl
oracle 3623 1 0 21:17 ? 00:00:01 ora_arc0_orcl
oracle 3625 1 0 21:17 ? 00:00:01 ora_arc1_orcl
oracle 3629 1 0 21:17 ? 00:00:00 ora_qmnc_orcl
oracle 3635 1 0 21:18 ? 00:00:00 ora_q000_orcl
oracle 3639 1 0 21:18 ? 00:00:00 ora_q001_orcl
oracle 5108 3566 0 21:25 pts/0 00:00:00 sqlplus as sysdba
oracle 5109 5108 0 21:25 ? 00:00:01 oracleorcl (DESCRIPTION=(LOCAL=YES)(ADDRESS=(PROTOCOL=beq)))
oracle 6212 1 0 21:28 pts/1 00:00:00 /opt/oracle/product/10.2.0/Database/perl/bin/perl /opt/oracle/product/10.2.0/Database/bin/emwd.pl dbconsole /opt/oracle/product/10.2.0/Database/oracle_orcl/sysman/log/emdb.nohup
oracle 6237 6212 16 21:29 pts/1 00:00:51 /opt/oracle/product/10.2.0/Database/jdk/bin/java -server -Xmx256M -XX:MaxPermSize=96m -XX:MinHeapFreeRatio=20 -XX:MaxHeapFreeRatio=40 -DORACLE_HOME=/opt/oracle/product/10.2.0/Database -Doracle.home=/opt/oracle/product/10.2.0/Database/oc4j -Doracle.oc4j.localhome=/opt/oracle/product/10.2.0/Database/oracle_orcl/sysman -DEMSTATE=/opt/oracle/product/10.2.0/Database/oracle_orcl -Doracle.j2ee.dont.use.memory.archive=true -Djava.protocol.handler.pkgs=HTTPClient -Doracle.security.jazn.config=/opt/oracle/product/10.2.0/Database/oc4j/j2ee/OC4J_DBConsole_oracle_orcl/config/jazn.xml -Djava.security.policy=/opt/oracle/product/10.2.0/Database/oc4j/j2ee/OC4J_DBConsole_oracle_orcl/config/java2.policy -Djava.security.properties=/opt/oracle/product/10.2.0/Database/oc4j/j2ee/home/config/jazn.security.props -DEMDROOT=/opt/oracle/product/10.2.0/Database/oracle_orcl -Dsysman.md5password=true -Drepapi.oracle.home=/opt/oracle/product/10.2.0/Database -Ddisable.checkForUpdate=true -Djava.awt.headless=true -jar /opt/oracle/product/10.2.0/Database/oc4j/j2ee/home/oc4j.jar -config /opt/oracle/product/10.2.0/Database/oc4j/j2ee/OC4J_DBConsole_oracle_orcl/config/server.xml
oracle 6774 6212 1 21:30 pts/1 00:00:03 /opt/oracle/product/10.2.0/Database/bin/emagent
oracle 7105 1 4 21:33 ? 00:00:01 ora_j000_orcl
root 7116 5123 0 21:34 pts/1 00:00:00 grep ora
[root@oracle ~]#

em也啟動了
[oracle@oracle log]$ emctl status dbconsole
TZ set to PRC
Oracle Enterprise Manager 10g Database Control Release 10.2.0.1.0
Copyright (c) 1996, 2005 Oracle Corporation. All rights reserved.

Oracle Enterprise Manager 10g is running.
------------------------------------------------------------------
Logs are generated in directory /opt/oracle/product/10.2.0/Database/oracle_orcl/sysman/log
[oracle@oracle log]$

監聽也正常，不過監聽起不起應該和em沒有關係呀
[oracle@oracle log]$ lsnrctl start

LSNRCTL for Linux: Version 10.2.0.1.0 - Production on 21-SEP-2007 21:34:47

Copyright (c) 1991, 2005, Oracle. All rights reserved.

Starting /opt/oracle/product/10.2.0/Database/bin/tnslsnr: please wait...

TNSLSNR for Linux: Version 10.2.0.1.0 - Production
Log messages written to /opt/oracle/product/10.2.0/Database/network/log/listener.log
Listening on: (DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=oracle)(PORT=1521)))

Connecting to (ADDRESS=(PROTOCOL=tcp)(HOST=)(PORT=1521))
STATUS of the LISTENER
------------------------
Alias LISTENER
Version TNSLSNR for Linux: Version 10.2.0.1.0 - Production
Start Date 21-SEP-2007 21:34:48
Uptime 0 days 0 hr. 0 min. 1 sec
Trace Level off
Security ON: Local OS Authentication
SNMP OFF
Listener Log File /opt/oracle/product/10.2.0/Database/network/log/listener.log
Listening Endpoints Summary...
(DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=oracle)(PORT=1521)))
The listener supports no services
The command completed successfully
[oracle@oracle log]$

itpub上面有朋友說這樣解決：
Enterprise Manager 無法連線到資料庫例項
SQL> conn
請輸入使用者名稱: sys as sysdba
已連線。
SQL> desc dba_users 發現該檢視無效。用D:oracleproduct10.2.0db_1RDBMSADMINsql.bsq 新建立user_astatus_map ， DBA_USERS .

SQL> desc dba_users

名稱 是否為空? 型別
----------------------------------------- -------- ----------------------------
USERNAME NOT NULL VARCHAR2(30)
USER_ID NOT NULL NUMBER
PASSWORD VARCHAR2(30)
ACCOUNT_STATUS NOT NULL VARCHAR2(32)
LOCK_DATE DATE
EXPIRY_DATE DATE
DEFAULT_TABLESPACE NOT NULL VARCHAR2(30)
TEMPORARY_TABLESPACE NOT NULL VARCHAR2(30)
CREATED NOT NULL DATE
PROFILE NOT NULL VARCHAR2(30)
INITIAL_RSRC_CONSUMER_GROUP VARCHAR2(30)
EXTERNAL_NAME VARCHAR2(4000)

SQL> select username,account_status from dba_users
2 where username='SYSMAN'
3 /

USERNAME ACCOUNT_STATUS
------------------------------ --------------------------------
SYSMAN LOCKED

SQL> alter user sysman account unlock
2 /

使用者已更改。
＝＝＝＝＝＝＝＝＝＝＝＝＝＝＝＝＝＝＝＝＝＝＝＝＝＝＝＝＝＝＝＝＝＝
再次登入問題解決！

我察看了一下我的這幾個使用者都是open的。沒有鎖定。

SQL> select username,account_status from dba_users;

USERNAME ACCOUNT_STATUS
------------------------------ --------------------------------
MGMT_VIEW OPEN
SYS OPEN
SYSTEM OPEN
DBSNMP OPEN
SYSMAN OPEN

其中的操作有重啟dbconsole的，重啟資料庫，還重啟過作業系統。呵呵，試了好多種方法。

在其他電腦上可以登入這個連線，登入正常。然後關閉我的ie瀏覽器重新登入後正常。

我的這次的問題應該是和我的本機效能不夠有點關係，還有ie記錄了我的資訊，造成我重新整理都是一樣的效果。