有两台电脑A和B,A装了ORACLE服务器,B装了ORACLE客户端,用PL/SQL可以直接连接得上,后来又在B上装了ORACLE服务器,后来在机器B上就无法用PL/SQL访问电脑A的ORACLE服务了, 出现了TNS错误,问题出现在了电脑B上的TNS配置上,只须修改电脑B上的TN配置,就可以了!
$ORACLE_HOME/network/admin/tnsnames.ora
可以仿照$ORACLE_HOME/network/admin/sample/tnsnames.ora的配置方法,同时根据你的两个Oracle数据库实际的配置情况,如SID、hostname、ip、protocol、port等信息,编辑一下tnsnames.ora文件,就应该可以了。
下面就是tnsnames.ora文件要配置:
# TNSNAMES.ORA Network Configuration
File
: D:oracleserverora92 etworkadmin nsnames.ora
# Generated by Oracle configuration tools.
TEST192 =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = ftp01)(PORT = 1521 ))
)
(CONNECT_DATA =
(SERVER = DEDICATED)
(SERVICE_NAME = test192)
)
)
GOU_192. 168.0 . 200 =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = 192.168 . 0.200 )(PORT = 1521 ))
)
(CONNECT_DATA =
(SERVER = DEDICATED)
(SERVICE_NAME = GOU)
)
)
INST1_HTTP =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = ftp01)(PORT = 1521 ))
)
(CONNECT_DATA =
(SERVER = SHARED)
(SERVICE_NAME = MODOSE)
(PRESENTATION = http: // HRService)
)
)
EXTPROC_CONNECTION_DATA =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = IPC)( KEY = EXTPROC2))
)
(CONNECT_DATA =
(SID = PLSExtProc)
(PRESENTATION = RO)
)
)
# Generated by Oracle configuration tools.
TEST192 =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = ftp01)(PORT = 1521 ))
)
(CONNECT_DATA =
(SERVER = DEDICATED)
(SERVICE_NAME = test192)
)
)
GOU_192. 168.0 . 200 =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = 192.168 . 0.200 )(PORT = 1521 ))
)
(CONNECT_DATA =
(SERVER = DEDICATED)
(SERVICE_NAME = GOU)
)
)
INST1_HTTP =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = ftp01)(PORT = 1521 ))
)
(CONNECT_DATA =
(SERVER = SHARED)
(SERVICE_NAME = MODOSE)
(PRESENTATION = http: // HRService)
)
)
EXTPROC_CONNECTION_DATA =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = IPC)( KEY = EXTPROC2))
)
(CONNECT_DATA =
(SID = PLSExtProc)
(PRESENTATION = RO)
)
)