用VMWARE在OEL 5下装的11g r2 单机版ASM数据库,
其他一切搞定,就是EM启动不了,看em的提示信息貌似是listener的问题,
但是我看listener是成功注册的。
[oracle@localhost bin]$ lsnrctl status
LSNRCTL for Linux: Version 11.2.0.1.0 - Production on 22-OCT-2009 00:51:53
Copyright (c) 1991, 2009, Oracle.All rights reserved.
Connecting to (ADDRESS=(PROTOCOL=tcp)(HOST=)(PORT=1521))
STATUS of the LISTENER
------------------------
Alias
LISTENER
Version
TNSLSNR for Linux: Version 11.2.0.1.0 - Production
Start Date
21-OCT-2009 23:56:33
Uptime
0 days 0 hr. 55 min. 20 sec
Trace Level
off
Security
ON: Local OS Authentication
SNMP
OFF
Listener Parameter File /u01/app/oracle/product/11.2.0/grid/network/admin/listener.ora
Listener Log File /u01/app/oracle/diag/tnslsnr/localhost/listener/alert/log.xml
Listening Endpoints Summary...
(DESCRIPTION=(ADDRESS=(PROTOCOL=ipc)(KEY=EXTPROC1521)))
(DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=localhost.localdomain)(PORT=1521)))
Services Summary...
Service "+ASM" has 1 instance(s).
Instance "+ASM", status READY, has 1 handler(s) for this service...
Service "DB11GXDB.localdomain" has 1 instance(s).
Instance "DB11G", status READY, has 1 handler(s) for this service...
Service "orcl.localdomain" has 1 instance(s).
Instance "DB11G", status READY, has 1 handler(s) for this service...
The command completed successfully
sqlplus也可以顺利登入。
[oracle@localhost bin]$ sqlplus scott/tiger@db11g
SQL*Plus: Release 11.2.0.1.0 Production on Thu Oct 22 00:52:38 2009
Copyright (c) 1982, 2009, Oracle.All rights reserved.
Connected to:
Oracle Database 11g Enterprise Edition Release 11.2.0.1.0 - Production
With the Partitioning, Automatic Storage Management, OLAP, Data Mining
and Real Application Testing options
SQL>
尝试启动EM
[oracle@localhost bin]$ emctl start dbconsole
Environment variable ORACLE_UNQNAME not defined. Please set ORACLE_UNQNAME to database unique name.
[oracle@localhost bin]$ export ORACLE_UNQNAME=DB11G
[oracle@localhost bin]$ emctl start dbconsole
OC4J Configuration issue. /u01/app/oracle/product/11.2.0/db_1/oc4j/j2ee/OC4J_DBConsole_local.localdomain_DB11G not found.
尝试使用 emca重新配置
[oracle@localhost bin]$ emca -config dbcontrol db -repos recreate
STARTED EMCA at Oct 22, 2009 12:18:37 AM
EM Configuration Assistant, Version 11.2.0.0.2 Production
Copyright (c) 2003, 2005, Oracle.All rights reserved.
Enter the following information:
Database SID: DB11G
Listener port number: 1521
Listener ORACLE_HOME [ /u01/app/oracle/product/11.2.0/grid ]:
Password for SYS user: oracle
Password for DBSNMP user: oracle
Password for SYSMAN user: oracle
Password for SYSMAN user: Email address for notifications (optional):
Outgoing Mail (SMTP) server for notifications (optional):
ASM ORACLE_HOME [ /u01/app/oracle/product/11.2.0/grid ]:
ASM SID [ +ASM ]:
ASM port [ 1521 ]:
ASM username [ ASMSNMP ]:
ASM user password: oracle
-----------------------------------------------------------------
You have specified the following settings
Database ORACLE_HOME ................ /u01/app/oracle/product/11.2.0/db_1
Local hostname ................ local.localdomain
Listener ORACLE_HOME ................ /u01/app/oracle/product/11.2.0/grid
Listener port number ................ 1521
Database SID ................ DB11G
Email address for notifications ...............
Outgoing Mail (SMTP) server for notifications ...............
ASM ORACLE_HOME ................ /u01/app/oracle/product/11.2.0/grid
ASM SID ................ +ASM
ASM port ................ 1521
ASM user role ................ SYSDBA
ASM username ................ ASMSNMP
-----------------------------------------------------------------
Do you wish to continue? [yes(Y)/no(N)]: yes
Oct 22, 2009 12:19:19 AM oracle.sysman.emcp.EMConfig perform
INFO: This operation is being logged at /u01/app/oracle/cfgtoollogs/emca/orcl/emca_2009_10_22_00_18_37.log.
Oct 22, 2009 12:20:22 AM oracle.sysman.emcp.EMConfig perform
SEVERE: Listener is not up or database service is not registered with it. Start the Listener and register database service and run EM Configuration Assistant again .
Refer to the log file at /u01/app/oracle/cfgtoollogs/emca/orcl/emca_2009_10_22_00_18_37.log for more details.
Could not complete the configuration. Refer to the log file at /u01/app/oracle/cfgtoollogs/emca/orcl/emca_2009_10_22_00_18_37.log for more details.
把LOG贴上来给大家看看,实在不行的话,只能格式化重装了。。。
|