ERP Cloning 11i Procedure

 Cloning 11i Procedure

Preclone in the source machine while users are application is running without allowing users to access i.e. to run adpreclone.pl

1. Preclone must be run in the DBTier first then in AppsTier

i)             #su  - oracle

ii)           $ cd

/oracle/proddb/9.2.0/appsutil/scripts/<context_name>

iii)          $perl adpreclone.pl dbTier

iv)          Exit

v)            # su – applmgr

vi)          $ cd /oracle

vii)         $cd COMMON_TOP

viii)       cd admin/scripts/<context_name>

ix)          $perl adpreclone.pl appTier

2. After running adpreclone.pl, SHUTDOWN the applications and then DB properly
3. Take a cold backup of /oracle
1. Ensure new machine OS has been properly installed and configured with new IP and domain name.
4. Restore the cold backup in the target machine
5. Run the adcfgclone.pl in the target machine in the appropriate directory

While Configuration follow the given set of instructions:

# su – oracle

$ cd /oracle

$ cd $ORACLE_HOME

$ cd appsutil/clone/bin

$ perl adcfgclone.pl dbTier

1. DBTIER
1. Do you want to use a virtual hostname for the target node (y/n) [n]?Y
2. Target hostname [linux3]:linux5
3. Target instance is a real Application Cluster (RAC) instance (y/n) [n]: N
4. Target system database name[prod]:Clone

[default value found for S_contextname:Clone_linux5

5. Target system RDBMS_ORACLE_HOME directory

[/oracle/visdb/9.2.0] – press ENTER key

6. Target system utl-file accessible directories list [/usr/tmp]:

                        Press ENTER

7. Number of DATA_TOP’s on the target system [1]:1

Since this is a single node

8. Target system DATA_TOP [/oracle/visdata]: Press ENTER

Message would appearing as follows this is just for knowledge.. creating /oracle/visdb/9.2.0/appsutil/clone/bin/../data/stage/addbhometgt.xml which will contain target system database mount points

9.  Do you want to preserve the Display set to linux3:0.0(y/n) [y]

Type ‘N’ and press ENTER

10. Target system display [Linux5:0.0] press ENTER

**** In case of error message

Error message would appears as: File oratab already exists at /etc/oratab

File oraInst.loc already exists at /etc/oraInst.loc

Solutions follows –

Go to /tmp and run oraInstroot.sh

May be for twice from within the same window from where you executed this perl adcfglone.pl

2. APPTIER

# su – applmgr

$ cd /oracle/prodcomm/clone/bin

$  perl adcfgclone.pl appsTier

a)    Do you want to use a virtual hostname for the target node (y/n) [n]:Y

b)    Target hostname [linux3]:linux5

c)    Target system database SID [PROD]: CLONE

(Default value found for S_Contextname:Clone_linux5)

d)    Target system database server node [linux3]:linux5

e)    Target system database domain name:com

f)     Does the target system have more than one application tier server node (y/n):[n] N

g)    Is the target APPL_TOP divided into multiple mount points (y/n) [n]:N

h)    Target system APPL_TOP mount point [/oracle/prodcomm] press ENTER

i)     Target system COMMON_TOP mount point [/oracle/prodappl] press ENTER

j)     Target system 8.0.6 ORACLE_HOME directory /oracle/prodora/8.0.6? Press ENTER

k)    Target system iAS ORACLE_HOME directory [/oracle/prodora/iAS]: Press ENTER

l)     Do you want to preserve the display set to linux3:0.0 (y/n) [y]N

m)  Target system display[linux5:0.0]:Press ENTER

n)    Do you want to preserve the port values from the source system on the target system (y/n) [y]Y

o)    UTL_FILE_DIR on database tier consists of following directories

1)    /usr/tmp

2)    /oracle/proddb/9.2.0/appsutil/outbound/CLONE_linux5

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

Change the directory (path) of oraInventory as /etc/

Remove one entry

Create manually the directory oraInventory under /etc by the following this command

# mkdir oraInventory

And then run the command orainstRoot.sh

DB level clone directory /oracle/9.2.0/appsutil/clone

Application level directory /oracle/viscomm/clone

Cloning step – Copy all the folders from /oracle/*.* to the target machine /Oracle/