In Oracle Apps R12.2 what will happen when we run adop phase=prepare

 

1. Checks that the environment is set to the run APPL_TOP.

2. Checks whether to perform a cleanup, which will be needed if the user failed to invoke cleanup after the cutover phase of a previous online patching cycle.

3. Checks to see if the database is prepared for online patching:

• Checks that the FILE_EDITION environment variable value is set to ‘run
• Checks to see if enough space is available in the database (SYSTEM tablespace should have minimum of 25 GB of free space and APPS_TS_SEED tablespace should have minimum of 5 GB of free space)

4. Checks the file system, using the TXK script $AD_TOP/patch/115/bin/txkADOPPreparePhaseSanityCheck.pl. This script checks for the file system space, database connections, Apps/System/Weblogic Passwords, Contextfile Validation and so on

5. Produces a report showing information about the most important tablespaces is generated. This report is created in $APPL_TOP/admin/$TWO_TASK/out.

6. Checks for the existence of the “Online Patching In Progress” (ADZDPATCH) concurrent program. This program prevents certain predefined concurrent programs from being started, and as such needs to be active while a patching cycle is in progress.

7.Invokes the TXK script $AD_TOP/patch/115/bin/txkADOPPreparePhaseSynchronize.pl to synchronize the patches which have been applied to the run appltop.

8. Checks the database for the existence of a patch edition, and creates one if it does not find one

• A patch edition is created in the database.
• All code objects in the patch edition begin as pointers to code objects in the run edition. Code objects in the patch edition begin as lightweight “stub objects” that point to the actual object definitions, which are inherited from earlier editions. Stub objects consume minimal space, so the database patch edition is initially very small in size.
• As patches are applied to the patch edition, code objects are actualized (have a new definition created) in that edition.

9. Calls the $AD_TOP/patch/115/bin/txkADOPPreparePhaseSanityCheck.pl script again to confirm that the database connection to the patch edition is working.

 

 

 

Online Patching ? ADOP AD Online Patching replaces adpatch in 12.2.

Online Patching is new feature which  is major change with R12 12.2 for DBA's , as downtime would be reduced for any patching activity from hours to few minutes.

Now it is possible to apply even upgrade patches in Online Patching mode minimizing downtime to very low, But please note upgrade to 12.2 is not possible via online patching from lower versions . 

On the technology part  of online patching, It is some what similar to Stage APPLTOP, But in online patching database objects also will maintain two copies to support this method. i.e. run file system and run edition of DB, patch file system and patch edition of DB.

In applications  contains two set of file systems patch and run file system, run is where actually applications is running from and patch is used for patching the applications when it is running. in database we have edition based concept, where we contain patch edition and run edition.

Actually the base for the online patching concept came into picture with 11GR2 database version , Where there is concept called "Edition Based Redefinition", Online patching database part is based on it.

Online Patching in 12.2. is done using adop utility (No Longer adpatch), But this utility calls internally the required patching(adpatch) or other  utilities.

and all the patches need to be applied using adop only, Other methods are not supported. But we can apply the patches in hot patch mode using adop, But in this method , The online patching concept will not come into picture , It is traditional way of applying patch directly on the run file system and run edition of the database when applications and DB is running.


Online Patching (adop) runs in different phases, The below are phases and syntax of adop.

prepare
apply
finalize
cutover
cleanup


prepare  Phase


patch edition and run editions are synchronized in incremental synchronizations of files changed in the run file system.

patch edition is created in the database

Syntax: $ adop phase=prepare

apply phase 


patches are applied to patch patch edition in the database and patch file system in the applications.

adpatch is called internally by adop to apply the patches.

production application is un effected by these changes, and multiple patches can be applied.

Syntax: $ adop phase=apply

To Apply specific patch in 12.2 using adop is :

 

$ adop phase=apply patches=17323764

finalize phase 


Performs all the activities which can be done when applications is up & running.

example: compile invalids, generate objects, pre-compile DDL

Syntax: $ adop phase=finalize

