Oracle EBS 12.2 Cloning


Introduction to Cloning

Cloning is the process of creating a copy of an existing Oracle E-Business Suite system. The cloning methodology described in this document covers the process used to clone an Oracle E-Business Suite Release 12.2 system.

Note: An Oracle E-Business Suite system can only be cloned to the same, or a higher, major release of a platform (operating system). For example, you can clone a system running on Oracle Solaris 10 to run on Oracle Solaris 11, but it is not supported to clone a system running on Solaris 11 to run on Solaris 10.

There are various scenarios that require cloning an Oracle E-Business Suite system:

  • Standard cloning – Copying an existing Oracle E-Business Suite system, for example, to test updates against a duplicate of a production system.  

Note: Be aware that standard cloning is different from file system cloning. Standard cloning is creating a copy of an Oracle E-Business Suite system using Rapid Clone (for example, cloning a complete Oracle E-Business Suite system to create a test copy from your production environment). In contrast, file system cloning is copying the run file system to the patch file system in online patching, and can only be undertaken with the adop phase=fs_clone command.

  • System scale-up – Adding new machines to an Oracle E-Business Suite system to provide capacity for processing increased workloads. 
  • System transformations – Altering system data or file systems, including actions such as platform migration, provisioning of high availability architectures, and data scrambling (or the preferred alternative of data masking, as described in My Oracle Support Knowledge Document 1437485.1Using Oracle E-Business Suite Release 12.1.3 Template for the Data Masking Pack with Oracle Enterprise Manager 11g). 
  • Patching and upgrading – Delivering new versions of Oracle E-Business Suite components, and providing a mechanism to create rolling environments that minimize downtimes.

An important principle in Oracle E-Business Suite cloning is that the system is cloned, rather than the topology. Producing an exact copy of the patch level and data is much more important than creating an exact copy of topology, as a cloned system must be able to provide the same output to the end user as the Source System. However, while a cloned system does not need to have the full topology of its Source, it must have available all of the topology components that are available to the Source.

Note: When cloning, ensure that you specify the actual locations for the directories involved, so that AD utilities can properly identify the directories afterward. Do not use symbolic links to specify directory locations.

High Level Standard Cloning Process for Application Tier

In addition to cloning the database tier node, the standard cloning process for application tier basically involves the following two key processes:

  1. Copy the application tier node from the Source Run Edition File System to the Target Run Edition File System. 
  2. Copy the application tier node from the Target Run Edition File System to the Target Patch Edition File System.

This high level cloning process specific to application tier can be illustrated in the following diagram:

  1. Prepare the Source System database tier for cloning
    1. Log on to the Source System as the oracle user.
    2. Source the Database tier environment file.
    3. Execute the following commands:

$ cd <RDBMS ORACLE_HOME>/appsutil/scripts/<CONTEXT_NAME> 
$ perl adpreclone.pl dbTier

[oracle@source_dbhost CRP1_source_dbhost]$ perl adpreclone.pl dbTier

                     Copyright (c) 2011, 2014 Oracle Corporation

                        Redwood Shores, California, USA
Oracle E-Business Suite Rapid Clone 

                                 Version 12.2 

                      adpreclone Version 120.31.12020000.16

Enter the APPS User Password:

Running:

perl /u01/install/PROD/11.2.0/appsutil/bin/adclone.pl java=/u01/install/PROD/11.2.0/appsutil/jre mode=stage stage=/u01/install/PROD/11.2.0/appsutil/clone component=dbTier method=CUSTOM dbctx=/u01/install/PROD/11.2.0/appsutil/CRP1_source_dbhost.xml showProgress

Beginning database tier Stage – Tue Mar 31 16:22:17 2015

/u01/install/PROD/11.2.0/appsutil/jre/bin/java -Xmx600M -DCONTEXT_VALIDATED=false
-Doracle.installer.oui_loc=/u01/install/PROD/11.2.0/oui
-classpath /u01/install/PROD/11.2.0/lib/xmlparserv2.jar:
/u01/install/PROD/11.2.0/jdbc/lib/ojdbc6.jar:
/u01/install/PROD/11.2.0/appsutil/java:
/u01/install/PROD/11.2.0/oui/jlib/OraInstaller.jar:
/u01/install/PROD/11.2.0/oui/jlib/ewt3.jar:
/u01/install/PROD/11.2.0/oui/jlib/share.jar:
/u01/install/PROD/11.2.0/oui/jlib/srvm.jar:
/u01/install/PROD/11.2.0/jlib/ojmisc.jar   oracle.apps.ad.clone.StageDBTier -e /u01/install/PROD/11.2.0/appsutil/CRP1_source_dbhost.xml -stage /u01/install/PROD/11.2.0/appsutil/clone -tmp /tmp -method CUSTOM    -showProgress

APPS Password :

Log file located at /u01/install/PROD/11.2.0/appsutil/log/CRP1_source_dbhost/StageDBTier_03311622.log

–     50% completed      

Completed Stage…

Tue Mar 31 16:22:47 2015

[oracle@source_dbhost CRP1_source_dbhost]$ 

  1. Prepare the Source System application tier for cloning
  1. Log on to the primary node of the Source System as the applmgr user.
  2. Source the environment file of the Run Edition File system.

    You can use the following command to confirm that the environment variable FILE_EDITION points to the Run Edition File System:

$ echo $FILE_EDITION
It should return the value: run

  1. Execute the following commands:

[root@source_appshost ~]# su – applmgr

 

  E-Business Suite Environment Information

  —————————————-

  RUN File System           : /u01/install/APPS/fs1/EBSapps/appl
  PATCH File System         : /u01/install/APPS/fs2/EBSapps/appl
Non-Editioned File System : /u01/install/APPS/fs_ne
DB Host: source_dbhost.domain  Service/SID: CRP1

 E-Business Suite Environment Setting
 ————————————

  – Enter [R/r] for sourcing Run File System Environment file, or

  – Enter [P/p] for sourcing Patch File System Environment file, or

  – Enter anything else to exit

Please choose the environment file you wish to source [R/P]:R

Sourcing the RUN File System …

[applmgr@source_appshost ~]$ cd $ADMIN_SCRIPTS_HOME

[applmgr@source_appshost scripts]$ perl adpreclone.pl appsTier

                     Copyright (c) 2011, 2014 Oracle Corporation

                        Redwood Shores, California, USA

                        Oracle E-Business Suite Rapid Clone

                                 Version 12.2

                      adpreclone Version 120.31.12020000.16

Enter the APPS User Password:

Enter the Weblogic AdminServer password :

Checking the status of the Oracle WebLogic Administration Server….

Running perl /u01/install/APPS/fs1/EBSapps/appl/ad/12.0.0/patch/115/bin/adProvisionEBS.pl ebs-get-serverstatus -contextfile=/u01/install/APPS/fs1/inst/apps/CRP1_source_appshost/appl/admin/CRP1_source_appshost.xml -servername=AdminServer -promptmsg=hide

 

The Oracle WebLogic Administration Server is up.

 

Running:

perl /u01/install/APPS/fs1/EBSapps/appl/ad/12.0.0/bin/adclone.pl java=/u01/install/APPS/fs1/EBSapps/comn/util/jdk64 mode=stage stage=/u01/install/APPS/fs1/EBSapps/comn/clone component=appsTier
method=appctx=/u01/install/APPS/fs1/inst/apps/CRP1_source_appshost/appl/admin/CRP1_source_appshost.xml showProgress

Setting the wls environment

Beginning application tier Stage – Thu Mar 19 09:47:15 2015

/u01/install/APPS/fs1/EBSapps/comn/util/jdk64/bin/java -Xmx600M -DCONTEXT_VALIDATED=false -Doracle.installer.oui_loc=/oui
-classpath /u01/install/APPS/fs1/FMW_Home/webtier/lib/xmlparserv2.jar:
/u01/install/APPS/fs1/FMW_Home/webtier/jdbc/lib/ojdbc6.jar:
/u01/install/APPS/fs1/EBSapps/comn/java/classes:
/u01/install/APPS/fs1/FMW_Home/webtier/oui/jlib/OraInstaller.jar:
/u01/install/APPS/fs1/FMW_Home/webtier/oui/jlib/ewt3.jar:
/u01/install/APPS/fs1/FMW_Home/webtier/oui/jlib/share.jar:
/u01/install/APPS/fs1/FMW_Home/webtier/../Oracle_EBS-app1/oui/jlib/srvm.jar:
/u01/install/APPS/fs1/FMW_Home/webtier/jlib/ojmisc.jar:
/u01/install/APPS/fs1/FMW_Home/wlserver_10.3/server/lib/weblogic.jar:
/u01/install/APPS/fs1/FMW_Home/oracle_common/jlib/obfuscatepassword.jar  oracle.apps.ad.clone.StageAppsTier -e /u01/install/APPS/fs1/inst/apps/CRP1_source_appshost/appl/admin/CRP1_source_appshost.xml -stage /u01/install/APPS/fs1/EBSapps/comn/clone -tmp /tmp -method CUSTOM   -showProgress -nopromptmsg

Log file located at /u01/install/APPS/fs1/inst/apps/CRP1_source_appshost/admin/log/clone/StageAppsTier_03190947.log

\     20% completed

Completed Stage…

Thu Mar 19 09:55:17 2015

[applmgr@source_appshost scripts]$

  1. Copy both database tier and application tier nodes from the Source System to the Target System

    Copy the application tier file system from the Source node to the Target node by executing the following steps in the order listed. Ensure the application tier files copied to the Target System are owned by the Target applmgr user, and that the database node files are owned by the Target oracle user. 

    Copy the database node file system

    Log on to the Source System database node as the oracle user, and then: 

  1. Perform a normal shut down of the Source System database. 
  2. Copy the database (.dbf) files from the Source System to the Target System. 
  3. Copy the Source System database ORACLE_HOME to the Target System. 
  4. Start the Source applications system database and application tier processes.
  1. Copy the application tier file from the Source “Run Edition File System” to the Target “Run Edition File System”

    Log on to Run Edition File System in the Source System application tier nodes as the applmgr user. 

    Copy the following application tier directories from the Source Node to the Target Run Edition File System application tier node:

<APPL_TOP> 
<COMMON_TOP>
<OracleAS Tools 10.1.2 ORACLE_HOME>

  1. Configure the Target System Database

Run the following commands to configure the Target System. You will be prompted for specific Target System values such as SID, paths, and ports.

Configure the Target System database server

Log on to the Target System as the oracle user and enter the following commands:

$ cd <RDBMS ORACLE_HOME>/appsutil/clone/bin 
$ perl adcfgclone.pl dbTier

 

[oracle@dbhost ~]$ cd /u01/install/DEV/11.2.0/appsutil/clone/bin
[oracle@dbhost bin]$ perl adcfgclone.pl dbTier

                     Copyright (c) 2011 Oracle Corporation

                        Redwood Shores, California, USA

                        Oracle E-Business Suite Rapid Clone

                                 Version 12.2

                      adcfgclone Version 120.63.12020000.35

Enter the APPS password :

Running:

/u01/install/DEV/11.2.0/appsutil/clone/bin/../jre/bin/java -Xmx600M -cp /u01/install/DEV/11.2.0/appsutil/clone/jlib/java:
/u01/install/DEV/11.2.0/appsutil/clone/jlib/xmlparserv2.jar:
/u01/install/DEV/11.2.0/appsutil/clone/jlib/ojdbc5.jar:
/u01/install/DEV/11.2.0/appsutil/clone/jlib/obfuscatepassword.jar:
/u01/install/DEV/11.2.0/appsutil/clone/jlib/ojmisc.jar:
/u01/install/DEV/11.2.0/appsutil/clone/jlib/java:
/u01/install/DEV/11.2.0/appsutil/clone/jlib/emCfg.jar oracle.apps.ad.context.CloneContext -e /u01/install/DEV/11.2.0/appsutil/clone/bin/../context/db/CTXORIG.xml -validate -pairsfile /tmp/adpairsfile_1471.lst -stage /u01/install/DEV/11.2.0/appsutil/clone  2> /tmp/adcfgclone_1471.err; echo $? > /tmp/adcfgclone_1471.res

Log file located at /u01/install/DEV/11.2.0/appsutil/clone/bin/CloneContext_0331162811.log

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

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

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

Target System Database SID : DEV

Target System Base Directory : /u01/install/DEV

Target System utl_file_dir Directory List : /usr/tmp

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

Target System DATA_TOP Directory 1 [/u01/install/PROD/data] : /u01/install/DEV/data

Target System RDBMS ORACLE_HOME Directory [/u01/install/DEV/11.2.0] : /u01/install/DEV/11.2.0

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

Target System Display [dbhost:0.0] : dbhost:1.0

Do you want the target system to have the same port values as the source system (y/n) [y] ? : n

Target System Port Pool [0-99] : 2

Checking the port pool 2

done: Port Pool 2 is free

Report file located at /u01/install/DEV/11.2.0/appsutil/temp/portpool.lst

Complete port information available at /u01/install/DEV/11.2.0/appsutil/temp/portpool.lst

Backing up /u01/install/DEV/11.2.0/appsutil/DEV_dbhost.xml to /u01/install/DEV/11.2.0/appsutil/DEV_dbhost.xml.bak

Creating the new Database Context file from :  /u01/install/DEV/11.2.0/appsutil/clone/context/db/adxdbctx.tmp

The new database context file has been created :  /u01/install/DEV/11.2.0/appsutil/DEV_dbhost.xml

Log file located at /u01/install/DEV/11.2.0/appsutil/clone/bin/CloneContext_0331194625.log

Check Clone Context logfile /u01/install/DEV/11.2.0/appsutil/clone/bin/CloneContext_0331194625.log for details.

Running Rapid Clone with command:

Running:

perl /u01/install/DEV/11.2.0/appsutil/clone/bin/adclone.pl java=/u01/install/DEV/11.2.0/appsutil/clone/bin/../jre mode=apply stage=/u01/install/DEV/11.2.0/appsutil/clone component=dbTier method=CUSTOM dbctxtg=/u01/install/DEV/11.2.0/appsutil/DEV_dbhost.xml showProgress contextValidated=true

Beginning database tier Apply – Tue Mar 31 19:48:04 2015

/u01/install/DEV/11.2.0/appsutil/clone/bin/../jre/bin/java -Xmx600M -DCONTEXT_VALIDATED=true -Doracle.installer.oui_loc=/u01/install/DEV/11.2.0/oui
-classpath /u01/install/DEV/11.2.0/appsutil/clone/jlib/xmlparserv2.jar:
/u01/install/DEV/11.2.0/appsutil/clone/jlib/ojdbc6.jar:
/u01/install/DEV/11.2.0/appsutil/clone/jlib/java:
/u01/install/DEV/11.2.0/appsutil/clone/jlib/oui/OraInstaller.jar:
/u01/install/DEV/11.2.0/appsutil/clone/jlib/oui/ewt3.jar:
/u01/install/DEV/11.2.0/appsutil/clone/jlib/oui/share.jar:
/u01/install/DEV/11.2.0/appsutil/clone/jlib/oui/srvm.jar:
/u01/install/DEV/11.2.0/appsutil/clone/jlib/ojmisc.jar
oracle.apps.ad.clone.ApplyDBTier
-e /u01/install/DEV/11.2.0/appsutil/DEV_dbhost.xml
-stage /u01/install/DEV/11.2.0/appsutil/clone   -showProgress

APPS Password : Log file located at /u01/install/DEV/11.2.0/appsutil/log/DEV_dbhost/ApplyDBTier_03311948.log

  |      0% completed       Determining Source system database type (“single” or “rac”).

Source system indentified as being of type “single”!

  |     50% completed      

Completed Apply…

Tue Mar 31 19:54:47 2015

Starting database listener for DEV:

Running:

/u01/install/DEV/11.2.0/appsutil/scripts/DEV_dbhost/addlnctl.sh start DEVLogfile: /u01/install/DEV/11.2.0/appsutil/log/DEV_dbhost/addlnctl.txt

You are running addlnctl.sh version 120.4
Starting listener process DEV …

Listener DEV has already been started.
addlnctl.sh: exiting with status 0

addlnctl.sh: check the logfile /u01/install/DEV/11.2.0/appsutil/log/DEV_dbhost/addlnctl.txt for more information … 

Do you want to change the password for all EBS Schemas? (y/n) [n]) : n

Do you want to change the apps password? (y/n) [n]) : n

Do you want to change the sys and system passwords? (y/n) [n]) : n

[oracle@dbhost bin]$

 

  1. Configure the Target System application tier server nodes (RUN File System)

Log on to the Run Edition File System in the Target System as the applmgr user and enter the following commands:

$ cd <COMMON_TOP>/clone/bin
$ perl adcfgclone.pl appsTier

 

[applmgr@target_appshost apps]$ cd /u01/install/DEV/fs1/EBSapps/comn/clone/bin
[applmgr@target_appshost bin]$ perl adcfgclone.pl appsTier

                     Copyright (c) 2011 Oracle Corporation
                        Redwood Shores, California, USA
                        Oracle E-Business Suite Rapid Clone

                                 Version 12.2

                      adcfgclone Version 120.63.12020000.37

Enter the APPS password :

Running:

/u01/install/DEV/fs1/EBSapps/comn/clone/bin/../jre/bin/java -Xmx600M
-classpath /u01/install/DEV/fs1/EBSapps/comn/clone/jlib/obfuscatepassword.jar:
/u01/install/DEV/fs1/EBSapps/comn/clone/jlib/ojmisc.jar:
/u01/install/DEV/fs1/EBSapps/comn/clone/jlib/java:
/u01/install/DEV/fs1/EBSapps/comn/clone/jlib/emCfg.jar oracle.apps.ad.clone.util.OPWrapper -encryptpwd /u01/install/DEV/fs1/EBSapps/comn/clone/bin/../FMW/tempinfoApps.txt

Enter the Weblogic AdminServer password :

Running:

/u01/install/DEV/fs1/EBSapps/comn/clone/bin/../jre/bin/java -Xmx600M
-classpath /u01/install/DEV/fs1/EBSapps/comn/clone/jlib/obfuscatepassword.jar:
/u01/install/DEV/fs1/EBSapps/comn/clone/jlib/ojmisc.jar:
/u01/install/DEV/fs1/EBSapps/comn/clone/jlib/java:
/u01/install/DEV/fs1/EBSapps/comn/clone/jlib/emCfg.jar oracle.apps.ad.clone.util.OPWrapper /u01/install/DEV/fs1/EBSapps/comn/clone/bin/../FMW/tempinfo.txt

Running:

/u01/install/DEV/fs1/EBSapps/comn/clone/bin/../jre/bin/java -Xmx600M
-classpath /u01/install/DEV/fs1/EBSapps/comn/clone/jlib/obfuscatepassword.jar:
/u01/install/DEV/fs1/EBSapps/comn/clone/jlib/ojmisc.jar:
/u01/install/DEV/fs1/EBSapps/comn/clone/jlib/java:
/u01/install/DEV/fs1/EBSapps/comn/clone/jlib/emCfg.jar oracle.apps.ad.clone.util.OPWrapper /u01/install/DEV/fs1/EBSapps/comn/clone/bin/../FMW/EBSDataSource

