wfjabcd 发表于 2010-12-20 17:50

em 无法打开的问题

操作系统 redhat as5.3 32bit
数据库 oracle10g
第一次安装完成的时候, 还可以在本机打开 em, 可以登录sys 帐号.

现在打开em , 完全没有反应, 没有任何提示. 就是网页打不开.

em的服务可能没有开启, 无法drop,也无法create,

$ emctl status dbconsole
TZ set to PRC
perl: warning: Setting locale failed.
perl: warning: Please check that your locale settings:
        LANGUAGE = (unset),
        LC_ALL = (unset),
        LC_CTYPE = "en",
        LANG = (unset)
    are supported and installed on your system.
perl: warning: Falling back to the standard locale ("C").
OC4J Configuration issue. /home/oracle/oracle/product/10.2.0 _1/oc4j/j2ee/OC4J_DBConsole_reda_p1 not found.
$

$ emca -config dbcontrol db -repos create

STARTED EMCA at Dec 20, 2010 3:37:59 PM
EM Configuration Assistant, Version 10.2.0.1.0 Production
Copyright (c) 2003, 2005, Oracle.All rights reserved.

Enter the following information:
Database SID: p1
Listener port number: 1523
Password for SYS user:
Password for DBSNMP user:
Password for DBSNMP user:
Password for DBSNMP user: Invalid username/password.
Invalid username/password.
在重建的时候,输入dbsnmp用户密码的时候,一直说密码不对,实际上,密码是对的,可以使用dbsnmp用户登录的.

$ emca -deconfig dbcontrol db -repos drop

STARTED EMCA at Dec 20, 2010 5:10:57 PM
EM Configuration Assistant, Version 10.2.0.1.0 Production
Copyright (c) 2003, 2005, Oracle.All rights reserved.

Enter the following information:
Database SID: p1
Database SID: Listener port number: 1158
Password for SYS user:
Password for SYSMAN user:

Do you wish to continue? : yes
Dec 20, 2010 5:12:52 PM oracle.sysman.emcp.EMConfig perform
INFO: This operation is being logged at /home/oracle/oracle/product/10.2.0 _1/cfgtoollogs/emca/emca_2010-12-20_05-10-56-PM.log.
Dec 20, 2010 5:12:53 PM oracle.sysman.emcp.EMConfig perform
SEVERE: Database instance unavailable.
Refer to the log file at /home/oracle/oracle/product/10.2.0 _1/cfgtoollogs/emca/emca_2010-12-20_05-10-56-PM.log for more details.
Could not complete the configuration. Refer to the log file at /home/oracle/oracle/product/10.2.0 _1/cfgtoollogs/emca/emca_2010-12-20_05-10-56-PM.log for more details.

这里有提示说实例不可用, 但不明白为什么不可用,


SQL> select * from v$instance;

INSTANCE_NUMBER INSTANCE_NAME
--------------- ----------------
HOST_NAME
----------------------------------------------------------------
VERSION           STARTUP_T STATUS       PAR        THREAD# ARCHIVE LOG_SWITCH_WAIT
----------------- --------- ------------ --- ---------- ------- ---------------
LOGINS           SHU DATABASE_STATUS       INSTANCE_ROLE          ACTIVE_ST BLO
---------- --- ----------------- ------------------ --------- ---
              1 p1
reda
10.2.0.1.0          20-DEC-10 OPEN       NO              1 STOPPED
ALLOWED    NOACTIVE               PRIMARY_INSTANCE   NORMAL    NO


SQL> select * from v$tablespace;   

       TS# NAME                           INC BIG FLA ENC
---------- ------------------------------ --- --- --- ---
       0 SYSTEM                          YES NOYES
       1 UNDOTBS1                          YES NOYES
       2 SYSAUX                          YES NOYES
       4 USERS                          YES NOYES
       3 TEMP                           NONOYES
       6 EXAMPLE                          YES NOYES

6 rows selected.

SQL>

renxiao2003 发表于 2010-12-20 20:01

怎么打不开了啊。

wfjabcd 发表于 2010-12-21 11:09

回复 1# wfjabcd


    刚装上数据库的时候,EM 可以进的, 当时用sys 登录进去过的, 后来因为还有些配置没有设好, 就一直调来调去的, 现在其他的弄好了, 发现em打不开了, 打开网页什么都没有, 没有什么提示.

renxiao2003 发表于 2010-12-21 11:12

回复 3# wfjabcd


    1158端口开了吗？

ilsyx 发表于 2010-12-21 11:38

/home/oracle/oracle/product/10.2.0 _1/cfgtoollogs/emca/emca_2010-12-20_05-10-56-PM.log

这个日志的详细内容是什么呢?　instance不可用?　　

wfjabcd 发表于 2010-12-21 16:12

回复 5# ilsyx


    1158 开的, 那个日志里面写的也是 实例不可用.

duolanshizhe 发表于 2010-12-23 11:18

重建下em

yukonboy 发表于 2010-12-23 17:10

运行以下语句，重新建立em
1.emca -deconfig dbcontrol db
2. emca -repos drop
3. emca -repos create
4. emca -config dbcontrl db

我在我的数据库上可以开启成功的，祝你成功！

laoadiy 发表于 2013-02-25 15:15

我重新建立emca -config dbcontrol db一直提示DBSNMP用户的密码不对回复 8# yukonboy


   
页: [1]
查看完整版本: em 无法打开的问题