Database connection between Oracle9i and Oracle 7.x

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 - 03:58:29 CST