Hi ,首先恭祝下路过的朋友新年快乐。
刚接触oracle 10g,安装了一套rac 系统,但是远程连接的时候提示TNS-12505错误。
相关日志如下:
07-FEB-2013 08:39:52 * (CONNECT_DATA=(CID=(PROGRAM=)(HOST=lastrac2)(USER=oracle))(COMMAND=status)(ARGUMENTS=64)(SERVICE=LISTENER_LASTRAC2)(VERSION=169869568)) * status * 0
07-FEB-2013 08:41:53 * service_update * rac2 * 0
07-FEB-2013 08:41:53 * service_update * rac2 * 0
07-FEB-2013 08:46:18 * service_update * rac1 * 0
07-FEB-2013 08:48:23 * service_update * rac1 * 0
07-FEB-2013 08:48:47 * service_update * rac2 * 0
07-FEB-2013 08:48:47 * service_update * rac2 * 0
07-FEB-2013 08:51:12 * (CONNECT_DATA=(SID=RAC)(CID=(PROGRAM=)(HOST=__jdbc__)(USER=fgh))) * (ADDRESS=(PROTOCOL=tcp)(HOST=172.23.150.151)(PORT=50080)) * establish * RAC * 12505
TNS-12505: TNS:listener does not currently know of SID given in connect descriptor
./crs_stat -t如下:
[oracle@lastrac1 bin]$ ./crs_stat -t
Name Type Target State Host
------------------------------------------------------------
ora....SM1.asm application ONLINE ONLINE lastrac1
ora....C1.lsnr application ONLINE ONLINE lastrac1
ora....ac1.gsd application ONLINE ONLINE lastrac1
ora....ac1.ons application ONLINE ONLINE lastrac1
ora....ac1.vip application ONLINE ONLINE lastrac1
ora....SM2.asm application ONLINE ONLINE lastrac2
ora....C2.lsnr application ONLINE ONLINE lastrac2
ora....ac2.gsd application ONLINE ONLINE lastrac2
ora....ac2.ons application ONLINE ONLINE lastrac2
ora....ac2.vip application ONLINE ONLINE lastrac2
ora.rac.db application ONLINE ONLINE lastrac2
ora....c1.inst application ONLINE ONLINE lastrac1
ora....c2.inst application ONLINE ONLINE lastrac2
listener.ora如下:
LISTENER_LASTRAC2 =
(DESCRIPTION_LIST =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = TCP)(HOST = lastrac2-vip)(PORT = 1521))
)
(DESCRIPTION =
(ADDRESS = (PROTOCOL = TCP)(HOST = 172.23.11.253)(PORT = 1521))
)
)
SID_LIST_LISTENER_LASTRAC2 =
(SID_LIST =
(SID_DESC =
(SID_NAME = PLSExtProc)
(ORACLE_HOME = /u01/app/oracle/product/10.2.0/db_1/)
(PROGRAM = extproc)
)
)
tnsnames.ora如下:
RAC =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = TCP)(HOST = lastrac1-vip)(PORT = 1521))
(ADDRESS = (PROTOCOL = TCP)(HOST = lastrac2-vip)(PORT = 1521))
(LOAD_BALANCE = yes)
(CONNECT_DATA =
(SERVER = DEDICATED)
(SERVICE_NAME = rac)
)
)
LISTENERS_RAC =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = lastrac1-vip)(PORT = 1521))
(ADDRESS = (PROTOCOL = TCP)(HOST = lastrac2-vip)(PORT = 1521))
)
RAC2 =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = TCP)(HOST = lastrac2-vip)(PORT = 1521))
(CONNECT_DATA =
(SERVER = DEDICATED)
(SERVICE_NAME = rac)
(INSTANCE_NAME = rac2)
)
)
RAC1 =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = TCP)(HOST = lastrac1-vip)(PORT = 1521))
(CONNECT_DATA =
(SERVER = DEDICATED)
(SERVICE_NAME = rac)
(INSTANCE_NAME = rac1)
)
)
EXTPROC_CONNECTION_DATA =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC0))
)
(CONNECT_DATA =
(SID = PLSExtProc)
(PRESENTATION = RO)
)
)
我使用netca配置了监听,是不是需要配置netmgr 配置监听对应于某个实例?
如果需要配置netmgr,在配置netmgr时候,需要怎么配置呢?网上专门找rac 下配置netmgr的文件很少。
谢谢!