Home » RDBMS Server » Server Administration » DB Link problem.
DB Link problem. [message #408771] Wed, 17 June 2009 14:02 Go to next message
gajini
Messages: 259
Registered: January 2006
Senior Member
Hi All,

In production database,in a schema there is a synonym ""LOG" which is refering a table in another database
using database link "RTP.WORLD" and the package "ORD_PKG" which is using that synonym is valid.

Yesterday, I refreshed the development schema in development with production schema,
after refresh We drop the db link "RTP.WORLD" and create the db link "RTD.WORLD" and
recreate the corresponding the synonyms so that it points to "RTD.WORLD".
Everything is working fine upto this point but when I try to recompile the package "ORD_PKG"
it is hanging and then I checked using following query,

Quote:
select referenced_link_name from user_dependencies where name='ORD_PKG'
this query returns "RTP.WORLD".


Quote:
select db_link from user_synonyms where synonym_name='LOG'
this query return "RTD.WORLD".


I think the compilation problem because the package while using that synonym
it refers the db link "RTP.WORLD" which is not existing in the development database.
Because of this problem I couldn't compile "ORD_PKG" and it is invalid status.

Please anyone help me in resolving this problem so that I can compile the package body successfully.

Thanks..


Re: DB Link problem. [message #408788 is a reply to message #408771] Wed, 17 June 2009 16:12 Go to previous messageGo to next message
babuknb
Messages: 1734
Registered: December 2005
Location: NJ
Senior Member


Check DB Link status.

Try to Grant Execute permission to the USER.

Babu
Re: DB Link problem. [message #408794 is a reply to message #408771] Wed, 17 June 2009 16:35 Go to previous messageGo to next message
gajini
Messages: 259
Registered: January 2006
Senior Member
Hi,

There is no problem with permission and the db link "RTD.WORLD" is working fine, the package compilation is hanging jsu because
the PKG refers the db link "RTD.WORLD" which is not existing in dev database.

Thanks..
Re: DB Link problem. [message #408795 is a reply to message #408771] Wed, 17 June 2009 16:55 Go to previous messageGo to next message
BlackSwan
Messages: 25036
Registered: January 2009
Location: SoCal
Senior Member
> the db link "RTD.WORLD" is working fine
>the PKG refers the db link "RTD.WORLD" which is not existing in dev database.


From my perspective, the 2 lines above contradict each other.

You need to help us by following the Posting Guidelines as stated below.
http://www.orafaq.com/forum/t/88153/0/
Go to the URL above click the link "Posting Guidelines"
Go to the section labeled "Practice" & do as directed.

You describe what you think you see.
You can change either the DBLINK or the tnsnames.ora on Dev to point any instance which is needed.

If you think the package contains incorrect code, what prevents you from changing the code?
Re: DB Link problem. [message #408813 is a reply to message #408794] Wed, 17 June 2009 23:00 Go to previous message
vamsi kasina
Messages: 2107
Registered: October 2003
Location: Riyadh, Saudi Arabia
Senior Member
Quote:
the PKG refers the db link "RTD.WORLD" which is not existing in dev database.
I think OP means RTP.WORLD.
Check whether the package (ORD_PKG) code contains RTP.WORLD or not.

By
Vamsi

[Updated on: Wed, 17 June 2009 23:01]

Report message to a moderator

Previous Topic: upgrade from oracle 9.2.0.1 to 9.2.0.8
Next Topic: Help on SQL Server 2000 to Oracle 10g
Goto Forum:
  


Current Time: Sun Dec 04 20:57:52 CST 2016

Total time taken to generate the page: 0.04973 seconds