Do you want to add a node (yes/no) [no] : no

Running:

/u01/install/DEV/fs1/EBSapps/comn/clone/bin/../jre/bin/java -Xmx600M -cp /u01/install/DEV/fs1/EBSapps/comn/clone/jlib/java:
/u01/install/DEV/fs1/EBSapps/comn/clone/jlib/xmlparserv2.jar:
/u01/install/DEV/fs1/EBSapps/comn/clone/jlib/ojdbc6.jar:
/u01/install/DEV/fs1/EBSapps/comn/clone/jlib/obfuscatepassword.jar:
/u01/install/DEV/fs1/EBSapps/comn/clone/jlib/ojmisc.jar:
/u01/install/DEV/fs1/EBSapps/comn/clone/jlib/java:
/u01/install/DEV/fs1/EBSapps/comn/clone/jlib/emCfg.jar oracle.apps.ad.context.CloneContext -e /u01/install/DEV/fs1/EBSapps/comn/clone/bin/../context/apps/CTXORIG.xml
-validate -pairsfile /tmp/adpairsfile_2838.lst
-stage /u01/install/DEV/fs1/EBSapps/comn/clone  2> /tmp/adcfgclone_2838.err;
echo $? > /tmp/adcfgclone_2838.res

Log file located at /u01/install/DEV/fs1/EBSapps/comn/clone/bin/CloneContext_0401050637.log

Target System File Edition type [run] : run

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

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

Target System Database SID : DEV

Target System Database Server Node [target_appshost] : dbhost

Target System Database Domain Name [domain] : domain

Target System Base Directory : /u01/install/DEV

Target System Base Directory set to /u01/install/DEV

Target System Current File System Base set to /u01/install/DEV/fs1

Target System Other File System Base set to /u01/install/DEV/fs2

Target System Fusion Middleware Home set to /u01/install/DEV/fs1/FMW_Home

Target System Web Oracle Home set to /u01/install/DEV/fs1/FMW_Home/webtier

Target System Appl TOP set to /u01/install/DEV/fs1/EBSapps/appl

Target System COMMON TOP set to /u01/install/DEV/fs1/EBSapps/comn

Target System Instance Home Directory [/u01/install/DEV] : /u01/install/DEV

Target System Instance Top set to /u01/install/DEV/fs1/inst/apps/DEV_target_appshost

Do you want to preserve the Display [localhost:5.0] (y/n)  : n

Target System Display [target_appshost:0.0] : target_appshost:1.0

Target System Root Service [enabled] : enabled

Target System Web Administration [enabled] : enabled

Target System Web Entry Point Services [enabled] : enabled

Target System Web Application Services [enabled] : enabled

Target System Batch Processing Services [enabled] : enabled

Target System Other Services [disabled] : disabled

Do you want the target system to have the same port values as the source system (y/n) [y] ? : n

Target System Port Pool [0-99] : 2

Checking the port pool 2

done: Port Pool 2 is free

Report file located at /u01/install/DEV/fs1/inst/apps/DEV_target_appshost/admin/out/portpool.lst

Complete port information available at /u01/install/DEV/fs1/inst/apps/DEV_target_appshost/admin/out/portpool.lst

UTL_FILE_DIR on database tier consists of the following directories.

  1. /usr/tmp
  2. /usr/tmp
  3. /u01/install/DEV/11.2.0/appsutil/outbound/DEV_dbhost
  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 :  /u01/install/DEV/fs1/EBSapps/comn/clone/context/apps/adxmlctx.tmp
The new APPL_TOP context file has been created :  /u01/install/DEV/fs1/inst/apps/DEV_target_appshost/appl/admin/DEV_target_appshost.xml

Log file located at /u01/install/DEV/fs1/EBSapps/comn/clone/bin/CloneContext_0401051142.log

Check Clone Context logfile /u01/install/DEV/fs1/EBSapps/comn/clone/bin/CloneContext_0401051142.log for details.

Running Rapid Clone with command:

Running:

perl /u01/install/DEV/fs1/EBSapps/comn/clone/bin/adclone.pl java=/u01/install/DEV/fs1/EBSapps/comn/clone/bin/../jre mode=apply stage=/u01/install/DEV/fs1/EBSapps/comn/clone component=appsTier method=CUSTOM appctxtg=/u01/install/DEV/fs1/inst/apps/DEV_target_appshost/appl/admin/DEV_target_appshost.xml showProgress contextValidated=true

FMW Pre-requisite check log file location : /u01/install/DEV/fs1/EBSapps/comn/clone/FMW/logs/prereqcheck.log

Running: /u01/install/DEV/fs1/EBSapps/comn/clone/FMW/t2pjdk/bin/java -classpath /u01/install/DEV/fs1/EBSapps/comn/clone/prereq/webtier/Scripts/ext/jlib/engine.jar:
/u01/install/DEV/fs1/EBSapps/comn/clone/prereq/webtier/oui/jlib/OraPrereq.jar:
/u01/install/DEV/fs1/EBSapps/comn/clone/prereq/webtier/oui/jlib/OraPrereqChecks.jar:
/u01/install/DEV/fs1/EBSapps/comn/clone/prereq/webtier/oui/jlib/OraInstaller.jar:
/u01/install/DEV/fs1/EBSapps/comn/clone/prereq/webtier/oui/jlib/OraInstallerNet.jar:
/u01/install/DEV/fs1/EBSapps/comn/clone/prereq/webtier/oui/jlib/srvm.jar:
/u01/install/DEV/fs1/EBSapps/comn/clone/prereq/webtier/Scripts/ext/jlib/ojdl.jar:
/u01/install/DEV/fs1/EBSapps/comn/clone/prereq/webtier/Scripts/ext/jlib/ojdl2.jar:
/u01/install/DEV/fs1/EBSapps/comn/clone/prereq/webtier/Scripts/ext/jlib/ojdl-log4j.jar:
/u01/install/DEV/fs1/EBSapps/comn/clone/prereq/webtier/oui/jlib/xmlparserv2.jar:
/u01/install/DEV/fs1/EBSapps/comn/clone/prereq/webtier/oui/jlib/share.jar:
/u01/install/DEV/fs1/EBSapps/comn/clone/jlib/java oracle.apps.ad.clone.util.FMWOracleHomePreReqCheck -prereqCheckFMW -e /u01/install/DEV/fs1/inst/apps/DEV_target_appshost/appl/admin/DEV_target_appshost.xml -stage /u01/install/DEV/fs1/EBSapps/comn/clone -log /u01/install/DEV/fs1/EBSapps/comn/clone/FMW/logs/prereqcheck.log

Beginning application tier Apply – Wed Apr  1 05:12:31 2015

/u01/install/DEV/fs1/EBSapps/comn/clone/bin/../jre/bin/java -Xmx600M -DCONTEXT_VALIDATED=true -Doracle.installer.oui_loc=/oui -classpath /u01/install/DEV/fs1/EBSapps/comn/clone/jlib/xmlparserv2.jar:
/u01/install/DEV/fs1/EBSapps/comn/clone/jlib/ojdbc6.jar:
/u01/install/DEV/fs1/EBSapps/comn/clone/jlib/java:
/u01/install/DEV/fs1/EBSapps/comn/clone/jlib/oui/OraInstaller.jar:
/u01/install/DEV/fs1/EBSapps/comn/clone/jlib/oui/ewt3.jar:
/u01/install/DEV/fs1/EBSapps/comn/clone/jlib/oui/share.jar:
/u01/install/DEV/fs1/FMW_Home/webtier/../Oracle_EBS-app1/oui/jlib/srvm.jar:/u01/install/DEV/fs1/EBSapps/comn/clone/jlib/ojmisc.jar:
/u01/install/DEV/fs1/FMW_Home/wlserver_10.3/server/lib/weblogic.jar:
/u01/install/DEV/fs1/EBSapps/comn/clone/jlib/obfuscatepassword.jar  oracle.apps.ad.clone.ApplyAppsTier -e /u01/install/DEV/fs1/inst/apps/DEV_target_appshost/appl/admin/DEV_target_appshost.xml -stage /u01/install/DEV/fs1/EBSapps/comn/clone    -showProgress -nopromptmsg

Log file located at /u01/install/DEV/fs1/inst/apps/DEV_target_appshost/admin/log/clone/ApplyAppsTier_04010512.log

  /    100% completed  

Completed Apply…

Wed Apr  1 05:32:51 2015

 Executing command: /u01/install/DEV/fs1/EBSapps/10.1.2/bin/sqlplus @/u01/install/DEV/fs1/EBSapps/appl/ad/12.0.0/patch/115/sql/truncate_ad_nodes_config_status.sql

Do you want to startup the Application Services for DEV? (y/n) [n] : y

Services not started

[applmgr@target_appshost bin]$

When asked the question:
“Do you want to startup the Application Services for mult35? (y/n)” you should answer ‘y’.

  1. Configure the Target System application tier server nodes (PATCH File System)

    1. Source the environment file of the Run Edition File System and run plon the Run Edition File System.

[root@target_appshost ~]# su – applmgr

  E-Business Suite Environment Information

  —————————————-

  RUN File System           : /u01/install/DEV/fs1/EBSapps/appl

  PATCH File System         : /u01/install/DEV/fs2/EBSapps/appl

  Non-Editioned File System : /u01/install/DEV/fs_ne

  DB Host: dbhost.domain  Service/SID: DEV

  E-Business Suite Environment Setting

  ————————————

  – Enter [R/r] for sourcing Run File System Environment file, or
  – Enter [P/p] for sourcing Patch File System Environment file, or
– Enter anything else to exit

  Please choose the environment file you wish to source [R/P]:R

  Sourcing the RUN File System …

[applmgr@target_appshost ~]$ cd $ADMIN_SCRIPTS_HOME

[applmgr@target_appshost scripts]$ perl adpreclone.pl appsTier

                     Copyright (c) 2011, 2014 Oracle Corporation
                        Redwood Shores, California, USA

                        Oracle E-Business Suite Rapid Clone

                                 Version 12.2

                      adpreclone Version 120.31.12020000.16

Enter the APPS User Password:

Enter the Weblogic AdminServer password :

 Checking the status of the Oracle WebLogic Administration Server….

 Running perl /u01/install/DEV/fs1/EBSapps/appl/ad/12.0.0/patch/115/bin/adProvisionEBS.pl ebs-get-serverstatus -contextfile=/u01/install/DEV/fs1/inst/apps/DEV_target_appshost/appl/admin/DEV_target_appshost.xml -servername=AdminServer -promptmsg=hide 

The Oracle WebLogic Administration Server is up.

Running:

perl /u01/install/DEV/fs1/EBSapps/appl/ad/12.0.0/bin/adclone.pl java=/u01/install/DEV/fs1/EBSapps/comn/util/jdk64 mode=stage stage=/u01/install/DEV/fs1/EBSapps/comn/clone component=appsTier method= appctx=/u01/install/DEV/fs1/inst/apps/DEV_target_appshost/appl/admin/DEV_target_appshost.xml showProgress

 Setting the wls environment

Beginning application tier Stage – Wed Apr  1 07:38:32 2015

/u01/install/DEV/fs1/EBSapps/comn/util/jdk64/bin/java -Xmx600M -DCONTEXT_VALIDATED=false -Doracle.installer.oui_loc=/oui -classpath /u01/install/DEV/fs1/FMW_Home/webtier/lib/xmlparserv2.jar:
/u01/install/DEV/fs1/FMW_Home/webtier/jdbc/lib/ojdbc6.jar:
/u01/install/DEV/fs1/EBSapps/comn/java/classes:
/u01/install/DEV/fs1/FMW_Home/webtier/oui/jlib/OraInstaller.jar:
/u01/install/DEV/fs1/FMW_Home/webtier/oui/jlib/ewt3.jar:
/u01/install/DEV/fs1/FMW_Home/webtier/oui/jlib/share.jar:
/u01/install/DEV/fs1/FMW_Home/webtier/../Oracle_EBS-app1/oui/jlib/srvm.jar:/u01/install/DEV/fs1/FMW_Home/webtier/jlib/ojmisc.jar:
/u01/install/DEV/fs1/FMW_Home/wlserver_10.3/server/lib/weblogic.jar:
/u01/install/DEV/fs1/FMW_Home/oracle_common/jlib/obfuscatepassword.jar  oracle.apps.ad.clone.StageAppsTier -e /u01/install/DEV/fs1/inst/apps/DEV_target_appshost/appl/admin/DEV_target_appshost.xml -stage /u01/install/DEV/fs1/EBSapps/comn/clone -tmp /tmp -method CUSTOM   -showProgress -nopromptmsg

Log file located at /u01/install/DEV/fs1/inst/apps/DEV_target_appshost/admin/log/clone/StageAppsTier_04010738.log

  –     20% completed    

Completed Stage…

Wed Apr  1 07:45:41 2015

[applmgr@target_appshost scripts]$

Shutdown the Application running on RUN file system

Copy Oracle E-Business Suite application directories from the Run Edition File System to the Patch Edition File System. 

Note: Make sure you pay attention to symbolic links under <OracleAS Tools 10.1.2 ORACLE_HOME> and <COMMON_TOP> directories when copying files.

  1. Log on to the Patch Edition File System in the Target System as the applmgr user and enter the following commands:

$ cd <COMMON_TOP>/clone/bin
$ perl adcfgclone.pl appsTier 

[applmgr@target_appshost bin]$ cd /u01/install/DEV/fs2/EBSapps/comn/clone/bin
[applmgr@target_appshost bin]$ perl adcfgclone.pl appsTier

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

                        Oracle E-Business Suite Rapid Clone

                                 Version 12.2

                      adcfgclone Version 120.63.12020000.37

Enter the APPS password :

Running:

/u01/install/DEV/fs2/EBSapps/comn/clone/bin/../jre/bin/java -Xmx600M -classpath /u01/install/DEV/fs2/EBSapps/comn/clone/jlib/obfuscatepassword.jar:
/u01/install/DEV/fs2/EBSapps/comn/clone/jlib/ojmisc.jar:
/u01/install/DEV/fs2/EBSapps/comn/clone/jlib/java:
/u01/install/DEV/fs2/EBSapps/comn/clone/jlib/emCfg.jar oracle.apps.ad.clone.util.OPWrapper -encryptpwd /u01/install/DEV/fs2/EBSapps/comn/clone/bin/../FMW/tempinfoApps.txt

Enter the Weblogic AdminServer password :

Running:

/u01/install/DEV/fs2/EBSapps/comn/clone/bin/../jre/bin/java -Xmx600M -classpath /u01/install/DEV/fs2/EBSapps/comn/clone/jlib/obfuscatepassword.jar:
/u01/install/DEV/fs2/EBSapps/comn/clone/jlib/ojmisc.jar:
/u01/install/DEV/fs2/EBSapps/comn/clone/jlib/java:
/u01/install/DEV/fs2/EBSapps/comn/clone/jlib/emCfg.jar oracle.apps.ad.clone.util.OPWrapper /u01/install/DEV/fs2/EBSapps/comn/clone/bin/../FMW/tempinfo.txt

Running:

/u01/install/DEV/fs2/EBSapps/comn/clone/bin/../jre/bin/java -Xmx600M -classpath /u01/install/DEV/fs2/EBSapps/comn/clone/jlib/obfuscatepassword.jar:
/u01/install/DEV/fs2/EBSapps/comn/clone/jlib/ojmisc.jar:
/u01/install/DEV/fs2/EBSapps/comn/clone/jlib/java:
/u01/install/DEV/fs2/EBSapps/comn/clone/jlib/emCfg.jar oracle.apps.ad.clone.util.OPWrapper /u01/install/DEV/fs2/EBSapps/comn/clone/bin/../FMW/EBSDataSource

Do you want to add a node (yes/no) [no] : no

Running:

/u01/install/DEV/fs2/EBSapps/comn/clone/bin/../jre/bin/java -Xmx600M -cp /u01/install/DEV/fs2/EBSapps/comn/clone/jlib/java:
/u01/install/DEV/fs2/EBSapps/comn/clone/jlib/xmlparserv2.jar:
/u01/install/DEV/fs2/EBSapps/comn/clone/jlib/ojdbc6.jar:
/u01/install/DEV/fs2/EBSapps/comn/clone/jlib/obfuscatepassword.jar:
/u01/install/DEV/fs2/EBSapps/comn/clone/jlib/ojmisc.jar:
/u01/install/DEV/fs2/EBSapps/comn/clone/jlib/java:
/u01/install/DEV/fs2/EBSapps/comn/clone/jlib/emCfg.jar oracle.apps.ad.context.CloneContext -e /u01/install/DEV/fs2/EBSapps/comn/clone/bin/../context/apps/CTXORIG.xml
-validate -pairsfile /tmp/adpairsfile_31120.lst
-stage /u01/install/DEV/fs2/EBSapps/comn/clone  2> /tmp/adcfgclone_31120.err;
echo $? > /tmp/adcfgclone_31120.res

Log file located at /u01/install/DEV/fs2/EBSapps/comn/clone/bin/CloneContext_0401144631.log

Target System File Edition type [run] : patch

Enter the full path of Run File System Context file : /u01/install/DEV/fs1/inst/apps/DEV_target_appshost/appl/admin/DEV_target_appshost.xml

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

Target System Fusion Middleware Home set to /u01/install/DEV/fs2/FMW_Home

Target System Web Oracle Home set to /u01/install/DEV/fs2/FMW_Home/webtier

Target System Appl TOP set to /u01/install/DEV/fs2/EBSapps/appl

Target System COMMON TOP set to /u01/install/DEV/fs2/EBSapps/comn

Target System Instance Top set to /u01/install/DEV/fs2/inst/apps/DEV_target_appshost

Target System Port Pool [0-99] : 1

Checking the port pool 1
done: Port Pool 1 is free

Report file located at /u01/install/DEV/fs2/inst/apps/DEV_target_appshost/admin/out/portpool.lst
Complete port information available at /u01/install/DEV/fs2/inst/apps/DEV_target_appshost/admin/out/portpool.lst

UTL_FILE_DIR on database tier consists of the following directories.

  1. /usr/tmp
  2. /usr/tmp
  3. /u01/install/DEV/11.2.0/appsutil/outbound/DEV_dbhost
  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 :  /u01/install/DEV/fs2/EBSapps/comn/clone/context/apps/adxmlctx.tmp

The new APPL_TOP context file has been created :  /u01/install/DEV/fs2/inst/apps/DEV_target_appshost/appl/admin/DEV_target_appshost.xml

Log file located at /u01/install/DEV/fs2/EBSapps/comn/clone/bin/CloneContext_0401144631.log

Check Clone Context logfile /u01/install/DEV/fs2/EBSapps/comn/clone/bin/CloneContext_0401144631.log for details.

Running Rapid Clone with command:

Running:

perl /u01/install/DEV/fs2/EBSapps/comn/clone/bin/adclone.pl java=/u01/install/DEV/fs2/EBSapps/comn/clone/bin/../jre mode=apply stage=/u01/install/DEV/fs2/EBSapps/comn/clone component=appsTier method=CUSTOM appctxtg=/u01/install/DEV/fs2/inst/apps/DEV_target_appshost/appl/admin/DEV_target_appshost.xml showProgress contextValidated=true

FMW Pre-requisite check log file location : /u01/install/DEV/fs2/EBSapps/comn/clone/FMW/logs/prereqcheck.log

Running: /u01/install/DEV/fs2/EBSapps/comn/clone/FMW/t2pjdk/bin/java -classpath /u01/install/DEV/fs2/EBSapps/comn/clone/prereq/webtier/Scripts/ext/jlib/engine.jar:
/u01/install/DEV/fs2/EBSapps/comn/clone/prereq/webtier/oui/jlib/OraPrereq.jar:
/u01/install/DEV/fs2/EBSapps/comn/clone/prereq/webtier/oui/jlib/OraPrereqChecks.jar:
/u01/install/DEV/fs2/EBSapps/comn/clone/prereq/webtier/oui/jlib/OraInstaller.jar:
/u01/install/DEV/fs2/EBSapps/comn/clone/prereq/webtier/oui/jlib/OraInstallerNet.jar:
/u01/install/DEV/fs2/EBSapps/comn/clone/prereq/webtier/oui/jlib/srvm.jar:
/u01/install/DEV/fs2/EBSapps/comn/clone/prereq/webtier/Scripts/ext/jlib/ojdl.jar:
/u01/install/DEV/fs2/EBSapps/comn/clone/prereq/webtier/Scripts/ext/jlib/ojdl2.jar:
/u01/install/DEV/fs2/EBSapps/comn/clone/prereq/webtier/Scripts/ext/jlib/ojdl-log4j.jar:
/u01/install/DEV/fs2/EBSapps/comn/clone/prereq/webtier/oui/jlib/xmlparserv2.jar:
/u01/install/DEV/fs2/EBSapps/comn/clone/prereq/webtier/oui/jlib/share.jar:
/u01/install/DEV/fs2/EBSapps/comn/clone/jlib/java oracle.apps.ad.clone.util.FMWOracleHomePreReqCheck -prereqCheckFMW -e /u01/install/DEV/fs2/inst/apps/DEV_target_appshost/appl/admin/DEV_target_appshost.xml
-stage /u01/install/DEV/fs2/EBSapps/comn/clone -log /u01/install/DEV/fs2/EBSapps/comn/clone/FMW/logs/prereqcheck.log

Beginning application tier Apply – Wed Apr  1 14:48:10 2015

/u01/install/DEV/fs2/EBSapps/comn/clone/bin/../jre/bin/java -Xmx600M -DCONTEXT_VALIDATED=true -Doracle.installer.oui_loc=/oui -classpath /u01/install/DEV/fs2/EBSapps/comn/clone/jlib/xmlparserv2.jar:
/u01/install/DEV/fs2/EBSapps/comn/clone/jlib/ojdbc6.jar:
/u01/install/DEV/fs2/EBSapps/comn/clone/jlib/java:
/u01/install/DEV/fs2/EBSapps/comn/clone/jlib/oui/OraInstaller.jar:
/u01/install/DEV/fs2/EBSapps/comn/clone/jlib/oui/ewt3.jar:
/u01/install/DEV/fs2/EBSapps/comn/clone/jlib/oui/share.jar:
/u01/install/DEV/fs2/FMW_Home/webtier/../Oracle_EBS-app1/oui/jlib/srvm.jar:
/u01/install/DEV/fs2/EBSapps/comn/clone/jlib/ojmisc.jar:
/u01/install/DEV/fs2/FMW_Home/wlserver_10.3/server/lib/weblogic.jar:
/u01/install/DEV/fs2/EBSapps/comn/clone/jlib/obfuscatepassword.jar  oracle.apps.ad.clone.ApplyAppsTier -e /u01/install/DEV/fs2/inst/apps/DEV_target_appshost/appl/admin/DEV_target_appshost.xml -stage /u01/install/DEV/fs2/EBSapps/comn/clone    -showProgress -nopromptmsg

Log file located at /u01/install/DEV/fs2/inst/apps/DEV_target_appshost/admin/log/clone/ApplyAppsTier_04011448.log

  \    100% completed     

Completed Apply…

Wed Apr  1 15:06:46 2015

Looking for incomplete CLONE record in ad_adop_session_patches table

The CLONE record status is no rows selected

[applmgr@target_appshost bin]$

  1. Reset Password

  2. SYSADMIN Password

[applmgr@target_appshost ~]$ AFPASSWD -f SYSADMIN

Enter the ORACLE password of Application Object Library ‘APPSUSER’:

Connected successfully to APPS.

Log file: AFPWD_DEV_868117.log

Enter new password for user [SYSADMIN]:

Verify new password for user [SYSADMIN]:

[applmgr@target_appshost ~]$ cat AFPWD_DEV_868117.log

+—————————————————————————-+

Application Object Library – AFPASSWD

+—————————————————————————-+

Copyright (c) 1998, 2014, Oracle and/or its affiliates. All rights reserved.

+—————————————————————————-+

Current system time is 01-APR-15 12:01:56 

+—————————————————————————-+

Working…

Password is changed successfully for user SYSADMIN.

AFPASSWD completed successfully.

+—————————————————————————-+

Current system time is 01-APR-15 12:02:24 

+—————————————————————————-+

[applmgr@target_appshost ~]$

  1. APPS Password

    Source Run Filesystem and execute AFPASSSWD

[root@target_appshost ~]# su – applmgr

  E-Business Suite Environment Information

  —————————————-

  RUN File System           : /u01/install/DEV/fs1/EBSapps/appl

  PATCH File System         : /u01/install/DEV/fs2/EBSapps/appl

  Non-Editioned File System : /u01/install/DEV/fs_ne

  DB Host: dbhost.domain  Service/SID: DEV

  E-Business Suite Environment Setting

  ————————————

  – Enter [R/r] for sourcing Run File System Environment file, or

  – Enter [P/p] for sourcing Patch File System Environment file, or

  – Enter anything else to exit

  Please choose the environment file you wish to source [R/P]:R

  Sourcing the RUN File System …

[applmgr@target_appshost ~]$ AFPASSWD -c APPS -s APPLSYS

Enter the ORACLE password of Application Object Library ‘APPSUSER’:

Connected successfully to APPS.

Enter the password for your ‘SYSTEM’ ORACLE schema:

Connected successfully to SYSTEM.

Log file: AFPWD_DEV_158811.log

Enter new password for user:       <Enter new APPS password>

Verify new password for user:     <Re-Enter new APPS password>

AFPASSWD completed successfully.

