Home » RDBMS Server » Networking and Gateways » SQLGate and Me
SQLGate and Me [message #189232] Wed, 23 August 2006 14:07 Go to next message
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






Re: SQLGate and Me [message #190775 is a reply to message #189232] Fri, 01 September 2006 03:22 Go to previous message
kimant
Messages: 201
Registered: August 2006
Location: Denmark
Senior Member
Hi

Can You connect to both databases from a single client, fx. using SQL*Plus ?

Br
Kim
Previous Topic: naming methods
Next Topic: ODBC periodic disconnect from portable tablet PC
Goto Forum:
  


Current Time: Sat Dec 03 00:56:19 CST 2016

Total time taken to generate the page: 0.10126 seconds