| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
 |
 | |||
| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
|
| |||
Home -> Community -> Usenet -> c.d.o.server -> Re: Client problem
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_at_tnsalias
cmd
SET
On Dec 13, 3:46 pm, Randy <banjolici..._at_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)
> ...
Received on Wed Dec 13 2006 - 21:56:01 CST
 |
 |