This stage we can stay as long as we want, until once we have downtime to move the changed in the cutover stage , 


cutover phase


This is a stage where actual changes reflects and downtime is required for this stage. 

Users are logged off during this stage.

patch file system is promoted to be the run file system

patch database edition is promoted to the run database edition.

users are actually brought back on online on the patched system.

Syntax: $ adop phase=cutover


cleanup phase


Cleanup happens once users online on the system


There are no cleanup on the file system , Only it happens on the database where it deletes the code objects from old editions of the database where patching happened.

Syntax: $ adop phase=cleanup

 

 

 

 

 

AC-00005: No write permissions for creating the Context file - /tmp/temp.xml

Error:


RC-50004: Error occurred in CloneContext:
AC-00005: No write permissions for creating the Context file - /tmp/temp.xml
Raised by oracle.apps.ad.context.AppsContext
Context file creation not successful

Sol

Apps user does  not have write permissions on /tmp directory.

1- Give write permission to apps user on "/tmp" directory.

       Example :

        As root:

        # chmod 777 /tmp

       # ls -al | grep tmp

       drwxrwxrwx     11 root root     4096 Jun 15 04:02 tmp

 2- Re-run the Postclone.

      perl adcfgclone.pl

    

The error above  is a bit misleading. adcfgclone.pl should not  be creating a "temp.xml" file under appsutil, The context file created under "/appsutil"  should be _.xml.

Normally adcfgclone.pl is trying to do is,  create files under /usr/tmp and/or /tmp.

Check if you have a temp.xml file or other RapidClone files under either of those directories owned
by a different user? If so please delete them and retry adcfgclone.pl.  

Adpatch Issues - Worker failed

While applying patch in Oracle E-Business Suite, we get issues like

   1. Worker failed patching
  
Whenever adpatch gives error and stops patching because some reason. First check the status of worker with ADCTRL  utility and then go through your adpatch log and get some hint why patch is failed, then try to fix accordingly. Each issue has specific approach for fixing it.

Worker failed patching:
While we check the adpacth log at location APL_TOP/ADMIN/SID/LOG/adpatch.log and we notice that adpatch failed because of worker has failed patching. We must immediately check the worker log at location APPL_TOP/ADMIN/SID/LOG/adworkxxx.log and check for the issue and fix it.

Once issue is fixed then follow below steps:

    Login with applmgr user
    Source the environment
    Start adctrl and restart the failed Worker.

.rf9 is the file which helps the adpatch to determine where patch was left patching. Patching information is held into tables AD_DEFERRED_JOBS and FND_INSTALLED_PROCESSES.

RT1223O applmgr@linuxrt64:~[101] adctrl
                     Copyright (c) 2002, 2012 Oracle Corporation
                        Redwood Shores, California, USA
                                 AD Controller
                                 Version 12.2.0
NOTE: You may not use this utility for custom development
      unless you have written permission from Oracle Corporation.
Your default directory is '/remote/app/applmgr/rt1223o/fs1/EBSapps/appl'.
Is this the correct APPL_TOP [Yes] ?
AD Controller records your AD Controller session in a text file
you specify.  Enter your AD Controller log file name or press [Return]
to accept the default file name shown in brackets.
Filename [adctrl.log] :
************* Start of AD Controller session *************
AD Controller version: 12.2.0
AD Controller started at: Sat Oct 04 2014 07:46:43
APPL_TOP is set to /remote/app/applmgr/rt1223o/fs1/EBSapps/appl
Reading product information from file...
Reading language and territory information from file...
Reading language information from applUS.txt ...
Enter the ORACLE username of Application Object Library [APPLSYS] :
Enter the ORACLE password of Application Object Library [APPS] :
AD Controller is verifying your username/password.
*** Not Edition Enabled User ***
The status of various features in this run of AD Controller is:
                                           <-feature in-="" version="">
