R12.2 Cloning Steps

Hey DBA-Mates,

Hope you all are rocking in APPS DBA because we DBAs always rock in case of work.. :D, just kidding.

Friends, when I searched in google almost people posted only for Apps tier cloning , what about DB tier which no one has mentioned. So, I thought let me cover that.

From long time, I was thinking for cloning as per real time scenario. But due to lack of time, I was not able to do so…

R12.2 CLONING STEPS:

Source: PROD

Target: TEST

1. Pre-requiste TASK AT PROD Instance PROD (Before Backup check space)

Please check the space for DB Backup, Conc Backup and App Backup as per your environment on server.

2. Preclone & Cold Backup on PROD Source                       

Prepare the source system database tier for cloning

$ cd $ORACLE_HOME/appsutil/scripts/PROD_hostname

$ perl adpreclone.pl dbTier

Prepare the Source System Application Tier for cloning

$ echo $FILE_EDITION  ==> Should return run

$ cd <INST_TOP>/admin/scripts

$ perl adpreclone.pl appsTier

Verification of adpreclone.pl done in all Tiers.

AT DBTier

Under cd $ORACLE_HOME/appsutil/clone below 2 files should be latest timestamp:

ls -lrtd jlib

ls -lrtd data

Same as above data => stage , below 2 files should be with current timestamp.

ls -lrt adcrdb.zip

ls -lrt addbhomsrc.xml

At AP(MT)

Here, we check the clone directory under $COMMON_TOP and for more confirmation we can check below two files:

cd $COMMON_TOP/clone

ls -lrtd jlib

ls -lrtd appl

As of Release 12.2, the adpreclone.pl process on the Application Tier creates a complete compressed archive of the Oracle Fusion Middleware such as:

Oracle WebLogic Server home,

Oracle Web Tier Utilities home,

Oracle Common Utilities home and

The Oracle E-Business Suite home.

Now, Shutdown PROD Completely [ because we are using cold backup]

cd $ADMIN_SCRIPTS_HOME

$./adstpall.sh

We need to take COLD Backup of PROD database and application RUN_BASE files system:

From DB Tier files need to be copied:

/u01/PROD/oradata/data

/u01/PROD/oradata/11.2.0 

From APPS Tier files need to be copied:

$RUN_BASE/EBSapps/appl

$RUN_BASE/EBSapps/comn

$RUN_BASE//EBSapps/10.1.2

Copy/Restore (unzip) to TEST by using cp command as per file structure and directory.
For Example:

$cp -R /u01/PROD/oradata/data /u01/TEST/oradata/data

Start the PROD Services because we don’t need.

3. Let’s start DB Clone:

Log on to the Target System as the ORACLE and Run the adcfgclone on the DBTier with dbTier option:

$ cd $ORACLE_HOME/appsutil/clone/bin

$ perl adcfgclone.pl dbTier

After adcfgclone.pl at DB-TIER please check whether DB services and DB listener is up and running. Then Proceed to next step.

Check DB Status and Create Temp Tablespace(if Not exists).

select count(*) from v$datafile; ==> should match as source count

Select distinct status from v$datafile;

Output as below shown:

SYSTEM

ONLINE

select file_name , tablespace_name , bytes/1024/1024 from dba_temp_files;

Example to add:

ALTER TABLESPACE TEMP ADD TEMPFILE '/u01/TEST/oradata/data/temp01.dbf' SIZE 1100M REUSE AUTOEXTEND OFF;

Clean FND_NODES table

Connect apps/<passwd>

EXEC FND_CONC_CLONE.SETUP_CLEAN;

commit;

Run Following command to close open mails:

sqlplus apps/appspwd

SQL>Update WF_NOTIFICATIONS set status = 'CLOSED', mail_status = 'SENT' where status = 'OPEN' and mail_status = 'MAIL';

Run autoconfig in DB tier and check whether the DB entry is updated in FND_NODES table.

$cd $ORACLE_HOME/appsutil/scripts/$CONTEXT_NAME

$adautocfg.sh

After Autoconfig runs successfull check following entry, it should not point to PROD :

sqlplus apps/appspwd

SQL> select node_name,support_db,last_update_date from fnd_nodes;

4. Application Tier Clone TEST

Run adcfgclone.pl on Apps Tier on "Run Edition File System".

Log on to the "Run Edition File System" in the Target System as the applmgr user:

$ cd <COMMON_TOP>/clone/bin

$ perl adcfgclone.pl appsTier

Start the application Tier using adstral.sh on RUN FILE System

cd $ADMIN_SCRIPTS_HOME

adstrtall.sh apps/appspwd

Run adpreclone on TARGET(TEST) RUN FILESYSTEM

We have to run adpreclone.pl on the "Run Edition File System" in the Target System. [New in R12.2]

Note: We are not Running Autoconfig because adcfgclone.pl will run internally autoconfig.

On TARGET (TEST) RUN FILE System

$ cd <INST_TOP>/admin/scripts

$ perl adpreclone.pl appsTier

SHUTDOWN THE APPLICATION which is running on RUN FILESYSTEM

cd $ADMIN_SCRIPTS_HOME

adstpal.sh apps/appspwd

Weblogic admin password:

COPY THE TARGET RUN FILESYSTEM to TARGET PATCH FILESYSTEM

Now, CONFIGURE TARGET PATCH FILESYSTEM

Run adcfgclone.pl on Apps Tier on "Patch Edition File System"

Log on to the "Patch Edition File System" in the Target System( as the APPLMGR user) and enter the following commands:

$ cd <COMMON_TOP>/clone/bin

$ perl adcfgclone.pl appsTier

Note-1: It will ask for Context file name, provide the fs1 (Run Fs) contetxt file name.

Note-2: Port will be different for Run and Patch FS.

Once completed: Startup the application tier services of  TEST

cd $ADMIN_SCRIPTS_HOME

adstrtal.sh apps/password

Enter WLSADMIN password:

Once above all done successfully, please perform Sanity Check.[Here, I can provide your some points or steps very soon]

5. Post Clone steps:

Update profile options and FND_CONCURRENT_REQUESTS:

sqlplus apps/passwd

UPDATE FND_CONCURRENT_REQUESTS

SQL> update fnd_concurrent_requests set status_code='C', phase_code='C'  where phase_code='P';

Change Site level Profile option.

Execute the below sql for running programs.

a) Set Terminating or Running to Completed/Terminated

SQL>UPDATE fnd_concurrent_requests

SET phase_code = 'C', status_code = 'X'

WHERE status_code ='T'

OR phase_code = 'R'

/

b) Place Pending/(Normal/Standby) to On Hold

SQL>UPDATE fnd_concurrent_requests

SET hold_flag = 'Y'

WHERE phase_code = 'P'

AND status_code in ('Q','I')

/

Then check for Health check and sanity check. Login to front end and submit the request.

Some more useful links:

ADADMIN ,ADCONFIG and ADMRGPCH
Oracle DBA Troubleshooting Tips and Guide
ORA-03113: end-of-fileon communication channel Fixed and Troubleshooting

Custom apps read only schema concepts in R12.2

Please let us know for any suggestions either in comment box or contact us @https://ora-data.blogspot.com

Regards,