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/mmmmsqlplus rem_user/rem_pwd@my_tnse ntry

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]

Re: Oracle 9i client connectivity to Oracle 7.1.4

"Jane" <Jane@dossss.co mwrote in message news:<ycVib.272 87$Eh3.9859104@ news4.srv.hcvln y.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/mmmmsqlplus rem_user/rem_pwd@my_tnse ntry
>
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]

Re: Oracle 9i client connectivity to Oracle 7.1.4


"Pete's" <empete2000@yah oo.comwrote in message
news:6724a51f.0 310141358.c7ca9 5a@posting.goog le.com...

"Jane" <Jane@dossss.co mwrote in message

news:<ycVib.272 87$Eh3.9859104@ news4.srv.hcvln y.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!!