Oracle Blog: Cloning EBS R12.1.1 with Manual(HOT Backup)

Cloning EBS R12.1.1 with Manual(HOT Backup)

EBS R12.1.1

DB 11.1.0.7.0

Source System : OraApps.nitin (192.168.99.125)

Target System : OraApps.nitin (192.168.99.155)

on Source System

User (both DB and Apps): oracle

go to oracle home -- appsutil -- scripts--context name directory

[oracle@OraApps PROD_oraapps]$ pwd

/oracle/PROD/db/tech_st/11.1.0/appsutil/scripts/PROD_oraapps

[oracle@OraApps PROD_oraapps]$ ls

adautocfg.sh addbctl.sh adexecsql.pl adpreclone.pl adstrtdb.sql

adchknls.pl addlnctl.sh adlsnodes.sh adstopdb.sql

run " adpreclone.pl dbTier " script

[oracle@OraApps PROD_oraapps]$ perl adpreclone.pl dbTier

Redwood Shores, California, USA

Oracle Applications Rapid Clone

Version 12.0.0

adpreclone Version 120.20.12010000.2

Enter the APPS User Password:

Running:

perl /oracle/PROD/db/tech_st/11.1.0/appsutil/bin/adclone.pl java=/oracle/PROD/db/tech_st/11.1.0/appsutil/jre mode=stage stage=/oracle/PROD/db/tech_st/11.1.0/appsutil/clone component=dbTier method=CUSTOM dbctx=/oracle/PROD/db/tech_st/11.1.0/appsutil/PROD_oraapps.xml showProgress

APPS Password :

Beginning database tier Stage - Fri Dec 2 10:41:32 2016

/oracle/PROD/db/tech_st/11.1.0/appsutil/jre/bin/java -Xmx600M -DCONTEXT_VALIDATED=false -Doracle.installer.oui_loc=/oracle/PROD/db/tech_st/11.1.0/oui -classpath /oracle/PROD/db/tech_st/11.1.0/lib/xmlparserv2.jar:/oracle/PROD/db/tech_st/11.1.0/jdbc/lib/ojdbc6.jar:/oracle/PROD/db/tech_st/11.1.0/appsutil/java:/oracle/PROD/db/tech_st/11.1.0/oui/jlib/OraInstaller.jar:/oracle/PROD/db/tech_st/11.1.0/oui/jlib/ewt3.jar:/oracle/PROD/db/tech_st/11.1.0/oui/jlib/share.jar:/oracle/PROD/db/tech_st/11.1.0/oui/jlib/srvm.jar:/oracle/PROD/db/tech_st/11.1.0/jlib/ojmisc.jar oracle.apps.ad.clone.StageDBTier -e /oracle/PROD/db/tech_st/11.1.0/appsutil/PROD_oraapps.xml -stage /oracle/PROD/db/tech_st/11.1.0/appsutil/clone -tmp /tmp -method CUSTOM -showProgress

APPS Password :

Log file located at /oracle/PROD/db/tech_st/11.1.0/appsutil/log/PROD_oraapps/StageDBTier_12021041.log

/ 50% completed

Completed Stage...

Fri Dec 2 10:41:46 2016

After the script is executed successfully, a new folder ‘clone’ gets created under

$ORACLE_HOME/appsutil

[oracle@OraApps appsutil]$ pwd

/oracle/PROD/db/tech_st/11.1.0/appsutil

[oracle@OraApps appsutil]$ ls

bin clone conf_PROD.txt conf_PROD.txt.bac driver html install java jre log media out outbound perl PROD_oraapps.xml scripts sql temp template

[oracle@OraApps appsutil]$

Now run similar scripts on Apps server.

[oracle@OraApps PROD_oraapps]$ cd /oracle/PROD/apps/apps_st/appl/

source Apps server env. file

[oracle@OraApps appl]$ . ./APPSPROD_oraapps.env

cd /oracle/PROD/inst/apps/PROD_oraapps/admin/scripts or CD

$ADMIN_SCRIPTS_HOME

and run perl " adpreclone.pl appsTier "

[oracle@OraApps scripts]$ pwd

/oracle/PROD/inst/apps/PROD_oraapps/admin/scripts

[oracle@OraApps scripts]$ ls

adalnctl.sh adautocfg.sh adexecsql.pl adformsrvctl.sh adoafmctl.sh adpreclone.pl adstrtal.sh ieo jtffmctl.sh mwactl.sh

adapcctl.sh adcmctl.sh adformsctl.sh adoacorectl.sh adopmnctl.sh adstpall.sh gsmstart.sh java.sh msc mwactlwrpr.sh

[oracle@OraApps scripts]$

[oracle@OraApps scripts]$ perl adpreclone.pl appsTier

Redwood Shores, California, USA

Oracle Applications Rapid Clone

Version 12.0.0

adpreclone Version 120.20.12010000.2

Running:

perl /oracle/PROD/apps/apps_st/appl/ad/12.0.0/bin/adclone.pl java=/oracle/PROD/apps/tech_st/10.1.3/appsutil/jdk mode=stage stage=/oracle/PROD/apps/apps_st/comn/clone component=appsTier method= appctx=/oracle/PROD/inst/apps/PROD_oraapps/appl/admin/PROD_oraapps.xml showProgress

