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

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

Re: Database connection between Oracle9i and Oracle 7.x

From: Mark D Powell <Mark.Powell_at_eds.com>
Date: 1 Nov 2002 10:34:23 -0800
Message-ID: <2687bb95.0211011034.908cc97@posting.google.com>


Matt, there is no need to cross-post.

It is my understanding that Oracle 9 will not talk to Oracle 7. I have seen posts of metalink saying this is unsupported and the version 7 db should be upgraded.

What I have done in the past when two version could not communicate was to build a between level version database and point each non-compatible version to it so that it relayed the SQL.

HTH -- Mark D Powell --

"Mathhew Johnston" <mathhew.johnston_at_tma.co.uk> wrote in message 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 - 12:34:23 CST

Original text of this message

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