Friday, March 11, 2016

How to clone the Oracle Application EBS

Oracle Application Clone(OFF)



  • .mv  $COMMON_TOP/clone clone1 
  •  run adcfgpreclone.pl on the production server.
  • create tar ball ( tar -cvf )for com, ora . appl, inventory directory.
  • copy over target system.
  • untar tar ball (tar -xvf )



/apps2/ebs/product/dev/comn/clone/bin/adcfgclone.pl

adcfgclone.pl appsTier
Enter the APPS password [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] ?:


Target system database SID [xdb02}:xdb01 


Target system database server node [xdb02]:xdb01

Target system database domain name [xxxxx.xxx]:

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


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


Target system APPL_TOP mount point [/apps2/ebs/product/oa11i/appl]:/apps2/ebs/product/dev/appl


Target system COMMON_TOP directory [/apps2/ebs/product/oa11i/comn]:/apps2/ebs/product/dev/comn


Target system 8.0.6 ORACLE_HOME directory [/apps2/ebs/product/oa11i/ora/8.0.6]:/apps2/ebs/product/dev/ora/8.0.6


Target system iAS ORACLE_HOME directory [/apps2/ebs/product/oa11i/ora/iAS]:/apps2/ebs/prosduct/dev/ora/iAS


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


Target system Display [xdb01:0.0]:  


Location of the JDK on the target system [/usr/java]:/apps2/ebs/product/jdk1685


Target system JRE_TOP [/usr/java]:/apps2/ebs/product/jdk1685


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


Clone Context uses the same port pool mechanism as the Rapid Install

Once you choose a port pool, Clone Context will validate the port availability.

Enter the port pool number [0-99]:

24

Checking the port pool 24

done: Port Pool 24 is free

Complete port information available at /apps2/ebs/productt/dev/appl/admin/out/SID_hostname/portpool.lst


Verifying Database Connection...

RC-40201: Unable to connect to Database xdb01

Enter the Database listener port [2034]:enter you db port number(


Database Connection on Port 2035 Successful


Target system proxy hostname [xdb01.xxxx.xxxx]:xdbs01.xxxx.xxx


Target system proxy port [4410]:4411


UTL_FILE_DIR on database tier consists of the following directories.


1. /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 :

  /apps2/ebs/product/dev/appl/ad/11.5.0/admin/template/adxmlctx.tmp

The new APPL_TOP context file has been created :

  /apps2/ebs/product/dev/appl/admin/xdb01_web2.xml

Log file located at /tmp/CloneContext_0310034417.log


Running Rapid Clone with command:

        perl ./adclone.pl java=./../jre/jre mode=apply stage=/apps2/ebs/product/dev/comn/clone/bin/./.. component=appsTier method=CUSTOM appctxtg=/apps2/property/product/dev/appl/admin/SID_hostname

Beginning application tier Apply - Thu Mar 10 16:09:34 2016

Log file located at /apps2/ebs/product/dev/appl/admin/SID_hostname/log/ApplyAppsTier_03101609.log
                                       

Completed Apply...

Thu Mar 10 16:13:55 2016

Beginning APPSIAS_xdb01 registration to central inventory...


ORACLE_HOME NAME   : APPSIAS_SID

ORACLE_HOME PATH   : /apps2/ebs/product/dev/ora/iAS
Using Inventory location in /var/opt/oracle/oraInst.loc
Log file located at /apps2/ebs/product/dev/oraInventory/logs/OracleHomeCloner_03100413.log
ORACLE_HOME /apps2/ebs/product/dev/ora/iAS was registered successfully.
---------
admkappsutil.pl
Starting the generation of appsutil.zip
Log file located at /apps2/ebs/product/dev/appl/admin/log/MakeAppsUtil_03111320.log
output located at /apps2/ebs/product/dev/appl/admin/out/appsutil.zip
MakeAppsUtil completed successfully.


move appsutil.zip to db oracle home and unzip appsuttil.zip file.
appsutil directory will be created.

take backup on  TSN_admin.


for me 12.1.0.2 is new home

/apps/ebs/product/oa11idev/12.1.0.2/appsutil/bin
$ execute perl adbldxml.pl tier=db appsuser=apps appspass=xxxx



Starting context file generation for db tier..
Using JVM from /apps/ebs/product/oa11idev/12.1.0.2/jdk/bin/java to execute java programs..

The log file for this adbldxml session is located at:
/apps/ebs/product/oa11idev/12.1.0.2/appsutil/log/adbldxml_03111417.log

Could not Connect to the Database with the above parameters, Please answer the Questions below


Enter Hostname of Database server: hostname


Enter Port of Database server: 0000

Enter SID of Database server: SID

The context fisle has been created at:
/apps/eb/product/oa11idev/12.1.0.2/appsutil/SID_hostname.xml
$ sqlplus apps/xxxxx
SQL> exec FND_CONC_CLONE.SETUP_CLEAN;

PL/SQL procedure successfully completed.

SQL> 

run adconfig.sh on db tier and apps Tier.

reset password using fndcpass







No comments: