第一问答网»论坛 › 中问网 › 问答 › 8.1.6 for solaris6是不是TNS、LISTENER有BUG的？ ...

8.1.6 for solaris6是不是TNS、LISTENER有BUG的？

11 |

0 | 2005-10-30 17:05:33 | 显示全部楼层 |阅读模式

我用其他机器配置了TNSNAMES.ORA（8.0.5,9I)也无法连接
用如下配置
sol6 =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = 10.3.2.11)(PORT = 1521))
)
(CONNECT_DATA =
(SERVICE_NAME = oracle)
)
)
报错ORA-12500: TNS:listener failed to start a dedicated server process
如果用
sol6 =
(DESCRIPTION =
(ADDRESS = (PROTOCOL= TCP)(Host= 10.3.2.11)(Port= 1521))
(CONNECT_DATA = (SID = oracle))
)
报错
ERROR:
ORA-12505: TNS:listener could not resolve SID given in connect descriptor
ORALCE那边的LISTENTR.ORA配置如下
LISTENER =
(DESCRIPTION_LIST =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC))
)
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = sol6.gzai.com)(PORT = 1521))
)
)
(DESCRIPTION =
(PROTOCOL_STACK =
(PRESENTATION = GIOP)
(SESSION = RAW)
)
(ADDRESS = (PROTOCOL = TCP)(HOST = sol6.gzai.com)(PORT = 2481))
)
)
SID_LIST_LISTENER =
(SID_LIST =
(SID_DESC =
(SID_NAME = PLSExtProc)
(ORACLE_HOME = /export/home/oracle/OraHome1)
(PROGRAM = extproc)
)
(SID_DESC =
(GLOBAL_DBNAME = dba)
(ORACLE_HOME = /export/home/oracle/OraHome1)
(SID_NAME = oracle)
)
)
真的是很奇怪，我怀疑是ORACLE8.1.6的BUG??

使用道具举报

返回列表发新帖

千问

主题	0 回帖	4882万积分

论坛元老

Rank: 8 Rank: 8

积分: 48824836

回复楼主返回列表

问答

热门排行