一台机子两个实例问题,另外一个实例启动不了报ORA-12505错误--急!
一台机子两个实例问题,另外一个实例启动不了--急!一台机子两个实例名分别为TEST 和EXC现在用TEST可以正常使用,EXC用不了报ORA-12505错误
$ export ORACLE_SID=EXC
$ sqlplus /nologSQL*Plus: Release 9.2.0.7.0 - Production on Tue Aug 5 10:35:42 2008Copyright (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 statusLSNRCTL for IBM/AIX RISC System/6000: Version 9.2.0.7.0 - Production on 05-AUG-2008 10:32:38Copyright (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
一台机子两个实例问题,另外一个实例启动不了--急!一台机子两个实例名分别为TEST 和EXC现在用TEST可以正常使用,EXC用不了报ORA-12505错误
$ export ORACLE_SID=EXC
$ sqlplus /nologSQL*Plus: Release 9.2.0.7.0 - Production on Tue Aug 5 10:35:42 2008Copyright (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 statusLSNRCTL for IBM/AIX RISC System/6000: Version 9.2.0.7.0 - Production on 05-AUG-2008 10:32:38Copyright (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
解决方案 »
- 关于Oracle的数据统计
- 基础提问: oracle锁表(LOCK TABLE wq IN EXCLUSIVE MODE)后,网线断后,发现表还是一直锁着。。
- 这段语句谁能说一下
- 请高手执教,如何使用pro c/c++
- 在oracle里有没有像foxpro中的那样编程输入编中各项的
- 在ADO.Net中如何实验一个函数同时往两个表中插入数据
- 急,在线等,关于Oracle Management Server的问题
- 请问哪里有TOAD工具下载,以及下载的后的注册码是多少啊?
- 请教简单的SQL问题
- CentOS7上安装Oracle12c问题
- UNDOTBS01.DBF太大的问题
- 为什么oracle有些系统package看不了代码
从你的操作看tnsname.ora中exc没有设置或者设置不对。执行:tnsping exc 应该会报错的,如果你配对了,就不保错了。
Used TNSNAMES adapter to resolve the alias
Attempting to contact (DESCRIPTION = (ADDRESS_LIST = (ADDRESS = (PROTOCOL = TCP)(HOST = oadb)(PORT = 1521))) (CONNECT_DATA = (SID = exc) (SERVER = DEDICATED)))
OK (150 msec)
$
# TNSNAMES.ORA Network Configuration File: /opt/oracle/product/9.2.0/network/admin/tnsnames.ora
# Generated by Oracle configuration tools.TEST_OADB =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = oadb)(PORT = 1521))
)
(CONNECT_DATA =
(SID = test)
(SERVER = DEDICATED)
)
)
TEST =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = oadb)(PORT = 1521))
)
(CONNECT_DATA =
(SID = test)
(SERVER = DEDICATED)
)
)EXC =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = oadb)(PORT = 1521))
)
(CONNECT_DATA =
(SID = exc)
(SERVER = DEDICATED)
)
)
$ 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 as sysdba
不能conn sys/sys@exc as sysdba;