APPS Password :

method defaulted to CUSTOM

Beginning application tier Stage - Fri Dec 2 10:47:10 2016

/oracle/PROD/apps/tech_st/10.1.3/appsutil/jdk/bin/java -Xmx600M -DCONTEXT_VALIDATED=false -Doracle.installer.oui_loc=/oui -classpath /oracle/PROD/apps/tech_st/10.1.3/lib/xmlparserv2.jar:/oracle/PROD/apps/tech_st/10.1.3/jdbc/lib/ojdbc14.jar:/oracle/PROD/apps/apps_st/comn/java/classes:/oracle/PROD/apps/tech_st/10.1.3/oui/jlib/OraInstaller.jar:/oracle/PROD/apps/tech_st/10.1.3/oui/jlib/ewt3.jar:/oracle/PROD/apps/tech_st/10.1.3/oui/jlib/share.jar:/oracle/PROD/apps/tech_st/10.1.3/oui/jlib/srvm.jar:/oracle/PROD/apps/tech_st/10.1.3/jlib/ojmisc.jar oracle.apps.ad.clone.StageAppsTier -e /oracle/PROD/inst/apps/PROD_oraapps/appl/admin/PROD_oraapps.xml -stage /oracle/PROD/apps/apps_st/comn/clone -tmp /tmp -method CUSTOM -showProgress

Log file located at /oracle/PROD/inst/apps/PROD_oraapps/admin/log/StageAppsTier_12021047.log

/ 80% completed

Completed Stage...

Fri Dec 2 10:47:26 2016

[oracle@OraApps scripts]$

Similar clone directory will be created under /oracle/PROD/apps/apps_st/comn/

Now Copy Application and Database directory to target. First tar/zip it whichever suits you.

Run below command from a directory where you've good free space

tar -czvf db_home.tar /oracle/PROD/db/tech_st

Then logon to oracle and start backup

[oracle@OraApps oracle]$ sqlplus / as sysdba

SQL*Plus: Release 11.1.0.7.0 - Production on Fri Dec 2 11:53:26 2016

Connected to:

Oracle Database 11g Enterprise Edition Release 11.1.0.7.0 - 64bit Production

With the Partitioning, OLAP, Data Mining and Real Application Testing options

SQL> alter database begin backup;

Database altered.

SQL> select * from v$backup;

FILE# STATUS CHANGE# TIME

---------- ------------------ ---------- ---------

1 ACTIVE 5.9651E+12 02-DEC-16

2 ACTIVE 5.9651E+12 02-DEC-16

3 ACTIVE 5.9651E+12 02-DEC-16

4 ACTIVE 5.9651E+12 02-DEC-16

5 ACTIVE 5.9651E+12 02-DEC-16

6 ACTIVE 5.9651E+12 02-DEC-16

7 ACTIVE 5.9651E+12 02-DEC-16

8 ACTIVE 5.9651E+12 02-DEC-16

9 ACTIVE 5.9651E+12 02-DEC-16

10 ACTIVE 5.9651E+12 02-DEC-16

11 ACTIVE 5.9651E+12 02-DEC-16

FILE# STATUS CHANGE# TIME

---------- ------------------ ---------- ---------

12 ACTIVE 5.9651E+12 02-DEC-16

13 ACTIVE 5.9651E+12 02-DEC-16

14 ACTIVE 5.9651E+12 02-DEC-16

15 ACTIVE 5.9651E+12 02-DEC-16

16 ACTIVE 5.9651E+12 02-DEC-16

17 ACTIVE 5.9651E+12 02-DEC-16

18 ACTIVE 5.9651E+12 02-DEC-16

288 ACTIVE 5.9651E+12 02-DEC-16

295 ACTIVE 5.9651E+12 02-DEC-16

314 ACTIVE 5.9651E+12 02-DEC-16

351 ACTIVE 5.9651E+12 02-DEC-16

FILE# STATUS CHANGE# TIME

---------- ------------------ ---------- ---------

352 ACTIVE 5.9651E+12 02-DEC-16

353 ACTIVE 5.9651E+12 02-DEC-16

354 ACTIVE 5.9651E+12 02-DEC-16

379 ACTIVE 5.9651E+12 02-DEC-16

392 ACTIVE 5.9651E+12 02-DEC-16

393 ACTIVE 5.9651E+12 02-DEC-16

394 ACTIVE 5.9651E+12 02-DEC-16

395 ACTIVE 5.9651E+12 02-DEC-16

396 ACTIVE 5.9651E+12 02-DEC-16

397 ACTIVE 5.9651E+12 02-DEC-16

398 ACTIVE 5.9651E+12 02-DEC-16

FILE# STATUS CHANGE# TIME

---------- ------------------ ---------- ---------

399 ACTIVE 5.9651E+12 02-DEC-16

400 ACTIVE 5.9651E+12 02-DEC-16

401 ACTIVE 5.9651E+12 02-DEC-16

402 ACTIVE 5.9651E+12 02-DEC-16

403 ACTIVE 5.9651E+12 02-DEC-16

