Home » Applications » Oracle Fusion Apps & E-Business Suite » Invalid DBLinks after cloning
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.
Previous Topic: Purchase : Blanket
Next Topic: Oracle Purchasing FAQ
Goto Forum:
  


Current Time: Thu Dec 08 16:18:48 CST 2016

Total time taken to generate the page: 0.08292 seconds