Database connection between Oracle9i and Oracle 7.x
Mathhew Johnston
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.
Andy Finkenstadt
> 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.
This is not a supported, nor working, ability. The patchset
9.2.0.2.0 now returns an explicit error for this condition, rather
than crashing or returning wierd errors.
Andy
--
Andrew Finkenstadt (http://www.finkenstadt.com/andy/)
Mark D Powell
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....@tma.co.uk> wrote in message news:<3dc24fe6$0$24756$7b0f...@reader.news.newnet.co.uk>...
akhtar
As for as i know of, oracle 9.2 is not certified against 7.3.4, i
came across similar problem when i am trying to connect from 9.2 OEM
to oracle 7.3.4. So i would think this problem relate to the same
scenerio, meaning oracle 9.2 not supporting 7.3.4 rdbms. I checked
with oracle corp. and they say that oracle 9.2 client is not certified
with 7.3.4.
Hope this helps.
Akhtar Tiwana
"Mathhew Johnston" <mathhew....@tma.co.uk> wrote in message news:<3dc24fe6$0$24756$7b0f...@reader.news.newnet.co.uk>...