404 ACTIVE 5.9651E+12 02-DEC-16

405 ACTIVE 5.9651E+12 02-DEC-16

406 ACTIVE 5.9651E+12 02-DEC-16

407 ACTIVE 5.9651E+12 02-DEC-16

42 rows selected.

SQL> exit

now start zipping datafile

tar -czvf db_home.tar /oracle/PROD/db/apps_st

also zip application server

tar -czvf apps.tar /oracle/PROD/apps

Then logon to oracle and issue below command to end online backup and also generate archivelogs and controlfile

[oracle@OraApps oracle]$ sqlplus / as sysdba

SQL*Plus: Release 11.1.0.7.0 - Production on Fri Dec 2 11:53:26 2016

Connected to:

Oracle Database 11g Enterprise Edition Release 11.1.0.7.0 - 64bit Production

With the Partitioning, OLAP, Data Mining and Real Application Testing options

SQL> alter database end backup;

Database altered.

SQL> alter system archive log current ;

SQL> alter database backup contolfile to trace as ‘/oracle/cntrlfile.sql’;

SQL> exit;

Now copy below files to target server with archive logs generated after the command “alter system archive log current ;” above.

Archive logs can be found in $ORACLE_HOME/dbs or $ORACLE_HOME/dbs/arc or FLASH_RECOVERY_AREA or /oracle/PROD/db/apps_st/data/

depending upon your environment .

/oracle/cntrlfile.sql

apps.tar

db_home.tar

Configure the target system

Database configuration first.

Go to below directory

cd /oracle/PROD/db/tech_st/11.1.0/appsutil/clone/bin

and issue below command

$ perl adcfgclone.pl dbTechStack

you can check log file mentioned in the process for any error

tail -f /oracle/PROD/db/tech_st/11/1/0/appsutil/log/DEV_oraapps/ApplyDBTechStach_12030588.log

This will ask you few questions like below..I've answered considering my environment

oracle base directory – /oracle

Target Instance RAC – N

Target system SID – DEV (you can give whatever you want like ERPDEV or like whatever you already have)

Hostname – oraapps

util_file_dir - /usr/tmp

DATA_TOP - /oracle/PROD/db/apps_st/data

ORACLE_HOME directory - /oracle/PROD/db/tech_st/11.1.0

Display - oraapps:0.0

