OraFAQ Forum: Oracle Fusion Apps & E-Business Suite

Home » Applications » Oracle Fusion Apps & E-Business Suite » Invalid DBLinks after cloning

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

Invalid DBLinks after cloning [message #253662]

Tue, 24 July 2007 09:44

Anand Ramaswamy
Messages: 111
Registered: January 2005

Senior Member

I am in Oracle Apps 11.5.10 environment. After cloning (Apps & Database) from production to development.
I checked :
SELECT * FROM USER_DB_LINKS under APPS
I get the following output:

DB_LINK                     USERNAME      PASSWORD       HOST   
APPS_TO_APPS                  APPS        appsProdPwd    PROD      
APPS_TO_APPS.MYDOMAIN.US.COM  APPS        appsDevPwd     DEV

EDW_APPS_TO_WH                 APPS       appsProdPwd    PROD                                             
EDW_APPS_TO_WH.MYDOMAIN.US.COM APPS       appsDevPwd     DEV

When I try to drop the database link:

for example:
DROP DATABASE LINK APPS_TO_APPS
or
DROP DATABASE LINK APPS_TO_APPS.MYDOMAIN.US.COM
The database link APPS_TO_APPS.MYDOMAIN.US.COM is dropped and APPS_TO_APPS pointing to PROD still remains. How do I drop these two database links
APPS_TO_APPS and EDW_APPS_TO_WH which points to PROD

After cloning, I ran FND_CONC_CLONE.SETUP_CLEAN;
commit; and ran autoconfig. But it doesn't help.

Can anyone help me in resolving this?

Thanks in advance
qA

I have posted this query in other forums also and haven't got a solution.

Report message to a moderator

Previous Topic:	Purchase : Blanket
Next Topic:	Oracle Purchasing FAQ

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Fri Dec 27 13:25:11 CST 2024