Client problem
in [Oracle]
|
From: Randy on 13 Dec 2006 15:46 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) ....
From: EdStevens on 13 Dec 2006 18:23 Randy wrote: > 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) > ... What did you discover when you looked up ORA-12571 and ORA-01041. What does "Error: Inconsistent trace parameters line: 962" suggest?
From: EscVector on 13 Dec 2006 22:56 Here are some questions: 1. Why do you need the 8 client? Are you connecting to any 7 or older databases? 2. The install is "messed" up. On windows? Also, I have a win version of 8.0 and never installed it. Maybe compatibility issues exist when multi-homed. This is the case with Ora7. You can't multihome on windows unless you do some tricks. I have had no 8i/9i multihome issues. Personal Opinion: Never use that home tool even if support tell you to do so.... I never really works and you get errors like the one you are seeing. If yes to win: Via cmd prompt sqlplus, not the GUI, set the PATH,ORACLE_HOME and TNS_ADMIN If no to win, then you should know what to export, and should require no further detail :) cmd SET ORACLE_HOME=path to your home SET TNS_ADMIN path to your network admin directory. SET PATH=%ORACLE_HOME%\bin;%PATH% sqlplus /nolog connect user/pass(a)tnsalias ======================= If the above doesn't work, post the env setting here if on windows cmd SET On Dec 13, 3:46 pm, Randy <banjolici...(a)netscape.net> wrote: > 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) > ...
From: banjolicious on 14 Dec 2006 09:02 Comments in-line EdStevens wrote: > What did you discover when you looked up ORA-12571 and ORA-01041. 12571 - Could mean almost anything 01041 - Something is really hosed > What does "Error: Inconsistent trace parameters line: 962" suggest? Something is really hosed.... Does it mean anything to you?
From: sybrandb on 14 Dec 2006 09:11
On Dec 14, 3:02 pm, banjolici...(a)netscape.net wrote: > Comments in-line > > EdStevens wrote: > > What did you discover when you looked up ORA-12571 and ORA-01041.12571 - Could mean almost anything > 01041 - Something is really hosed > > > What does "Error: Inconsistent trace parameters line: 962" suggest?Something is really hosed.... > > Does it mean anything to you? Sure it does: it means that when you troubleshooting skills are that limited, you could better open the window, throw the laptop out of it, and quit your job. |