请教高手tnsnames.ora和listener.ora配置问题
请教高手tnsnames.ora和listener.ora配置问题
我在本机创建了两个数据库实例：appdb和rman。
listener.ora的配置内容为：
# listener.ora Network Configuration File: D:\oracle\product\10.2.0\db_1\network\admin\listener.ora
# Generated by Oracle configuration tools.
SID_LIST_LISTENER =
(SID_LIST =
(SID_DESC =
(SID_NAME = PLSExtProc)
(ORACLE_HOME = D:\oracle\product\10.2.0\db_1)
(PROGRAM = extproc)
)
)
LISTENER =
(DESCRIPTION_LIST =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = TCP)(HOST = 192.168.1.101)(PORT = 1521))
(ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC0))
)
)
tnsnames.ora的配置内容为：
# tnsnames.ora Network Configuration File: D:\oracle\product\10.2.0\db_1\network\admin\tnsnames.ora
# Generated by Oracle configuration tools.
RMAN =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = TCP)(HOST = 192.168.1.101)(PORT = 1521))
(CONNECT_DATA =
(SERVER = DEDICATED)
(SERVICE_NAME = rman)
)
)
APPDB=
(DESCRIPTION =
(ADDRESS = (PROTOCOL = TCP)(HOST = 192.168.1.101)(PORT = 1521))
(CONNECT_DATA =
(SERVER = DEDICATED)
(SERVICE_NAME = APPDB)
)
)
出现了一个令我很疑惑的问题，恳请大侠给予指点，现象如下：
1)SQL>conn sys/sysadmin@APPDB as sysdba 这条命令可以成功连接到APPDB实例；
2)SQL>conn sys/sysadmin@RMAN as sysdba 这条命令无法连接到RMAN实例，提示：ORA-12154: TNS:could not resolve the connect identifier specified；
3)set oracle_sid=RMAN
SQL>conn /as sysdba则可以成功连接到RMAN实例。
怀疑是listener.ora和tnsnames.ora文件的配置问题，但是找不到问题在哪里，困惑很久了，请各位大侠指点，感谢ing！
1. 不同的实例监听不同的端口，所以tnsnames.ora不能都配1521啊
2. listener.ora里要配两个监听，你只配了一个，怎么可能两个实例都能连上