Target System port pool – 5 (this one according to your environment like prodution have login url port 8000, you can change this to 8005 by giving 5 in above.

so all default oracle port will have +5 value. Like listener will listen on 1526

same value (5) need to provide in Application configuration time.

Once this is completed, oracle Listener will start automatically

now after this go ORACLE_HOME/dbs directory

find init.ora file and mke below changes

db_name='DEV' --change the name as given in script perl adcfgclone.pl dbTechStack Target system SID – DEV above

control_files = (/oracle/PROD/db/apps_st/data/control01.ctl,/oracle/PROD/db/apps_st/data/control02.ctl,/oracle/PROD/db/apps_st/data/control03.ctl) –-- change the location according to your environment.

Save it and close it.

Now open the controlfile we copied from source system and copy below content to other some other file..

The highlighted part changed according to our environment.

CREATE CONTROLFILE SET DATABASE "DEV" RESETLOGS ARCHIVELOG

MAXLOGFILES 32

MAXLOGMEMBERS 5

MAXDATAFILES 512

MAXINSTANCES 8

MAXLOGHISTORY 14607

LOGFILE

GROUP 1 (

'/oracle/PROD/db/apps_st/data/log01a.dbf',

'/oracle/PROD/db/apps_st/data/log01b.dbf'

) SIZE 1000M,

GROUP 2 (

'/oracle/PROD/db/apps_st/data/log02a.dbf',

'/oracle/PROD/db/apps_st/data/log02b.dbf'

) SIZE 1000M

-- STANDBY LOGFILE

DATAFILE

'/oracle/PROD/db/apps_st/data/system01.dbf',

'/oracle/PROD/db/apps_st/data/system02.dbf',

'/oracle/PROD/db/apps_st/data/system03.dbf',

'/oracle/PROD/db/apps_st/data/system04.dbf',

'/oracle/PROD/db/apps_st/data/system05.dbf',

'/oracle/PROD/db/apps_st/data/ctxd01.dbf',

'/oracle/PROD/db/apps_st/data/owad01.dbf',

'/oracle/PROD/db/apps_st/data/a_queue02.dbf',

'/oracle/PROD/db/apps_st/data/odm.dbf',

'/oracle/PROD/db/apps_st/data/olap.dbf',

'/oracle/PROD/db/apps_st/data/sysaux01.dbf',

'/oracle/PROD/db/apps_st/data/apps_ts_tools01.dbf',

'/oracle/PROD/db/apps_st/data/system12.dbf',

'/oracle/PROD/db/apps_st/data/a_txn_data04.dbf',

'/oracle/PROD/db/apps_st/data/a_txn_ind06.dbf',

'/oracle/PROD/db/apps_st/data/a_ref03.dbf',

'/oracle/PROD/db/apps_st/data/a_int02.dbf',

'/oracle/PROD/db/apps_st/data/sysaux02.dbf',

'/oracle/PROD/db/apps_st/data/system10.dbf',

'/oracle/PROD/db/apps_st/data/system06.dbf',

'/oracle/PROD/db/apps_st/data/portal01.dbf',

'/oracle/PROD/db/apps_st/data/system07.dbf',

'/oracle/PROD/db/apps_st/data/system09.dbf',

'/oracle/PROD/db/apps_st/data/system08.dbf',

'/oracle/PROD/db/apps_st/data/system11.dbf',

'/oracle/PROD/db/apps_st/data/undo01.dbf',

'/oracle/PROD/db/apps_st/data/a_txn_data01.dbf',

'/oracle/PROD/db/apps_st/data/a_txn_ind01.dbf',

'/oracle/PROD/db/apps_st/data/a_ref01.dbf',

'/oracle/PROD/db/apps_st/data/a_int01.dbf',

'/oracle/PROD/db/apps_st/data/a_summ01.dbf',

'/oracle/PROD/db/apps_st/data/a_nolog01.dbf',

'/oracle/PROD/db/apps_st/data/a_archive01.dbf',

'/oracle/PROD/db/apps_st/data/a_queue01.dbf',

'/oracle/PROD/db/apps_st/data/a_media01.dbf',

'/oracle/PROD/db/apps_st/data/a_txn_data02.dbf',

'/oracle/PROD/db/apps_st/data/a_txn_data03.dbf',

'/oracle/PROD/db/apps_st/data/a_txn_ind02.dbf',

'/oracle/PROD/db/apps_st/data/a_txn_ind03.dbf',

'/oracle/PROD/db/apps_st/data/a_txn_ind04.dbf',

'/oracle/PROD/db/apps_st/data/a_txn_ind05.dbf',

'/oracle/PROD/db/apps_st/data/a_ref02.dbf'

CHARACTER SET US7ASCII

;

copy/save the above file to ORACLE_HOME/dbs location( you can keep it anywhere)

and source DB environment file

[oracle@OraApps DEV_oraapps]$ cd /oracle/PROD/db/tech_st/11.1.0

[oracle@OraApps DEV_oraapps]$ . ./DEV_oraapps.env

[oracle@OraApps DEV_oraapps]$ cd dbs/

[oracle@OraApps 11.1.0]$ sqlplus / as sysdba

SQL*Plus: Release 11.1.0.7.0 - Production on Sat Dec 3 05:32:08 2016

Connected to an idle instance.

SQL>

SQL> @controlDEV.sql

Control file created.

SQL> select open_mode from v$database;

OPEN_MODE

----------

MOUNTED

SQL>

Now recover database with below command and give the path of archive logs we copied from source system.

In my case I kept it at /oracle directory

[oracle@OraApps Desktop]$ cd /oracle/

[oracle@OraApps oracle]$ ls -al

total 184568

drwxrwxr-x. 5 oracle dba 4096 Dec 3 07:17 .

dr-xr-xr-x. 28 root root 4096 Dec 3 20:10 ..

-rwxrwxr-x. 1 oracle dba 184759808 Dec 3 04:59 arch1_1_929428055.dbf

-rwxrwxr-x. 1 oracle dba 2048 Dec 3 04:59 arch1_2_929428055.dbf

-rwxrwxr-x. 1 oracle dba 1024 Dec 3 04:59 arch1_3_929428055.dbf

-rwxrwxr-x. 1 oracle dba 3568640 Dec 3 04:59 arch1_4_929428055.dbf

-rwxrwxr-x. 1 oracle dba 73728 Dec 3 04:59 arch1_5_929428055.dbf

-rwxrwxr-x. 1 oracle dba 2560 Dec 3 04:59 arch1_6_929428055.dbf

now issue recover command and apply all archive logs. Once you finish applying all logs, type cancel

and then issue below command to open database.

alter database open resetlogs;

SQL> recover database using backup controlfile until cancel;

ORA-00279: change 5965125779861 generated at 12/02/2016 11:55:04 needed for

thread 1

ORA-00289: suggestion :

/oracle/PROD/db/tech_st/11.1.0/dbs/arch1_4_929428055.dbf

ORA-00280: change 5965125779861 for thread 1 is in sequence #4

Specify log: {<RET>=suggested | filename | AUTO | CANCEL}

/oracle/arch1_4_929428055.dbf

ORA-00279: change 5965125780812 generated at 12/02/2016 12:23:17 needed for

thread 1

ORA-00289: suggestion :

/oracle/PROD/db/tech_st/11.1.0/dbs/arch1_5_929428055.dbf

ORA-00280: change 5965125780812 for thread 1 is in sequence #5

ORA-00278: log file '/oracle/arch1_4_929428055.dbf' no longer needed for this

recovery

Specify log: {<RET>=suggested | filename | AUTO | CANCEL}

/oracle/arch1_4_929428055.dbf

ORA-00310: archived log contains sequence 4; sequence 5 required

ORA-00334: archived log: '/oracle/arch1_4_929428055.dbf'

SQL> recover database using backup controlfile until cancel;

ORA-00279: change 5965125780812 generated at 12/02/2016 12:23:17 needed for

thread 1

ORA-00289: suggestion :

/oracle/PROD/db/tech_st/11.1.0/dbs/arch1_5_929428055.dbf

ORA-00280: change 5965125780812 for thread 1 is in sequence #5

Specify log: {<RET>=suggested | filename | AUTO | CANCEL}

/oracle/arch1_5_929428055.dbf

ORA-00279: change 5965125785083 generated at 12/03/2016 04:53:20 needed for

thread 1

ORA-00289: suggestion :

/oracle/PROD/db/tech_st/11.1.0/dbs/arch1_6_929428055.dbf

ORA-00280: change 5965125785083 for thread 1 is in sequence #6

ORA-00278: log file '/oracle/arch1_5_929428055.dbf' no longer needed for this

recovery

Specify log: {<RET>=suggested | filename | AUTO | CANCEL}

/oracle/arch1_6_929428055.dbf

ORA-00279: change 5965125785103 generated at 12/03/2016 04:54:06 needed for

thread 1

ORA-00289: suggestion :

/oracle/PROD/db/tech_st/11.1.0/dbs/arch1_7_929428055.dbf

ORA-00280: change 5965125785103 for thread 1 is in sequence #7

ORA-00278: log file '/oracle/arch1_6_929428055.dbf' no longer needed for this

recovery

Specify log: {<RET>=suggested | filename | AUTO | CANCEL}

cancel

Media recovery cancelled.

SQL> alter database open resetlogs;

Database altered.

add Temporary datafile to Temporary tablespace. This command can be found in controlfile we copied from source.

SQL> ALTER TABLESPACE TEMP1 ADD TEMPFILE '/oracle/PROD/db/apps_st/data/temp01.dbf'

SIZE 1100M REUSE AUTOEXTEND OFF;

Tablespace altered.

SQL> ALTER TABLESPACE TEMP2 ADD TEMPFILE '/oracle/PROD/db/apps_st/data/temp02.dbf'

SIZE 1024M REUSE AUTOEXTEND OFF;

Tablespace altered.

SQL> exit

now run below script to update library in Database

[oracle@OraApps DEV_oraapps]$ cd /oracle/PROD/db/tech_st/11.1.0/appsutil/install/DEV_oraapps

[oracle@OraApps DEV_oraapps]$ pwd

/oracle/PROD/db/tech_st/11.1.0/appsutil/install/DEV_oraapps

[oracle@OraApps DEV_oraapps]$ sqlplus / as sysdba

Connected to:

Oracle Database 11g Enterprise Edition Release 11.1.0.7.0 - 64bit Production

With the Partitioning, OLAP, Data Mining and Real Application Testing options

SQL> @adupdlib.sql so

PL/SQL procedure successfully completed.

SQL> exit

Disconnected from Oracle Database 11g Enterprise Edition Release 11.1.0.7.0 - 64bit Production

With the Partitioning, OLAP, Data Mining and Real Application Testing options

Now run the main adcfgclone.pl script on database to finalize the process for Database.

Provide the context file to it.

[oracle@OraApps DEV_oraapps]$ cd $ORACLE_HOME/appsutil/clone/bin

[oracle@OraApps bin]$ pwd

/oracle/PROD/db/tech_st/11.1.0/appsutil/clone/bin

[oracle@OraApps bin]$

[oracle@OraApps bin]$ echo $CONTEXT_FILE

/oracle/PROD/db/tech_st/11.1.0/appsutil/DEV_oraapps.xml

[oracle@OraApps bin]$

[oracle@OraApps bin]$ perl adcfgclone.pl dbconfig /oracle/PROD/db/tech_st/11.1.0/appsutil/DEV_oraapps.xml

Redwood Shores, California, USA

Oracle Applications Rapid Clone

Version 12.0.0

adcfgclone Version 120.31.12010000.1

Enter the APPS password :

Running Rapid Clone with command:

perl /oracle/PROD/db/tech_st/11.1.0/appsutil/clone/bin/adclone.pl java=/oracle/PROD/db/tech_st/11.1.0/appsutil/clone/bin/../jre mode=apply stage=/oracle/PROD/db/tech_st/11.1.0/appsutil/clone component=dbconfig method=CUSTOM dbctxtg=/oracle/PROD/db/tech_st/11.1.0/appsutil/DEV_oraapps.xml showProgress contextValidated=false

Running:

APPS Password :

Beginning dbconfig Apply - Sat Dec 3 06:52:27 2016

/oracle/PROD/db/tech_st/11.1.0/appsutil/clone/bin/../jre/bin/java -Xmx600M -DCONTEXT_VALIDATED=false -Doracle.installer.oui_loc=/oracle/PROD/db/tech_st/11.1.0/oui -classpath /oracle/PROD/db/tech_st/11.1.0/appsutil/clone/jlib/xmlparserv2.jar:/oracle/PROD/db/tech_st/11.1.0/appsutil/clone/jlib/ojdbc6.jar:/oracle/PROD/db/tech_st/11.1.0/appsutil/clone/jlib/java:/oracle/PROD/db/tech_st/11.1.0/appsutil/clone/jlib/oui/OraInstaller.jar:/oracle/PROD/db/tech_st/11.1.0/appsutil/clone/jlib/oui/ewt3.jar:/oracle/PROD/db/tech_st/11.1.0/appsutil/clone/jlib/oui/share.jar:/oracle/PROD/db/tech_st/11.1.0/appsutil/clone/jlib/oui/srvm.jar:/oracle/PROD/db/tech_st/11.1.0/appsutil/clone/jlib/ojmisc.jar oracle.apps.ad.clone.ApplyDatabase -e /oracle/PROD/db/tech_st/11.1.0/appsutil/DEV_oraapps.xml -stage /oracle/PROD/db/tech_st/11.1.0/appsutil/clone -showProgress -checkDBConnection

-e

/oracle/PROD/db/tech_st/11.1.0/appsutil/DEV_oraapps.xml

-stage

/oracle/PROD/db/tech_st/11.1.0/appsutil/clone

-showProgress

-checkDBConnection

APPS Password : Log file located at /oracle/PROD/db/tech_st/11.1.0/appsutil/log/DEV_oraapps/ApplyDatabase_12030652.log

| 0% completed

Log file located at /oracle/PROD/db/tech_st/11.1.0/appsutil/log/DEV_oraapps/ApplyDatabase_12030652.log

\ 30% completed

Completed Apply...

Sat Dec 3 06:53:41 2016

Starting database listener for DEV:

Running:

/oracle/PROD/db/tech_st/11.1.0/appsutil/scripts/DEV_oraapps/addlnctl.sh start DEV

You are running addlnctl.sh version 120.1.12010000.2

Logfile: /oracle/PROD/db/tech_st/11.1.0/appsutil/log/DEV_oraapps/addlnctl.txt

Starting listener process DEV ...

Listener DEV has already been started.

addlnctl.sh: exiting with status 0

you can refer below logfile for any error /oracle/PROD/db/tech_st/11.1.0/appsutil/log/DEV_oraapps/ApplyDatabase_12030652.log

This finishes Database cloning part. Now follows Apps cloning

========================

APPS CLONING

========================

go to /oracle/PROD/apps/apps_st/comn/clone/bin as application owner OS user .

[oracle@OraApps bin]$ export PATH=/usr/bin;$PATH

[oracle@OraApps bin]$ /oracle/PROD/apps/apps_st/comn/clone/bin

/oracle/PROD/apps/apps_st/comn/clone/bin

[oracle@OraApps bin]$ ls

adaddnode.pl adclonectx.pl CloneContext_1203072432.log

adcfgclone.pl adclone.pl CloneContext_1203120403.log

adchkutl.sh CloneContext_1203065607.log CloneContext_1203120436.log

[oracle@OraApps bin]$

now run adcfgclone.pl script and answer few of environment paths. I've highlighted those below. Change it according to your environment.

[oracle@OraApps bin]$ perl adcfgclone.pl appsTier

Redwood Shores, California, USA

Oracle Applications Rapid Clone

Version 12.0.0

adcfgclone Version 120.31.12010000.1

Enter the APPS password :

Running:

/oracle/PROD/apps/apps_st/comn/clone/bin/../jre/bin/java -Xmx600M -cp /oracle/PROD/apps/apps_st/comn/clone/jlib/java:/oracle/PROD/apps/apps_st/comn/clone/jlib/xmlparserv2.jar:/oracle/PROD/apps/apps_st/comn/clone/jlib/ojdbc14.jar oracle.apps.ad.context.CloneContext -e /oracle/PROD/apps/apps_st/comn/clone/bin/../context/apps/CTXORIG.xml -validate -pairsfile /tmp/adpairsfile_5193.lst -stage /oracle/PROD/apps/apps_st/comn/clone 2> /tmp/adcfgclone_5193.err; echo $? > /tmp/adcfgclone_5193.res

Log file located at /oracle/PROD/apps/apps_st/comn/clone/bin/CloneContext_1203120436.log

Provide the values required for creation of the new APPL_TOP Context file.

Target System Hostname (virtual or normal) [oraapps] : oraapps

Target System Database SID : DEV

Target System Database Server Node [oraapps] :

Target System Base Directory : /oracle

Target System Tools ORACLE_HOME Directory [/oracle/apps/tech_st/10.1.2] : /oracle/PROD/apps/tech_st/10.1.2

Target System Web ORACLE_HOME Directory [/oracle/apps/tech_st/10.1.3] : /oracle/PROD/apps/tech_st/10.1.3

Target System APPL_TOP Directory [/oracle/apps/apps_st/appl] : /oracle/PROD/apps/apps_st/appl

Target System COMMON_TOP Directory [/oracle/apps/apps_st/comn] : /oracle/PROD/apps/apps_st/comn

Target System Instance Home Directory [/oracle/inst] :

Target System Root Service [enabled] :

Target System Web Entry Point Services [enabled] :

Target System Web Application Services [enabled] :

Target System Batch Processing Services [enabled] :

Target System Other Services [disabled] :

Do you want to preserve the Display [oraapps:0.0] (y/n) ? :

Invalid input value. 'y' or 'n' required.

Do you want to preserve the Display [oraapps:0.0] (y/n) ? : y

Target System Port Pool [0-99] : 5

Checking the port pool 5

done: Port Pool 5 is free

Report file located at /oracle/inst/apps/DEV_oraapps/temp/portpool.lst

Complete port information available at /oracle/inst/apps/DEV_oraapps/temp/portpool.lst

UTL_FILE_DIR on database tier consists of the following directories.

1. /usr/tmp

2. /usr/tmp

3. /oracle/PROD/db/tech_st/11.1.0/appsutil/outbound/DEV_oraapps

4. /usr/tmp

Choose a value which will be set as APPLPTMP value on the target node [1] : 1

Backing up /oracle/inst/apps/DEV_oraapps/appl/admin/DEV_oraapps.xml to /oracle/inst/apps/DEV_oraapps/appl/admin/DEV_oraapps.xml.bak

Creating the new APPL_TOP Context file from :

/oracle/PROD/apps/apps_st/appl/ad/12.0.0/admin/template/adxmlctx.tmp

The new APPL_TOP context file has been created :

/oracle/inst/apps/DEV_oraapps/appl/admin/DEV_oraapps.xml

Log file located at /oracle/PROD/apps/apps_st/comn/clone/bin/CloneContext_1203120436.log

Check Clone Context logfile /oracle/PROD/apps/apps_st/comn/clone/bin/CloneContext_1203120436.log for details.

Running Rapid Clone with command:

perl /oracle/PROD/apps/apps_st/comn/clone/bin/adclone.pl java=/oracle/PROD/apps/apps_st/comn/clone/bin/../jre mode=apply stage=/oracle/PROD/apps/apps_st/comn/clone component=appsTier method=CUSTOM appctxtg=/oracle/inst/apps/DEV_oraapps/appl/admin/DEV_oraapps.xml showProgress contextValidated=true

Running:

APPS Password :

Beginning application tier Apply - Sat Dec 3 12:06:01 2016

/oracle/PROD/apps/apps_st/comn/clone/bin/../jre/bin/java -Xmx600M -DCONTEXT_VALIDATED=true -Doracle.installer.oui_loc=/oui -classpath /oracle/PROD/apps/apps_st/comn/clone/jlib/xmlparserv2.jar:/oracle/PROD/apps/apps_st/comn/clone/jlib/ojdbc14.jar:/oracle/PROD/apps/apps_st/comn/clone/jlib/java:/oracle/PROD/apps/apps_st/comn/clone/jlib/oui/OraInstaller.jar:/oracle/PROD/apps/apps_st/comn/clone/jlib/oui/ewt3.jar:/oracle/PROD/apps/apps_st/comn/clone/jlib/oui/share.jar:/oracle/PROD/apps/apps_st/comn/clone/jlib/oui/srvm.jar:/oracle/PROD/apps/apps_st/comn/clone/jlib/ojmisc.jar oracle.apps.ad.clone.ApplyAppsTier -e /oracle/inst/apps/DEV_oraapps/appl/admin/DEV_oraapps.xml -stage /oracle/PROD/apps/apps_st/comn/clone -showProgress

APPS Password : Log file located at /oracle/inst/apps/DEV_oraapps/admin/log/ApplyAppsTier_12031206.log

\ 73% completed

Completed Apply...

Sat Dec 3 12:10:01 2016

Starting application Services for DEV:

Running:

/oracle/inst/apps/DEV_oraapps/admin/scripts/adstrtal.sh -nopromptmsg

You are running adstrtal.sh version 120.15

The logfile for this session is located at /oracle/inst/apps/DEV_oraapps/logs/appl/admin/log/adstrtal.log

Executing service control script:

/oracle/inst/apps/DEV_oraapps/admin/scripts/adopmnctl.sh start

script returned:

****************************************************

You are running adopmnctl.sh version 120.6

Starting Oracle Process Manager (OPMN) ...

opmnctl: opmn started.

adopmnctl.sh: exiting with status 0

adopmnctl.sh: check the logfile /oracle/inst/apps/DEV_oraapps/logs/appl/admin/log/adopmnctl.txt for more information ...

.end std out.

.end err out.

****************************************************

Executing service control script:

/oracle/inst/apps/DEV_oraapps/admin/scripts/adalnctl.sh start

script returned:

****************************************************

adalnctl.sh version 120.3

Checking for FNDFS executable.

Starting listener process APPS_DEV.

adalnctl.sh: exiting with status 0

adalnctl.sh: check the logfile /oracle/inst/apps/DEV_oraapps/logs/appl/admin/log/adalnctl.txt for more information ...

.end std out.

.end err out.

****************************************************

Executing service control script:

/oracle/inst/apps/DEV_oraapps/admin/scripts/adapcctl.sh start

script returned:

****************************************************

You are running adapcctl.sh version 120.7.12010000.2

Starting OPMN managed Oracle HTTP Server (OHS) instance ...

opmnctl: opmn is already running.

opmnctl: starting opmn managed processes...

adapcctl.sh: exiting with status 0

adapcctl.sh: check the logfile /oracle/inst/apps/DEV_oraapps/logs/appl/admin/log/adapcctl.txt for more information ...

.end std out.

.end err out.

****************************************************

Executing service control script:

/oracle/inst/apps/DEV_oraapps/admin/scripts/adoacorectl.sh start

script returned:

****************************************************

You are running adoacorectl.sh version 120.13

Starting OPMN managed OACORE OC4J instance ...

adoacorectl.sh: exiting with status 0

adoacorectl.sh: check the logfile /oracle/inst/apps/DEV_oraapps/logs/appl/admin/log/adoacorectl.txt for more information ...

.end std out.

.end err out.

****************************************************

Executing service control script:

/oracle/inst/apps/DEV_oraapps/admin/scripts/adformsctl.sh start

script returned:

****************************************************

You are running adformsctl.sh version 120.16

Starting OPMN managed FORMS OC4J instance ...

adformsctl.sh: exiting with status 0

adformsctl.sh: check the logfile /oracle/inst/apps/DEV_oraapps/logs/appl/admin/log/adformsctl.txt for more information ...

.end std out.

.end err out.

****************************************************

Executing service control script:

/oracle/inst/apps/DEV_oraapps/admin/scripts/adoafmctl.sh start

script returned:

****************************************************

You are running adoafmctl.sh version 120.8

Starting OPMN managed OAFM OC4J instance ...

adoafmctl.sh: exiting with status 0

adoafmctl.sh: check the logfile /oracle/inst/apps/DEV_oraapps/logs/appl/admin/log/adoafmctl.txt for more information ...

.end std out.

.end err out.

****************************************************

Executing service control script:

/oracle/inst/apps/DEV_oraapps/admin/scripts/adcmctl.sh start

script returned:

****************************************************

You are running adcmctl.sh version 120.17.12010000.3

Starting concurrent manager for DEV ...

Starting DEV_1203@DEV Internal Concurrent Manager

Default printer is noprint

adcmctl.sh: exiting with status 0

adcmctl.sh: check the logfile /oracle/inst/apps/DEV_oraapps/logs/appl/admin/log/adcmctl.txt for more information ...

.end std out.

.end err out.

****************************************************

Executing service control script:

/oracle/inst/apps/DEV_oraapps/admin/scripts/jtffmctl.sh start

script returned:

****************************************************

You are running jtffmctl.sh version 120.3

Validating Fulfillment patch level via /oracle/PROD/apps/apps_st/comn/java/classes

Fulfillment patch level validated.

Starting Fulfillment Server for DEV on port 9305 ...

jtffmctl.sh: exiting with status 0

.end std out.

.end err out.

****************************************************

All enabled services for this node are started.

adstrtal.sh: Exiting with status 0

adstrtal.sh: check the logfile /oracle/inst/apps/DEV_oraapps/logs/appl/admin/log/adstrtal.log for more information ...

Once the process finishes successfully, it will start all application services and start the application as well.

Now check all the services are up and running.

oracle@OraApps scripts]$ adopmnctl.sh status

