471,092 Members | 1,550 Online
Bytes | Software Development & Data Engineering Community
Post +

Home Posts Topics Members FAQ

Join Bytes to post your question to a community of 471,092 software developers and data experts.

Oracle 9i client connectivity to Oracle 7.1.4

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


Jul 19 '05 #1
2 7831
"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.
Jul 19 '05 #2

"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!!

Jul 19 '05 #3

This discussion thread is closed

Replies have been disabled for this discussion.

Similar topics

1 post views Thread by Dominic | last post: by
3 posts views Thread by David Gray | last post: by
4 posts views Thread by BookerW | last post: by
1 post views Thread by Migguel Angel Sánchez Pérez | last post: by
2 posts views Thread by Will | last post: by

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.