oracle 突然报12505错误,一台机子两个实例问题，另外一个实例启动不了报ORA-12505错误－－急！...

一台机子两个实例问题，另外一个实例启动不了－－急！一台机子两个实例名分别为TEST 和EXC

现在用TEST可以正常使用，EXC用不了报ORA-12505错误

$ export ORACLE_SID=EXC

$ sqlplus /nolog

SQL*Plus: Release 9.2.0.7.0 - Production on Tue Aug 5 10:35:42 2008

Copyright (c) 1982, 2002, Oracle Corporation.  All rights reserved.

SQL> conn sys/sys@exc as sysdba;

ERROR:

ORA-12505: TNS:listener could not resolve SID given in connect descriptor

SQL>

用lsnrctl status查看结果如下：

$ lsnrctl status

LSNRCTL for IBM/AIX RISC System/6000: Version 9.2.0.7.0 - Production on 05-AUG-2008 10:32:38

Copyright (c) 1991, 2002, Oracle Corporation.  All rights reserved.

Connecting to (ADDRESS=(PROTOCOL=tcp)(PORT=1521))

STATUS of the LISTENER

------------------------

Alias                     LISTENER

Version                   TNSLSNR for IBM/AIX RISC System/6000: Version 9.2.0.7.0 - Production

Start Date                05-AUG-2008 10:18:06

Uptime                    0 days 0 hr. 14 min. 31 sec

Trace Level               off

Security                  OFF

SNMP                      OFF

Listener Parameter File   /opt/oracle/product/9.2.0/network/admin/listener.ora

Listener Log File         /opt/oracle/product/9.2.0/network/log/listener.log

Listening Endpoints Summary...

(DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=oadb)(PORT=1521)))

Services Summary...

Service "test" has 1 instance(s).

Instance "test", status READY, has 1 handler(s) for this service...

Service "testXDB" has 1 instance(s).

Instance "test", status READY, has 1 handler(s) for this service...

The command completed successfully