Hi it will also not work!
I made the test it's not supported!
Francois.
Anton Buijs wrote:
> Instead of a 8i database in the middle, would a Connection Manager running
> on 8i in the middle be a solution too? I have no environment (yet) to try
> this.
>
> Van Messner <vmessner_at_bestweb.net> schreef in berichtnieuws
> us6btprhfp3h7f_at_corp.supernews.com...
> | Mark has the answer. We have tried this with an 8i database as the
> "middle
> | level" between 9i2 and 7.3.4 and it works. Of course, it's an awkward
> thing
> | to have to do and far from an ideal solution. But it does work.
> |
> | Van
> |
> |
> | "Mark D Powell" <Mark.Powell_at_eds.com> wrote in message
> | news:2687bb95.0211011034.908cc97_at_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 Tue Nov 05 2002 - 16:07:23 CST