Feature                          Active?   APPLTOP    Data model    Flags
------------------------------   -------   --------   -----------   -----------
CHECKFILE                        Yes       1          1             Y N N Y N Y
PREREQ                           Yes       6          6             Y N N Y N Y
CONCURRENT_SESSIONS              No        2          2             Y Y N Y Y N
PATCH_TIMING                     Yes       2          2             Y N N Y N Y
PATCH_HIST_IN_DB                 Yes       6          6             Y N N Y N Y
SCHEMA_SWAP                      Yes       1          1             Y N N Y Y Y
JAVA_WORKER                      Yes       1          1             Y N N Y N Y
CODELEVEL                        Yes       1          1             Y N N Y N Y

                    AD Controller Menu
     ---------------------------------------------------
     1.    Show worker status
     2.    Tell worker to restart a failed job
     3.    Tell worker to quit
     4.    Tell manager that a worker failed its job
     5.    Tell manager that a worker acknowledges quit
     6.    Restart a worker on the current machine
     7.    Exit



Enter your choice [1] : 2
Enter the worker number(s)/range(s) or 'all' for all workers,
or press [Return] to go back to the menu : 1
Status changed to 'Fixed, restart' for worker 1.
Review the messages above, then press [Return] to continue.
                    AD Controller Menu
     ---------------------------------------------------
     1.    Show worker status
     2.    Tell worker to restart a failed job
     3.    Tell worker to quit
     4.    Tell manager that a worker failed its job
     5.    Tell manager that a worker acknowledges quit
     6.    Restart a worker on the current machine
     7.    Exit



Enter your choice [1] :


Note:

What are the tables created while we start adpatch session?

AD_DEFERRED_JOBS and FND_INSTALLED_PROCESSES tables are created.

What does AD_DEFERRED_JOBS and FND_INSTALLED_PROCESSES tables contain?

FND_INSTALLED_PROCESSES: adpacth creates FND_INSTALL_PROCESSES table, assigns each worker unique ID with new row for each worker. This table is used to store the information about the job for each worker. Once all jobs are completed, worker shuts down and drops FND_INSTALL_PROCESSES table.

AD_DEFERRED_JOBS: This table holds the information of failed (workers which has failed its job). This table is created on starting the session of adpatch utility and drops once it is complete.

From which table ADCTRL gathers information?

FND_INSTALL_PROCESSES

OUI-67028:Inventory load failed... OPatch cannot load inventory for the given Oracle Home

Error:

[Sep 26, 2014 9:30:25 AM]    Patch history file: /app/oracle/product/11.2.0.4/cfgtoollogs/opatch/opatch_history.txt
[Sep 26, 2014 9:30:25 AM]    Starting LsInventorySession at Fri Sep 26 09:30:25 PDT 2014
[Sep 26, 2014 9:30:25 AM]    List of Homes on this system:
[Sep 26, 2014 9:30:25 AM]    OUI-67028:Inventory load failed... OPatch cannot load inventory for the given Oracle Home.
                             Possible causes are:
                                Oracle Home dir. path does not exist in Central Inventory
                                Oracle Home is a symbolic link
                                Oracle Home inventory is corrupted
[Sep 26, 2014 9:30:25 AM]    OUI-67073:LsInventorySession failed: OracleHomeInventory gets null oracleHomeInfo
[Sep 26, 2014 9:30:25 AM]    Finishing LsInventorySession at Fri Sep 26 09:30:25 PDT 2014

Solution

Step 1. Check the oraInst.loc file
cat /etc/oraInst.loc
inventory_loc=/app/oracle/product/11.2.0.4/oraInst.loc
inst_group=dba
Check the inventory is exist in the location and in file entries in particular sequence

Step 2. If first step is ok, Then you need to register the Oracle Home in the inventory

# cd $ORACLE_HOME/oui/bin
# ./attachHome.sh
or

