oracle 10g enterprise manager无法连接到数据库实例

最新推荐文章于 2021-04-15 21:00:24 发布

congsikuai0611

最新推荐文章于 2021-04-15 21:00:24 发布

阅读量130

点赞数

文章标签：数据库 java 网络

从http://oracle:1158/em登录后，就会报‘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.
http://oracle:1158/em/console/aboutApplication
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

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记录了我的信息，造成我刷新都是一样的效果。

来自 “ ITPUB博客 ” ，链接：http://blog.itpub.net/312079/viewspace-245769/，如需转载，请注明出处，否则将追究法律责任。

转载于:http://blog.itpub.net/312079/viewspace-245769/