Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
![]() |
![]() |
Home -> Community -> Mailing Lists -> Oracle-L -> RE: Database Link
You didn't say where the 9.2 database is located. It's not on the same =
server as your 8.0 database is it? Check the TNS names entry for the =
target database (8.0) on the (9.2) server. The entry may not exist or =
is incorrect. If you search the archives of the list there is a lot of =
info about db links. I find them troublesome also. My cube neighbor is =
trying to hunt down the same problem <g>.
Don Freeman
Database Administrator 1
Pennsylvania Dept of Health
Bureau of Information Technology
717-783-8095 Ext 337
-----Original Message-----
From: oracle-l-bounce_at_freelists.org
[mailto:oracle-l-bounce_at_freelists.org]On Behalf Of Burton, Laura
Sent: Tuesday, May 03, 2005 10:17 PM
To: oracle-l_at_freelists.org
Subject: Database Link
I am trying to access an 8.0 database from a 9.2 database. I can do this via sql*plus, but no luck when using a database link. I have an 8.1 database on the same server as the 8.0 database and can connect via a db link and sqlplus.
I have looked at Metalink and found an article that is pretty straight forward. I don't have my connections 'fully qualified' but the connections are set up the same and one works and one doesn't. When you use a link does it use the 'listener' where the database resides and where the connection is coming from? This is probably a dumb question but at this point I am questioning everything I think I know about it.
Any guidance??
Thanks, Laura
--
http://www.freelists.org/webpage/oracle-l
--
http://www.freelists.org/webpage/oracle-l
Received on Wed May 04 2005 - 08:56:03 CDT
![]() |
![]() |