# cd $ORACLE_HOME/oui/bin
#./runInstaller -silent -attachHome -invPtrLoc /app/oracle/product/11.2.0.4/oraInst.loc ORACLE_HOME=$ORACLE_HOME ORACLE_HOME_NAME=ORAHOME11Gr24
Starting Oracle Universal Installer...
Checking swap space: must be greater than 500 MB.   Actual 153840 MB    Passed
The inventory pointer is located at /app/oracle/product/11.2.0.4/oraInst.loc
The inventory is located at /app/oracle/product/oraInventory
'AttachHome' was successful.
DBAoracle@dba:/app/oracle/product/11.2.0.4/oui/bin[31] cd ..


Check the inventory file.

DBA oracle@dba:/app/oracle/product/oraInventory/ContentsXML[30] cat inventory.xml


DBA oracle@dba:/app/oracle/product/oraInventory/ContentsXML[31]

Clone R12.1.3

As an Apps DBA, the ability to quickly produce clones is mandatory to be a successful EBS DBA. The following post will show details on how to clone. First let’s get started with the prep work.

Pre-Clone Steps

Unlike a regular Oracle database environment, cloning the E-Business Suite is a complex affair. You need to prepare the source and target environments before a clone operation can be performed.

 

1) DB Tier preparation for Cloning

---

Login as Oracle User and run the preclone Step.

oracle@linux64:/remote/app/oracle//db/tech_st/11.2.0/appsutil/scripts/_linux64[9] perl  adpreclone.pl dbTier

                     Copyright (c) 2002 Oracle Corporation
                        Redwood Shores, California, USA

                        Oracle Applications Rapid Clone

                                 Version 12.0.0

                      adpreclone Version 120.20.12010000.5

Enter the APPS User Password:
Running:
perl /remote/app/oracle//db/tech_st/11.2.0/appsutil/bin/adclone.pl java=/remote/app/oracle//db/tech_st/11.2.0/jdk/jre mode=stage stage=/remote/app/oracle//db/tech_st/11.2.0/appsutil/clone component=dbTier method=CUSTOM dbctx=/remote/app/oracle//db/tech_st/11.2.0/appsutil/_linux64.xml showProgress
APPS Password :

Beginning database tier Stage - Fri Sep 12 16:26:52 2014

/remote/app/oracle//db/tech_st/11.2.0/jdk/jre/bin/java -Xmx600M -DCONTEXT_VALIDATED=false  -Doracle.installer.oui_loc=/remote/app/oracle//db/tech_st/11.2.0/oui -classpath /remote/app/oracle//db/tech_st/11.2.0/lib/xmlparserv2.jar:/remote/app/oracle//db/tech_st/11.2.0/jdbc/lib/ojdbc5.jar:/remote/app/oracle//db/tech_st/11.2.0/appsutil/java:/remote/app/oracle//db/tech_st/11.2.0/oui/jlib/OraInstaller.jar:/remote/app/oracle//db/tech_st/11.2.0/oui/jlib/ewt3.jar:/remote/app/oracle//db/tech_st/11.2.0/oui/jlib/share.jar:/remote/app/oracle//db/tech_st/11.2.0/oui/jlib/srvm.jar:/remote/app/oracle//db/tech_st/11.2.0/jlib/ojmisc.jar   oracle.apps.ad.clone.StageDBTier -e /remote/app/oracle//db/tech_st/11.2.0/appsutil/_linux64.xml -stage /remote/app/oracle//db/tech_st/11.2.0/appsutil/clone -tmp /tmp -method CUSTOM    -showProgress
APPS Password :
Log file located at /remote/app/oracle//db/tech_st/11.2.0/appsutil/log/_linux64/StageDBTier_09121626.log

  |     50% completed

Completed Stage...
Fri Sep 12 16:27:47 2014

2) Apps Tier preparation for Cloning

---

Login as applmgr user and run the preclone step.

applmgr@linux64:/remote/app/applmgr//inst/apps/_linux64/admin/scripts[106] perl adpreclone.pl appsTier

                     Copyright (c) 2002 Oracle Corporation
                        Redwood Shores, California, USA

                        Oracle Applications Rapid Clone

                                 Version 12.0.0

                      adpreclone Version 120.20.12010000.5