[applmgr@target_appshost ~]$ sqlplus apps/****

SQL*Plus: Release 10.1.0.5.0 – Production on Sat Apr 4 14:47:09 2015

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

Connected to:

Oracle Database 11g Enterprise Edition Release 11.2.0.4.0 – 64bit Production

With the Partitioning, OLAP, Data Mining and Real Application Testing options

SQL> show user

USER is “APPS”

SQL> exit

Disconnected from Oracle Database 11g Enterprise Edition Release 11.2.0.4.0 – 64bit Production

With the Partitioning, OLAP, Data Mining and Real Application Testing options

[applmgr@target_appshost ~]$ cat AFPWD_DEV_158811.log

+—————————————————————————-+

Application Object Library – AFPASSWD

+—————————————————————————-+

Copyright (c) 1998, 2014, Oracle and/or its affiliates. All rights reserved.

+—————————————————————————-+

Current system time is 04-APR-15 14:46:50 

+—————————————————————————-+

Working…

AFPASSWD completed successfully.

+—————————————————————————-+

Current system time is 04-APR-15 14:47:02 

+—————————————————————————-+

[applmgr@target_appshost ~]$

  1. Run autoconfig with the newly changed password.

    [applmgr@target_appshost ~]$ adautocfg.sh -appspass=devapps

    iii. Start AdminServer
    [applmgr@target_appshost ~]$ $INST_TOP/admin/scripts/adadminsrvctl.sh start

  2. Change the “apps” password in WLS Datasource as follows
  3. Log in to WLS Administration Console.
  4. Click Lock & Edit in Change Center.
  5. In the Domain Structure tree, expand Services, then select Data Sources.
  6. On the “Summary of JDBC Data Sources” page, select EBSDataSource.
  7. On the “Settings for EBSDataSource” page, select the Connection Pool tab.
  8. Enter the new password in the “Password” field.
  9. Enter the new password in the “Confirm Password” field.
  10. Click Save.
  11. Click Activate Changes in Change Center.

 

  1. Update Below Profiles at Site Level

Profile Option Name Value
Java Color Scheme Red
Site Name :::::::::::: [ DEV ]  – Cloned from CRP1 on 01-April-2015 ::::::::::::
Signon Password Length 6
Signon Password Hard To Guess Yes
Signon Password No Reuse 180
Sign-On:Notification Yes
ICX:Session Timeout 30

 Check the Login and release the environment 🙂

Oracle EBS 12.2.4 Installation using VM Template from eDelivery


Installing Oracle™ E-Business Suite 12.2.4 from Oracle VM Template on ODA X4-2

  • Install Oracle VM Server
    • Install Oracle VM Manager
    • Download the EBS 12.2.4 templates
    • Import the relevant template in to VM Server– using VM Manager
    • Create a Virtual Machine from the Template
    • Start the newly created VM which is an EBS machine.
    • Confirm OS Pre-Req
    • Configure the network through the prepared scripts
    • Configure the EBS’s Database Tier through the prepared scripts
    • Configure the EBS’s Application Tier through the prepared scripts
  1. Download the EBS 12.2.4 templates

    The Oracle E-Business Suite Release 12.2.4 VM Virtual Appliances are delivered in a single media pack, “Oracle VM Virtual Appliances for Oracle E-Business Suite Release 12.2.4 Media Pack for x86 (64-bit)”. This media pack contains a series of downloadable components or packages, and each package contains one or more zip files.
    For the Production database install, you will need the following six component packages:

  • V56218-01 Oracle E-Business Suite Release 12.2.4 Production Database Tier Install X86 (64 bit) (Part 1 of 2) Linux x86-64
    • V56218-01 Oracle E-Business Suite Release 12.2.4 Production Database Tier Install X86 (64 bit) (Part 2 of 2) Linux x86-64
    • V56219-01 Oracle E-Business Suite Release 12.2.4 Production Database Tier Install X86 (64 bit) (Part 1 of 2) Linux x86-64
    • V56219-01 Oracle E-Business Suite Release 12.2.4 Production Database Tier Install X86 (64 bit) (Part 2 of 2) Linux x86-64
    • V56220-01 Oracle E-Business Suite Release 12.2.4 Production Database Tier Install X86 (64 bit) (Part 1 of 2) Linux x86-64
    • V56220-01 Oracle E-Business Suite Release 12.2.4 Production Database Tier Install X86 (64 bit) (Part 2 of 2) Linux x86-64

For the application tier install, you will need the following ten component packages:
• V59635-01 Oracle E-Business Suite Release 12.2.4 Application Tier Install X86 (64 bit) (Part 1 of 2) Linux x86-64
• V59635-01 Oracle E-Business Suite Release 12.2.4 Application Tier Install X86 (64 bit) (Part 2 of 2) Linux x86-64
• V59636-01 Oracle E-Business Suite Release 12.2.4 Application Tier Install X86 (64 bit) (Part 1 of 2) Linux x86-64
• V59636-01 Oracle E-Business Suite Release 12.2.4 Application Tier Install X86 (64 bit) (Part 2 of 2) Linux x86-64
• V59637-01 Oracle E-Business Suite Release 12.2.4 Application Tier Install X86 (64 bit) (Part 1 of 2) Linux x86-64
• V59637-01 Oracle E-Business Suite Release 12.2.4 Application Tier Install X86 (64 bit) (Part 2 of 2) Linux x86-64
• V59638-01 Oracle E-Business Suite Release 12.2.4 Application Tier Install X86 (64 bit) (Part 1 of 2) Linux x86-64
• V59638-01 Oracle E-Business Suite Release 12.2.4 Application Tier Install X86 (64 bit) (Part 2 of 2) Linux x86-64
• V59639-01 Oracle E-Business Suite Release 12.2.4 Application Tier Install X86 (64 bit) (Part 1 of 2) Linux x86-64
• V59639-01 Oracle E-Business Suite Release 12.2.4 Application Tier Install X86 (64 bit) (Part 2 of 2) Linux x86-64
For the sparse application tier install, you will need the following component package:
• V55217-01 Oracle E-Business Suite Release 12.2.4 Sparse Tier/OS Install X86 (64 bit) Linux x86-64
To download the VM Virtual Appliances for Oracle E-Business Suite Release 12.2.4:
1. On the Oracle Software Delivery Cloud (https://edelivery.oracle.com/) page, use the “Cloud Portal (Main)” drop-down menu to select “Oracle Linux/VM”.
2. Click the Sign In/Register button.
3. Read and accept the Terms and Restrictions and click the Continue button.
4. On the Media Pack Search page, select the following values:
o Select a Product Pack: Oracle VM Templates
o Platform: x86 64 bit
5. Select the “Oracle VM Virtual Appliances for Oracle E-Business Suite 12.2.4 for x86 (64-bit)” media pack from the search result table, and click the Continue button.
The packages listed above, corresponding to the 5 available Oracle E-Business Suite 12.2.4 appliances, appear.
6. Download the desired packages and thus the zip files which contain the associated appliances.
For example, download the eight component packages for “Oracle E-Business Suite Release 12.2.4 Vision Demo Database Tier Install X86 (64 bit)”.

  1. Confirm OS Pre-Req

    If not using the pre-install rpm, the following packages (or versions of packages) which are not part of the OS distribution media must be downloaded separately (from http://oss.oracle.com/projects/compat-oracle/files/Enterprise_Linux/) for both Oracle Linux 6 and RHEL 6 and installed manually on the application tier:
    • openmotif21-2.1.30-11.EL6.i686 (32-bit)1
    • xorg-x11-libs-compat-6.8.2-1.EL.33.0.1.i386 (32-bit)
    Additionally, the following rpm needs to be installed from the Oracle Linux 6 or RHEL 6 distribution media on the application tier:
    • libXrender-0.9.5-1.el6.i686
    If not using the pre-install rpm, the following packages must be installed from the Oracle Linux 6 or RHEL 6 distribution media on both the application and database tiers:
    • binutils-2.20.51.0.2-5.20.el6.x86_64
    • compat-libstdc++-296-2.96-144.el6.i686
    • compat-libstdc++-33-3.2.3-69.el6.i686
    • gcc-4.4.5-6.el6.x86_64
    • gcc-c++-4.4.5-6.el6.x86_64
    • glibc-2.12-1.7.el6.i686 (32-bit)
    • glibc-2.12-1.7.el6.x86_64
    • glibc-common-2.12-1.7.el6.x86_64
    • glibc-devel-2.12-1.7.el6.i686 (32-bit)
    • glibc-devel-2.12-1.7.el6.x86_64
    • libgcc-4.4.4-13.el6.i686
    • libgcc-4.4.4-13.el6.x86_64
    • libstdc++-devel-4.4.4-13.el6.i686
    • libstdc++-devel-4.4.4-13.el6.x86_64
    • libstdc++-4.4.4-13.el6.i686
    • libstdc++-4.4.4-13.el6.x86_64
    • libXi-1.3-3.el6.i686
    • libXp-1.0.0-15.1.el6.i686
    • libXp-1.0.0-15.1.el6.x86_64
    • libaio-0.3.107-10.el6.i686
    • libaio-0.3.107-10.el6.x86_64
    • libgomp-4.4.4-13.el6.x86_64
    • make-3.81-19.el6.x86_64
    • gdbm-1.8.0-36.el6.i686
    • gdbm-1.8.0-36.el6.x86_64
    • redhat-lsb-4.0-3.0.1.el6.x86_64
    • sysstat-9.0.4-11.el6.x86_64
    • util-linux-ng-2.17.2-6.el6.x86_64
    Additionally, the following RPMs are required for the database tier (running Oracle Database 11gR2):
    • compat-libcap1-1.10-1.x86_64
    • compat-libstdc++-33-3.2.3-69.el6.x86_64
    • elfutils-libelf-devel-0.148.1-el6.x86_64
    • libaio-devel-0.3.107-10.el6.i686
    • libaio-devel-0.3.107-10.el6.x86_64
    • unixODBC-2.2.14-11.el6.i686
    • unixODBC-devel-2.2.14-11.el6.i686
    • xorg-x11-utils-7.4-8.el6.x86_64
    Alternatively on the database tier, users can install the following pre-install rpm (available via ULN on http://linux.oracle.com or the Oracle Public yum repository on http://public-yum.oracle.com) :
    • oracle-rdbms-server-11gR2-preinstall.x86_64
    The E-Business Suite Pre-Install RPM includes all the above required rpms and dependencies for running the application and database tiers – see the ‘E-Business Suite Pre-Install RPM’ section below for more details.
    Note:
    The openmotif package version must be 2.1.30 (for example, openmotif-2.3.3-1 is not supported).
    Swap Space
    It is recommended that the swap space on the system be 16 GB or more. To determine the size of the configured swap space, enter the following command:
    # grep SwapTotal /proc/meminfo

Kernel Settings
Edit the /etc/sysctl.conf file to configure your kernel settings to the minimum values shown below. After editing the file, use the “sysctl -p” command or restart the system to invoke the new settings.
Note: If the current value for any parameter is higher than the value listed in the following table, then do not change the value of that parameter.
The following table lists the kernel settings for Oracle Linux 5 and 6, Red Hat Enterprise Linux 5 and 6, and SUSE Linux Enterprise Server 10 and 11:
Parameter Value
kernel.semmsl 2561
kernel.semmns 320001
kernel.semopm 1001
kernel.semmni 1421
kernel.shmall 20971524
kernel.shmmax Half the size of the physical memory (in bytes), and at least 42949672952
kernel.shmmni 4096
kernel.msgmax 8192
kernel.msgmnb 65535
kernel.msgmni 2878
fs.file-max 6815744
fs.aio-max-nr 1048576
net.ipv4.ip_local_port_range 9000 655003
net.ipv4.tcp_tw_recycle 05
net.core.rmem_default 262144
net.core.rmem_max 4194304
net.core.wmem_default 262144
net.core.wmem_max 1048576
set using the following entry in the /etc/sysctl.conf file
kernel.sem = 256 32000 100 142

Domain Name System (DNS) Resolver Parameters
Two Domain Name System (DNS) resolver parameters (timeout and attempts) are set by default to low values when the operating system is installed. These low values may cause network connections to an Oracle database to fail. If this happens, add or update the following entries to these minimum settings in the /etc/resolv.conf file on each server node:
options attempts:5
options timeout:15

For Oracle Linux 5 and 6, and Red Hat Enterprise Linux 5 and 6:
1. Verify that the /etc/hosts file is formatted as follows:
127.0.0.1 localhost.localdomain localhost
[ip_address] [node_name].[domain_name] [node_name]
2. Verify that the /etc/sysconfig/network file is formatted as follows:
HOSTNAME=[node_name].[domain_name]

or as follows:
HOSTNAME=[node_name]
NISDOMAIN=[domain_name]

  1. If the /etc/sysconfig/networking/profiles/default/network file exists, remove it.
    4. If you changed any files in the previous steps, restart the system.
    Modifying the Number of Open File Descriptors
    Open the /etc/security/limits.conf file and change the existing values for “hard” and “soft” parameters as follows. Restart the system after making changes.
    Note: If the current value for any parameter is higher than the value listed below, do not change the value of that parameter as the following are suggested minimum values.
    * hard nofile 65536
    * soft nofile 4096
    * hard nproc 16384
    * soft nproc 2047
    * hard stack 16384

Link to Motif library in Oracle Application Server 10.1.2 (on Oracle Linux 5, 6 and RHEL 5, 6 only)
Perform the following command (as root on your system) to update a required link to a Motif library prior to relinking or patching the 10.1.2 Application Server Oracle Home:
# unlink /usr/lib/libXtst.so.6
# ln -s /usr/X11R6/lib/libXtst.so.6.1 /usr/lib/libXtst.so.6

  1. Configure EBS Database Tier

Run script visiondbconfig.sh from /u01/install/VISION/scripts
Add your SID or Database Name (i.e.: VIS)

[root@dbhost scripts]# sh proddbconfig.sh

Pinging the Host dbhost.domain.com…
The Host dbhost.domain.com is responding
proceeding with the configuration…

==================================================
Prepare the Pairs File for Database Tier Clone…
===================================================

===========================================
ORACLE_SID is not set in the Pairs File
Enter the Oracle Database SID :CRP1

==========================================================
Starting DB Tier configuration
==========================================================
Parameters Used for this Configuration…
The Pairs File :/u01/install/PROD/scripts/inst_db_pairs.txt
The Source context file used :/u01/install/PROD/11.2.0/appsutil/clone/context/db/CTXORIG.xml
The Target context file :/u01/install/PROD/11.2.0/appsutil/CRP1_dbhost.xml
==========================================================
The Configuration Used to Create this VM…
The Oracle E-Business Suite DBSID : CRP1
The Oracle E-Business Suite DB HostName : <Enter Database Host Server Name>
The Oracle E-Business Suite DB Domain Name :<Enter Server Domain>
The Oracle E-Business Suite DB TNS Port :1521
==========================================================
/u01/install/PROD/11.2.0/oui/bin/detachHome.sh: line 5: cd: /u01/install/VISION/db/tech_st/11.2.0/oui/bin: No such file or directory
/u01/install/PROD/11.2.0/oui/bin/detachHome.sh: line 6: ./runInstaller: No such file or directory

==========================================================
Cloning the DB Tier Context File
==========================================================

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

Oracle E-Business Suite Rapid Clone

Version 12.2

adclonectx Version 120.30.12020000.8

Running:
/u01/install/PROD/11.2.0/appsutil/clone/bin/../jre/bin/java -Xmx600M -classpath /u01/install/PROD/11.2.0/appsutil/clone/bin/../jlib/ojdbc5.jar:/u01/install/PROD/11.2.0/appsutil/clone/bin/../jlib/xmlparserv2.jar:/u01/install/PROD/11.2.0/appsutil/clone/bin/../jlib/java oracle.apps.ad.context.CloneContext -e /u01/install/PROD/11.2.0/appsutil/clone/context/db/CTXORIG.xml -pairsfile /u01/install/PROD/scripts/inst_db_pairs.txt -out /u01/install/PROD/11.2.0/appsutil/CRP1_dbhost.xml -noprompt

Log file located at /u01/install/PROD/11.2.0/appsutil/log/CloneContext_0319065452.log
Report file located at /u01/install/PROD/11.2.0/appsutil/temp/portpool.lst
Complete port information available at /u01/install/PROD/11.2.0/appsutil/temp/portpool.lst

Creating the new Database Context file from :
/u01/install/PROD/11.2.0/appsutil/clone/context/db/adxdbctx.tmp

The new database context file has been created :
/u01/install/PROD/11.2.0/appsutil/CRP1_dbhost.xml

Log file located at /u01/install/PROD/11.2.0/appsutil/log/CloneContext_0319065452.log
contextfile=/u01/install/PROD/11.2.0/appsutil/CRP1_dbhost.xml
Check Clone Context logfile /u01/install/PROD/11.2.0/appsutil/log/CloneContext_0319065452.log for details.

Executing adcfgclone.pl on the Database Tier
Copyright (c) 2011 Oracle Corporation
Redwood Shores, California, USA

Oracle E-Business Suite Rapid Clone

Version 12.2

adcfgclone Version 120.63.12020000.35
stty: standard input: Inappropriate ioctl for device

Enter the APPS password :
stty: standard input: Inappropriate ioctl for device

Running Rapid Clone with command:
Running:
perl /u01/install/PROD/11.2.0/appsutil/clone/bin/adclone.pl java=/u01/install/PROD/11.2.0/appsutil/clone/bin/../jre mode=apply stage=/u01/install/PROD/11.2.0/appsutil/clone component=dbTier method=CUSTOM dbctxtg=/u01/install/PROD/11.2.0/appsutil/CRP1_dbhost.xml showProgress contextValidated=false

Beginning database tier Apply – Thu Mar 19 06:54:54 2015

/u01/install/PROD/11.2.0/appsutil/clone/bin/../jre/bin/java -Xmx600M -DCONTEXT_VALIDATED=false -Doracle.installer.oui_loc=/u01/install/PROD/11.2.0/oui -classpath /u01/install/PROD/11.2.0/appsutil/clone/jlib/xmlparserv2.jar:/u01/install/PROD/11.2.0/appsutil/clone/jlib/ojdbc6.jar:/u01/install/PROD/11.2.0/appsutil/clone/jlib/java:/u01/install/PROD/11.2.0
/appsutil/clone/jlib/oui/OraInstaller.jar:/u01/install/PROD/11.2.0/appsutil/clone/jlib/oui/ewt3.jar:/u01/install/PROD/11.2.0/appsutil/clone/jlib/oui/share.jar:/u01/install/PROD/11.2.0/appsutil/

clone/jlib/oui/srvm.jar:/u01/install/PROD/11.2.0/appsutil/clone/jlib/ojmisc.jar oracle.apps.ad.clone.ApplyDBTier -e /u01/install/PROD/11.2.0/appsutil/CRP1_dbhost.xml -stage /u01/install/PROD/11.2.0/appsutil/clone -showProgress
APPS Password : Log file located at /u01/install/PROD/11.2.0/appsutil/log/CRP1_dbhost/ApplyDBTier_03190654.log
| 0% completed
Log file located at /u01/install/PROD/11.2.0/appsutil/log/CRP1_dbhost/ApplyDBTier_03190654.log
Determining Source system database type (“single” or “rac”).
Source system indentified as being of type “single”!
\ 15% completed

Completed Apply…
Thu Mar 19 07:02:52 2015

Starting database listener for CRP1:
Running:
/u01/install/PROD/11.2.0/appsutil/scripts/CRP1_dbhost/addlnctl.sh start CRP1
Logfile: /u01/install/PROD/11.2.0/appsutil/log/CRP1_dbhost/addlnctl.txt

You are running addlnctl.sh version 120.4

Starting listener process CRP1 …

Listener CRP1 has already been started.

addlnctl.sh: exiting with status 0

addlnctl.sh: check the logfile /u01/install/PROD/11.2.0/appsutil/log/CRP1_dbhost/addlnctl.txt for more information …

Do you want to change the password for all EBS Schemas? (y/n) [n]) :
Do you want to change the apps password? (y/n) [n]) :
Do you want to change the sys and system passwords? (y/n) [n]) :

Cloning the DB Tier Completed SuccessfullyLogfile: /u01/install/PROD/11.2.0/appsutil/log/CRP1_dbhost/addlnctl.txt

You are running addlnctl.sh version 120.4

Shutting down listener process CRP1 …

LSNRCTL for Linux: Version 11.2.0.4.0 – Production on 19-MAR-2015 07:02:53

Copyright (c) 1991, 2013, Oracle. All rights reserved.

Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=dbhost.domain.com)(PORT=1521)))
The command completed successfully

addlnctl.sh: exiting with status 0

addlnctl.sh: check the logfile /u01/install/PROD/11.2.0/appsutil/log/CRP1_dbhost/addlnctl.txt for more information …

You are running addbctl.sh version 120.1

Shutting down database CRP1 …

SQL*Plus: Release 11.2.0.4.0 Production on Thu Mar 19 07:02:53 2015

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

Connected.
Database closed.
Database dismounted.
ORACLE instance shut down.
Disconnected from Oracle Database 11g Enterprise Edition Release 11.2.0.4.0 – 64bit Production
With the Partitioning, OLAP, Data Mining and Real Application Testing options

addbctl.sh: exiting with status 0

========================================================== Enabling the DB Service Startup on Boot ==========================================================

==========================================================
Starting the Oracle E-Business Suite DB Tier Services
==========================================================
Logfile: /u01/install/PROD/11.2.0/appsutil/log/CRP1_dbhost/addlnctl.txt

You are running addlnctl.sh version 120.4

Starting listener process CRP1 …

LSNRCTL for Linux: Version 11.2.0.4.0 – Production on 19-MAR-2015 07:03:32

Copyright (c) 1991, 2013, Oracle. All rights reserved.

Starting /u01/install/PROD/11.2.0/bin/tnslsnr: please wait…

TNSLSNR for Linux: Version 11.2.0.4.0 – Production
System parameter file is /u01/install/PROD/11.2.0/network/admin/CRP1_dbhost/listener.ora
Log messages written to /u01/install/PROD/11.2.0/admin/CRP1_dbhost/diag/tnslsnr/dbhost/crp1/alert/log.xml
Listening on: (DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=dbhost.domain.com)(PORT=1521)))

Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=dbhost.domain.com)(PORT=1521)))
STATUS of the LISTENER
————————
Alias CRP1
Version TNSLSNR for Linux: Version 11.2.0.4.0 – Production
Start Date 19-MAR-2015 07:03:32
Uptime 0 days 0 hr. 0 min. 0 sec
Trace Level off
Security ON: Local OS Authentication
SNMP OFF
Listener Parameter File /u01/install/PROD/11.2.0/network/admin/CRP1_dbhost/listener.ora
Listener Log File /u01/install/PROD/11.2.0/admin/CRP1_dbhost/diag/tnslsnr/dbhost/crp1/alert/log.xml
Listening Endpoints Summary…
(DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=dbhost.domain.com)(PORT=1521)))
Services Summary…
Service “CRP1” has 1 instance(s).
Instance “CRP1”, status UNKNOWN, has 1 handler(s) for this service…
The command completed successfully

addlnctl.sh: exiting with status 0

addlnctl.sh: check the logfile /u01/install/PROD/11.2.0/appsutil/log/CRP1_dbhost/addlnctl.txt for more information …

You are running addbctl.sh version 120.1

Starting the database CRP1 …

SQL*Plus: Release 11.2.0.4.0 Production on Thu Mar 19 07:03:32 2015

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

Connected to an idle instance.
ORACLE instance started.

Total System Global Area 2137886720 bytes
Fixed Size 2254952 bytes
Variable Size 486541208 bytes
Database Buffers 1627389952 bytes
Redo Buffers 21700608 bytes
Database mounted.
Database opened.
Disconnected from Oracle Database 11g Enterprise Edition Release 11.2.0.4.0 – 64bit Production
With the Partitioning, OLAP, Data Mining and Real Application Testing options

addbctl.sh: exiting with status 0

=====================INSTALLATION SUMMARY============

The Oracle E-Business Suite DB HostName : dbhost.domain.com
The Base Installation Directory : /u01/install/PROD
The Oracle Home Location : /u01/install/PROD/11.2.0
The Oracle E-Business Suite Data File Dir: /u01/install/PROD/data
The Oracle E-Business Suite DBSID : CRP1
The Oracle E-Business Suite DB TNS Port : 1521
==========================================================
[root@dbhost scripts]#

 

  1. Configure EBS Application Tier

    Run script appsconfig.sh from /u01/install/APPS/scripts

[root@appshost scripts]# pwd
/u01/install/APPS/scripts
[root@appshost scripts]# ls
appscleanup.sh appsconfig.sh appspairs.txt apps.rc inst_apps_pairs.txt startapps.sh stopapps.sh
[root@appshost scripts]# hostname
appshost.domain.com
[root@appshost scripts]# sh appsconfig.sh
===================ATTENTION====================================
Successful Configuration of this Virtual Machine requires
connectivity to the E-Business Suite Database Tier
Please Ensure that this host can connect to the DB Tier before
proceeding with the configuration. The sqlnet.ora file on the
Database Tier need to contain the hostname you are going
to use for this Virtual Machine.
============================================================
Press any key to continue…

=======================================
Configuring Oracle E-Business Suite…

==================================================
Prepare the Pairs File for Application Tier Clone…
===================================================

Pinging the Host appshost.domain.com…
The Host appshost.domain.com is responding
proceeding with the configuration…

==================================================
Checking if the FQDN is > 30 chars…
===================================================

The FQDN is less than 30 characters. Proceeding with the configuration
Database Tier Information is not set in the Pairs File
Prompting the user for Database Tier Information

Enter the IP Address of the DB Tier Host:**.**.**.**

Enter the Database Tier Host Name (without the domain) :dbhost

Enter the Database Tier Domain Name :domain.com

Enter the Oracle Database SID :CRP1

Enter the TNS Listener Port Number :1521

Updating /etc/hosts file with DB Tier Information

==========================================================
Starting Apps Tier configuration
==========================================================
Parameters Used for this Configuration…
The Pairs File :/u01/install/APPS/scripts/inst_apps_pairs.txt
The Source context file used :/u01/install/APPS/fs1/EBSapps/comn/clone/context/apps/CTXORIG.xml
The Target context file :/u01/install/APPS/fs1/inst/apps/CRP1_appshost/appl/admin/CRP1_appshost.xml

==========================================================
Checking for the DB Host and Database
==========================================================

Pinging the Database Host dbhost.domain.com…

The Database Host dbhost.domain.com seem to be up
Proceeding with rest of the configuration…

Connected to Database CRP1 on dbhost…

==========================================================
Configuring the VM as a new Application Tier Node
==========================================================

==========================================================
Configuring the Application Tier File System (fs1)
==========================================================

==========================================================
Cloning the Application Tier Context File
==========================================================

Executing the command su applmgr -c echo apps|./adclonectx.pl contextfile=/u01/install/APPS/fs1/EBSapps/comn/clone/context/apps/CTXORIG.xml pairsfile=/u01/install/APPS/scripts/inst_apps_pairs.txt outfile=/u01/install/APPS/fs1/inst/apps/CRP1_appshost/appl/admin/CRP1_appshost.xml nopromptmsg
Copyright (c) 2011 Oracle Corporation
Redwood Shores, California, USA

Oracle E-Business Suite Rapid Clone

Version 12.2

adclonectx Version 120.30.12020000.10

Running:
/u01/install/APPS/fs1/EBSapps/comn/clone/bin/../jre/bin/java -Xmx600M -classpath /u01/install/APPS/fs1/EBSapps/comn/clone/bin/../jlib/ojdbc6.jar:/u01/install/APPS/fs1/EBSapps/comn/clone/bin/../jlib/xmlparserv2.jar:/u01/install/APPS/fs1/EBSapps/comn/clone/bin/../jlib/java oracle.apps.ad.context.CloneContext -e /u01/install/APPS/fs1/EBSapps/comn/clone/context/apps/CTXORIG.xml -pairsfile /u01/install/APPS/scripts/inst_apps_pairs.txt -out /u01/install/APPS/fs1/inst/apps/CRP1_appshost/appl/admin/CRP1_appshost.xml -noprompt

Log file located at /u01/install/APPS/fs1/inst/apps/CRP1_appshost/appl/admin/log/CloneContext_0319064602.log

Target System Base Directory set to /u01/install/APPS

Target System Current File System Base set to /u01/install/APPS/fs1

Target System Other File System Base set to /u01/install/APPS/fs2

Target System Fusion Middleware Home set to /u01/install/APPS/fs1/FMW_Home

Target System Web Oracle Home set to /u01/install/APPS/fs1/FMW_Home/webtier

Target System Appl TOP set to /u01/install/APPS/fs1/EBSapps/appl

Target System COMMON TOP set to /u01/install/APPS/fs1/EBSapps/comn

Target System Instance Top set to /u01/install/APPS/fs1/inst/apps/CRP1_appshost
Report file located at /u01/install/APPS/fs1/inst/apps/CRP1_appshost/admin/out/portpool.lst
Complete port information available at /u01/install/APPS/fs1/inst/apps/CRP1_appshost/admin/out/portpool.lst

Creating the new APPL_TOP Context file from :
/u01/install/APPS/fs1/EBSapps/comn/clone/context/apps/adxmlctx.tmp

The new APPL_TOP context file has been created :
/u01/install/APPS/fs1/inst/apps/CRP1_appshost/appl/admin/CRP1_appshost.xml

Log file located at /u01/install/APPS/fs1/inst/apps/CRP1_appshost/appl/admin/log/CloneContext_0319064602.log
contextfile=/u01/install/APPS/fs1/inst/apps/CRP1_appshost/appl/admin/CRP1_appshost.xml
Check Clone Context logfile /u01/install/APPS/fs1/inst/apps/CRP1_appshost/appl/admin/log/CloneContext_0319064602.log for details.

Executing the command perl adcfgclone.pl appsTier /u01/install/APPS/fs1/inst/apps/CRP1_appshost/appl/admin/CRP1_appshost.xml
Copyright (c) 2011 Oracle Corporation
Redwood Shores, California, USA

Oracle E-Business Suite Rapid Clone

Version 12.2

adcfgclone Version 120.63.12020000.37
stty: standard input: Inappropriate ioctl for device

Enter the APPS password :
stty: standard input: Inappropriate ioctl for device
Running:
/u01/install/APPS/fs1/EBSapps/comn/clone/bin/../jre/bin/java -Xmx600M -classpath /u01/install/APPS/fs1/EBSapps/comn/clone/jlib/obfuscatepassword.jar:/u01/install/APPS/fs1/EBSapps/comn/clone/jlib/ojmisc.jar:/u01/install/APPS/fs1/EBSapps/comn/clone/jlib/java:
/u01/install/APPS/fs1/EBSapps/comn/clone/jlib/emCfg.jar oracle.apps.ad.clone.util.OPWrapper -encryptpwd /u01/install/APPS/fs1/EBSapps/comn/clone/bin/../FMW/tempinfoApps.txt

stty: standard input: Inappropriate ioctl for device

Enter the Weblogic AdminServer password :
stty: standard input: Inappropriate ioctl for device
Running:
/u01/install/APPS/fs1/EBSapps/comn/clone/bin/../jre/bin/java -Xmx600M -classpath /u01/install/APPS/fs1/EBSapps/comn/clone/jlib/obfuscatepassword.jar:/u01/install/APPS/fs1/EBSapps/comn/clone/jlib/ojmisc.jar:/u01/install/APPS/fs1/EBSapps/comn/clone/jlib/java:
/u01/install/APPS/fs1/EBSapps/comn/clone/jlib/emCfg.jar oracle.apps.ad.clone.util.OPWrapper /u01/install/APPS/fs1/EBSapps/comn/clone/bin/../FMW/tempinfo.txt
Running:
/u01/install/APPS/fs1/EBSapps/comn/clone/bin/../jre/bin/java -Xmx600M -classpath /u01/install/APPS/fs1/EBSapps/comn/clone/jlib/obfuscatepassword.jar:/u01/install/APPS/fs1/EBSapps/comn/clone/jlib/ojmisc.jar:/u01/install/APPS/fs1/EBSapps/comn/clone/jlib/java:
/u01/install/APPS/fs1/EBSapps/comn/clone/jlib/emCfg.jar oracle.apps.ad.clone.util.OPWrapper /u01/install/APPS/fs1/EBSapps/comn/clone/bin/../FMW/EBSDataSource

Running Rapid Clone with command:
Running:
perl /u01/install/APPS/fs1/EBSapps/comn/clone/bin/adclone.pl java=/u01/install/APPS/fs1/EBSapps/comn/clone/bin/../jre mode=apply
stage=/u01/install/APPS/fs1/EBSapps/comn/clone component=appsTier method=CUSTOM appctxtg=/u01/install/APPS/fs1/inst/apps/CRP1_appshost/appl/admin/CRP1_appshost.xml showProgress contextValidated=false

FMW Pre-requisite check log file location : /u01/install/APPS/fs1/EBSapps/comn/clone/FMW/logs/prereqcheck.log

Running: /u01/install/APPS/fs1/EBSapps/comn/clone/FMW/t2pjdk/bin/java -classpath /u01/install/APPS/fs1/EBSapps/comn/clone/prereq/webtier/Scripts/ext/jlib/engine.jar:/u01/install/APPS/fs1/EBSapps/comn/clone/prereq/webtier/oui/jlib/OraPrereq.jar:
/u01/install/APPS/fs1/EBSapps/comn/clone/prereq/webtier/oui/jlib/OraPrereqChecks.jar:/u01/install/APPS/fs1/EBSapps/comn/clone/prereq/webtier/oui/jlib/OraInstaller.jar:
/u01/install/APPS/fs1/EBSapps/comn/clone/prereq/webtier/oui/jlib/OraInstallerNet.jar:/u01/install/APPS/fs1/EBSapps/comn/clone/prereq/webtier/oui/jlib/srvm.jar:
/u01/install/APPS/fs1/EBSapps/comn/clone/prereq/webtier/Scripts/ext/jlib/ojdl.jar:/u01/install/APPS/fs1/EBSapps/comn/clone/prereq/webtier/Scripts/ext/jlib/ojdl2.jar:
/u01/install/APPS/fs1/EBSapps/comn/clone/prereq/webtier/Scripts/ext/jlib/ojdl-log4j.jar:/u01/install/APPS/fs1/EBSapps/comn/clone/prereq/webtier/oui/jlib/xmlparserv2.jar:/u01/install/APPS/fs1/EBSapps/comn/clone/prereq/webtier/oui/jlib/share.jar:
/u01/install/APPS/fs1/EBSapps/comn/clone/jlib/java oracle.apps.ad.clone.util.FMWOracleHomePreReqCheck -prereqCheckFMW -e /u01/install/APPS/fs1/inst/apps/CRP1_appshost/appl/admin/CRP1_appshost.xml -stage /u01/install/APPS/fs1/EBSapps/comn/clone -log /u01/install/APPS/fs1/EBSapps/comn/clone/FMW/logs/prereqcheck.log

Beginning application tier Apply – Thu Mar 19 06:46:11 2015

/u01/install/APPS/fs1/EBSapps/comn/clone/bin/../jre/bin/java -Xmx600M -DCONTEXT_VALIDATED=false -Doracle.installer.oui_loc=/oui -classpath /u01/install/APPS/fs1/EBSapps/comn/clone/jlib/xmlparserv2.jar:/u01/install/APPS/fs1/EBSapps/comn/clone/jlib/ojdbc6.jar:/u01/install/APPS/fs1/EBSapps/comn/clone/jlib/java:
/u01/install/APPS/fs1/EBSapps/comn/clone/jlib/oui/OraInstaller.jar:/u01/install/APPS/fs1/EBSapps/comn/clone/jlib/oui/ewt3.jar:/u01/install/APPS/fs1/EBSapps/comn/
clone/jlib/oui/share.jar:/u01/install/APPS/fs1/FMW_Home/webtier/../Oracle_EBS-app1/oui/jlib/srvm.jar:/u01/install/APPS/fs1/EBSapps/comn/clone/jlib/ojmisc.jar:/u01/install/APPS/fs1/FMW_Home/wlserver_10.3/server/lib/weblogic.jar:
/u01/install/APPS/fs1/EBSapps/comn/clone/jlib/obfuscatepassword.jar oracle.apps.ad.clone.ApplyAppsTier -e /u01/install/APPS/fs1/inst/apps/CRP1_appshost/appl/admin/CRP1_appshost.xml -stage /u01/install/APPS/fs1/EBSapps/comn/clone -showProgress -nopromptmsg
Log file located at /u01/install/APPS/fs1/inst/apps/CRP1_appshost/admin/log/clone/ApplyAppsTier_03190646.log
| 0% completed
Log file located at /u01/install/APPS/fs1/inst/apps/CRP1_appshost/admin/log/clone/ApplyAppsTier_03190646.log
/ 100% completed

Completed Apply…
Thu Mar 19 07:05:06 2015

Executing command: /u01/install/APPS/fs1/EBSapps/10.1.2/bin/sqlplus @/u01/install/APPS/fs1/EBSapps/appl/ad/12.0.0/patch/115/sql/truncate_ad_nodes_config_status.sql

Do you want to startup the Application Services for CRP1? (y/n) [n] :
Services not started

==========================================================
Configuring the Application Tier File System (fs2) appsconfig.sh: line 373: print: command not found

Copying the Application Tier File System from fs1 to fs2

/u01/install/APPS/fs2/FMW_Home exists. Proceeding to detach and remove the Home
Starting Oracle Universal Installer…

Checking swap space: must be greater than 500 MB. Actual 10239 MB Passed
The inventory pointer is located at /etc/oraInst.loc
The inventory is located at /u01/install/oraInventory
‘DetachHome’ was successful.
Starting Oracle Universal Installer…

Checking swap space: must be greater than 500 MB. Actual 10239 MB Passed
The inventory pointer is located at /etc/oraInst.loc
The inventory is located at /u01/install/oraInventory
‘DetachHome’ was successful.
Starting Oracle Universal Installer…

Checking swap space: must be greater than 500 MB. Actual 10239 MB Passed
The inventory pointer is located at /etc/oraInst.loc
The inventory is located at /u01/install/oraInventory
‘DetachHome’ was successful.

Executing the command su applmgr -c perl adcfgclone.pl appsTier
Copyright (c) 2011 Oracle Corporation
Redwood Shores, California, USA

Oracle E-Business Suite Rapid Clone

Version 12.2

adcfgclone Version 120.63.12020000.37
stty: standard input: Inappropriate ioctl for device

Enter the APPS password :
stty: standard input: Inappropriate ioctl for device
Running:
/u01/install/APPS/fs2/EBSapps/comn/clone/bin/../jre/bin/java -Xmx600M -classpath /u01/install/APPS/fs2/EBSapps/comn/clone/jlib/obfuscatepassword.jar:/u01/install/APPS/fs2/EBSapps/comn/clone/jlib/ojmisc.jar:/u01/install/APPS/fs2/EBSapps/comn/clone/jlib/java:
/u01/install/APPS/fs2/EBSapps/comn/clone/jlib/emCfg.jar oracle.apps.ad.clone.util.OPWrapper -encryptpwd /u01/install/APPS/fs2/EBSapps/comn/clone/bin/../FMW/tempinfoApps.txt
stty: standard input: Inappropriate ioctl for device

Enter the Weblogic AdminServer password :
stty: standard input: Inappropriate ioctl for device
Running:
/u01/install/APPS/fs2/EBSapps/comn/clone/bin/../jre/bin/java -Xmx600M -classpath /u01/install/APPS/fs2/EBSapps/comn/clone/jlib/obfuscatepassword.jar:/u01/install/APPS/fs2/EBSapps/comn/clone/jlib/ojmisc.jar:/u01/install/APPS/fs2/EBSapps/comn/
clone/jlib/java:/u01/install/APPS/fs2/EBSapps/comn/clone/jlib/emCfg.jar oracle.apps.ad.clone.util.OPWrapper /u01/install/APPS/fs2/EBSapps/comn/clone/bin/../FMW/tempinfo.txt
Running:
/u01/install/APPS/fs2/EBSapps/comn/clone/bin/../jre/bin/java -Xmx600M -classpath /u01/install/APPS/fs2/EBSapps/comn/clone/jlib/obfuscatepassword.jar:/u01/install/APPS/fs2/EBSapps/comn/clone/jlib/ojmisc.jar:/u01/install/APPS/fs2/EBSapps/comn/
clone/jlib/java:/u01/install/APPS/fs2/EBSapps/comn/clone/jlib/emCfg.jar oracle.apps.ad.clone.util.OPWrapper /u01/install/APPS/fs2/EBSapps/comn/clone/bin/../FMW/EBSDataSource

Do you want to add a node (yes/no) [no] :

Running:
/u01/install/APPS/fs2/EBSapps/comn/clone/bin/../jre/bin/java -Xmx600M -cp /u01/install/APPS/fs2/EBSapps/comn/clone/jlib/java:/u01/install/APPS/fs2/EBSapps/comn/clone/jlib/xmlparserv2.jar:/u01/install/APPS/fs2/EBSapps/comn/clone/jlib/ojdbc6.jar:
/u01/install/APPS/fs2/EBSapps/comn/clone/jlib/obfuscatepassword.jar:/u01/install/APPS/fs2/EBSapps/comn/clone/jlib/ojmisc.jar:/u01/install/APPS/fs2/EBSapps/comn/clone/jlib/java:
/u01/install/APPS/fs2/EBSapps/comn/clone/jlib/emCfg.jar oracle.apps.ad.context.CloneContext
-e /u01/install/APPS/fs2/EBSapps/comn/clone/bin/../context/apps/CTXORIG.xml -validate -pairsfile /tmp/adpairsfile_15345.lst
-stage /u01/install/APPS/fs2/EBSapps/comn/clone 2> /tmp/adcfgclone_15345.err; echo $? > /tmp/adcfgclone_15345.res

Log file located at /u01/install/APPS/fs2/EBSapps/comn/clone/bin/CloneContext_0319070637.log

Target System File Edition type [patch] :
Enter the full path of Run File System Context file :
Provide the values required for creation of the new APPL_TOP Context file.

Target System Fusion Middleware Home set to /u01/install/APPS/fs2/FMW_Home

Target System Web Oracle Home set to /u01/install/APPS/fs2/FMW_Home/webtier

Target System Appl TOP set to /u01/install/APPS/fs2/EBSapps/appl

Target System COMMON TOP set to /u01/install/APPS/fs2/EBSapps/comn

Target System Instance Top set to /u01/install/APPS/fs2/inst/apps/CRP1_appshost

Target System Port Pool [0-99] :
Checking the port pool 1
done: Port Pool 1 is free
Report file located at /u01/install/APPS/fs2/inst/apps/CRP1_appshost/admin/out/portpool.lst
Complete port information available at /u01/install/APPS/fs2/inst/apps/CRP1_appshost/admin/out/portpool.lst

UTL_FILE_DIR on database tier consists of the following directories.

  1. /usr/tmp
    2. /usr/tmp
    3. /u01/install/PROD/11.2.0/appsutil/outbound/CRP1_dbhost
    4. /usr/tmp
    Choose a value which will be set as APPLPTMP value on the target node [1] : RC-00208: Error: Not a valid number

UTL_FILE_DIR on database tier consists of the following directories.

  1. /usr/tmp
    2. /usr/tmp
    3. /u01/install/PROD/11.2.0/appsutil/outbound/CRP1_dbhost
    4. /usr/tmp
    Choose a value which will be set as APPLPTMP value on the target node [1] : RC-00200: Error: Exception occurred while taking input from user

Creating the new APPL_TOP Context file from :
/u01/install/APPS/fs2/EBSapps/comn/clone/context/apps/adxmlctx.tmp

The new APPL_TOP context file has been created :
/u01/install/APPS/fs2/inst/apps/CRP1_appshost/appl/admin/CRP1_appshost.xml

Log file located at /u01/install/APPS/fs2/EBSapps/comn/clone/bin/CloneContext_0319070637.log
Check Clone Context logfile /u01/install/APPS/fs2/EBSapps/comn/clone/bin/CloneContext_0319070637.log for details.

Running Rapid Clone with command:
Running:
perl /u01/install/APPS/fs2/EBSapps/comn/clone/bin/adclone.pl java=/u01/install/APPS/fs2/EBSapps/comn/clone/bin/../jre mode=apply
stage=/u01/install/APPS/fs2/EBSapps/comn/clone component=appsTier method=CUSTOM appctxtg=/u01/install/APPS/fs2/inst/apps/CRP1_appshost/appl/admin/CRP1_appshost.xml showProgress contextValidated=true

FMW Pre-requisite check log file location : /u01/install/APPS/fs2/EBSapps/comn/clone/FMW/logs/prereqcheck.log

Running: /u01/install/APPS/fs2/EBSapps/comn/clone/FMW/t2pjdk/bin/java -classpath /u01/install/APPS/fs2/EBSapps/comn/clone/prereq/webtier/Scripts/ext/jlib/engine.jar:/u01/install/APPS/fs2/EBSapps/comn/clone/prereq/webtier/oui/jlib/OraPrereq.jar:
/u01/install/APPS/fs2/EBSapps/comn/clone/prereq/webtier/oui/jlib/OraPrereqChecks.jar:/u01/install/APPS/fs2/EBSapps/comn/clone/prereq/webtier/oui/jlib/OraInstaller.jar:
/u01/install/APPS/fs2/EBSapps/comn/clone/prereq/webtier/oui/jlib/OraInstallerNet.jar:/u01/install/APPS/fs2/EBSapps/comn/clone/prereq/webtier/oui/jlib/srvm.jar:
/u01/install/APPS/fs2/EBSapps/comn/clone/prereq/webtier/Scripts/ext/jlib/ojdl.jar:/u01/install/APPS/fs2/EBSapps/comn/clone/prereq/webtier/Scripts/ext/jlib/ojdl2.jar:
/u01/install/APPS/fs2/EBSapps/comn/clone/prereq/webtier/Scripts/ext/jlib/ojdl-log4j.jar:/u01/install/APPS/fs2/EBSapps/comn/clone/prereq/webtier/oui/jlib/xmlparserv2.jar:/u01/install/APPS/fs2/EBSapps/comn/clone/prereq/webtier/oui/jlib/share.jar:
/u01/install/APPS/fs2/EBSapps/comn/clone/jlib/java oracle.apps.ad.clone.util.FMWOracleHomePreReqCheck -prereqCheckFMW -e /u01/install/APPS/fs2/inst/apps/CRP1_appshost/appl/admin/CRP1_appshost.xml -stage /u01/install/APPS/fs2/EBSapps/comn/clone -log /u01/install/APPS/fs2/EBSapps/comn/clone/FMW/logs/prereqcheck.log

Beginning application tier Apply – Thu Mar 19 07:06:48 2015

/u01/install/APPS/fs2/EBSapps/comn/clone/bin/../jre/bin/java -Xmx600M -DCONTEXT_VALIDATED=true -Doracle.installer.oui_loc=/oui -classpath /u01/install/APPS/fs2/EBSapps/comn/clone/jlib/xmlparserv2.jar:/u01/install/APPS/fs2/EBSapps/comn/clone/jlib/ojdbc6.jar:/u01/install/APPS/fs2/EBSapps/comn/clone/jlib/java:
/u01/install/APPS/fs2/EBSapps/comn/clone/jlib/oui/OraInstaller.jar:/u01/install/APPS/fs2/EBSapps/comn/clone/jlib/oui/ewt3.jar:
/u01/install/APPS/fs2/EBSapps/comn/clone/jlib/oui/share.jar:/u01/install/APPS/fs2/FMW_Home/webtier/../Oracle_EBS-app1/oui/jlib/srvm.jar:/u01/install/APPS/fs2/EBSapps/comn/clone/jlib/ojmisc.jar:/u01/install/APPS/fs2/FMW_Home/wlserver_10.3/server/lib/weblogic.jar:
/u01/install/APPS/fs2/EBSapps/comn/clone/jlib/obfuscatepassword.jar oracle.apps.ad.clone.ApplyAppsTier -e /u01/install/APPS/fs2/inst/apps/CRP1_appshost/appl/admin/CRP1_appshost.xml -stage /u01/install/APPS/fs2/EBSapps/comn/clone -showProgress -nopromptmsg
Log file located at /u01/install/APPS/fs2/inst/apps/CRP1_appshost/admin/log/clone/ApplyAppsTier_03190706.log
/ 100% completed

Completed Apply…
Thu Mar 19 07:25:07 2015

Looking for incomplete CLONE record in ad_adop_session_patches table

The CLONE record status is no rows selected

==========================================================
Enabling the Apps Tier Service Startup on Boot
==========================================================

==========================================================
Starting the Oracle E-Business Suite Application tier Services
==========================================================
Starting the Oracle E-Business Suite Application Tier Services
You are running adstrtal.sh version 120.24.12020000.10

The logfile for this session is located at /u01/install/APPS/fs1/inst/apps/CRP1_appshost/logs/appl/admin/log/adstrtal.log

Executing service control script:
/u01/install/APPS/fs1/inst/apps/CRP1_appshost/admin/scripts/jtffmctl.sh start
Timeout specified in context file: 100 second(s)

script returned:
dbhostdbhostdbhostdbhostdbhostdbhostdbhostdbhostdbhostdbhostdbhostdbhostdbhost

You are running jtffmctl.sh version 120.3.12020000.4

Validating Fulfillment patch level via /u01/install/APPS/fs1/EBSapps/comn/java/classes
Fulfillment patch level validated.
Starting Fulfillment Server for CRP1 on port 9300 …

jtffmctl.sh: exiting with status 0

.end std out.

.end err out.

dbhostdbhostdbhostdbhostdbhostdbhostdbhostdbhostdbhostdbhostdbhostdbhostdbhost

Executing service control script:
/u01/install/APPS/fs1/inst/apps/CRP1_appshost/admin/scripts/adopmnctl.sh start
Timeout specified in context file: 100 second(s)

script returned:
dbhostdbhostdbhostdbhostdbhostdbhostdbhostdbhostdbhostdbhostdbhostdbhostdbhost

You are running adopmnctl.sh version 120.0.12020000.2

Starting Oracle Process Manager (OPMN) …

adopmnctl.sh: exiting with status 0

adopmnctl.sh: check the logfile /u01/install/APPS/fs1/inst/apps/CRP1_appshost/logs/appl/admin/log/adopmnctl.txt for more information …

.end std out.

.end err out.

dbhostdbhostdbhostdbhostdbhostdbhostdbhostdbhostdbhostdbhostdbhostdbhostdbhost

Executing service control script:
/u01/install/APPS/fs1/inst/apps/CRP1_appshost/admin/scripts/adapcctl.sh start
Timeout specified in context file: 100 second(s)

script returned:
dbhostdbhostdbhostdbhostdbhostdbhostdbhostdbhostdbhostdbhostdbhostdbhostdbhost

You are running adapcctl.sh version 120.0.12020000.6

Starting OPMN managed Oracle HTTP Server (OHS) instance …

adapcctl.sh: exiting with status 0

adapcctl.sh: check the logfile /u01/install/APPS/fs1/inst/apps/CRP1_appshost/logs/appl/admin/log/adapcctl.txt for more information …

.end std out.

.end err out.

dbhostdbhostdbhostdbhostdbhostdbhostdbhostdbhostdbhostdbhostdbhostdbhostdbhost

Executing service control script:
/u01/install/APPS/fs1/inst/apps/CRP1_appshost/admin/scripts/adnodemgrctl.sh start -nopromptmsg
Timeout specified in context file: -1 second(s)

script returned:
dbhostdbhostdbhostdbhostdbhostdbhostdbhostdbhostdbhostdbhostdbhostdbhostdbhost

You are running adnodemgrctl.sh version 120.11.12020000.11

Calling txkChkEBSDependecies.pl to perform dependency checks for ALL MANAGED SERVERS
Perl script txkChkEBSDependecies.pl got executed successfully

Starting the Node Manager…
Refer /u01/install/APPS/fs1/inst/apps/CRP1_appshost/logs/appl/admin/log/adnodemgrctl.txt for details

adnodemgrctl.sh: exiting with status 0

adnodemgrctl.sh: check the logfile /u01/install/APPS/fs1/inst/apps/CRP1_appshost/logs/appl/admin/log/adnodemgrctl.txt for more information …

.end std out.
*** ALL THE FOLLOWING FILES ARE REQUIRED FOR RESOLVING RUNTIME ERRORS
*** Log File = /u01/install/APPS/fs1/inst/apps/CRP1_appshost/logs/appl/rgf/TXK/txkChkEBSDependecies_Thu_Mar_19_07_25_16_2015/txkChkEBSDependecies_Thu_Mar_19_07_25_16_2015.log

.end err out.

dbhostdbhostdbhostdbhostdbhostdbhostdbhostdbhostdbhostdbhostdbhostdbhostdbhost

Executing service control script:
/u01/install/APPS/fs1/inst/apps/CRP1_appshost/admin/scripts/adalnctl.sh start
Timeout specified in context file: 100 second(s)

script returned:
dbhostdbhostdbhostdbhostdbhostdbhostdbhostdbhostdbhostdbhostdbhostdbhostdbhost

adalnctl.sh version 120.3.12020000.2

Checking for FNDFS executable.
Starting listener process APPS_CRP1.

adalnctl.sh: exiting with status 0

adalnctl.sh: check the logfile /u01/install/APPS/fs1/inst/apps/CRP1_appshost/logs/appl/admin/log/adalnctl.txt for more information …

.end std out.

.end err out.

dbhostdbhostdbhostdbhostdbhostdbhostdbhostdbhostdbhostdbhostdbhostdbhostdbhost

Executing service control script:
/u01/install/APPS/fs1/inst/apps/CRP1_appshost/admin/scripts/adcmctl.sh start
Timeout specified in context file: 1000 second(s)

script returned:
dbhostdbhostdbhostdbhostdbhostdbhostdbhostdbhostdbhostdbhostdbhostdbhostdbhost

You are running adcmctl.sh version 120.19.12020000.3

Starting concurrent manager for CRP1 …
Starting CRP1_0319@CRP1 Internal Concurrent Manager
Default printer is noprint

adcmctl.sh: exiting with status 0

adcmctl.sh: check the logfile /u01/install/APPS/fs1/inst/apps/CRP1_appshost/logs/appl/admin/log/adcmctl.txt for more information …

.end std out.

.end err out.

dbhostdbhostdbhostdbhostdbhostdbhostdbhostdbhostdbhostdbhostdbhostdbhostdbhost

Executing service control script:
/u01/install/APPS/fs1/inst/apps/CRP1_appshost/admin/scripts/adadminsrvctl.sh start -nopromptmsg
Timeout specified in context file: -1 second(s)

script returned:
dbhostdbhostdbhostdbhostdbhostdbhostdbhostdbhostdbhostdbhostdbhostdbhostdbhost

You are running adadminsrvctl.sh version 120.10.12020000.9

Starting WLS Admin Server…
Refer /u01/install/APPS/fs1/inst/apps/CRP1_appshost/logs/appl/admin/log/adadminsrvctl.txt for details

adadminsrvctl.sh: exiting with status 0

adadminsrvctl.sh: check the logfile /u01/install/APPS/fs1/inst/apps/CRP1_appshost/logs/appl/admin/log/adadminsrvctl.txt for more information …

.end std out.

.end err out.

dbhostdbhostdbhostdbhostdbhostdbhostdbhostdbhostdbhostdbhostdbhostdbhostdbhost

Executing service control script:
/u01/install/APPS/fs1/inst/apps/CRP1_appshost/admin/scripts/admanagedsrvctl.sh start forms_server1 -nopromptmsg
Timeout specified in context file: -1 second(s)

script returned:
dbhostdbhostdbhostdbhostdbhostdbhostdbhostdbhostdbhostdbhostdbhostdbhostdbhost

You are running admanagedsrvctl.sh version 120.14.12020000.9

Starting forms_server1…

admanagedsrvctl.sh: exiting with status 0

admanagedsrvctl.sh: check the logfile /u01/install/APPS/fs1/inst/apps/CRP1_appshost/logs/appl/admin/log/adformsctl.txt for more information …

.end std out.

.end err out.

dbhostdbhostdbhostdbhostdbhostdbhostdbhostdbhostdbhostdbhostdbhostdbhostdbhost

Executing service control script:
/u01/install/APPS/fs1/inst/apps/CRP1_appshost/admin/scripts/admanagedsrvctl.sh start forms-c4ws_server1 -nopromptmsg
Timeout specified in context file: -1 second(s)

script returned:
dbhostdbhostdbhostdbhostdbhostdbhostdbhostdbhostdbhostdbhostdbhostdbhostdbhost

You are running admanagedsrvctl.sh version 120.14.12020000.9

Starting forms-c4ws_server1…

admanagedsrvctl.sh: exiting with status 0

admanagedsrvctl.sh: check the logfile /u01/install/APPS/fs1/inst/apps/CRP1_appshost/logs/appl/admin/log/adforms-c4wsctl.txt for more information …

.end std out.

.end err out.

dbhostdbhostdbhostdbhostdbhostdbhostdbhostdbhostdbhostdbhostdbhostdbhostdbhost

Executing service control script:
/u01/install/APPS/fs1/inst/apps/CRP1_appshost/admin/scripts/admanagedsrvctl.sh start oafm_server1 -nopromptmsg
Timeout specified in context file: -1 second(s)

script returned:
dbhostdbhostdbhostdbhostdbhostdbhostdbhostdbhostdbhostdbhostdbhostdbhostdbhost

You are running admanagedsrvctl.sh version 120.14.12020000.9

Starting oafm_server1…

admanagedsrvctl.sh: exiting with status 0

admanagedsrvctl.sh: check the logfile /u01/install/APPS/fs1/inst/apps/CRP1_appshost/logs/appl/admin/log/adoafmctl.txt for more information …

.end std out.

.end err out.

dbhostdbhostdbhostdbhostdbhostdbhostdbhostdbhostdbhostdbhostdbhostdbhostdbhost

Executing service control script:
/u01/install/APPS/fs1/inst/apps/CRP1_appshost/admin/scripts/admanagedsrvctl.sh start oacore_server1 -nopromptmsg
Timeout specified in context file: -1 second(s)

script returned:
dbhostdbhostdbhostdbhostdbhostdbhostdbhostdbhostdbhostdbhostdbhostdbhostdbhost

You are running admanagedsrvctl.sh version 120.14.12020000.9

Starting oacore_server1…

admanagedsrvctl.sh: exiting with status 0

admanagedsrvctl.sh: check the logfile /u01/install/APPS/fs1/inst/apps/CRP1_appshost/logs/appl/admin/log/adoacorectl.txt for more information …

.end std out.

.end err out.

dbhostdbhostdbhostdbhostdbhostdbhostdbhostdbhostdbhostdbhostdbhostdbhostdbhost

All enabled services for this node are started.

adstrtal.sh: Exiting with status 0

adstrtal.sh: check the logfile /u01/install/APPS/fs1/inst/apps/CRP1_appshost/logs/appl/admin/log/adstrtal.log for more information …

===================INSTALLATION SUMMARY=============================
Oracle E-Business Suite Installation Top Level Directory : /u01/install/APPS
Oracle E-Business Suite Context File : /u01/install/APPS/fs1/inst/apps/CRP1_appshost/appl/admin/CRP1_appshost.xml
Oracle E-Business Suite Login Page : http://appshost.domain.com:8000/OA_HTML/AppsLogin
Oracle E-Business Suite Database Tier Host : dbhost.domain.com
Oracle E-Business Suite Database SID : CRP1
Oracle E-Business Suite TNS_PORT : 1521
==================================================================

Press any key to continue…
[root@appshost scripts]#

5. Run PreClone on Application Tier
[root@appshost ~]# su – applmgr

E-Business Suite Environment Information
—————————————-
RUN File System : /u01/install/APPS/fs1/EBSapps/appl
PATCH File System : /u01/install/APPS/fs2/EBSapps/appl
Non-Editioned File System : /u01/install/APPS/fs_ne

DB Host: dbhost.domain.com Service/SID: CRP1

E-Business Suite Environment Setting
————————————
– Enter [R/r] for sourcing Run File System Environment file, or
– Enter [P/p] for sourcing Patch File System Environment file, or
– Enter anything else to exit

Please choose the environment file you wish to source [R/P]:R

Sourcing the RUN File System …
[applmgr@appshost ~]$ cd $ADMIN_SCRIPTS_HOME
[applmgr@appshost scripts]$ perl adpreclone.pl appsTier

Copyright (c) 2011, 2014 Oracle Corporation
Redwood Shores, California, USA

Oracle E-Business Suite Rapid Clone

Version 12.2

adpreclone Version 120.31.12020000.16

Enter the APPS User Password:
Enter the Weblogic AdminServer password :

Checking the status of the Oracle WebLogic Administration Server….

Running perl /u01/install/APPS/fs1/EBSapps/appl/ad/12.0.0/patch/115/bin/adProvisionEBS.pl ebs-get-serverstatus -contextfile=/u01/install/APPS/fs1/inst/apps/CRP1_appshost/appl/admin/CRP1_appshost.xml -servername=AdminServer -promptmsg=hide

The Oracle WebLogic Administration Server is up.

Running:
perl /u01/install/APPS/fs1/EBSapps/appl/ad/12.0.0/bin/adclone.pl java=/u01/install/APPS/fs1/EBSapps/comn/util/jdk64 mode=stage stage=/u01/install/APPS/fs1/EBSapps/comn/clone component=appsTier method= appctx=/u01/install/APPS/fs1/inst/apps/CRP1_appshost/appl/admin/CRP1_appshost.xml showProgress

Setting the wls environment

Beginning application tier Stage – Thu Mar 19 09:47:15 2015

/u01/install/APPS/fs1/EBSapps/comn/util/jdk64/bin/java -Xmx600M -DCONTEXT_VALIDATED=false -Doracle.installer.oui_loc=/oui -classpath /u01/install/APPS/fs1/FMW_Home/webtier/lib/xmlparserv2.jar:/u01/install/APPS/fs1/FMW_Home/webtier/jdbc/lib/ojdbc6.jar:
/u01/install/APPS/fs1/EBSapps/comn/java/classes:/u01/install/APPS/fs1/FMW_Home/webtier/oui/jlib/OraInstaller.jar:
/u01/install/APPS/fs1/FMW_Home/webtier/oui/jlib/ewt3.jar:/u01/install/APPS/fs1/FMW_Home/webtier/oui/jlib/share.jar:
/u01/install/APPS/fs1/FMW_Home/webtier/../Oracle_EBS-app1/oui/jlib/srvm.jar:/u01/install/APPS/fs1/FMW_Home/webtier/jlib/ojmisc.jar:/u01/install/APPS/fs1/FMW_Home/wlserver_10.3/server/lib/weblogic.jar:
/u01/install/APPS/fs1/FMW_Home/oracle_common/jlib/obfuscatepassword.jar oracle.apps.ad.clone.StageAppsTier -e /u01/install/APPS/fs1/inst/apps/CRP1_appshost/appl/admin/CRP1_appshost.xml -stage /u01/install/APPS/fs1/EBSapps/comn/clone -tmp /tmp -method CUSTOM -showProgress -nopromptmsg

Log file located at /u01/install/APPS/fs1/inst/apps/CRP1_appshost/admin/log/clone/StageAppsTier_03190947.log

\ 20% completed

Completed Stage…
Thu Mar 19 09:55:17 2015
[applmgr@appshost scripts]$

  1. Take Cold Backup

Growth of DB


— SQL to find Historical Growth Of Oracle Database
set echo off
set pagesize 9999
set lines 9999
col Month for a10
col year for a8
clear breaks
break on year nodup skip 1

select
to_char(creation_time,’RRRR’) Year
,to_char(creation_time,’MM’) Month
,sum(bytes) / 1024/1024 “Size in MB”
from v$datafile
group by to_char(creation_time,’RRRR’)
,to_char(creation_time,’MM’)
order by 1,2;

E-Business Suite 12.2


There are lots of updates coming in this release, but from a technology stack perspective, EBS 12.2 will be notable for two things:

1) Replacing Oracle Containers for Java (OC4J) 10g with WebLogic Server 11g
2) Online Patching support via 11gR2 Edition-Based Redefinition

1. Replacing OC4J with WebLogic Server

EBS 12.2 will use WebLogic Server from Fusion Middleware 11g in place of OC4J 10g as part of the release’s internal technology stack. Other additional new Fusion Middleware 11g components used will include WebLogic JSP and UIX 11g.

2. Online Patching support via 11gR2 Edition-Based Redefinition

EBS 12.2 will use the 11gR2 Database’s Edition-Based Redefinition features to provide support for Online Patching. Edition-Based Redefinition is really exciting new technology. From the 11gR2 Application Developer’s Guide:

“Edition-based redefinition enables you to upgrade the database component of an application while it is in use, thereby minimizing or eliminating down time.

“To upgrade an application while it is in use, you copy the database objects that comprise the application and redefine the copied objects in isolation. Your changes do not affect users of the application—they continue to run the unchanged application. When you are sure that your changes are correct, you make the upgraded application available to all users.”

Online Patching means that patches that change EBS database objects can be applied while the E-Business Suite production instance is fully operational. Only a short downtime will be required to complete the patching process. This will make your patching downtimes more predictable.

Read more on Steven Chan Blog

SQL to get details of Concurrent Program (FND_CONC_REQ_SUMMARY_V)


Hi Friends,

I have framed a sql query with help of my technical friends to get below details

1. Request id

2. Concurrent program full name

3. Concurrent program short name

4. Start time, and End time.

5. Runtime

6. Parameters passed to the request

7. Submitted by

8. Status code and Phase code

SELECT request_id,
user_concurrent_program_name Concurrent_Program_Full_Name,
program_short_name Concurrent_Program_Short_Name,
actual_start_date,
actual_completion_date,
FLOOR( ( (actual_completion_date – actual_start_date) * 24 * 60 * 60)
/ 3600)
|| ‘ HOURS ‘
|| FLOOR( ( ( (actual_completion_date – actual_start_date)
* 24
* 60
* 60)
– FLOOR( ( (actual_completion_date – actual_start_date)
* 24
* 60
* 60)
/ 3600)
* 3600)
/ 60)
|| ‘ MINUTES ‘
|| ROUND( ( ( (actual_completion_date – actual_start_date)
* 24
* 60
* 60)
– FLOOR( ( (actual_completion_date – actual_start_date)
* 24
* 60
* 60)
/ 3600)
* 3600
– (FLOOR( ( ( (actual_completion_date – actual_start_date)
* 24
* 60
* 60)
– FLOOR( ( (actual_completion_date
– actual_start_date)
* 24
* 60
* 60)
/ 3600)
* 3600)
/ 60)
* 60)))
|| ‘ SECS ‘
time_difference,
argument_text Parameter,
requestor submited_by,
status_code,
phase_code
FROM FND_CONC_REQ_SUMMARY_V

Concurrent Manager showing status “System Hold, Fix Manager before resetting counters”.


Hi friends,

Recently after EBS upgrade to 12.1.3 CM were not functional and was showing status “System Hold, Fix Manager before resetting counters”.

Issue:
Concurrent Manager showing status “System Hold, Fix Manager before resetting counters”.

Solution:
To implement the solution, please execute the following steps:

1. Stop all middle tier services including the concurrent managers.
Please make sure that no FNDLIBR, FNDSM, or any dead process is
running.

2. Go to cd $FND_TOP/bin
$ adrelink.sh force=y link_debug=y “fnd FNDLIBR”
$ adrelink.sh force=y link_debug=y “fnd FNDFS”
$ adrelink.sh force=y link_debug=y “fnd FNDCRM”
$ adrelink.sh force=y link_debug=y “fnd FNDSM”

3. Run the CMCLEAN.SQL script from the referenced note below (don’t forget to commit).
Note 134007.1 CMCLEAN.SQL – Non Destructive Script to Clean Concurrent Manager Tables

4. Start the concurrent manager.

5. Retest the issue.

Reference :
SCHEDULE/PRERELEASER MANAGER STATUS : SYSTEM HOLD, FIX MANAGER BEFORE RESETTING [ID 985835.1]

SQL to get details of Scheduled Concurrent Program


Hi Friends,

I have found a interesting sql query which gives details of scheduled concurrent requests in EBS.

/*SQL 1*/

