RC-50409: Topology information required for cloning not found
                                                 Last update (2008-06-13 18:40:22)
                                                                                                                   Date added (2008-06-13 17:50:22)

Summary
Running the preclone steps (adpreclone.pl dbTier) to create a new clone (probably from a previous clone) you get the errors:
RC-50409: Topology information required for cloning not found in the database. 
Make sure that AutoConfig was run successfully prior to starting Rapid Clone, and try again
Raised by oracle.apps.ad.tools.AdCreateCtlFile
RC-50208: Exception  in method gen_crctrfclone_sql
RC-50208: Exception  in Constructor AdCreateCtlFile
Raised by oracle.apps.ad.tools.AdCreateCtlFile
This problem typically occurs when you try to create a new clone, from a clone created from a RAC database.

Workaround
Check if the following query returns a row!
SELECT DB_NAME, INSTANCE_NAME, INSTANCE_NUMBER, SID_GUID,
INTERCONNECT_NAME,PORT,
LISTENER_NAME, NAME, NODE_NAME, HOST
FROM applsys.FND_DATABASES, applsys.FND_DATABASE_INSTANCES, applsys.FND_TNS_LISTENERS,
applsys.FND_TNS_LISTENER_PORTS,
applsys.FND_APP_SERVERS, applsys.FND_NODES
WHERE FND_DATABASES.DB_GUID=FND_DATABASE_INSTANCES.DB_GUID AND
FND_DATABASE_INSTANCES.SERVER_GUID=FND_APP_SERVERS.SERVER_GUID AND
FND_TNS_LISTENERS.LISTENER_GUID = FND_TNS_LISTENER_PORTS.LISTENER_GUID AND
FND_TNS_LISTENERS.SERVER_GUID = FND_APP_SERVERS.SERVER_GUID AND
FND_NODES.NODE_ID = FND_APP_SERVERS.NODE_ID;
A. If YES, then update the INTERCONNECT_NAME column with the instance name. An example follows:
UPDATE applsys.FND_DATABASE_INSTANCES
SET INTERCONNECT_NAME = 'SID';

COMMIT;
B. If NO rows returned then run again the Autoconfig for the Database Tier.

At the end run again the precloning steps
Reviews
Filters
Search