Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.misc -> Re: Database connection between Oracle9i and Oracle 7.x

Re: Database connection between Oracle9i and Oracle 7.x

From: Peter van Rijn <p.vanrijnREMOVE_at_THISzhew.nl>
Date: Fri, 1 Nov 2002 12:10:27 +0100
Message-ID: <us4oeda3ouas21@corp.supernews.com>


Connecting from 9.2 to 7.x vv is no longer supported.

Peter

PS Please don't crosspost this sort of questions, cdo.misc and cdo.server is read by virtually everyone who's willing to answer questions here.

"Mathhew Johnston" <mathhew.johnston_at_tma.co.uk> schreef in bericht news:3dc24fe6$0$24756$7b0f0fd3_at_reader.news.newnet.co.uk...
> Hi all,
>
> We have been trying to connect between an Oracle 9i (9.2.0.1.0) and a
> Oracle 7.x (7.3.4.4.0) server via a public database link, and it keeps
> failing when the link is accessed.
>
> Oracle 9i Server:
>
> Windows 2000
> Oracle 9i (9.2.0.1.0)
> TNS for 32-bit Windows: 9.2.0.1.0
>
> Oracle 7 Server:
>
> Sun OS 5.5.1
> Oracle 7 (7.3.4.4.0)
> TNS for Solaris: 2.3.4.0.0
>
> When using a simple "select" command using the public database link to the
> Oracle 7 server the following error occurs:
>
> > ERROR:
> > ORA-01002: fetch out of sequence
> > ORA-02063: preceding line from TEMPLINK2
> >
> > no rows selected
>
> These errors, I think have nothing to do with the actual problem as it
seems
> to be a problem with the "SQL Net" connection as the trace log shows some
> type of error as follows: (Also when using SQLplus from the windows
command
> line connecting to the Oracle 7 server, the SQLplus crashes out without
any
> warning, and generates very similar nserror codes as below)
>
> [31-OCT-2002 16:39:20:468] sntpread: Attempting to read 2064 bytes from
200
>
> [31-OCT-2002 16:39:20:484] sntpread: Read returned 388 bytes
>
> [31-OCT-2002 16:39:20:484] nassky: failed with error 12630
>
> [31-OCT-2002 16:39:20:484] nszssk: failed with error 12630
>
> [31-OCT-2002 16:39:20:484] nserror: nsres: id=0, op=70, ns=12630, ns2=0;
> nt[0]=0, nt[1]=0, nt[2]=0; ora[0]=0, ora[1]=0, ora[2]=0
>
> [31-OCT-2002 16:39:20:484] sntpwrite: Attempting to write 51 bytes to 196
>
> [31-OCT-2002 16:39:20:484] sntpwrite: Write returned 51 bytes
>
> More bytes sent..............
>
> [31-OCT-2002 16:46:00:015] sntpread: Attempting to read 2064 bytes from
200
>
> [31-OCT-2002 16:46:00:359] sntpread: Read returned 11 bytes
>
> [31-OCT-2002 16:46:00:359] nsrdr: got NSPTMK packet
>
> [31-OCT-2002 16:46:00:359] nioqrc: Recieve: returning error: 3111
>
> [31-OCT-2002 16:46:00:359] nioqrs: state = interrupted (1)
>
> [31-OCT-2002 16:46:00:359] nsdo: sending NSPTMK packet
>
> [31-OCT-2002 16:46:00:359] sntpwrite: Attempting to write 11 bytes to 196
>
> [31-OCT-2002 16:46:00:359] sntpwrite: Write returned 11 bytes
>
> [31-OCT-2002 16:46:00:359] sntpread: Attempting to read 2064 bytes from
200
>
> [31-OCT-2002 16:46:00:359] sntpread: Read returned 11 bytes
>
> [31-OCT-2002 16:46:00:359] nsrdr: got NSPTMK packet
>
> [31-OCT-2002 16:46:00:359] nserror: nsres: id=0, op=70, ns=12582, ns2=0;
> nt[0]=0, nt[1]=0, nt[2]=0; ora[0]=0, ora[1]=0, ora[2]=0
>
> [31-OCT-2002 16:46:00:359] nserror: nsres: id=0, op=70, ns=12630, ns2=0;
> nt[0]=0, nt[1]=0, nt[2]=0; ora[0]=0, ora[1]=0, ora[2]=0
>
> [31-OCT-2002 16:46:00:359] sntpread: Attempting to read 2064 bytes from
200
>
> [31-OCT-2002 16:46:00:359] sntpread: Read returned 178 bytes
>
> [31-OCT-2002 16:46:09:687] sntpwrite: Attempting to write 13 bytes to 196
>
> [31-OCT-2002 16:46:09:687] sntpwrite: Write returned 13 bytes
>
> [31-OCT-2002 16:46:09:687] sntpread: Attempting to read 2064 bytes from
200
>
> [31-OCT-2002 16:46:09:765] sntpread: Read returned 15 bytes
>
> [31-OCT-2002 16:46:09:812] nstimarmed: no timer allocated
>
> [31-OCT-2002 16:46:09:812] sntpwrite: Attempting to write 10 bytes to 196
>
> [31-OCT-2002 16:46:09:812] sntpwrite: Write returned 10 bytes
>
> [31-OCT-2002 16:46:09:812] nsclose: closing transport
>
> [31-OCT-2002 16:46:09:812] sntpclose: Closing pipe 200
>
> [31-OCT-2002 16:46:09:812] sntpclose: Closing pipe 196
>
> [31-OCT-2002 16:46:09:812] nsclose: global context check-out (from slot 0)
> complete
>
> [31-OCT-2002 16:46:09:812] nigtrm: Count in the NI global area is now 0
>
> [31-OCT-2002 16:46:09:812] nigtrm: Count in the NL global area is now 0
>
>
>
> Thanks for your help.
>
> Mat.
>
>
Received on Fri Nov 01 2002 - 05:10:27 CST

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US