Re: Pb err: 12560 TNS protocol adapter error

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> Received on Fri Jan 10 2003 - 12:01:36 CST