Running:
perl /remote/app/applmgr//apps/apps_st/appl/ad/12.0.0/bin/adclone.pl java=/remote/app/applmgr//apps/tech_st/10.1.3/appsutil/jdk mode=stage stage=/remote/app/applmgr//apps/apps_st/comn/clone component=appsTier method= appctx=/remote/app/applmgr//inst/apps/_linux64/appl/admin/_linux64.xml showProgress
APPS Password :
method defaulted to CUSTOM


Beginning application tier Stage - Fri Sep 12 17:00:32 2014

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

Log file located at /remote/app/applmgr//inst/apps/_linux64/admin/log/StageAppsTier_09121700.log

  \     80% completed

Completed Stage...
Fri Sep 12 17:01:09 2014
applmgr@linux64:/remote/app/applmgr//inst/apps/_linux64/admin/scripts[107]

3) Application copy

---

Shutdown all the services, this is not mandatory step.

Copy the source system application tier file system to the target system, using your preferred method.

APPL_TOP

COMMON_TOP

ORACLEAS_10.1.2_ORACLE_HOME

ORACLEAS_10.1.3_ORACLE_HOME

4) Database copy

---

Shutdown the Database

copy the source database ORACLE_HOME to the target system.

copy the database (.dbf) files from the source to the target system

Activities on target

---

Do not set the environment files for the database tier! We need a clean slate for the database tier clone procedure.

1) DBTier Configuration and then start the Target System database Server

---

Login as oracle user and execute the clone procedure.

oracle@linux64:/remote/app/oracle//db/tech_st/11.2.0/appsutil/clone/bin[9] perl adcfgclone.pl dbTier

                     Copyright (c) 2002 Oracle Corporation
                        Redwood Shores, California, USA

                        Oracle Applications Rapid Clone

                                 Version 12.0.0

                      adcfgclone Version 120.31.12010000.8

Enter the APPS password :

Running:
/remote/app/oracle//db/tech_st/11.2.0/appsutil/clone/bin/../jre/bin/java -Xmx600M -cp /remote/app/oracle//db/tech_st/11.2.0/appsutil/clone/jlib/java:/remote/app/oracle//db/tech_st/11.2.0/appsutil/clone/jlib/xmlparserv2.jar:/remote/app/oracle//db/tech_st/11.2.0/appsutil/clone/jlib/ojdbc5.jar oracle.apps.ad.context.CloneContext -e /remote/app/oracle//db/tech_st/11.2.0/appsutil/clone/bin/../context/db/CTXORIG.xml -validate -pairsfile /tmp/adpairsfile_13167.lst -stage /remote/app/oracle//db/tech_st/11.2.0/appsutil/clone  2> /tmp/adcfgclone_13167.err; echo $? > /tmp/adcfgclone_13167.res

Log file located at /remote/app/oracle//db/tech_st/11.2.0/appsutil/clone/bin/CloneContext_0913163907.log

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

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

Target Instance is RAC (y/n) [n] :

Target System Database SID :

Target System Base Directory : /remote/app/oracle

Target System utl_file_dir Directory List : /usr/tmp

Number of DATA_TOP's on the Target System [1] :

Target System DATA_TOP Directory 1 [/remote/oradata/TDBNAME] : /remote/oradata/

Target System RDBMS ORACLE_HOME Directory [/remote/app/oracle/db/tech_st/11.1.0] : /remote/app/oracle//db/tech_st/11.2.0

Do you want to preserve the Display [linux-tr-64:1] (y/n)  :

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


Do you want to preserve the Display [linux-tr-64:1] (y/n)  : n

Target System Display [linux64:0.0] :

Target System Port Pool [0-99] : 35

Checking the port pool 35
done: Port Pool 35 is free
Report file located at /remote/app/oracle//db/tech_st/11.2.0/appsutil/temp/portpool.lst
Complete port information available at /remote/app/oracle//db/tech_st/11.2.0/appsutil/temp/portpool.lst

Creating the new Database Context file from :
  /remote/app/oracle//db/tech_st/11.2.0/appsutil/template/adxdbctx.tmp

The new database context file has been created :
  /remote/app/oracle//db/tech_st/11.2.0/appsutil/_linux64.xml

Log file located at /remote/app/oracle//db/tech_st/11.2.0/appsutil/clone/bin/CloneContext_0913163907.log
Check Clone Context logfile /remote/app/oracle//db/tech_st/11.2.0/appsutil/clone/bin/CloneContext_0913163907.log for details.

Running Rapid Clone with command:
perl /remote/app/oracle//db/tech_st/11.2.0/appsutil/clone/bin/adclone.pl java=/remote/app/oracle//db/tech_st/11.2.0/appsutil/clone/bin/../jre mode=apply stage=/remote/app/oracle//db/tech_st/11.2.0/appsutil/clone component=dbTier method=CUSTOM dbctxtg=/remote/app/oracle//db/tech_st/11.2.0/appsutil/_linux64.xml showProgress contextValidated=true
Running:
perl /remote/app/oracle//db/tech_st/11.2.0/appsutil/clone/bin/adclone.pl java=/remote/app/oracle//db/tech_st/11.2.0/appsutil/clone/bin/../jre mode=apply stage=/remote/app/oracle//db/tech_st/11.2.0/appsutil/clone component=dbTier method=CUSTOM dbctxtg=/remote/app/oracle//db/tech_st/11.2.0/appsutil/_linux64.xml showProgress contextValidated=true
APPS Password :

Beginning database tier Apply - Sat Sep 13 16:42:10 2014

/remote/app/oracle//db/tech_st/11.2.0/appsutil/clone/bin/../jre/bin/java -Xmx600M -DCONTEXT_VALIDATED=true  -Doracle.installer.oui_loc=/remote/app/oracle//db/tech_st/11.2.0/oui -classpath /remote/app/oracle//db/tech_st/11.2.0/appsutil/clone/jlib/xmlparserv2.jar:/remote/app/oracle//db/tech_st/11.2.0/appsutil/clone/jlib/ojdbc5.jar:/remote/app/oracle//db/tech_st/11.2.0/appsutil/clone/jlib/java:/remote/app/oracle//db/tech_st/11.2.0/appsutil/clone/jlib/oui/OraInstaller.jar:/remote/app/oracle//db/tech_st/11.2.0/appsutil/clone/jlib/oui/ewt3.jar:/remote/app/oracle//db/tech_st/11.2.0/appsutil/clone/jlib/oui/share.jar:/remote/app/oracle//db/tech_st/11.2.0/appsutil/clone/jlib/oui/srvm.jar:/remote/app/oracle//db/tech_st/11.2.0/appsutil/clone/jlib/ojmisc.jar   oracle.apps.ad.clone.ApplyDBTier -e /remote/app/oracle//db/tech_st/11.2.0/appsutil/_linux64.xml -stage /remote/app/oracle//db/tech_st/11.2.0/appsutil/clone   -showProgress
APPS Password : Log file located at /remote/app/oracle//db/tech_st/11.2.0/appsutil/log/_linux64/ApplyDBTier_09131642.log
  |      0% completed

/remote/app/oracle//db/tech_st/11.2.0/appsutil/clone/bin/../jre/bin/java -Xmx600M -DCONTEXT_VALIDATED=true  -Doracle.installer.oui_loc=/remote/app/oracle//db/tech_st/11.2.0/oui -classpath /remote/app/oracle//db/tech_st/11.2.0/appsutil/clone/jlib/xmlparserv2.jar:/remote/app/oracle//db/tech_st/11.2.0/appsutil/clone/jlib/ojdbc5.jar:/remote/app/oracle//db/tech_st/11.2.0/appsutil/clone/jlib/java:/remote/app/oracle//db/tech_st/11.2.0/appsutil/clone/jlib/oui/OraInstaller.jar:/remote/app/oracle//db/tech_st/11.2.0/appsutil/clone/jlib/oui/ewt3.jar:/remote/app/oracle//db/tech_st/11.2.0/appsutil/clone/jlib/oui/share.jar:/remote/app/oracle//db/tech_st/11.2.0/appsutil/clone/jlib/oui/srvm.jar:/remote/app/oracle//db/tech_st/11.2.0/appsutil/clone/jlib/ojmisc.jar   oracle.apps.ad.clone.ApplyDBTier -e /remote/app/oracle//db/tech_st/11.2.0/appsutil/_linux64.xml -stage /remote/app/oracle//db/tech_st/11.2.0/appsutil/clone   -showProgress
APPS Password : Log file located at /remote/app/oracle//db/tech_st/11.2.0/appsutil/log/_linux64/ApplyDBTier_09131642.log
  /     15% completed

Completed Apply...
Sat Sep 13 16:49:10 2014

Starting database listener for :
Running:
/remote/app/oracle//db/tech_st/11.2.0/appsutil/scripts/_linux64/addlnctl.sh start
Logfile: /remote/app/oracle//db/tech_st/11.2.0/appsutil/log/_linux64/addlnctl.txt

You are running addlnctl.sh version 120.1.12010000.4


Starting listener process ...


Listener has already been started.


addlnctl.sh: exiting with status 0

addlnctl.sh: check the logfile /remote/app/oracle//db/tech_st/11.2.0/appsutil/log/_linux64/addlnctl.txt for more information ...

oracle@linux64:/remote/app/oracle//db/tech_st/11.2.0/appsutil/clone/bin[10] sqlplus

SQL*Plus: Release 11.2.0.3.0 Production on Sat Sep 13 16:49:26 2014

Copyright (c) 1982, 2011, Oracle.  All rights reserved.

Enter user-name: /as sysdba

Connected to:
Oracle Database 11g Enterprise Edition Release 11.2.0.3.0 - 64bit Production
With the Partitioning, OLAP, Data Mining and Real Application Testing options

SQL> select name from v$database;

NAME
---------


SQL> exit
Disconnected from Oracle Database 11g Enterprise Edition Release 11.2.0.3.0 - 64bit Production
With the Partitioning, OLAP, Data Mining and Real Application Testing options
oracle@linux64:/remote/app/oracle//db/tech_st/11.2.0/appsutil/clone/bin[11]

2)  Apps Tier configuration on Target system application Server nodes

---

applmgr@linux64:/remote/app/applmgr//apps/apps_st/comn/clone/bin[152] perl adcfgclone.pl appsTier

                     Copyright (c) 2002 Oracle Corporation
                        Redwood Shores, California, USA

                        Oracle Applications Rapid Clone

                                 Version 12.0.0

                      adcfgclone Version 120.31.12010000.8

Enter the APPS password :

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

Log file located at /remote/app/applmgr//apps/apps_st/comn/clone/bin/CloneContext_0913175326.log

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

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

Target System Database SID :

Target System Database Server Node [linux64] :

Target System Database Domain Name [svs.usa.hp.com] :

Target System Base Directory : /remote/app/applmgr

Target System Tools ORACLE_HOME Directory [/remote/app/applmgr/apps/tech_st/10.1.2] : /remote/app/applmgr//apps/tech_st/10.1.2

Target System Web ORACLE_HOME Directory [/remote/app/applmgr/apps/tech_st/10.1.3] : /remote/app/applmgr//apps/tech_st/10.1.3

Target System APPL_TOP Directory [/remote/app/applmgr/apps/apps_st/appl] : /remote/app/applmgr//apps/apps_st/appl

Target System COMMON_TOP Directory [/remote/app/applmgr/apps/apps_st/comn] : /remote/app/applmgr//apps/apps_st/comn

Target System Instance Home Directory [/remote/app/applmgr/inst] : /remote/app/applmgr//inst/apps/TDBNAME_linux64

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 [linux64:0.0] (y/n)  : N

Target System Display [linux64:0.0] :

Target System Port Pool [0-99] : 35

Checking the port pool 35
done: Port Pool 35 is free
Report file located at /remote/app/applmgr//inst/apps/TDBNAME_linux64/apps/_linux64/admin/out/portpool.lst
Complete port information available at /remote/app/applmgr//inst/apps/TDBNAME_linux64/apps/_linux64/admin/out/portpool.lst

UTL_FILE_DIR on database tier consists of the following directories.

1. /usr/tmp
2. /usr/tmp
3. /remote/app/oracle//db/tech_st/11.2.0/appsutil/outbound/_linux64
4. /usr/tmp
Choose a value which will be set as APPLPTMP value on the target node [1] : 1

Creating the new APPL_TOP Context file from :
  /remote/app/applmgr//apps/apps_st/appl/ad/12.0.0/admin/template/adxmlctx.tmp

The new APPL_TOP context file has been created :
  /remote/app/applmgr//inst/apps/TDBNAME_linux64/apps/_linux64/appl/admin/_linux64.xml

Log file located at /remote/app/applmgr//apps/apps_st/comn/clone/bin/CloneContext_0913175326.log
Check Clone Context logfile /remote/app/applmgr//apps/apps_st/comn/clone/bin/CloneContext_0913175326.log for details.

Running Rapid Clone with command:
perl /remote/app/applmgr//apps/apps_st/comn/clone/bin/adclone.pl java=/remote/app/applmgr//apps/apps_st/comn/clone/bin/../jre mode=apply stage=/remote/app/applmgr//apps/apps_st/comn/clone component=appsTier method=CUSTOM appctxtg=/remote/app/applmgr//inst/apps/TDBNAME_linux64/apps/_linux64/appl/admin/_linux64.xml showProgress contextValidated=true
Running:
perl /remote/app/applmgr//apps/apps_st/comn/clone/bin/adclone.pl java=/remote/app/applmgr//apps/apps_st/comn/clone/bin/../jre mode=apply stage=/remote/app/applmgr//apps/apps_st/comn/clone component=appsTier method=CUSTOM appctxtg=/remote/app/applmgr//inst/apps/TDBNAME_linux64/apps/_linux64/appl/admin/_linux64.xml showProgress contextValidated=true
APPS Password :

Beginning application tier Apply - Sat Sep 13 17:58:52 2014

/remote/app/applmgr//apps/apps_st/comn/clone/bin/../jre/bin/java -Xmx600M -DCONTEXT_VALIDATED=true  -Doracle.installer.oui_loc=/oui -classpath /remote/app/applmgr//apps/apps_st/comn/clone/jlib/xmlparserv2.jar:/remote/app/applmgr//apps/apps_st/comn/clone/jlib/ojdbc14.jar:/remote/app/applmgr//apps/apps_st/comn/clone/jlib/java:/remote/app/applmgr//apps/apps_st/comn/clone/jlib/oui/OraInstaller.jar:/remote/app/applmgr//apps/apps_st/comn/clone/jlib/oui/ewt3.jar:/remote/app/applmgr//apps/apps_st/comn/clone/jlib/oui/share.jar:/remote/app/applmgr//apps/apps_st/comn/clone/jlib/oui/srvm.jar:/remote/app/applmgr//apps/apps_st/comn/clone/jlib/ojmisc.jar  oracle.apps.ad.clone.ApplyAppsTier -e /remote/app/applmgr//inst/apps/TDBNAME_linux64/apps/_linux64/appl/admin/_linux64.xml -stage /remote/app/applmgr//apps/apps_st/comn/clone    -showProgress
APPS Password : Log file located at /remote/app/applmgr//inst/apps/TDBNAME_linux64/apps/_linux64/admin/log/ApplyAppsTier_09131758.log
  |      0% completed




ApplyApplTop Completed Successfully.

# Checking the status of AutoConfig run of ApplyApplTop
# AutoConfig Completed successfully

[root@linux64 bin]#

-x-