SELECT r.request_id
, CASE
WHEN pt.user_concurrent_program_name = ‘Report Set’
THEN DECODE(
r.description
, NULL, pt.user_concurrent_program_name
, r.description
|| ‘ (‘
|| pt.user_concurrent_program_name
|| ‘)’
)
ELSE pt.user_concurrent_program_name
END job_name
, u.user_name requestor
, u.description requestor_description
, u.email_address
, frt.responsibility_name requested_by_resp
, r.request_date
, r.requested_start_date
, DECODE(
r.hold_flag
, ‘Y’, ‘Yes’
, ‘N’, ‘No’
) on_hold
, CASE
WHEN r.hold_flag = ‘Y’
THEN SUBSTR(
u2.description
, 0
, 40
)
END last_update_by
, CASE
WHEN r.hold_flag = ‘Y’
THEN r.last_update_date
END last_update_date
, r.argument_text PARAMETERS
, NVL2(
r.resubmit_interval
, ‘Periodically’
, NVL2(
r.release_class_id
, ‘On specific days’
, ‘Once’
)
) AS schedule_type
, r.resubmit_interval resubmit_every
, r.resubmit_interval_unit_code resubmit_time_period
, DECODE(
r.resubmit_interval_type_code
, ‘START’, ‘From the start of the prior run’
, ‘END’, ‘From the Completion of the prior run’
) apply_the_update_option
, r.increment_dates
, TO_CHAR((r.requested_start_date), ‘HH24:MI:SS’) start_time
FROM applsys.fnd_concurrent_programs_tl pt
, applsys.fnd_concurrent_programs pb
, applsys.fnd_user u
, applsys.fnd_user u2
, applsys.fnd_printer_styles_tl s
, applsys.fnd_concurrent_requests r
, applsys.fnd_responsibility_tl frt
WHERE pb.application_id = r.program_application_id
AND pb.concurrent_program_id = r.concurrent_program_id
AND pb.application_id = pt.application_id
AND r.responsibility_id = frt.responsibility_id
AND pb.concurrent_program_id = pt.concurrent_program_id
AND u.user_id = r.requested_by
AND u2.user_id = r.last_updated_by
AND s.printer_style_name(+) = r.print_style
AND r.phase_code = ‘P’
AND 1 = 1;

/*SQL 2*/

select r.request_id,
p.user_concurrent_program_name || nvl2(r.description,’ (‘||r.description||’)’,null) Conc_prog,
s.user_name REQUESTOR,
r.argument_text arguments,
r.requested_start_date next_run,
r.last_update_date LAST_RUN,
r.hold_flag on_hold,
r.increment_dates,
decode(c.class_type,
‘P’, ‘Periodic’,
‘S’, ‘On Specific Days’,
‘X’, ‘Advanced’,
c.class_type) schedule_type,
case
when c.class_type = ‘P’ then
‘Repeat every ‘ ||
substr(c.class_info, 1, instr(c.class_info, ‘:’) – 1) ||
decode(substr(c.class_info, instr(c.class_info, ‘:’, 1, 1) + 1, 1),
‘N’, ‘ minutes’,
‘M’, ‘ months’,
‘H’, ‘ hours’,
‘D’, ‘ days’) ||
decode(substr(c.class_info, instr(c.class_info, ‘:’, 1, 2) + 1, 1),
‘S’, ‘ from the start of the prior run’,
‘C’, ‘ from the completion of the prior run’)
when c.class_type = ‘S’ then
nvl2(dates.dates, ‘Dates: ‘ || dates.dates || ‘. ‘, null) ||
decode(substr(c.class_info, 32, 1), ‘1’, ‘Last day of month ‘) ||
decode(sign(to_number(substr(c.class_info, 33))),
‘1’, ‘Days of week: ‘ ||
decode(substr(c.class_info, 33, 1), ‘1’, ‘Su ‘) ||
decode(substr(c.class_info, 34, 1), ‘1’, ‘Mo ‘) ||
decode(substr(c.class_info, 35, 1), ‘1’, ‘Tu ‘) ||
decode(substr(c.class_info, 36, 1), ‘1’, ‘We ‘) ||
decode(substr(c.class_info, 37, 1), ‘1’, ‘Th ‘) ||
decode(substr(c.class_info, 38, 1), ‘1’, ‘Fr ‘) ||
decode(substr(c.class_info, 39, 1), ‘1’, ‘Sa ‘))
end as schedule,
c.date1 start_date,
c.date2 end_date
from fnd_concurrent_requests r,
fnd_conc_release_classes c,
fnd_concurrent_programs_tl p,
fnd_user s,
(with date_schedules as (
select release_class_id,
rank() over(partition by release_class_id order by s) a, s
from (select c.class_info, l,
c.release_class_id,
decode(substr(c.class_info, l, 1), ‘1’, to_char(l)) s
from (select level l from dual connect by level 0)
where s is not null)
SELECT release_class_id, substr(max(SYS_CONNECT_BY_PATH(s, ‘ ‘)), 2) dates
FROM date_schedules
START WITH a = 1
CONNECT BY nocycle PRIOR a = a – 1
group by release_class_id) dates
where r.phase_code = ‘P’
and c.application_id = r.release_class_app_id
and c.release_class_id = r.release_class_id
and nvl(c.date2, sysdate + 1) > sysdate
and c.class_type is not null
and p.concurrent_program_id = r.concurrent_program_id
and p.language = ‘US’
and dates.release_class_id(+) = r.release_class_id
and r.requested_by = s.user_id
order by conc_prog, on_hold, next_run;

SELECT fcr.request_id
, fcpt.user_concurrent_program_name|| NVL2(fcr.description, ‘ (‘ || fcr.description || ‘)’, NULL) conc_prog
, fu.user_name requestor
, fu.description requested_by
, fu.email_address
, frt.responsibility_name requested_by_resp
, trim(fl.meaning) status
, fcr.phase_code
, fcr.status_code
, fcr.argument_text “PARAMETERS”
, ‘——>’ dates
, TO_CHAR(fcr.request_date, ‘DD-MON-YYYY HH24:MI:SS’) requested
, TO_CHAR(fcr.requested_start_date, ‘DD-MON-YYYY HH24:MI:SS’) requested_start
, TO_CHAR((fcr.requested_start_date), ‘HH24:MI:SS’) start_time
, ‘——>’ holds
, DECODE(fcr.hold_flag, ‘Y’, ‘Yes’, ‘N’, ‘No’) on_hold
, CASE
WHEN fcr.hold_flag = ‘Y’
THEN SUBSTR(
u2.description
, 0
, 40
)
END last_update_by
, CASE
WHEN fcr.hold_flag = ‘Y’
THEN fcr.last_update_date
END last_update_date
, ‘——>’ prints
, fcr.number_of_copies print_count
, fcr.printer
, fcr.print_style
, ‘——>’ schedule
, fcr.increment_dates
, CASE WHEN fcrc.CLASS_INFO IS NULL THEN
‘Yes: ‘ || TO_CHAR(fcr.requested_start_date, ‘DD-MON-YYYY HH24:MI:SS’)
ELSE
‘n/a’
END run_once
, CASE WHEN fcrc.class_type = ‘P’ THEN
‘Repeat every ‘ ||
substr(fcrc.class_info, 1, instr(fcrc.class_info, ‘:’) – 1) ||
decode(substr(fcrc.class_info, instr(fcrc.class_info, ‘:’, 1, 1) + 1, 1),
‘N’, ‘ minutes’,
‘M’, ‘ months’,
‘H’, ‘ hours’,
‘D’, ‘ days’) ||
decode(substr(fcrc.class_info, instr(fcrc.class_info, ‘:’, 1, 2) + 1, 1),
‘S’, ‘ from the start of the prior run’,
‘C’, ‘ from the completion of the prior run’)
ELSE
‘n/a’
END set_days_of_week
, CASE WHEN fcrc.class_type = ‘S’ AND instr(substr(fcrc.class_info, 33),’1′,1) > 0 THEN
‘Days of week: ‘ ||
decode(substr(fcrc.class_info, 33, 1), ‘1’, ‘Sun, ‘) ||
decode(substr(fcrc.class_info, 34, 1), ‘1’, ‘Mon, ‘) ||
decode(substr(fcrc.class_info, 35, 1), ‘1’, ‘Tue, ‘) ||
decode(substr(fcrc.class_info, 36, 1), ‘1’, ‘Wed, ‘) ||
decode(substr(fcrc.class_info, 37, 1), ‘1’, ‘Thu, ‘) ||
decode(substr(fcrc.class_info, 38, 1), ‘1’, ‘Fri, ‘) ||
decode(substr(fcrc.class_info, 39, 1), ‘1’, ‘Sat ‘)
ELSE
‘n/a’
end days_of_week
, CASE WHEN fcrc.class_type = ‘S’ AND instr(substr(fcrc.class_info, 1, 31),’1′,1) > 0 THEN
‘Set Days of Month: ‘ ||
decode(substr(fcrc.class_info, 1, 1), ‘1’, ‘1st, ‘) ||
decode(substr(fcrc.class_info, 2, 1), ‘1’, ‘2nd, ‘) ||
decode(substr(fcrc.class_info, 3, 1), ‘1’, ‘3rd, ‘) ||
decode(substr(fcrc.class_info, 4, 1), ‘1’, ‘4th, ‘) ||
decode(substr(fcrc.class_info, 5, 1), ‘1’, ‘5th, ‘) ||
decode(substr(fcrc.class_info, 6, 1), ‘1’, ‘6th, ‘) ||
decode(substr(fcrc.class_info, 7, 1), ‘1’, ‘7th, ‘) ||
decode(substr(fcrc.class_info, 8, 1), ‘1’, ‘8th, ‘) ||
decode(substr(fcrc.class_info, 9, 1), ‘1’, ‘9th, ‘) ||
decode(substr(fcrc.class_info, 10, 1), ‘1’, ’10th, ‘) ||
decode(substr(fcrc.class_info, 11, 1), ‘1’, ’11th, ‘) ||
decode(substr(fcrc.class_info, 12, 1), ‘1’, ’12th, ‘) ||
decode(substr(fcrc.class_info, 13, 1), ‘1’, ’13th, ‘) ||
decode(substr(fcrc.class_info, 14, 1), ‘1’, ’14th, ‘) ||
decode(substr(fcrc.class_info, 15, 1), ‘1’, ’15th, ‘) ||
decode(substr(fcrc.class_info, 16, 1), ‘1’, ’16th, ‘) ||
decode(substr(fcrc.class_info, 17, 1), ‘1’, ’17th, ‘) ||
decode(substr(fcrc.class_info, 18, 1), ‘1’, ’18th, ‘) ||
decode(substr(fcrc.class_info, 19, 1), ‘1’, ’19th, ‘) ||
decode(substr(fcrc.class_info, 20, 1), ‘1’, ’20th, ‘) ||
decode(substr(fcrc.class_info, 21, 1), ‘1’, ’21st, ‘) ||
decode(substr(fcrc.class_info, 22, 1), ‘1’, ’22nd, ‘) ||
decode(substr(fcrc.class_info, 23, 1), ‘1’, ’23rd,’ ) ||
decode(substr(fcrc.class_info, 24, 1), ‘1’, ’24th, ‘) ||
decode(substr(fcrc.class_info, 25, 1), ‘1’, ’25th, ‘) ||
decode(substr(fcrc.class_info, 26, 1), ‘1’, ’26th, ‘) ||
decode(substr(fcrc.class_info, 27, 1), ‘1’, ’27th, ‘) ||
decode(substr(fcrc.class_info, 28, 1), ‘1’, ’28th, ‘) ||
decode(substr(fcrc.class_info, 29, 1), ‘1’, ’29th, ‘) ||
decode(substr(fcrc.class_info, 30, 1), ‘1’, ’30th, ‘) ||
decode(substr(fcrc.class_info, 31, 1), ‘1’, ’31st. ‘)
ELSE
‘n/a’
END days_of_month
, CASE WHEN fcrc.class_type = ‘S’ AND substr(fcrc.class_info, 32, 1) = ‘1’ THEN
‘Yes’
ELSE
‘n/a’
END last_day_of_month_ticked
, fcrc.CLASS_INFO
FROM applsys.fnd_concurrent_requests fcr
, applsys.fnd_user fu
, applsys.fnd_user u2
, applsys.fnd_concurrent_programs fcp
, applsys.fnd_concurrent_programs_tl fcpt
, applsys.fnd_printer_styles_tl fpst
, applsys.fnd_conc_release_classes fcrc
, applsys.fnd_responsibility_tl frt
, apps.fnd_lookups fl
WHERE fcp.application_id = fcpt.application_id
AND fcr.requested_by = fu.user_id
AND fcr.concurrent_program_id = fcp.concurrent_program_id
AND fcr.program_application_id = fcp.application_id
AND fcr.concurrent_program_id = fcpt.concurrent_program_id
AND fcr.responsibility_id = frt.responsibility_id
AND fcr.last_updated_by = u2.user_id
AND fcr.print_style = fpst.printer_style_name(+)
AND fcr.release_class_id = fcrc.release_class_id(+)
AND fcr.status_code = fl.lookup_code
AND fl.lookup_type = ‘CP_STATUS_CODE’
AND fcr.phase_code = ‘P’
AND 1=1
ORDER BY fu.description, fcr.requested_start_date asc;

How To Enable/Disable “Submit Another Request ?”


Profile Option “Concurrent: Show Requests Summary After Each Request” controls the behaviour of the application after request submission:

Sysdamin: Profile> System > Query for “Concurrent: Show Requests Summary After Each Request”

If set to Yes, the View Requests form displayed.

If set to No, the Decision Window displayed.

Enjoy Reading ….

Important Views when using Oracle RMAN


RC_ARCHIVED_LOG information about all archivelogs.

RC_BACKUP_CONTROLFILE backup control files in backup sets.

RC_BACKUP_CORRUPTION corrupt blocks in datafile backups and copies.

RC_BACKUP_DATAFILE datafile backups (in backup sets).

RC_BACKUP_PIECE backup pieces.

RC_BACKUP_REDOLOG redo log backups (in backup sets).

RC_BACKUP_SET backup sets.

RC_CHECKPOINT rc_checkpoint is replaced by rc_resync, but is still used by some tests.

RC_CONTROLFILE_COPY controlfile copies.

RC_COPY_CORRUPTION corrupt block ranges in datafile copies for all database incarnations.

RC_DATABASE information about databases and their current incarnations.

RC_DATABASE_INCARNATION information about all incarnations registered in recovery catalog.

RC_DATAFILE information about all datafiles registered in recovery catalog.

RC_DATAFILE_COPY datafile copies (on disk).

RC_LOG_HISTORY information about redo log history.

RC_OFFLINE_RANGE offline ranges for datafiles.

RC_REDO_LOG information about online redo logs.

RC_REDO_THREAD information about redo threads.

RC_RESYNC information about recovery catalog resyncs (checkpoints).

RC_STORED_SCRIPT stored scripts.

RC_STORED_SCRIPT_LINE each line of each stored script.

RC_TABLESPACE information about all tablespaces registered in recovery catalog.

How to Turn Archiving ON and OFF


Turning Archiving On and Off
You set a database’s initial archiving mode as part of database creation. Usually, you can use the default of NOARCHIVELOG mode at database creation
because there is no need to archive the redo information generated at that time. After creating the database, decide whether to change from the initial archiving mode.

After a database has been created, you can switch the database’s archiving mode on demand. However, you should generally not switch the database between archiving modes.

NOTE: If a database is automatically created during Oracle installation, the initial archiving mode of the database is operating system specific. See your operating system-specific Oracle documentation.

ARCHIVELOG mode is necessary for creating on-line backups and for certain types of database recovery. Configuring the database to operate in
ARCHIVELOG mode allows the user to perform complete and point-in-time recovery from media (disk) failures using off-line or on-line backups. If
ARCHIVELOG mode is disabled, the database can be restored from a backup in case of failure, but it cannot be rolled forward from that to a point when failure occurred.

Oracle recommends ARCHIVELOG mode for all production databases

Setting the Initial Database Archiving Mode
When you create the database, you set the initial archiving mode of the redo log in the CREATE DATABASE statement. If you do not specify either ARCHIVELOG or NOARCHIVELOG, NOARCHIVELOG is the default. To verify database mode, execute following statement:

SQL> Select NAME, CREATED, LOG_MODE, CHECKPOINT_CHANGE#, ARCHIVE_CHANGE# from V$DATABASENAME CREATED LOG_MODE CHECKPOINT_CHANGE# ARCHIVE_CHANGE#——— ——— ———— —————— —————O112 19-MAR-09 NOARCHIVELOG 1438426 135961

Changing the Database Archiving Mode
There are “init.ora” parameters you need to modify in order to properly handle your database being in archive log mode. They are:

LOG_ARCHIVE_DEST LOG_ARCHIVE_FORMAT LOG_ARCHIVE_DEST:
This parameter specifies the directory where your archive logs will be placed.

LOG_ARCHIVE_FORMAT:
This parameter names the archive logs in this format. For example, if your format is: arch%s.arc

Your log files will be called: arch1.arc, arch2.arc, arch3.arc where the ‘1’, ‘2’, ‘3’, etc is the sequence number.

To Prepare to Switch Database Archiving Mode
1. Shut down the database instance.

SQL> shutdown immediateAn open database must be closed and dismounted and any associated instances shut down before the database’s archiving mode can be switched. Archiving cannot be disabled if any datafiles need media recovery.

2. Backup the database.

This backup can be used with the archive logs that you will generate.

3. Perform any operating system specific steps (optional).

4. Start up a new instance and mount, but do not open the database.

SQL> startup mountNOTE: If you are using the Oracle Parallel Server, you must mount the database exclusively using one instance to switch the database’s archiving mode.

5. Put the database into archivelog mode

SQL> alter database archivelog; NOTE: You can also use

alter database noarchivelog to take the database out of archivelog mode

6. Open the database.

SQL> alter database open; 7. Verify your database is now in archivelog mode.

SQL> archive log listDatabase log mode Archive ModeAutomatic archival EnabledArchive destination USE_DB_RECOVERY_FILE_DESTOldest online log sequence 22Next log sequence to archive 24Current log sequence 248. Archive all your redo logs at this point.

SQL> archive log all; 9. Ensure these newly created Archive log files are added to the backup process.

Ref: Metalink ID 69739.1

What Happens When A Tablespace/Database Is Kept In Begin Backup Mode


To perform online/hot backup we have to put the tablespace in begin backup mode followed by copying the datafiles and then putting the tablespace to end backup.

In 8i, 9i we have to put each tablespace individually in begin/end backup mode to perform the online backup. From 10g onwards the entire database can be put in begin/end backup mode.

Make sure that the database is in archivelog mode

Example :

Performing a single tablespace backup

+ sql>alter tablespace system begin backup;
+ Copy the corresponding datafiles using appropriate O/S commands.
+ sql>alter tablespace system end backup;

Performing a full database backup (starting from 10g)

+ sql> alter database begin backup;
+ Copy all the datafiles using appropriate O/S commands.
+ sql> alter database end backup;

One danger in making online backups is the possibility of inconsistent data within a block. For example, assume that you are backing up block 100 in datafile users.dbf. Also, assume that the copy utility reads the entire block while DBWR is in the middle of updating the block. In this case, the copy utility may read the old data in the top half of the block and the new data in the bottom top half of the block. The result is called a fractured block, meaning that the data contained in this block is not consistent. at a given SCN.

Therefore oracle internally manages the consistency as below :

1. The first time a block is changed in a datafile that is in hot backup mode, the entire block is written to the redo log files, not just the changed bytes. Normally only the changed bytes (a redo vector) is written. In hot backup mode, the entire block is logged the first time. This is because you can get into a situation where the process copying the datafile and DBWR are working on the same block simultaneously.

Lets say they are and the OS blocking read factor is 512bytes (the OS reads 512 bytes from disk at a time). The backup program goes to read an 8k Oracle block. The OS gives it 4k. Meanwhile — DBWR has asked to rewrite this block. the OS schedules the DBWR write to occur right now. The entire 8k block is rewritten. The backup program starts running again (multi-tasking OS here) and reads the last 4k of the block. The backup program has now gotten an fractured block — the head and tail are from two points in time.

We cannot deal with that during recovery. Hence, we log the entire block image so that during recovery, this block is totally rewritten from redo and is consistent with itself atleast. We can recover it from there.

2. The datafile headers which contain the SCN of the last completed checkpoint are not updated while a file is in hot backup mode. This lets the recovery process understand what archive redo log files might be needed to fully recover this file.

To limit the effect of this additional logging, you should ensure you only place one tablepspace at a time in backup mode and bring the tablespace out of backup mode as soon as you have backed it up. This will reduce the number of blocks that may have to be logged to the minimum possible.

Ref : Metalink ID 469950.1

Query to find number of archive logs getting generated every day


SELECT A.*,
Round(A.Count#*B.AVG#/1024/1024) Daily_Avg_Mb
FROM
(
SELECT
To_Char(First_Time,’YYYY-MM-DD’) DAY,
Count(1) Count#,
Min(RECID) Min#,
Max(RECID) Max#
FROM
v$log_history
GROUP
BY To_Char(First_Time,’YYYY-MM-DD’)
ORDER
BY 1 DESC
) A,
(
SELECT
Avg(BYTES) AVG#,
Count(1) Count#,
Max(BYTES) Max_Bytes,
Min(BYTES) Min_Bytes
FROM
v$log
) B;

What Tables Are Involved In Using The System Profile ‘Sign-On:Audit Level’


Applies to:

Oracle Application Object Library – Version: 11.5.0 to 11.5.10.2 – Release: 11.5 to 11.5
Information in this document applies to any platform.
Checked for relevance on 29-MAY-2010

Goal

What tables are involved in using the system profile ‘Sign-On:Audit Level’?

Solution

There are three primary tables:

FND_LOGINS
FND_LOGIN_RESPONSIBILITIES
FND_LOGIN_RESP_FORMS

1. Least detailed level: User.
When the profile is set to User, the only table that gets updated is the table FND_LOGINS and only one record per user session.

2. Next level: Responsibility.
When the profile is set to Responsbility both FND_LOGINS and FND_LOGIN_RESPONSIBILITIES will be updated.
FND_LOGINS gets only one record per user session.
FND_LOGIN_RESPONSIBILITIES will be updated with one record for each
responsibility selected during the session.

3. Most detailed level: Form.
When the profile is set to Form all three tables are involved.
FND_LOGINS gets only one record per user session.
FND_LOGIN_RESPONSIBILITIES will be updated with one record for each
responsibility selected during the session.
FND_LOGIN_RESP_FORMS will be updated with one record for each form selected during the session.

Reference: Metalink Note 368260.1

Helpful SQL for Users Monitoring


— Current Forms Based Users in ERP

SELECT TIME, user_name, responsibility_name, user_form_name
FROM apps.fnd_form_sessions_v ORDER BY 1;

— Users Count Who Logged in to ERP

select count(distinct d.user_name)
from apps.fnd_logins a, v$session b, v$process c, apps.fnd_user d
where b.paddr = c.addr
and a.pid=c.pid and a.spid = b.process
and d.user_id = a.user_id and (d.user_name = ‘USER_NAME’ OR 1=1);

— Users Who Logged in to ERP

select distinct d.user_name
from apps.fnd_logins a, v$session b, v$process c, apps.fnd_user d
where b.paddr = c.addr
and a.pid=c.pid
and a.spid = b.process
and d.user_id = a.user_id
and (d.user_name = ‘USER_NAME’ OR 1=1);

Query to list of Responsibilities attached to a particular Oracle Application User


Hi Friends,

Kindly run below sql query as apps user for listing all the responsibilities attached to a particular user (prompted by query).

set pages 300 lines 300
col USER_NAME for a40
col RESPONSIBILITY_NAME for a50

select fu.user_name, fr.responsibility_name, furg.START_DATE, furg.END_DATE
from fnd_user_resp_groups_direct furg, fnd_user fu, fnd_responsibility_tl fr
where fu.user_name = ‘&user_name’
and furg.user_id = fu.user_id
and furg.responsibility_id = fr.responsibility_id
and fr.language = userenv(‘LANG’);

Happy Reading !!

Farhan Shaikh

Trace a Concurrent Request And Generate TKPROF File


Enable Tracing For The Concurrent Manager Program

Responsibility: System Administrator
Navigate: Concurrent > Program > Define
Query Concurrent Program
Select the Enable Trace Checkbox
Turn On Tracing
Responsibility: System Administrator
Navigate: Profiles > System
Query Profile Option Concurrent: Allow Debugging
Set profile to Yes
Run Concurrent Program With Tracing Turned On
Logon to the Responsibility that runs the Concurrent Program
In the Submit Request Screen click on Debug Options (B)
Select the Checkbox for SQL Trace

Find Trace File Name
Run the following SQL to find out the Raw trace name and location for the concurrent program. The SQL prompts the user for the request id

SELECT ’Request id: ’||request_id , ‘Trace id: ’||oracle_Process_id, ‘Trace Flag: ’||req.enable_trace, ‘Trace Name: ‘||dest.value||’/’||lower(dbnm.value)||’_ora_’||oracle_process_id||’.trc’,
‘Prog. Name: ’||prog.user_concurrent_program_name, ‘File Name: ’||execname.execution_file_name|| execname.subroutine_name , ‘Status : ’||decode(phase_code,’R’,’Running’) ||’-‘||decode(status_code,’R’,’Normal’), ‘SID Serial: ’||ses.sid||’,’|| ses.serial#, ‘Module : ’||ses.module from fnd_concurrent_requests req, v$session ses, v$process proc, v$parameter dest,
v$parameter dbnm, fnd_concurrent_programs_vl prog, fnd_executables execname where req.request_id = &request and req.oracle_process_id=proc.spid(+) and proc.addr = ses.paddr(+)
and dest.name=’user_dump_dest’ and dbnm.name=’db_name’ and req.concurrent_program_id = prog.concurrent_program_id and req.program_application_id = prog.application_id
and prog.application_id = execname.application_id and prog.executable_id=execname.executable_id;

TKPROF Trace File
Once you have obtained the Raw trace file you need to format the file using TKPROF.

$tkprof raw_trace_file.trc output_file explain=apps/ sort=(exeela,fchela) sys=no

Where: raw_trace_file.trc: Name of trace file
output_file: tkprof out file
explain: This option provides the explain plan for the sql statements
sort: his provides the sort criteria in which all sql statements will be sorted. This will bring the bad sql at the top of the outputfile.
sys=no:Disables sql statements issued by user SYS

Another example: To get (TKPROF) sorted by longest running queries first and limits the results to the “Top 10″ long running queries

$ tkprof raw_trace_file.trc output_file sys=no explain=apps/ sort=’(prsela,exeela,fchela)’ print=10

Usage: tkprof tracefile outputfile [explain= ] [table= ]
[print= ] [insert= ] [sys= ] [sort= ]
table=schema.tablename Use ‘schema.tablename’ with ‘explain=’ option.
explain=user/password Connect to ORACLE and issue EXPLAIN PLAN.
print=integer List only the first ‘integer’ SQL statements.
aggregate=yes|no
insert=filename List SQL statements and data inside INSERT statements.
sys=no TKPROF does not list SQL statements run as user SYS.
record=filename Record non-recursive statements found in the trace file.
sort=option Set of zero or more of the following sort options:
prscnt number of times parse was called
prscpu cpu time parsing
prsela elapsed time parsing
prsdsk number of disk reads during parse
prsqry number of buffers for consistent read during parse
prscu number of buffers for current read during parse
prsmis number of misses in library cache during parse
execnt number of execute was called
execpu cpu time spent executing
exeela elapsed time executing
exedsk number of disk reads during execute
exeqry number of buffers for consistent read during execute
execu number of buffers for current read during execute
exerow number of rows processed during execute
exemis number of library cache misses during execute
fchcnt number of times fetch was called
fchcpu cpu time spent fetching
fchela elapsed time fetching
fchdsk number of disk reads during fetch
fchqry number of buffers for consistent read during fetch
fchcu number of buffers for current read during fetch
fchrow number of rows fetched
userid userid of user that parsed the cursor

Enjoy Reading

Farhan Shaikh

Cloning Multi Node to Single Node


Description :
With Oracle Applications 11.5.10 the ability to clone from a multi node to a single node system using rapid clone has now been certified.
This is accomplished by the Shared APPL_TOP and Merging APPL_TOP features.
The information mentioned here is the steps which i have used and found them to be successful for a more elaborate explanation you might want to refer to the Metalink notes mentioned at the end of this document.

Source System here refers to the multi node Production system to be cloned Target System refers to the newly to be created T&D single node system
Applications Version 11.5.10.2
Database Version 10.2.0.4.0
Operating System RedHat Enterprise Linux Advance Server 5 update 4

Source Setup Information:

192.168.200.2 Database
192.168.200.2 Concurrent Manager & Report (Admin Node)
192.168.200.3 Forms & Apache (Web Node)

Step 1: Check OS configuration and utilities
Red Hat Enterprise Linux 5* (base and Advanced Platform) Update 1 (RHEL 5.1) or higher is
required.
The following packages are not part of the OEL 5 or RHEL 5 distribution media and must be installed
manually:
• compat-libstdc++-egcs-1.1.2-11
• compat-libcwait-2.1-11
• compat-oracle-el5-1.0-51
• openmotif21-2.1.30-11.EL51
• binutils-2.152
The following packages must be installed from the OEL 5 or RHEL 5 distribution media:
• libXp-1.0.0-8.1.el5
• compat-libgcc-296-2.96-138
• compat-libstdc++-33-3.2.3-61
• compat-db-4.2.52-5.1
Note :
1: Download from http://oss.oracle.com/projects/compat-oracle/files/Enterprise_Linux/ (for both OEL 5 and RHEL 5)
2: GNU linker (ld) version 2.15 is required for relinking the modules in Advanced Planning &
Scheduling (MSC, MSO, MSR) – download binutils-2.15 from http://oss.oracle.com/projects/compat oracle/files/Enterprise_Linux/ (for both OEL 5 and RHEL 5)
glibc Requirements  Oracle Enterprise Linux 5 2.3.4-2.26

Domain Name System (DNS) Resolver Parameters
Two Domain Name System (DNS) resolver parameters (timeout and attempts) are set by default to low values when the operating system is installed. These low values may cause attempted network connections to an Oracle database to fail. If this happens, add or update the following entries to these
minimum settings in the /etc/resolv.conf file on each server node:
options attempts:5
options timeout:15

Net Service Listeners in Multi-user Installations
Give all users in a multi-user installation write privileges to the .oracle directory:
$ chmod 777 /var/tmp/.oracle

Verifying Host Names
Use the following to verify host name settings:
For Oracle Enterprise Linux 4 and 5, Red Hat Enterprise Linux 3, 4 and 5:
1. Verify that the /etc/hosts file is formatted as follows:
127.0.0.1 localhost.localdomain localhost
.
2. Verify that the /etc/sysconfig/network file is formatted as follows:
HOSTNAME=.
3. If the /etc/sysconfig/networking/profiles/default/network file exists, remove it.
4. If you changed any files in the previous steps, restart the system.

Modifying the Number of Open File Descriptors
Open the /etc/security/limits.conf file and change the existing values for “hard” and “soft” parameters
as follows. Restart the system after making changes.
For Oracle Enterprise Linux 4 and 5, Red Hat Enterprise Linux 3, 4 and 5 and SUSE Linux Enterprise
Server 9 and 10:
* hard nofile 65535
* soft nofile 4096
Modifying the Port Range Values
Open the /etc/sysctl.conf file and change the value of net.ipv4.ip_local_port_range as follows. Restart the system after making changes.
net.ipv4.ip_local_port_range = 10000 65000
Please note that this range is a recommended range, and may need to be adjusted according to the specific needs of the user’s environment in order to avoid port conflicts.

Setting the Environment
Perform the following tasks to set the environment before you run Rapid Install.
1. Create symbolic links For Oracle Enterprise Linux 5 and Red Hat Enterprise Linux 5 only :
# ln -s /usr/bin/ld215 /usr/bin/ld
Download and apply the OS library patch 6078836 from Oracle MetaLink and create the following symbolic link:
# ln -s /usr/lib/libdb.so.2 /usr/lib/libdb.so.3
2. Verify that the host name setting is correct. The command should return a fully qualified hostname.
For example: ..
# hostname -f

For Oracle Enterprise Linux 5, Red Hat Enterprise Linux 5 and SUSE Linux Enterprise Server 10 customers, the LD_ASSUME_KERNEL environment variable should be unset before starting the installation. The installation fails when the LD_ASSUME_KERNEL variable is set by the adgetlnxver.sh file during the course of the installation. Patch 6365595 contains the fix for adgetlnxver.sh file. The procedure below is a guideline for replacing the adgetlnxver.sh file in the
Oracle Applications 11i ship home.

Merging existing APPL_TOPs into a single APPL_TOP
In preparation for sharing a file system in an existing system with multiple APPL_TOPs, you can use the Rapid Clone utility to merge the multiple APPL_TOP (and COMMON_TOP) file systems into a single APPL_TOP file system. See Oracle MetaLink Doc ID: 230672.1 for more information. Oracle
recommends that the different APPL_TOPs should be merged into a completely new APPL_TOP to facilitate rollback incase of merge failure.
Note : We have considered Web Node ie 192.168.200.3 as our primary node (Node A mentioned in below steps)

Step 2: Maintain snapshot information
Log in to each application tier node as the APPLXXX user and run the maintain snapshot task in AD Administration.

Step 3: Merge existing APPL_TOPs
I) Prepare the source system application tier for merging
Choose one of the source system nodes to be the primary node. This document refers to it as “Node A”.
o Log in to Node A as the APPLXXX (applprod in our case) user and run:
$ cd /admin/scripts/
$ perl adpreclone.pl appsTier merge
This will create clone directory under $COMMON_TOP on 192.168.200.3

o Log in as the APPLMGR user to each of the secondary nodes being merged and run:
$ cd /admin/scripts/
$ perl adpreclone.pl appltop merge

This will create clone directory under $COMMON_TOP on 192.168.200.2

Step 4: Perform Backup of Source System
II) Copy the Source System to the Target System
Copy the application tier file system from the source Applications system to the target node by executing the following steps in the order listed. Ensure the application tier files copied to the target system are owned by the target APPLXXX user, and that the database tier files are owned by the ORAXXX user.

