本文共 5740 字,大约阅读时间需要 19 分钟。
从登录后,就会报‘Enterprise Manager 无法连接到数据库实例。下面列出了组件的状态.’,dbconsole重启也不管用。
数据库是正常的,并且安装的时候也没有报一个错误。
数据库正常
[root@oracle ~]# ps -ef | grep oraroot 3565 3533 0 21:17 pts/0 00:00:00 su - oracleoracle 3566 3565 0 21:17 pts/0 00:00:00 -bashoracle 3595 1 0 21:17 ? 00:00:01 ora_pmon_orcloracle 3597 1 0 21:17 ? 00:00:01 ora_psp0_orcloracle 3599 1 0 21:17 ? 00:00:01 ora_mman_orcloracle 3601 1 0 21:17 ? 00:00:01 ora_dbw0_orcloracle 3603 1 0 21:17 ? 00:00:02 ora_lgwr_orcloracle 3605 1 0 21:17 ? 00:00:04 ora_ckpt_orcloracle 3607 1 0 21:17 ? 00:00:09 ora_smon_orcloracle 3609 1 0 21:17 ? 00:00:00 ora_reco_orcloracle 3611 1 0 21:17 ? 00:00:02 ora_cjq0_orcloracle 3613 1 0 21:17 ? 00:00:05 ora_mmon_orcloracle 3615 1 0 21:17 ? 00:00:03 ora_mmnl_orcloracle 3617 1 0 21:17 ? 00:00:00 ora_d000_orcloracle 3619 1 0 21:17 ? 00:00:00 ora_s000_orcloracle 3623 1 0 21:17 ? 00:00:01 ora_arc0_orcloracle 3625 1 0 21:17 ? 00:00:01 ora_arc1_orcloracle 3629 1 0 21:17 ? 00:00:00 ora_qmnc_orcloracle 3635 1 0 21:18 ? 00:00:00 ora_q000_orcloracle 3639 1 0 21:18 ? 00:00:00 ora_q001_orcloracle 5108 3566 0 21:25 pts/0 00:00:00 sqlplus as sysdbaoracle 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.nohuporacle 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.xmloracle 6774 6212 1 21:30 pts/1 00:00:03 /opt/oracle/product/10.2.0/Database/bin/emagentoracle 7105 1 4 21:33 ? 00:00:01 ora_j000_orclroot 7116 5123 0 21:34 pts/1 00:00:00 grep ora[root@oracle ~]#em也启动了
[oracle@oracle log]$ emctl status dbconsoleTZ set to PRCOracle 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 startLSNRCTL 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.logListening on: (DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=oracle)(PORT=1521)))Connecting to (ADDRESS=(PROTOCOL=tcp)(HOST=)(PORT=1521))
STATUS of the LISTENER------------------------Alias LISTENERVersion TNSLSNR for Linux: Version 10.2.0.1.0 - ProductionStart Date 21-SEP-2007 21:34:48Uptime 0 days 0 hr. 0 min. 1 secTrace Level offSecurity ON: Local OS AuthenticationSNMP OFFListener Log File /opt/oracle/product/10.2.0/Database/network/log/listener.logListening Endpoints Summary...(DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=oracle)(PORT=1521)))The listener supports no servicesThe 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 NUMBERPASSWORD VARCHAR2(30)ACCOUNT_STATUS NOT NULL VARCHAR2(32)LOCK_DATE DATEEXPIRY_DATE DATEDEFAULT_TABLESPACE NOT NULL VARCHAR2(30)TEMPORARY_TABLESPACE NOT NULL VARCHAR2(30)CREATED NOT NULL DATEPROFILE 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 LOCKEDSQL> alter user sysman account unlock
2 /用户已更改。
==================================再次登入问题解决! 我察看了一下我的这几个用户都是open的。没有锁定。SQL> select username,account_status from dba_users;
USERNAME ACCOUNT_STATUS
------------------------------ --------------------------------MGMT_VIEW OPENSYS OPENSYSTEM OPENDBSNMP OPENSYSMAN OPEN其中的操作有重启dbconsole的,重启数据库,还重启过操作系统。呵呵,试了好多种方法。
在其他电脑上可以登录这个连接,登录正常。然后关闭我的ie浏览器重新登录后正常。我的这次的问题应该是和我的本机性能不够有点关系,还有ie记录了我的信息,造成我刷新都是一样的效果。
来自 “ ITPUB博客 ” ,链接:http://blog.itpub.net/312079/viewspace-245769/,如需转载,请注明出处,否则将追究法律责任。
转载于:http://blog.itpub.net/312079/viewspace-245769/