You are running adopmnctl.sh version 120.6

Checking status of OPMN managed processes...

Processes in Instance: DEV_oraapps.oraapps.nitin

---------------------------------+--------------------+---------+---------

ias-component | process-type | pid | status

---------------------------------+--------------------+---------+---------

OC4JGroup:default_group | OC4J:oafm | 14474 | Alive

OC4JGroup:default_group | OC4J:forms | 14404 | Alive

OC4JGroup:default_group | OC4J:oacore | 14320 | Alive

HTTP_Server | HTTP_Server | 15451 | Alive

adopmnctl.sh: exiting with status 0

adopmnctl.sh: check the logfile /oracle/inst/apps/DEV_oraapps/logs/appl/admin/log/adopmnctl.txt for more information ...

to get login URL you can check in context file

[oracle@OraApps scripts]$ echo $CONTEXT_FILE

/oracle/inst/apps/DEV_oraapps/appl/admin/DEV_oraapps.xml

[oracle@OraApps scripts]$ cat /oracle/inst/apps/DEV_oraapps/appl/admin/DEV_oraapps.xml | grep login

<login_page oa_var="s_login_page">http://oraapps.nitin:8005/OA_HTML/AppsLogin</login_page>

[oracle@OraApps scripts]$

the 8005 we have given while cloning process, it can be different with user environment.

go to browser and check you can login

Source System before cloning

Target System system after cloning

also check concurrent managers up and running on target system.

This completes Cloning process.

Error received
---------------

HTTP server not starting
---HTTP error---
oracle/inst/apps/VIS_upgrade-apps/ora/10.1.3/Apache/Apache/bin/apachectl startssl: execing httpd
/oracle/app/tech_st/10.1.3/Apache/Apache/bin/httpd: error while loading shared libraries: libdb.so.2: cannot open shared object file: No such file or directory

---Solution
As a root..

[oracle@upgrade-apps bin]$ su
Password:

[root@upgrade-apps bin]# ln -s /usr/lib/libgdbm.so.2.0.0 /usr/lib/libdb.so.2

Ref:
http://dbatalent.com/kbarticles/hot-cloning-oracle-e-business-suite-r12/

Oracle Blog

Wednesday, December 14, 2016

Cloning EBS R12.1.1 with Manual(HOT Backup)

Configure the target system

No comments: