How to Clone EBS 11i from one server to another on Linux

Cloning Oracle EBS 11i 

1-login as a Oracle user and clone DbTier

[oracle@app1 VIS_app1]$ perl adpreclone.pl dbTier
Running Rapid Clone with command…
perl /u02/app/visdb/9.2.0/appsutil/bin/adclone.pl java=/u02/app/visdb/9.2.0/jre/1.4.2 mode=stage
stage=/u02/app/visdb/9.2.0/appsutil/clone component=dbTier method=CUSTOM dbctx=/u02/app/visdb/9.2.0/appsutil/VIS_app1.xml
showProgress
Beginning database tier Stage – Mon Apr 28 02:34:15 2014
APPS Password : APPS
Log file located at /u02/app/visdb/9.2.0/appsutil/log/VIS_app1/StageDBTier_04280234.log
Completed Stage…
Mon Apr 28 02:34:32 2014
[oracle@app1 VIS_app1]$
 

2- Login as applmgr user and take a clone of appsTier

[applmgr@app1 VIS_app1]$ pwd
/u02/app/viscomn/admin/scripts/VIS_app1
[applmgr@app1 VIS_app1]$ perl adpreclone.pl appsTier
 
Running Rapid Clone with command…
perl /u02/app/visappl/ad/11.5.0/bin/adclone.pl java=/u02/app/visora/iAS/appsoui/jre/1.3.1 mode=stage
stage=/u02/app/viscomn/clone component=appsTier method=CUSTOM appctx=/u02/app/visappl/admin/VIS_app1.xml showProgress
.
Beginning application tier Stage – Mon Apr 28 02:54:21 2014
Log file located at /u02/app/visappl/admin/VIS_app1/log/StageAppsTier_04280254.log
.
.
Completed Stage…
Mon Apr 28 03:00:01 2014
.
[applmgr@app1 VIS_app1]$

3- Copy the data to linuxapps3 Server and set permission.

[root@linuxapps3 ~]# chown -R oracle:dba /u02/app/visdata
[root@linuxapps3 ~]# chmod -R 775 /u02/app/visdata
[root@linuxapps3 ~]# su – oracle
[oracle@linuxapps3 ~]$ export PATH=/u02/app/visdb/9.2.0/Apache/perl/bin/lib/man/
[oracle@linuxapps3 ~]$ export PATH=/u02/app/visdb/9.2.0/Apache/perl/:$PATH
[oracle@linuxapps3 ~]$ export
PERL5LIB=/u02/app/visdb/9.2.0/Apache/perl/lib/5.8.3:/u02/app/visdb/9.2.0/Apache/perl/lib/site_perl/5.8.3
[oracle@linuxapps3 ~]$ cd /u02/app/visdb/9.2.0/appsutil/clone/bin

4- Login as Oracle user and start dbclone and follow the instruction

[oracle@linuxapps3 bin]$ perl adcfgclone.pl dbTier
Enter the APPS password [APPS]:
apps
.
First Creating a new context file for the cloned system.
The program is going to ask you for information about the new system:
.
.
Provide the values required for creation of the new Database Context file.
.
Do you want to use a virtual hostname for the target node (y/n) [n] ?:
.
Target instance is a Real Application Cluster (RAC) instance (y/n) [n]:
.
Target System database name [VIS]:
.
Target system RDBMS ORACLE_HOME directory [/u02/app/visdb/9.2.0]:/u02/app/visdb/9.2.0
.
Target system utl_file accessible directories list [/usr/tmp]:
.
Number of DATA_TOP’s on the target system [1]:
.
Target system DATA_TOP 1 [/u02/app/visdata]:
.
Do you want to preserve the Display set to app1:0.0 (y/n) [y] ?:
.
Do you want to preserve the port values from the source system on the target system (y/n) [y] ?:
Database port is 1521
.
Backing up /u02/app/visdb/9.2.0/appsutil/VIS_linuxapps3.xml to /u02/app/visdb/9.2.0/appsutil/VIS_linuxapps3.xml2.bak
.
Creating the new Database Context file from :
/u02/app/visdb/9.2.0/appsutil/template/adxdbctx.tmp
.
The new database context file has been created :
/u02/app/visdb/9.2.0/appsutil/VIS_linuxapps3.xml
.
Log file located at /u02/app/visdb/9.2.0/appsutil/clone/bin/CloneContext_04290852.log
.
Running Rapid Clone with command:
perl /u02/app/visdb/9.2.0/appsutil/clone/bin/adclone.pl java=/u02/app/visdb/9.2.0/appsutil/clone/bin/../jre mode=apply
stage=/u02/app/visdb/9.2.0/appsutil/clone/bin/.. component=dbTier method=CUSTOM
dbctxtg=/u02/app/visdb/9.2.0/appsutil/VIS_linuxapps3.xml showProgress contextValidated=true
.
Beginning database tier Apply – Tue Apr 29 08:55:12 2014
Log file located at /u02/app/visdb/9.2.0/appsutil/log/VIS_linuxapps3/ApplyDBTier_04290855.log
.
.
Completed Apply…
Tue Apr 29 09:01:11 2014
.
Beginning APPSDB_VIS registration to central inventory…
.
ORACLE_HOME NAME : APPSDB_VIS
ORACLE_HOME PATH : /u02/app/visdb/9.2.0
Using Inventory location in /etc/oraInst.loc
Log file located at /etc/oraInventory/logs/OracleHomeCloner_04290901.log
ORACLE_HOME /u02/app/visdb/9.2.0 was registered successfully.
.
Starting database listener for VIS:
Running:
/u02/app/visdb/9.2.0/appsutil/scripts/VIS_linuxapps3/addlnctl.sh start VIS
.
You are running addlnctl.sh version 115.6
.
Logfile: /u02/app/visdb/9.2.0/appsutil/log/VIS_linuxapps3/addlnctl.txt
.
Starting listener process VIS …
.
.
Listener VIS has already been started.
.
.
addlnctl.sh: exiting with status 0
[oracle@linuxapps3 bin]$

5- Now login as applmgr user and clone appsTier

[applmgr@linuxapps3 ~]$ export PATH=/u02/app/visora/iAS/Apache/perl/bin:$PATH
[applmgr@linuxapps3 ~]$ cd /u02/app/visora/
8.0.6/ iAS/
[applmgr@linuxapps3 ~]$ export PATH=/u02/app/visora/iAS/Apache/perl/bin:$PATH
[applmgr@linuxapps3 ~]$ export
PERL5LIB=/u02/app/visora/iAS/Apache/perl/lib/5.00503/:/u02/app/visora/iAS/Apache/perl/lib/site_perl/5.005
[applmgr@linuxapps3 ~]$ cd /u02/app/viscomn/clone/bin
 
[applmgr@linuxapps3 bin]$ perl adcfgclone.pl appsTier
 
Enter the APPS password [APPS]:
APPS
.
First Creating a new context file for the cloned system.
The program is going to ask you for information about the new system:
.
.
Provide the values required for creation of the new APPL_TOP Context file.
.
Do you want to use a virtual hostname for the target node (y/n) [n] ?:n
.
Target system database SID [VIS]:
.
Target system database server node [app1]:linuxapps3
.
Target system database domain name [dxbdom02.com]:
.
Does the target system have more than one application tier server node (y/n) [n] ?:
.
Is the target system APPL_TOP divided into multiple mount points (y/n) [n] ?:
.
Target system APPL_TOP mount point [/u02/app/visappl]:
.
Target system COMMON_TOP directory [/u02/app/viscomn]:
.
Target system 8.0.6 ORACLE_HOME directory [/u02/app/visora/8.0.6]:
.
Target system iAS ORACLE_HOME directory [/u02/app/visora/iAS]:
.
Do you want to preserve the Display set to app1:0.0 (y/n) [y] ?:
.
Do you want to preserve the port values from the source system on the target system (y/n) [y] ?:
Web Listener port is 8000
Complete port information available at /u02/app/visappl/admin/out/VIS_linuxapps3/portpool.lst
.
UTL_FILE_DIR on database tier consists of the following directories.
.
1. /usr/tmp
2. /usr/tmp
3. /u02/app/visdb/9.2.0/appsutil/outbound/VIS_linuxapps3
4. /usr/tmp
Choose a value which will be set as APPLPTMP value on the target node [1]:
.
Creating the new APPL_TOP Context file from :
/u02/app/visappl/ad/11.5.0/admin/template/adxmlctx.tmp
.
The new APPL_TOP context file has been created :
/u02/app/visappl/admin/VIS_linuxapps3.xml
.
Log file located at /u02/app/viscomn/clone/bin/CloneContext_04291124.log
.
Running Rapid Clone with command:
perl /u02/app/viscomn/clone/bin/adclone.pl java=/u02/app/viscomn/clone/bin/../jre mode=apply
stage=/u02/app/viscomn/clone/bin/.. component=appsTier method=CUSTOM appctxtg=/u02/app/visappl/admin/VIS_linuxapps3.xml showProgress
contextValidated=true
.
Beginning application tier Apply – Tue Apr 29 11:27:20 2014
Log file located at /u02/app/visappl/admin/VIS_linuxapps3/log/ApplyAppsTier_04291127.log
.
.
Completed Apply…
Tue Apr 29 11:38:54 2014
.
Beginning APPSIAS_VIS registration to central inventory…
.
ORACLE_HOME NAME : APPSIAS_VIS
ORACLE_HOME PATH : /u02/app/visora/iAS
Using Inventory location in /etc/oraInst.loc
Log file located at /etc/oraInventory/logs/OracleHomeCloner_04291138.log
ORACLE_HOME /u02/app/visora/iAS was registered successfully.
.
Starting application Services for VIS:
Running:
/u02/app/viscomn/admin/scripts/VIS_linuxapps3/adstrtal.sh APPS/<appspwd>
.
You are running adstrtal.sh version 115.14
.
Executing service control script:
/u02/app/viscomn/admin/scripts/VIS_linuxapps3/adapcctl.sh start
script returned:

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

adapcctl.sh version 115.43

Starting Apache Web Server Listener (dedicated HTTP) …
Starting Apache Web Server Listener (dedicated PLSQL) …
adapcctl.sh: exiting with status 0
.end std out.
.end err out.

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

Executing service control script:
/u02/app/viscomn/admin/scripts/VIS_linuxapps3/adalnctl.sh start
script returned:
****************************************************
adalnctl.sh version
Checking for FNDFS executable.
Starting listener process APPS_VIS.
adalnctl.sh: exiting with status 0
.end std out.
.end err out.

****************************************************
Executing service control script:
/u02/app/viscomn/admin/scripts/VIS_linuxapps3/adcmctl.sh start
script returned:
****************************************************

You are running adcmctl.sh version 115.20
Starting concurrent manager for VIS …
Starting VIS_0429@VIS Internal Concurrent Manager
Default printer is noprint
adcmctl.sh: exiting with status 0
.end std out.
.end err out.

****************************************************
Executing service control script:
/u02/app/viscomn/admin/scripts/VIS_linuxapps3/adfrmctl.sh start
script returned:
****************************************************

You are running adfrmctl.sh version 115.34
Starting forms server for VIS on port 9000.
adfrmctl.sh: exiting with status 0
.end std out.
.end err out.

****************************************************
Executing service control script:
/u02/app/viscomn/admin/scripts/VIS_linuxapps3/adrepctl.sh start
script returned:
****************************************************

You are running adrepctl.sh version 115.29
starting Reports Server for VIS on port 7000.
adrepctl.sh: exiting with status 0
.end std out.
.end err out.

****************************************************
Executing service control script:
/u02/app/viscomn/admin/scripts/VIS_linuxapps3/adfmcctl.sh start
script returned:
****************************************************

You are running adfmcctl.sh version 115.17
Starting forms load balancing client for VIS.
adfmcctl.sh: exiting with status 0
.end std out.
.end err out.

****************************************************
Executing service control script:
/u02/app/viscomn/admin/scripts/VIS_linuxapps3/adfmsctl.sh start
script returned:
****************************************************

