adcfgclone.pl database cloning

[Roshan]

Hello,

when I run perl adcfgclone.pl dbTier, it is completing with some errors. I have attached the log file.

Before I ran perl adcfgclone.pl dbTier, i created the control files and temp files, started the database.

Do you have any idea how i can start the listener so that at least users can connect to the database? i am getting error "TNS-01101: Could not find service name preprod
"
ApplyDBTier_02120758.log

Rgds,
Roshan

[ErmanArslansOracleBlog]

I think youır listener does not listen on one of these addresses.
erppreprod.sunresort.local:1524:PREPROD
erppreprod.sunresort.local:1524:PREPROD.sunresort.local

Check your listener.

[ErmanArslansOracleBlog]

Sorry,
Now I see :

ORA-01503: CREATE CONTROLFILE failed
ORA-01158: database  already mounted

ORA-00210: cannot open the specified control file
ORA-06512: at "SYS.X$DBMS_BACKUP_RESTORE", line 4754
ORA-06512: at line 1

Check Troubleshooting RapidClone issues with Oracle Applications R12 (Doc ID 603104.1)
If it is hard for you; then ;
First do the preclone on source again and retry -->

1. Prepare the source system database tier for cloning

cd [RDBMS ORACLE_HOME]/appsutil/scripts/[CONTEXT_NAME]
perl adpreclone.pl dbTier
2. Copy the Source System to the Target System
b. Copy the database tier file system

3. Restart the DB-Tier configuration script on the target :

cd <RDBMS ORACLE_HOME>/appsutil/clone/bin
perl adcfgclone.pl dbTier


If it wont solve, diagnose using the following;

Troubleshooting RapidClone issues with Oracle Applications R12 (Doc ID 603104.1)

[Roshan]

Thanks. I managed to configure and run the database instance.

For the application instance, after I run the adcfgclone.pl, it completed successfully, but when I start it, the forms_server and oacore_server are in admin states. When it is starting listener process it is exiting with status 1
Starting listener process APPS_PREPROD.

adalnctl.sh: exiting with status 1

Please find attached the logsstartup.rar

[ErmanArslansOracleBlog]

I think your clone is not successful.
Shutdown all the services, run autoconfig on database and then run autoconfig application tier
Confirm this file exists in the application tier server;
/u01/oracle/PREPROD/fs2/inst/apps/PREPROD_erppreprod/ora/10.1.2/network/admin/listener.ora

Then retry.

If you still get the error, check autoconfig logs

[Roshan]

startup.rarHi,

on the database instance, when I run autoconfig, I am getting the error in the post "postclone database". The metalink IDs you gave me is for 12.1. I have raised an SR for this issue. Maybe there should be a patch for 12.2

When I run autoconfig on application tier, the listener cannot be created in /u01/oracle/PREPROD/fs2/inst/apps/PREPROD_erppreprod/ora/10.1.2/network/admin/listener.ora.

AC-50480: Internal error occurred: java.lang.Exception: Error while generating listener.ora.

Please find attached the logs.

Thanks and Rgds
Roshan

[ErmanArslansOracleBlog]

I guess you have; wrong "NODE_NAME"  value exists in the "FND_CONCURRENT_QUEUES" table.

Check FND_CONCURRENT_QUEUES and fix it by updating the wrong fields and retry your failed operation.

This blog post is for concurrent manager problem but it shows how to update. This may be used for your listener case as well.
http://ermanarslan.blogspot.com.tr/2015/12/ebs-11ir12-concurrent-manager-target.html

For making the things clean;

I would do the following;

use fnd_conc_clone.setup_clean to clean the fnd_nodes and other tables
Then run autoconfig in the db tier
Then run autoconfig on the application tier.
Check the FND_CONCURRENT_QUEUES table node_name column, and update the wrong node names if there are such entries
Rerun autoconfig on apps tier
Start the services.

[ErmanArslansOracleBlog]

Your database autoconfig have also encountered errors.
I think you are doing something wrong.
Start by fixing the errors of in db tier autoconfig and then when it is completed successfuly , continue with apps tier autoconfig.

First read and know the cloning process with all in details.

Follow your SR, because I cant assist you with fixing all of the problems that you have encountered in such as standard process like cloning. This is not the reason or in the scope of this forum.

If you need consultancy, we can give you technical support from my company.

Thanks.

[Roshan]

okay. Thank you. I will follow the SR.

[Roshan]

Hello

I managed to solve the issue. In fact the autoconfig should be run when the database and listener are up and running. This was why in the log file I was getting listener error.. could not establish connection. I had to use a bit of logic but I panicked.

You have helped enough for my problems. The project I am working there is lots of pressure. Next time I will not go into too much details to fix the problem.

Many thanks and regards.