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
- 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
- After running adpreclone.pl, SHUTDOWN the applications and then DB properly
- Take a cold backup of /oracle
- Ensure new machine OS has been properly installed and configured with new IP and domain name.
- Restore the cold backup in the target machine
- 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
- DBTIER
- Do you want to use a virtual hostname for the target node (y/n) [n]?Y
- Target hostname [linux3]:linux5
- Target instance is a real Application Cluster (RAC) instance (y/n) [n]: N
- Target system database name[prod]:Clone
[default value found for S_contextname:Clone_linux5
- Target system RDBMS_ORACLE_HOME directory
[/oracle/visdb/9.2.0] – press ENTER key
- Target system utl-file accessible directories list [/usr/tmp]:
Press ENTER
- Number of DATA_TOP’s on the target system [1]:1
Since this is a single node
- 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
- Do you want to preserve the Display set to linux3:0.0(y/n) [y]
Type ‘N’ and press ENTER
- 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
- 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/
