| SQLGate and Me [message #189232] |
Wed, 23 August 2006 14:07  |
whatfur
Messages: 29
Registered: July 2006
|
Junior Member |
|
|
SQLGate is a toad-like entity allowing tcp/ip sql access from a PC to an Oracle Database Server.
It is set up on a given PC and successfully accesses one of our clustered systems. I have another virtually identical clustered system, set up exactly the same way (IPs different, of course,
but otherwise sqlnet.ora listener.ora, and tnsnames.ora the same) that for some reason it cannot connect to (it does a connection check at the time of entering the "service name" SID that immediately returns the message "Invalid SID".
In tracing the listener I get:
nsanswer: deferring connect attempt; at stage 5
nscon: doing connect handshake...
nscon: got NSPTCN packet
nsevdansw: exit
nscon: sending NSPTRF packet
nstimarmed: no timer allocated
nsclose: closing transport
nsclose: global context check-out (from slot 8 ) complete
nsglecmd: Deallocating cxd 0x1105d11f0.
...on the one that fails, and
nsanswer: deferring connect attempt; at stage 5
nscon: doing connect handshake...
nscon: got NSPTCN packet
nsevdansw: exit
nscon: sending NSPTAC packet
nscon: doing connect handshake...
nscon: nsctxinf[0]=0x4d, [1]=0x9
nsconbrok: asking transport to enable NTOBROKEN
nsevdansw: exit
...on the one that is successful. Please note the one
seemingly going into NSPTRF and the other not.
Not sure if that means anything.
Any help appreciated.
Thanks,
Dave
|
|
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
