问题:我是一个oracle客户端连接两个oracle服务器。一个是192.168.2.132,一个是本地的。但是我只能连接上一个本地的,当我连接非本地的时候,提示信息:没有监听。
以下是我的配置信息,请哪位兄弟帮我看看。顺便帮我解释一下这些参数的关系。先谢啦。listener.ora中
*********************************************************
SID_LIST_LISTENER =
(SID_LIST =
(SID_DESC =
(SID_NAME = PLSExtProc)
(ORACLE_HOME = D:\oracle\product\10.1.0\Db_1)
(PROGRAM = extproc)
)
(SID_DESC =
(GOLBAL_DBNAME = orcl)
(ORACLE_HOME = D:\oracle\product\10.1.0\Db_1)
(SID_NAME = orcl)
)
)SID_LIST_NSFC =
(SID_LIST =
(SID_DESC =
(GOLBAL_DBNAME = nsfc)
(ORACLE_HOME = D:\oracle\product\10.1.0\Db_1)
(SID_NAME = nsfc)
)
)
NSFC =
(DESCRIPTION_LIST =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = administrator)(PORT = 1522))
)
)
)LISTENER =
(DESCRIPTION_LIST =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC))
)
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = administrator)(PORT = 1521))
)
)
)
***********************************************
tnsnames.ora中
NSFC =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = 192.168.2.132)(PORT = 1522))
)
(CONNECT_DATA =
(SERVICE_NAME = nsfc)
)
)ORCL =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = administrator)(PORT = 1521))
)
(CONNECT_DATA =
(SERVER = DEDICATED)
(SERVICE_NAME = orcl)
)
)EXTPROC_CONNECTION_DATA =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC))
)
(CONNECT_DATA =
(SID = PLSExtProc)
(PRESENTATION = RO)
)
)
以下是我的配置信息,请哪位兄弟帮我看看。顺便帮我解释一下这些参数的关系。先谢啦。listener.ora中
*********************************************************
SID_LIST_LISTENER =
(SID_LIST =
(SID_DESC =
(SID_NAME = PLSExtProc)
(ORACLE_HOME = D:\oracle\product\10.1.0\Db_1)
(PROGRAM = extproc)
)
(SID_DESC =
(GOLBAL_DBNAME = orcl)
(ORACLE_HOME = D:\oracle\product\10.1.0\Db_1)
(SID_NAME = orcl)
)
)SID_LIST_NSFC =
(SID_LIST =
(SID_DESC =
(GOLBAL_DBNAME = nsfc)
(ORACLE_HOME = D:\oracle\product\10.1.0\Db_1)
(SID_NAME = nsfc)
)
)
NSFC =
(DESCRIPTION_LIST =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = administrator)(PORT = 1522))
)
)
)LISTENER =
(DESCRIPTION_LIST =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC))
)
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = administrator)(PORT = 1521))
)
)
)
***********************************************
tnsnames.ora中
NSFC =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = 192.168.2.132)(PORT = 1522))
)
(CONNECT_DATA =
(SERVICE_NAME = nsfc)
)
)ORCL =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = administrator)(PORT = 1521))
)
(CONNECT_DATA =
(SERVER = DEDICATED)
(SERVICE_NAME = orcl)
)
)EXTPROC_CONNECTION_DATA =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC))
)
(CONNECT_DATA =
(SID = PLSExtProc)
(PRESENTATION = RO)
)
)
tnsnames.ora中
NSFC =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = 192.168.2.132)(PORT = 1522))
)
(CONNECT_DATA =
(SERVICE_NAME = nsfc)
)
)
远程服务器的监听端口是1522吗? 如果不是要改成1521 再试试..
------------------------------------------------------------------------------
Blog: http://blog.csdn.net/tianlesoftware
网上资源: http://tianlesoftware.download.csdn.net
相关视频:http://blog.csdn.net/tianlesoftware/archive/2009/11/27/4886500.aspx
Q Q 群:62697716
(DESCRIPTION_LIST =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = administrator)(PORT = 1522))
)
)
)把administrator改成192.168.2.132试试
关键看你自己的sqlnet.ora和tnsnames.ora文件.
NSFC =
(DESCRIPTION_LIST =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC))
)
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = 192.168.2.132)(PORT = 1522))
)
)
)