You are running adfmsctl.sh version 115.13
starting forms metrics server for VIS.
adfmsctl.sh: exiting with status 0
.end std out.
.end err out.
****************************************************

Executing service control script:
/u02/app/viscomn/admin/scripts/VIS_linuxapps3/jtffmctl.sh start
script returned:
****************************************************

You are running jtffmctl.sh version 115.16
Validating Fulfillment patch level via /u02/app/viscomn/java
Fulfillment patch level validated.
Starting Fulfillment Server for VIS on port 9300 …
jtffmctl.sh: exiting with status 0
.end std out.
.end err out.

****************************************************
Executing service control script:
/u02/app/viscomn/admin/scripts/VIS_linuxapps3/addisctl.sh start
script returned:
****************************************************

addisctl.sh version 115.14
/u02/app/visora/8.0.6/vbroker/bin/osagent
Started osagent.
Osagent logs messages to the file /u02/app/visora/8.0.6/discwb4/util/osagent.log.
Waiting for OAD to start…
Started OAD.
OAD logs messages to the file /u02/app/visora/8.0.6/discwb4/util/oad.log.
Discoverer Locator Started.
Locator logs messages to the file /u02/app/visora/8.0.6/discwb4/util/locator.log.
Registering Discoverer Session
Completed registration of repository_id = IDL:DCISessionManager:1.0
object_name = linuxapps3.dxbdom02.com_8000OracleDiscovererSession4
reference data =
path_name = /u02/app/visora/8.0.6/discwb4/util/runses.sh
activation_policy = UNSHARED_SERVER
args = (length=4)[-session; linuxapps3.dxbdom02.com_8000OracleDiscovererSession4; -preference;
linuxapps3.dxbdom02.com_8000OracleDiscovererPreferences4; ]
env = NONE
for OAD on host 172.17.174.215
Registering the Collector
Completed registration of repository_id = IDL:DCICollector:1.0
object_name = linuxapps3.dxbdom02.com_8000OracleDiscovererCollector4
reference data =
path_name = /u02/app/visora/8.0.6/discwb4/util/runcol.sh
activation_policy = SHARED_SERVER
args = (length=2)[-collector; linuxapps3.dxbdom02.com_8000OracleDiscovererCollector4; ]
env = NONE
for OAD on host 172.17.174.215
Applying preferences from file : /u02/app/visora/8.0.6/discwb4/util/pref.txt
Finished applying preferences
Closing down registry..
Registry File sync…
Registering Discoverer Preference Repository
Completed registration of repository_id = IDL:DCICORBAInterface:1.0
object_name = linuxapps3.dxbdom02.com_8000OracleDiscovererPreferences4
reference data =
path_name = /u02/app/visora/8.0.6/discwb4/util/runpref.sh
activation_policy = SHARED_SERVER
args = (length=2)[-preference; linuxapps3.dxbdom02.com_8000OracleDiscovererPreferences4; ]
env = NONE
for OAD on host 172.17.174.215
addisctl.sh: exiting with status 0
.end std out.
.end err out.

****************************************************
All enabled services for this node are started.
Check logfile /u02/app/viscomn/admin/log/VIS_linuxapps3/04291139.log for details

[applmgr@linuxapps3 bin]$

[applmgr@linuxapps3 bin]$ exit
logout
[root@linuxapps3 app]# su – oracle
[oracle@linuxapps3 ~]$ sqlplus /nolog

SQL*Plus: Release 9.2.0.6.0 – Production on Tue Apr 29 11:46:23 2014

Copyright (c) 1982, 2002, Oracle Corporation. All rights reserved.

SQL> conn /as sysdba
Connected.
SQL> conn apps/apps
Connected.
SQL>

Advertisements

About Sher khan

Senior Oracle DBA, Oracle 10g , Oracle 11g OCE ,Oracle 12C and Oracle 11g OPN certified Specialist, OCP Certified in Oracle 9i,10g , 11g and 12C. I am working in Oracle technology since 2004. Currently working in U.A.E Email: sher487@hotmail.com
This entry was posted in EBS and tagged . Bookmark the permalink.

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s