III) Create a copy of Node A (preferred)
If you want to place the merged APPL_TOPs in a new location instead of using an existing APPL_TOP location, create a copy of Node A (the other nodes in the system do not need to be copied). Include the following directories from Node A:

Step 5: Restore the backup on Target Node

IV) Copy the database tier file system
Log on to the source system database node as the ORACLE user.
• Perform a normal shutdown of the source system database
• Copy the database (DBF) files from the source to the target system
• Copy the source database ORACLE_HOME to the target system
• Start up the source Applications system database and application tier processes

V) Copy the required files for merging
Log in as the APPLMGR user to each source node and recursively copy:
directory /clone/appl
– to –
directory /clone/appl on Node A (or the copy of Node A).

VI) Configure target Database and Application
f. Configure the Target System
Execute the following commands to configure the target system.
You will be prompted for the target system specific values (SID, Paths, Ports, etc)
o Configure the target system database server
Log on to the target system as the ORACLE user and type the following commands
to configure and start the database:
cd /appsutil/clone/bin
perl adcfgclone.pl dbTier
o Configure the application tier server nodes
Log in to the merged APPL_TOP node as the APPLMGR user and execute the
following commands:
$ cd /clone/bin
$ perl adcfgclone.pl appsTier

Step 6: Finishing tasks
• Log in to the target system application tier node as the APPLMGR user.
• Run the following tasks in adadmin for all products:
o generate JAR files
o generate message files
o relink executables
o copy files to destination
• Depending on which tier you chose as the primary node, certain files may be missing. Run
adadmin to verify files required at runtime. If any files are listed as missing files, you must
manually copy them to the merged APPL_TOP.
• Remove the temporary directory /clone/appl to reduce disk space usage.
• Update Profile options
• Update Printer Settings
• Update the workflow configuration settings
• Verify the APPLCSF variable setting
• Update the session_cookie_domain value in icx_parameters

