- 论坛徽章:
- 0
|
操作系统 redhat as5.3 32bit
数据库 oracle10g
第一次安装完成的时候, 还可以在本机打开 em , 可以登录sys 帐号.
现在打开em , 完全没有反应, 没有任何提示. 就是网页打不开.
em的服务可能没有开启, 无法drop,也无法create,
[oracle@reda ~]$ 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.
[oracle@reda ~]$
[oracle@reda ~]$ 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用户登录的.
[oracle@reda ~]$ 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(Y) (N)]: 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 NO ACTIVE PRIMARY_INSTANCE NORMAL NO
SQL> select * from v$tablespace;
TS# NAME INC BIG FLA ENC
---------- ------------------------------ --- --- --- ---
0 SYSTEM YES NO YES
1 UNDOTBS1 YES NO YES
2 SYSAUX YES NO YES
4 USERS YES NO YES
3 TEMP NO NO YES
6 EXAMPLE YES NO YES
6 rows selected.
SQL> |
|