Oracle 9i client connectivity to Oracle 7.1.4

[Jane]

Hi All,

I created a DBLINK on a 9i server to a 7.1.4 server.
CREATE DATABASE LINK my_link CONNECT TO rem_user IDENTIFIED BY rem_pwd USING
'my_tnsentry';

- But when I query through the link using
"select max(t_date) from table1@mylink;", I get the following error:
select max(t_date) from table1@mylink
*
ERROR at line 1:
ORA-24439: Connections to Oracle7 server are no longer supported
ORA-02063: preceding line from MY_LINK

When I connect using SQLPLUS, I get a similar error as above:
/export/home/mmmm> sqlplus rem_user/rem_pwd@my_tnsentry

SQL*Plus: Release 9.2.0.2.0 - Production on Mon Oct 13 17:15:42 2003
Copyright (c) 1982, 2002, Oracle Corporation. All rights reserved.

ERROR:
ORA-24439: Connections to Oracle7 server are no longer supported

Enter user-name:

How do I query a remote Oracle 7 database from Oracle 9i? My queries will
run from a stored procedure in the 9i database.
Thanks in advance

[Pete's]

"Jane" <Ja**@dossss.com> wrote in message news:<yc*********************@news4.srv.hcvlny.cv. net>...

Hi All,

I created a DBLINK on a 9i server to a 7.1.4 server.
CREATE DATABASE LINK my_link CONNECT TO rem_user IDENTIFIED BY rem_pwd USING
'my_tnsentry';

- But when I query through the link using
"select max(t_date) from table1@mylink;", I get the following error:
select max(t_date) from table1@mylink
*
ERROR at line 1:
ORA-24439: Connections to Oracle7 server are no longer supported
ORA-02063: preceding line from MY_LINK

When I connect using SQLPLUS, I get a similar error as above:
/export/home/mmmm> sqlplus rem_user/rem_pwd@my_tnsentry

SQL*Plus: Release 9.2.0.2.0 - Production on Mon Oct 13 17:15:42 2003
Copyright (c) 1982, 2002, Oracle Corporation. All rights reserved.

ERROR:
ORA-24439: Connections to Oracle7 server are no longer supported

Enter user-name:

How do I query a remote Oracle 7 database from Oracle 9i? My queries will
run from a stored procedure in the 9i database.
Thanks in advance

Oracle only supports dblinks from 9i db's to 8.0.6 db's. You should
upgrade. However, to continue down your path, you would need to setup
a database in between the two so that 9i would eventually talk to the
7.1.4 db. i.e. db link from 9i to 8.0, then db link from 8.0 to
7.1.4. The 8.0 db would probably need synonyms to point to whatever
you are accessing on 7.1. Not sure if the 8.0 to 7.1 link will work,
but, try it.

HTH,
Pete's

The opinions I may have stated are mine and not that of my employer.
Use any advice given at your own risk.

[Jane]

"Pete's" <em********@yahoo.com> wrote in message
news:67*************************@posting.google.co m...

"Jane" <Ja**@dossss.com> wrote in message news:<yc*********************@news4.srv.hcvlny.cv. net>...

Hi All,

How do I query a remote Oracle 7 database from Oracle 9i? My queries will run from a stored procedure in the 9i database.

Oracle only supports dblinks from 9i db's to 8.0.6 db's. You should
upgrade. However, to continue down your path, you would need to setup
a database in between the two so that 9i would eventually talk to the
7.1.4 db. i.e. db link from 9i to 8.0, then db link from 8.0 to
7.1.4. The 8.0 db would probably need synonyms to point to whatever
you are accessing on 7.1. Not sure if the 8.0 to 7.1 link will work,
but, try it.

Thanks Pete. I just tried this and it works!!