Reference Metalink Note :
316806.1 – Oracle Applications Installation Update Notes, Release 11i (11.5.10.2)
233428.1 – Sharing the Application Tier File System in Oracle Applications 11i
230672.1 – Cloning Oracle Applications Release 11i with Rapid Clone

How to reset or Unlock the orcladmin password


Recently while upgrading Discoverer to 10.1.2.3 CP4 , we got stuck at one of the step.
This step asks for orcladmin password which was not known to us.

So , we need to reset that password.Here are the steps which we followed ;

Error:
orcladmin password lost or account locked

Cause:
orcladmin password not known to us.

Solution :
1. Login as OAS user [ here testbi ] and
sqlplus “/as sysdba”
SQL>> alter user ODS identified by [new password]

2. Execute $ORACLE_HOME/bin/oidpasswd create_wallet=true

3. oidpasswd connect=[connect string] change_oiddb_pwd=true
This will prompt us for old password and new password.
old password you can give the same as ODS user and unique new password.

4. To unlock the orcladmin account :
oidpasswd connect=[connect string] unlock_su_acct=trueThis will prompt for password ; enter the ODS password.Which will inturn unlock your orcladmin account.

5. To reset the password :
oidpasswd connect=[connect string] reset_su_password=true
This will prompt for new password. [keep the password same as ODS user.] and your are done.

You have successfully changed the orcladmin password.
Now, to test the password :
cd $ORACLE_HOME/bin/oidadmin
The window will prompt for orcladmin password.

Refer : http://eldapo.blogspot.com/2007/08/forcing-orcladmin-password.html

How To Reset the oc4jadmin password in R12


While upgrading our Tech Stack to 10.1.3.4 on RHEL 5 for EBS 12.0.4 the oui prompts for oc4jadmin’s password, if you don’t know the password below steps can be followed to reset OC4JADMIN password

Steps:

1 : Login as Application User (applxxx)
2 : cd $IAS_ORACLE_HOME/j2ee/home/config
3 : cp -rp system-jazn-data.xml system-jazn-data.xml_orig
4 : vi system-jazn-data.xml
5 : edit the following section ::

>> the credentials part with “!” sign followed with the password

[user]
[name]oc4jadmin[/name]
[display-name]OC4J Administrator[/display-name]
[description]OC4J Administrator[/description]
[credentials]!password123[/credentials]
[/user]

Save this file and restart your OPMN Services “opmnctl startall”

Reference : Metalink Note 576587.1