[求助]PB5连接Oracle出现ora-12203
同一个数据库用PB5连接时出现<font face="Verdana">ora-12203</font>，用PB9或sqlplus连接就正常(客户端Oracle7.3)，哪位有解决方法？多谢！ <p><font face="Verdana"><font face="Verdana">我的TNSNAMES.ORA的配置是这样的：</font></font></p><p> </p>
<p><font face="Verdana">misist.world =<br/> (DESCRIPTION = <br/> (ADDRESS_LIST = <br/> (ADDRESS = <br/> (COMMUNITY = TCP.world)<br/> (PROTOCOL = TCP)<br/> (Host = 10.255.255.10)<br/> (Port = 1521)<br/> )<br/> )<br/> (CONNECT_DATA =<br/> (SID = misist)<br/> (GLOBAL_NAME = misist.world)<br/> )<br/> )<br/></font></p>
<p><font face="Verdana"></font> </p>
<p><font face="Verdana">可是在<font face="Verdana">SQLNET.LOG</font>中出现的信息是这样：</font></p><font face="Verdana">
<p><font face="Verdana">***********************************************************************<br/>Fatal OSN connect error 12203, connecting to:<br/> (DESCRIPTION=(CONNECT_DATA=(SID=misist)(GLOBAL_NAME=misist.world)(CID=(PROGRAM=E:\PWRS\PB5\PBRTF050.DLL)(HOST=Windows PC)(USER=OraUser)))(ADDRESS_LIST=(ADDRESS=(PROTOCOL=ipc)(KEY=misist.world))(ADDRESS=(COMMUNITY=TCP.world)(PROTOCOL=TCP)(Host=10.255.255.10)(Port=1521))))</font></p>
<p><font face="Verdana"> VERSION INFORMATION:<br/> TNS for MSWINDOWS: Version 2.3.2.1.3 - Production<br/> Time: 21-MAY-08 11:55:19<br/> Tracing not turned on.<br/> Tns error struct:<br/> nr err code: 12203<br/> TNS-12203: TNS:unable to connect to destination<br/> ns main err code: 12538<br/> TNS-12538: TNS:no such protocol adapter<br/> ns secondary err code: 12560<br/> nt main err code: 508<br/> TNS-00508: No such protocol adapter<br/> nt secondary err code: 0<br/> nt OS err code: 0</font></p><font face="Verdana">
<p><br/>***********************************************************************<br/>Fatal OSN connect error 12203, connecting to:<br/> (DESCRIPTION=(CONNECT_DATA=(SID=mmsa)(GLOBAL_NAME=mmsa.world)(CID=(PROGRAM=E:\PWRS\PB5\PBRTF050.DLL)(HOST=Windows PC)(USER=OraUser)))(ADDRESS_LIST=(ADDRESS=(PROTOCOL=ipc)(KEY=MMSA.world))(ADDRESS=(COMMUNITY=TCP.world)(PROTOCOL=TCP)(Host=10.1.0.3)(Port=1521))))</p>
<p> VERSION INFORMATION:<br/> TNS for MSWINDOWS: Version 2.3.2.1.3 - Production<br/> Time: 21-MAY-08 11:55:19<br/> Tracing not turned on.<br/> Tns error struct:<br/> nr err code: 12203<br/> TNS-12203: TNS:unable to connect to destination<br/> ns main err code: 12538<br/> TNS-12538: TNS:no such protocol adapter<br/> ns secondary err code: 12560<br/> nt main err code: 508<br/> TNS-00508: No such protocol adapter<br/> nt secondary err code: 0<br/> nt OS err code: 0<br/></p>
<p> </p>
<p> </p></font></font> <p>花了好长时间才发现原来要把一个 <font face="Verdana">vsl.ini 放到windows目录下才行，只是不知道为什么要这个文件。</font></p>
<p> </p>
<p><font face="Verdana">;<br/>; VSL default settings<br/>;<br/><br/>; transport=netkey this is the network key of the default transport<br/>; that the VSL will use if the netkey passed to<br/>; InitVSL() is NULL<br/>transport=winsock</font></p>
<p><font face="Verdana">; trace=tracelevel<br/>; VSL tracing bit settings: - default is 1+2<br/>; 1 /* msgs from 3rd party socket lib */<br/>; 2 /* VSL detected errors */<br/>; 4 /* VSL call tracing, implies 1+2+32 */<br/>; 8 /* hex dump of received data */<br/>; 16 /* hex dump of sent data */<br/>; 32 /* msgs from VSL TSR code */<br/>;trace=4<br/>;<br/>; Transports supported by the VSL.<br/>; netkey=description where netkey is the network key for the transport and<br/>; description is the name or title of the transport.<br/>;<br/>version=3.0.11<br/><br/>3open="3Com 3+Open TCP"<br/>3open2="3Com 3+Open TCP version 2.0"<br/>bw="Beame & Whiteside TCP/IP"<br/>dlink="D-Link TCP/IP for DOS"<br/>pworks="digital PATHWORKS for DOS (TCP/IP)"<br/>novlwp="Novell LAN WorkPlace for DOS"<br/>ftp="FTP PC/TCP"<br/>hparpa="HP ARPA Services for DOS"<br/>locus2="Locus TCP/IP for DOS"<br/>lanman="Microsoft LAN Manager TCP/IP v2.1"<br/>lanman2="Microsoft LAN Manager TCP/IP v2.1a"<br/>pcnfs="Sun PC-NFS"<br/>pcnfs2="Sun PC-NFS v3.5"<br/>pcnfs4="Sun PC-NFS v4.0"<br/>net<br/>wintcp="Wollongong WIN/TCP for DOS"<br/>pathway="Wollongong PathWay Access for DOS"<br/>winsock="Windows Sockets TCP/IP v.1.1"<br/>wsock10="Windows Sockets TCP/IP v.1.0"</font></p>
<p><font face="Verdana">;<br/>; Transport specific information<br/>;<br/><br/>; protocol=This line is only used by JSB MultiView DeskTop<br/>protocol=rlogin,telnet,rsh,rexec<br/>; dllmodule=This line is only used by JSB MultiView DeskTop<br/>dllmodule=MSOCKLIB.DLL<br/>; netmodule=For a TSR supported transport, this should contain<br/>; the TSR signature.<br/>; For a DLL supported transport, the name of the DLL<br/>netmodule=MFTP<br/>; netinterface=This entry should contain TSR or DLL depending on how<br/>; the transport is supported through the VSL.<br/>netinterface=TSR<br/>; private=This line is only used by JSB MultiView DeskTop<br/>;private=</font></p>
<p><font face="Verdana"><br/>protocol=rlogin,telnet,rsh,rexec<br/>dllmodule=MSOCKLIB.DLL<br/>netmodule=M3OPEN<br/>netinterface=TSR<br/>;private=</font></p>
<p><font face="Verdana"><br/>protocol=rlogin,telnet,rsh,rexec<br/>dllmodule=MSOCKLIB.DLL<br/>netmodule=M3OPEN<br/>netinterface=TSR<br/>;private=</font></p>
<p><font face="Verdana"><br/>protocol=rlogin,telnet,rsh,rexec<br/>dllmodule=MSOCKLIB.DLL<br/>netmodule=M3OPEN.DLL<br/>netinterface=DLL<br/>;private=</font></p>
<p><font face="Verdana"><br/>protocol=rlogin,telnet,rsh,rexec<br/>dllmodule=MSOCKLIB.DLL<br/>netmodule=MBW<br/>netinterface=TSR<br/>;private=</font></p>
<p><font face="Verdana"><br/>protocol=rlogin,telnet,rsh,rexec<br/>dllmodule=MSOCKLIB.DLL<br/>netmodule=MLOCUS2<br/>netinterface=TSR<br/>;private=</font></p>
<p><font face="Verdana"><br/>protocol=rlogin,telnet,rsh,rexec<br/>dllmodule=MSOCKLIB.DLL<br/>netmodule=MWSOCK10.DLL<br/>netinterface=DLL<br/>;private=</font></p>
<p><font face="Verdana"><br/>protocol=rlogin,telnet,rsh,rexec<br/>dllmodule=MSOCKLIB.DLL<br/>netmodule=MWINSOCK.DLL<br/>netinterface=DLL<br/>;private=<br/>version=3.0.11</font></p>
<p><font face="Verdana"><br/>protocol=rlogin,telnet,rsh,rexec<br/>dllmodule=MSOCKLIB.DLL<br/>netmodule=MPCNFS4.DLL<br/>netinterface=DLL<br/>;private=</font></p>
<p><font face="Verdana"><br/>protocol=rlogin,telnet,rsh,rexec<br/>dllmodule=MSOCKLIB.DLL<br/>netmodule=MNOVLWP.DLL<br/>netinterface=DLL<br/>;private=</font></p>
<p><font face="Verdana"><br/>protocol=rlogin,telnet,rsh,rexec<br/>dllmodule=MSOCKLIB.DLL<br/>netmodule=MHPARPA.DLL<br/>netinterface=DLL<br/>;private=</font></p>
<p><font face="Verdana"><br/>protocol=rlogin,telnet,rsh,rexec<br/>dllmodule=MSOCKLIB.DLL<br/>netmodule=MHPARPA.DLL<br/>netinterface=DLL<br/>;private=</font></p>
<p><font face="Verdana"><br/>protocol=rlogin,telnet,rsh,rexec<br/>dllmodule=MSOCKLIB.DLL<br/>netmodule=M3OPEN<br/>netinterface=TSR<br/>;private=</font></p>
<p><font face="Verdana"><br/>protocol=rlogin,telnet,rsh,rexec<br/>dllmodule=MSOCKLIB.DLL<br/>netmodule=MLOCUS2<br/>netinterface=TSR<br/>;private=</font></p>
<p><font face="Verdana"><br/>protocol=rlogin,telnet,rsh,rexec<br/>dllmodule=MSOCKLIB.DLL<br/>netmodule=MPCNFS<br/>netinterface=TSR<br/>;private=</font></p>
<p><font face="Verdana"><br/>protocol=rlogin,telnet,rsh,rexec<br/>dllmodule=MSOCKLIB.DLL<br/>netmodule=MPCNFS2<br/>netinterface=TSR<br/>;private=</font></p>
<p><font face="Verdana"><br/>protocol=rlogin,telnet,rsh,rexec<br/>dllmodule=MSOCKLIB.DLL<br/>netmodule=MNETONE<br/>netinterface=TSR<br/>;private=</font></p>
<p><font face="Verdana"><br/>protocol=rlogin,telnet,rsh,rexec<br/>dllmodule=MSOCKLIB.DLL<br/>netmodule=MWINTCP<br/>netinterface=TSR<br/>;private=</font></p>
<p><font face="Verdana"><br/>protocol=rlogin,telnet,rsh,rexec<br/>dllmodule=MSOCKLIB.DLL<br/>netmodule=MPATHWAY.DLL<br/>netinterface=DLL<br/>;private=</font></p>
<p><font face="Verdana"></font> </p> <p>原来如此</p>
<p>学习</p>
页:
[1]