Home » Server Options » Replication » Database link active but could not be able to resolve object resolution
Database link active but could not be able to resolve object resolution [message #75555] Sat, 02 October 2004 05:07
Muhammad Rashid
Messages: 4
Registered: September 2004
Junior Member
I am using two Oracle 9i database named below:

shaddu01.BSW2K01.AIT.COM

shaddu01.BSW2K02.AIT.COM

global_names = FALSE

I created following database link on BSW2K01.AIT.COM

CREATE PUBLIC DATABASE LINK shaddu01.BSW2K02.AIT.COM

CONNECT TO scott IDENTIFIED BY doe

using 'abc'

service name 'abc' is working properly.

When we test databaselink from Oracle Enterprise manager, it shows that database link active.When we trying to access data from "shaddu01.BSW2K02.AIT.COM".

It shows object not found.

Please help me in this regard.I will be very thankful.

 

 

 
Previous Topic: Oracle 7 and Oracle 9i
Next Topic: dbms_refresh.refresh does not update secondary DB
Goto Forum:
  


Current Time: Wed Jan 22 17:14:15 CST 2020