Client problem

From: Randy <banjolicious_at_netscape.net>
Date: Wed, 13 Dec 2006 20:46:00 GMT
Message-ID: <cEZfh.8778$sf5.2424@newsread4.news.pas.earthlink.net>

I'm working with an application that uses Net8 to communicate with an Oracle server. On a particular notebook computer, I'm having a communication problem from the 8.0.6 client to the server. This machine has multiple Oracle homes for 9i and the older 8.0.6 client. The home for the 8 client is currently selected in the 'Home Selector'.

I'd appreciate any suggestions for troubleshooting / solving this one because I'm running out of ideas.

The target service is called INFO_S in the net8 easy config and uses TCP/IP and port 1521 and SID=info

Here's the symptoms:

From the application's log file:
12/13/06 15:02:11 Error Code -12571 ORA-12571: TNS:packet writer failure

12/13/06 15:02:15 Error Code -1041 ORA-01041: internal error. hostdef extension doesn't exist

From the accompanying sqlnet.log:
Fatal NI connect error 12203, connecting to:

(DESCRIPTION=(ADDRESS_LIST=(ADDRESS=(PROTOCOL=BEQ)(PROGRAM=oracle80)(ARGV0=oracle80ORCL)(ARGS='(DESCRIPTION=(LOCAL=YES)(ADDR
ESS=(PROTOCOL=beq)))')))(CONNECT_DATA=(SID=ORCL)(CID=(PROGRAM=C:\Program Files\appdir\theapp.exe)(HOST=TOSHIBA-XP1)(USER=testing))))

VERSION INFORMATION:

	TNS for 32-bit Windows: Version 8.0.6.0.0 - Production
	Oracle Bequeath NT Protocol Adapter for 32-bit Windows: Version

8.0.6.0.0 - Production

Time: 13-DEC-06 13:35:56
Tracing to file: c:\downloads\oratrace.trc Tns error struct:

     nr err code: 12203
     TNS-12203: TNS:unable to connect to destination
     ns main err code: 12560
     TNS-12560: TNS:protocol adapter error
     ns secondary err code: 0
     nt main err code: 530
     TNS-00530: Protocol adapter error
     nt secondary err code: 0
     nt OS err code: 0

(plus several more entries just like this one)

and from the oratrace.trc log:

...

nscon: sending NSPTCN packet
nscon: got NSPTRS packet
nscon: sending NSPTCN packet
nscon: got NSPTAC packet
nscon: doing connect handshake...
nscon: nsctxinf[0]=0x69, [1]=0x9

nsnainconn: inf->nsinfflg[0]: 0x69 inf->nsinfflg[1]: 0x9 nricdt: Call successful: returned data: . nricall: Exiting NRICALL with following termination result: 0. ntt2err: soc 200 error - operation=6, ntresnt[0]=530, ntresnt[1]=93, ntresnt[2]=0
nspsend: transport write error
nserror: nsres: id=0, op=67, ns=12571, ns2=12560; nt[0]=530, nt[1]=93, nt[2]=0

nioqper:  error from nioqrc
nioqper:    nr err code: 0
nioqper:    ns main err code: 12571
nioqper:    ns (2)  err code: 12560
nioqper:    nt main err code: 530
nioqper:    nt (2)  err code: 93
nioqper:    nt OS   err code: 0

niqme: reporting ns (2) error: (12571) as rdbms err (12571) nioqrc: Error: Inconsistent trace parameters line: 962 nioqbr: state = normal (0)
... Received on Wed Dec 13 2006 - 14:46:00 CST