Re: Pb err: 12560 TNS protocol adapter error

From: Frank <fvanbortel_at_netscape.net>
Date: Sat, 11 Jan 2003 19:54:24 +0100
Message-ID: <3E206860.2060005@netscape.net>

Karsten Farrell wrote:

> Eulfurax wrote:
> 

>> Hi,
>>
>> I can't connect Oracle 8i client ( on NT2K ) to the Oracle server 8i
>> on NT
>> 2K
>>
>> when i try to test the service via NET8 assistant i get :
>>
>> Err: 12560 TNS Protocol adapter error
>>
>> trace above ,
>>
>> I am puzzled.....
>>
>> Thanks all
>>
>> Philippe
>>

> [snip]
> 

>> nttcni: trying to connect to socket 1600.
>> ntt2err: entry
>> ntt2err: soc 1600 error - operation=1, ntresnt[0]=538, ntresnt[1]=65,
>> ntresnt[2]=0
>> ntt2err: exit
>> nttcni: exit
>> nttcon: exit
>> nserror: nsres: id=0, op=65, ns=12560, ns2=0; nt[0]=538, nt[1]=65,
>> nt[2]=0;
>> ora[0]=0, ora[1]=0, ora[2]=0
>> nsopen: unable to open transport
>> nsmfr: 1712 bytes at 0x34738a0
>> nsmfr: 428 bytes at 0x3225d48
>> nsmfr: 215 bytes at 0x3226008
>> nsmfr: 140 bytes at 0x345a490
>> nladtrm: entry
>> nladtrm: exit
>> nioqper: error from nscall
>> nioqper: nr err code: 0
>> nioqper: ns main err code: 12560

> 
> 
> Since the error occured when attempting to open socket 1600, and since 
> you're on a Windows box, you might be running into the shared socket 
> problem mentioned in Note 125021.1 on Metalink.
> 
> Is there a firewall between your client and server? Your trace shows 
> that your initial request was sent to port 1521, but is now trying to 
> connect on port 1602 (which is normal). But when it tries to open a 
> socket, it can't go any farther.
> 
> The Metalink note says:
> 
> <quote>
> A third solution for NT servers is to add the use_shared_socket = true 
> into the registry (see Note 124140.1). This will allow the OS to share 
> port 1521 and clients will then stay on 1521 when connecting to the 
> database and will not be port redirected. A downfall of this option is 
> all connections will stay on the listener port and if the listener is 
> stopped or restarted all the connections will be severed from the database.
> </quote>
> 

Works for 8.1.6, not for 8.1.7. And the OP didn't include the version...

Frank Received on Sat Jan 11 2003 - 12:54:24 CST