Re: Oracle 9i client connectivity to Oracle 7.1.4

"Jane" <Jane_at_dossss.com> wrote in message news:<ycVib.27287$Eh3.9859104_at_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_at_mylink;", I get the following error:
> select max(t_date) from table1_at_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_at_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. Received on Tue Oct 14 2003 - 23:58:12 CEST