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 Sat Nov 02 2002 - 05:20:08 CST
