各位高手,请教一个问题我用PL/SQL想在内网连接ORACEL10G的服务端,但是我将客户端配好后无法连接到服务端,提示“出现连接超时”,但是服务端的机器我能远程桌面过去。tnsnames.ora
配置如下RPS_136.192.24.131 =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = 136.192.24.131)(PORT = 1521))
)
(CONNECT_DATA =
(SID = PHS)
(SERVER = DEDICATED)
)
)
配置如下RPS_136.192.24.131 =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = 136.192.24.131)(PORT = 1521))
)
(CONNECT_DATA =
(SID = PHS)
(SERVER = DEDICATED)
)
)
# Generated by Oracle configuration tools.LZCCB_RZ =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = 61.234.50.195)(PORT = 1521))
)
(CONNECT_DATA =
(SERVICE_NAME = lzccb)
)
)
是不是你那个用户名的问题呀 ‘RPS_136.192.24.131’ 不能有点号吧。
# listener.ora Network Configuration File: D:\oracle\product\10.1.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.1.0\Db_1)
(PROGRAM = extproc)
) (SID_DESC =
(SID_NAME = ORCL)
(ORACLE_HOME = D:\oracle\product\10.1.0\Db_1)
(SID_NAME = ORCL)
)
)LISTENER =
(DESCRIPTION_LIST =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC))
)
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = sinosoft-jhj)(PORT = 1521))
)
)
)orcl是我的数据库名 sinosoft-jhj是我的计算机名。
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)
(HOST = 136.192.24.131)
(PORT = 1521))
)
(CONNECT_DATA =
(SID = PHS)
)
)
试试,若在不行,检查下服务器的tns listener是否开了或者尝试将SERVER = DEDICATED修改为server = shared
是已经启动的了,SERVER = DEDICATED修改为server = shared也不行,还是登录不上去,郁闷,求解