R12210 Apps Clone between OCI Compute Nodes

  1. Install OS Pre-requisites on CM, APP nodes(Target)

Login to AM501AMERAP0005 and AM501AMERAP0006 as “root” user 

# yum update 

# yum install oracle-ebs-server-R12-preinstall 

Create a softlink as “root” user as below on Target CM/Web nodes – AM501AMERAP0005 and AM501AMERAP0006 

[root@AM501AMERAP0005 lib]#  cd /usr/lib 

[root@AM501AMERAP0005 lib]#  ln -s libXm.so.4.0.4 libXm.so.2 

[root@AM501AMERAP0005 lib]# ls -s libXm.so.4.0.4 libXm.so.2 

   0 libXm.so.2  2728 libXm.so.4.0.4 

[root@AM501AMERAP0005 lib]# ls -ltr libXm.so.2 

lrwxrwxrwx 1 root root 14 May 12 16:40 libXm.so.2 -> libXm.so.4.0.4 

[root@AM501AMERAP0005 lib]# 

2. Running Pre-Clone on the Source Apps Tier(s) and DB Tier 

This was already done in my DB manual clone blog. Just need to validate if it is done.

3. Target DB must be already cloned along with Post DB refresh steps as in my DB manual clone bloghttps://wordpress.com/post/orama.blog/1766

4. Run Post Clone Steps on Target Application Server (Apps Tier ) https://wordpress.com/post/orama.blog/1766

5. Run Post Clone Steps on Target Application Server (Apps Tier ) 

cd /u01 

tar -xvzf /BACKUPS/R12Clone/runfilesystem_fs1_ebs.gtar.gz 

It should create directory like /u01/install/APPS/fs1/EBSapps 

  • Create below directories(if not in place) on AM501AMERAP0005 and match the ownership/permission from Source Admin Server(AM501AMERAP0001) 

/u01/app/oraInventory 

/u01/install/APPS/fs1 

/u01/install/APPS/fs2 

/u01/install/APPS/fs_ne 

  • Execute adcfgclone.pl appsTier dualfs 

echo $FILE_EDITION 

run  

cd $COMMON_TOP/clone/bin/ 

perl adcfgclone.pl appsTier dualfs 

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

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

Target System Database SID : TEST 

Target System Database Server Node [am501amerap0005] : am501amerdb0002 

Target System Database Domain Name [ad.global] : 

Target System Base Directory : /u01/install/APPS 

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 Other File System Fusion Middleware Home set to /u01/install/APPS/fs2/FMW_Home 

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

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

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

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

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

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

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

Target System Current File System Instance Top set to /u01/install/APPS/fs1/inst/apps/TEST_am501amerap0005 

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

Target System Root Service [enabled] : 

Target System Web Entry Point Services [disabled] : enabled 

Target System Web Application Services [disabled] : enabled 

Target System Batch Processing Services [enabled] : enabled 

Target System Other Services [disabled] : 

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

Validating if the source port numbers are available on the target system.. 

Complete port information available at /u01/install/APPS/fs1/EBSapps/comn/clone/bin/out/TEST_am501amerap0005/portpool.lst 

Target System proxy port [80] : 

The new APPL_TOP context file has been created : 

  /u01/install/APPS/fs1/inst/apps/TEST_am501amerap0005/appl/admin/TEST_am501amerap0005.xml 

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

Creating Patch file system context file….. 

Log file located at /u01/install/APPS/fs1/EBSapps/comn/clone/bin/CloneContextPatch_0511180352.log 

Target System Other File System Instance Top set to /u01/install/APPS/fs2/inst/apps/TEST_am501amerap0005 

Validating if the source port numbers are available on the target system.. 

Complete port information available at /u01/install/APPS/fs1/EBSapps/comn/clone/bin/out/TEST_am501amerap0005/portpool.lst 

The new APPL_TOP context file has been created : 

  /u01/install/APPS/fs2/inst/apps/TEST_am501amerap0005/appl/admin/TEST_am501amerap0005.xml 

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

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

Running: FMW pre-req check… 

Configuring: Run file system…. 

LogFile located at /u01/install/APPS/fs1/inst/apps/TEST_am501amerap0005/admin/log/clone/run/RCloneApplyAppstier_05111804.log 

<May 11, 2022 6:45:47 PM GMT> <Warning> <JNDI> <BEA-050001> <WLContext.close() was called in a different thread than the one in which it was created.> 

<May 11, 2022 6:54:55 PM GMT> <Warning> <JNDI> <BEA-050001> <WLContext.close() was called in a different thread than the one in which it was created.> 

Configuring: Patch file system…. 

LogFile located at /u01/install/APPS/fs1/inst/apps/TEST_am501amerap0005/admin/log/clone/patch/RCloneApplyAppstier_05111854.log 

<May 11, 2022 8:26:26 PM GMT> <Warning> <JNDI> <BEA-050001> <WLContext.close() was called in a different thread tha                                                                                  n the one in which it was created.> 

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

  • Shutdown EBS services and make below changes highlighted in YELLLOW to “RUN” filesystem context file. Ensure you take a backup before making changes.  Execute autoconfig on run filesystem after the changes.  

[applmgr@AM501AMERAP0005 ~]$. EBSapps.env run 

[applmgr@AM501AMERAP0005 ~]$ diff /u01/install/APPS/fs1/inst/apps/TEST_am501amerap0005/appl/admin/TEST_am501amerap0005.xml /u01/install/APPS/fs1/inst/apps/TEST_am501amerap0005/appl/admin/TEST_am501amerap0005.xml05122022 

148c148 

<          <EndUserMonitoringURL oa_var=”s_endUserMonitoringURL”>http://am501amerap0005.ad.global:8000/oracle_smp_chronos/oracle_smp_chronos_sdk.gif</EndUserMonitoringURL> 

>          <EndUserMonitoringURL oa_var=”s_endUserMonitoringURL”>http://am501amerap0005.ad.global:4443/oracle_smp_chronos/oracle_smp_chronos_sdk.gif</EndUserMonitoringURL> 

199c199 

<          <externURL oa_var=”s_external_url”>http://am501amerap0005.ad.global:8000</externURL> 

>          <externURL oa_var=”s_external_url”>http://am501amerap0005.ad.global:4443</externURL> 

236c236 

<          <login_page oa_var=”s_login_page”>http://am501amerap0005.ad.global:8000/OA_HTML/AppsLogin</login_page> 

>          <login_page oa_var=”s_login_page”>http://am501amerap0005.ad.global:4443/OA_HTML/AppsLogin</login_page> 

815c815 

<       <activewebport oa_var=”s_active_webport” oa_type=”DUP_PORT” base=”8000” step=”1” range=”-1” label=”Active Web Port”>8000</activewebport> 

>       <activewebport oa_var=”s_active_webport” oa_type=”DUP_PORT” base=”8000” step=”1” range=”-1” label=”Active Web Port”>4443</activewebport> 

[applmgr@AM501AMERAP0005 ~]$ 

[applmgr@AM501AMERAP0005 admin]$ cat $CONTEXT_FILE |egrep ‘s_opmnstatus|s_apcstatus|s_oacorestatus|s_formsstatus|s_oafmstatus|s_web_entry_status|s_web_applications_status’ 

<oa_service_status oa_var=”s_opmnstatus”>enabled</oa_service_status> 

<oa_service_status oa_var=”s_apcstatus”>enabled</oa_service_status> 

<oa_service_status oa_var=”s_oacorestatus”>enabled</oa_service_status> 

<oa_service_status oa_var=”s_formsstatus”>enabled</oa_service_status> 

<oa_service_status oa_var=”s_oafmstatus”>enabled</oa_service_status> 

<oa_service_group_status oa_var=”s_web_entry_status”>enabled</oa_service_group_status> 

<oa_service_group_status oa_var=”s_web_applications_status”>enabled</oa_service_group_status> 

[applmgr@AM501AMERAP0005 admin]$ cd $ADMIN_SCRIPTS_HOME 
[applmgr@AM501AMERAP0005 admin]$./adautocfg.sh 

  • Ensure EBS services are down and make above changes highlighted in YELLLOW to “PATCH” filesystem context file. Ensure you take a backup before making changes 

Connect to sqlplus using system user. 

. EBSapps.env run 
sqlplus system/manager 
alter trigger ebs_logon disable; 
 
 

. EBSapps.env patch 

Source Patch file system  
cd $ADMIN_SCRIPTS_HOME 
./adautocfg.sh  

. EBSapps.env run 

sqlplus system/manager 
alter trigger ebs_logon enable; 

6. Start EBS Clone Environment and Validate Single node EBS and DB node 

Start the EBS services from “run” filesystem and validate the front-end forms. “SYSADMIN” password is same as Source 

http://am501amerap0005.ad.global:8000/OA_HTML/AppsLogin 

Shutdown EBS services after the validation 

7. Multi-node Architecture Conversion 

  1. Backup the $CONTEXT_FILE & perform following, 

  

The value of the variable s_atName is defaulted to the hostname of the primary application tier node.  

In addition to setting the s_atName to the hostname of the primary application tier, the value of the applications context variable “ s_shared_file_system” also need to be set to true.  

  

      

S_atName= AT_am501amerap0001 

s_shared_file_system=true 

  1. Autoconfig 

Run autoconfig post $CONTEXT_FILE changes 

  1. Source Patch_fs 

./EBSapps.ev patch 

  1. Patch FS 

Update the Patch $CONTEXT_FILE  

  1. Update the DB 

[applmgr@AM501AMERAP0005 ~]$ $ADJVAPRG oracle.apps.ad.autoconfig.oam.CtxSynchronizer action=upload contextfile=/u01/install/APPS/fs2/inst/apps/TEST_am501amerap0005/appl/admin/TEST_am501amerap0005.xml logfile=/tmp/patchctxupload.log 

                ————————————————————————————————————————– 

                [applmgr@AM501AMERAP0005 ~]$ cat /tmp/patchctxupload.log 

                   ADX Database Utility 

getConnectionUsingAppsJDBCConnector() à 

    APPS_JDBC_URL=’jdbc:oracle:thin:@(DESCRIPTION=(ADDRESS_LIST=(LOAD_BALANCE=YES)(FAILOVER=YES)(ADDRESS=(PROTOCOL=tcp)(HOST=am501amerdb0002.ad.global)(PORT=1521)))(CONNECT_DATA=(SERVICE_NAME=TEST)))’ 

    Trying to connect using APPS_JDBC_URL 

    Connection obtained. 

——————-ADX Database Utility Finished————— 

                   ADX Database Utility 

getConnectionUsingAppsJDBCConnector() à 

    APPS_JDBC_URL=’jdbc:oracle:thin:@(DESCRIPTION=(ADDRESS_LIST=(LOAD_BALANCE=YES)(FAILOVER=YES)(ADDRESS=(PROTOCOL=tcp)(HOST=am501amerdb0002.ad.global)(PORT=1521)))(CONNECT_DATA=(SERVICE_NAME=TEST)))’ 

    Trying to connect using APPS_JDBC_URL 

    Connection obtained. 

——————-ADX Database Utility Finished————— 

[applmgr@AM501AMERAP0005 ~]$ 

  1. Run fs_clone on “run” file system 

adop phase=fs_clone 

adop -status 

  1. Start admin server on the run_fs 

$INST_TOP/admin/scripts/adadminsrvctl.sh start 

  1. Start the adminserver on the patch_fs 

$INST_TOP/admin/scripts/adadminsrvctl.sh start forcepatchfs 

  1. Preclone on RUN FS 

$INST_TOP/admin/scripts/adpreclone.pl appsTier 

  1. Preclone on PATCH FS 

$INST_TOP/admin/scripts/adpreclone.pl appsTier 

  1. Stop firewalld on AM501AMERAP0005 and AM501AMERAP0006 

sudo systemctl status firewalld 

sudo systemctl stop firewalld 

  1. Adding Connection Filter Rule for a new Application tier node – Run Filesystem 

java -cp $CLASSPATH:/u01/install/APPS/fs1/FMW_Home/wlserver_10.3/server/lib/weblogic.jar oracle.apps.ad.tools.configuration.RegisterNodePreReq add-filter-rule -contextfile /u01/install/APPS/fs1/inst/apps/TEST_am501amerap0005/appl/admin/TEST_am501amerap0005.xml -hostname AM501AMERAP0006.ad.global 

[applmgr@AM501AMERAP0005 ~]$ . EBSapps.env 

  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: am501amerdb0002.ad.global  Service/SID: TEST 

  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@AM501AMERAP0005 ~]$ pwd 

/home/applmgr 

[applmgr@AM501AMERAP0005 ~]$ java -cp $CLASSPATH:/u01/install/APPS/fs1/FMW_Home/wlserver_10.3/server/lib/weblogic.jar oracle.apps.ad.tools.configuration.RegisterNodePreReq add-filter-rule -contextfile /u01/install/APPS/fs1/inst/apps/TEST_am501amerap0005/appl/admin/TEST_am501amerap0005.xml -hostname AM501AMERAP0006.ad.global 

For details please refer log file /home/applmgr/RegisterNodePreReq.log 

Enter the WebLogic Server Admin Password: 

add-filter-rule option executed successfully. 

[applmgr@AM501AMERAP0005 ~]$ cat /home/applmgr/RegisterNodePreReq.log 

Validated the passed arguments for the option add-filter-rule 

Validating hostname :AM501AMERAP0006.ad.global 

Validating the AM501AMERAP0006.ad.global :true 

Existing Connection Filter rules: 

[am501amerap0005.ad.global * * allow, 0.0.0.0/0 * * deny] 

Updating Connection Filter rules: 

[am501amerap0005.ad.global * * allow, AM501AMERAP0006.ad.global * * allow   #MT, 0.0.0.0/0 * * deny] 

[applmgr@AM501AMERAP0005 ~]$ 

java -cp $CLASSPATH:/u01/install/APPS/fs1/FMW_Home/wlserver_10.3/server/lib/weblogic.jar oracle.apps.ad.tools.configuration.RegisterNodePreReq add-filter-rule -contextfile /u01/install/APPS/fs1/inst/apps/TEST_am501amerap0005/appl/admin/TEST_am501amerap0005.xml -hostname am501amerap0006.ad.global 

[applmgr@AM501AMERAP0005 Heema]$ java -cp $CLASSPATH:/u01/install/APPS/fs1/FMW_Home/wlserver_10.3/server/lib/weblogic.jar oracle.apps.ad.tools.configuration.RegisterNodePreReq add-filter-rule -contextfile /u01/install/APPS/fs1/inst/apps/TEST_am501amerap0005/appl/admin/TEST_am501amerap0005.xml -hostname am501amerap0006.ad.global^C 

[applmgr@AM501AMERAP0005 Heema]$ ls -ltr /u01/install/APPS/fs1/FMW_Home/wlserver_10.3/server/lib/weblogic.jar 

-rwxr-x— 1 applmgr oinstall 36339849 May 11 18:15 /u01/install/APPS/fs1/FMW_Home/wlserver_10.3/server/lib/weblogic.jar 

[applmgr@AM501AMERAP0005 Heema]$ ls -ltr /u01/install/APPS/fs1/inst/apps/TEST_am501amerap0005/appl/admin/TEST_am501amerap0005.xml 

-rw-r–r–1 applmgr oinstall 121325 May 12 17:48 /u01/install/APPS/fs1/inst/apps/TEST_am501amerap0005/appl/admin/TEST_am501amerap0005.xml 

[applmgr@AM501AMERAP0005 Heema]$ java -cp $CLASSPATH:/u01/install/APPS/fs1/FMW_Home/wlserver_10.3/server/lib/weblogic.jar oracle.apps.ad.tools.configuration.RegisterNodePreReq add-filter-rule -contextfile /u01/install/APPS/fs1/inst/apps/TEST_am501amerap0005/appl/admin/TEST_am501amerap0005.xml -hostname am501amerap0006.ad.global 

For details please refer log file /home/applmgr/Heema/RegisterNodePreReq.log 

Enter the WebLogic Server Admin Password: 

add-filter-rule option executed successfully. 

[applmgr@AM501AMERAP0005 Heema]$ cat /home/applmgr/Heema/RegisterNodePreReq.log 

Validated the passed arguments for the option add-filter-rule 

Validating hostname :am501amerap0006.ad.global 

Validating the am501amerap0006.ad.global :true 

Existing Connection Filter rules: 

[am501amerap0005.ad.global * * allow, AM501AMERAP0006.ad.global * * allow   #MT, 0.0.0.0/0 * * deny] 

Updating Connection Filter rules: 

[am501amerap0005.ad.global * * allow, AM501AMERAP0006.ad.global * * allow   #MT, am501amerap0006.ad.global * * allow   #MT, 0.0.0.0/0 * * deny] 

[applmgr@AM501AMERAP0005 Heema]$ 

  1. Adding Connection Filter Rule for a new Application tier node – Patch Filesystem 

. EBSenv Patch 

java -cp $CLASSPATH:/u01/install/APPS/fs2/FMW_Home/wlserver_10.3/server/lib/weblogic.jar oracle.apps.ad.tools.configuration.RegisterNodePreReq add-filter-rule -contextfile /u01/install/APPS/fs2/inst/apps/TEST_am501amerap0005/appl/admin/TEST_am501amerap0005.xml -hostname AM501AMERAP0006.ad.global 

java -cp $CLASSPATH:/u01/install/APPS/fs2/FMW_Home/wlserver_10.3/server/lib/weblogic.jar oracle.apps.ad.tools.configuration.RegisterNodePreReq add-filter-rule -contextfile /u01/install/APPS/fs2/inst/apps/TEST_am501amerap0005/appl/admin/TEST_am501amerap0005.xml -hostname am501amerap0006.ad.global 

  1. Enable SSH connectivity 

Enable SSH connectivity between the nodes 

                Login as applmgr 

                 cd $HOME 

cd .ssh 

ssh-keygen -t rsa on each node and take defaults 

Login to AM501AMERAP0005: cp id_rsa.pub id_rsa.pub_cm 

Login to AM501AMERAP0006: cp id_rsa.pub id_rsa.pub_app 

scp id_rsa.pub_cm from AM501AMERAP0005 to AM501AMERAP0006 

scp id_rsa.pub_app from AM501AMERAP006 to AM501AMERAP0005 

mv authorized_keys authorized_keys_bkp 

for the AM501AMERAP0005/ AM501AMERAP0006 

cat id_rsa.pub>authorized_keys 

  

scp id_rsa.pub_cm from AM501AMERAP0005 to AM501AMERAP0006 

scp id_rsa.pub_app from AM501AMERAP006 to AM501AMERAP0005 

On AM501AMERAP0005 

cat id_rsa.pub_app>>authorized_keys 

On AM501AMERAP0006 

cat id_rsa.pub_cm>> authorized_keys 

  

Validate the ssh connectivity 

On AM501AMERAP0005 

ssh AM501AMERAP0005 – Self ssh 

ssh AM501AMERAP0006  

On AM501AMERAP0006 

ssh AM501AMERAP0006  – Self ssh  

ssh AM501AMERAP0005 

  1. Prepare the pair file 

/BACKUPS/TEST/TEST_am501amerap0005_run.txt 

  1. Set the env on the new node 

On the app node, perform the following. 

  

[applmgr@AM501AMERAP0006 ~]$ export PATH=/u01/install/APPS/fs1/FMW_Home/webtier/perl/bin:$PATH 

[applmgr@AM501AMERAP0006 ~]$ cd /u01/install/APPS/fs1/EBSapps/comn/clone/bin 

[oracle@am501amerdb0002 ETCC]$ sh checkDBpatch.sh 

[applmgr@AM501AMERAP0005 ETCC]$ sh checkMTpatch.sh 

  1. Add node 

/u01/install/APPS/fs1/FMW_Home/webtier/perl/bin/perl ./adclonectx.pl addnode contextfile=/u01/install/APPS/fs1/inst/apps/TEST_am501amerap0005/appl/admin/TEST_am501amerap0005.xml pairsfile=/BACKUPS/TEST/TEST_am501amerap0005_run.txt dualfs=yes 

[applmgr@AM501AMERAP0006 ~]$ export PATH=/u01/install/APPS/fs1/FMW_Home/webtier/perl/bin:$PATH 

[applmgr@AM501AMERAP0006 ~]$ cd /u01/install/APPS/fs1/EBSapps/comn/clone/bin 

[applmgr@AM501AMERAP0006 bin]$ /u01/install/APPS/fs1/FMW_Home/webtier/perl/bin/perl ./adclonectx.pl addnode contextfile=/u01/install/APPS/fs1/inst/apps/TEST_am501amerap0005/appl/admin/TEST_am501amerap0005.xml pairsfile=/BACKUPS/TEST/TEST_am501amerap0005_run.txt dualfs=yes 

                     Copyright I 2011, 2015 Oracle Corporation 

                        Redwood Shores, California, USA 

                        Oracle E-Business Suite Rapid Clone 

                                 Version 12.2 

                      adclonectx Version 120.30.12020000.22 

Enter the APPS passwd : 

Enter the Weblogic AdminServer password : 

 Executing command: /u01/install/APPS/fs1/EBSapps/comn/clone/bin/../jre/bin/java -Xmx600M -Doracle.jdbc.autoCommitSpecCompliant=false -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::/u01/install/APPS/fs1/FMW_Home/wlserver_10.3/server/lib/weblogic.jar:/u01/install/APPS/fs1/EBSapps/comn/clone/bin/../jlib/wlfullclient.jar:/u01/install/APPS/fs1/EBSapps/comn/clone/bin/../jlib/wlclient.jar:/u01/install/APPS/fs1/EBSapps/comn/clone/bin/../jlib/wljmxclient.jar:/u01/install/APPS/fs1/EBSapps/comn/clone/bin/../jlib/ojmisc.jar:/u01/install/APPS/fs1/EBSapps/comn/clone/bin/../jlib/obfuscatepassword.jar:/u01/install/APPS/fs1/EBSapps/comn/clone/bin/../jlib/emCfg.jar oracle.apps.ad.clone.RCloneSFSAddNode -contextfile /u01/install/APPS/fs1/inst/apps/TEST_am501amerap0005/appl/admin/TEST_am501amerap0005.xml -configfile /BACKUPS/TEST/TEST_am501amerap0005_run.txt -machinelistenaddress am501amerap0006.ad.global -logdir /u01/install/APPS/fs1/EBSapps/comn/clone/bin/../FMW/logs/sfslog -promptmsg hide 

Verifying: Apps schema password 

Verifying: 

        pairsfile /BACKUPS/TEST/TEST_am501amerap0005_run.txt 

        Run file system AdminServer is running 

        Patch file system AdminServer is running 

        Run file system domain 

        Patch file system domain 

Executing: run clone context… 

Log file located at /u01/install/APPS/fs1/EBSapps/comn/clone/bin/../FMW/logs/sfslog/run/RCloneSFSAddNode_05131337.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 Other File System Fusion Middleware Home set to /u01/install/APPS/fs2/FMW_Home 

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

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

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

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

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

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

Target System Current File System Instance Top set to /u01/install/APPS/fs1/inst/apps/TEST_am501amerap0006 

Report file located at /u01/install/APPS/fs1/inst/apps/TEST_am501amerap0006/admin/out/portpool.lst 

The new APPL_TOP context file has been created : 

  /u01/install/APPS/fs1/inst/apps/TEST_am501amerap0006/appl/admin/TEST_am501amerap0006.xml 

contextfile=/u01/install/APPS/fs1/inst/apps/TEST_am501amerap0006/appl/admin/TEST_am501amerap0006.xml 

Configuring: run fs add node… 

Executing: patch clone context… 

Log file located at /u01/install/APPS/fs1/EBSapps/comn/clone/bin/../FMW/logs/sfslog/patch/RCloneSFSAddNode_05131344.log 

Target System Other File System Instance Top set to /u01/install/APPS/fs2/inst/apps/TEST_am501amerap0006 

Report file located at /u01/install/APPS/fs2/inst/apps/TEST_am501amerap0006/admin/out/portpool.lst 

The new APPL_TOP context file has been created : 

  /u01/install/APPS/fs2/inst/apps/TEST_am501amerap0006/appl/admin/TEST_am501amerap0006.xml 

contextfile=/u01/install/APPS/fs2/inst/apps/TEST_am501amerap0006/appl/admin/TEST_am501amerap0006.xml 

Configuring: patch fs add node… 

— Add node operation completed – 

Node am501amerap0006.ad.global has been added successfully 

[applmgr@AM501AMERAP0006 bin]$ 

  1. Run Autoconfig in the following order only  5-6-5 (CM-WEB-CM)  

7. Start EBS Clone Environment and Validate Multi-Node EBS and DB node 

  1. Start the EBS services from “run” filesystem and validate the front-end forms. “SYSADMIN” password is same as Source 

http://am501amerap0006.ad.global:8000/OA_HTML/AppsLogin 

Shutdown EBS services after the validation 

8. Load Balancer Setup and Configuration 

  1. Make changes to “run” filesystem context file to incorporate TEST LB URL – https://ebs.test.erp.oci.assaabloy.net:4443/OA_HTML/AppsLogin  

cat $CONTEXT_FILE| egrep ‘s_endUserMonitoringURL|s_external_url|s_webentryhost|s_webentrydomain|s_login_page|s_webentryurlprotocol|s_active_webport’ 

[applmgr@AM501AMERAP0005 .ssh]$ cat $CONTEXT_FILE| egrep ‘s_endUserMonitoringURL|s_external_url|s_webentryhost|s_webentrydomain|s_login_page|s_webentryurlprotocol|s_active_webport’ 

         <EndUserMonitoringURL oa_var=”s_endUserMonitoringURL”>https://ebs.test.erp.oci.assaabloy.net:4443/oracle_smp_chronos/oracle_smp_chronos_sdk.gif</EndUserMonitoringURL> 

         <externURL oa_var=”s_external_url”>https://ebs.test.erp.oci.assaabloy.net:4443</externURL> 

         <webentryhost oa_var=”s_webentryhost”>ebs.test.erp.oci</webentryhost> 

         <webentrydomain oa_var=”s_webentrydomain”>assaabloy.net</webentrydomain> 

         <login_page oa_var=”s_login_page”>https://ebs.test.erp.oci.assaabloy.net:4443/OA_HTML/AppsLogin</login_page> 

         <webentryurlprotocol oa_var=”s_webentryurlprotocol”>https</webentryurlprotocol> 

      <activewebport oa_var=”s_active_webport” oa_type=”DUP_PORT” base=”8000” step=”1” range=”-1” label=”Active Web Port”>4443</activewebport> 

[applmgr@AM501AMERAP0005 .ssh]$ 

  1. Run Autoconfig in the following order only  5-6-5 (CM-WEB-CM)  
  1. Update patch $CONTEXT_FILE 

Upload the Patch file system context file to the Database 

source patch File system 

$ADJVAPRG oracle.apps.ad.autoconfig.oam.CtxSynchronizer action=upload contextfile= /u01/install/APPS/fs2/inst/apps/TEST_am501amerap0005/appl/admin/TEST_am501amerap0005.xml logfile=/tmp/patchctxupload.log 

9. Final Steps 

  • Create all /interface/TEST directories on AM501AMERAP0005 and sub-directories as AM501AMERAP0001. /interface should be a FSS among all “3” nodes – AM501AMERAP0005, AM501AMERAP0006 and am501amerdb0002. 
  • Connect to PDB and Change all dba_directories location for “/interface/PROD/*” to “/interface/TEST/*” individually. Ensure all those directories are existing at Unix level with same permissions as AM501AMERAP0001. 

CREATE [OR REPLACE] DIRECTORY directory_name AS ‘path_name’; 

  • Request ASSA ABLOY Team to create SAMBA configuration for /interface/TEST mountpoint 
  • Validate oacore_server in the $CONTEXT_FILE 

[applmgr@AM501AMERAP0005 .ssh]$ grep -I oacore_server $CONTEXT_FILE 

      <oacore_server> 

      </oacore_server> 

         <oacore_server_ports oa_var=”s_oacore_server_ports”>oacore_server1:7201</oacore_server_ports> 

         <oacore_server_sslports oa_var=”s_oacore_server_sslports”/> 

            <oa_service_name oa_var=”s_oacorename” type=”managed_server”>oacore_server1</oa_service_name> 

            <oa_managed_server_name oa_var=”s_oacore_managed_servers”>oacore_server1</oa_managed_server_name> 

[applmgr@AM501AMERAP0005 .ssh]$ 

  • Start the admin server 

adadminsrvctl.sh start 

  • Create below directories for run and patch fs 

[applmgr@AM501AMERAP0006 servers]$ pwd 

/u01/install/APPS/fs1/FMW_Home/user_projects/domains/EBS_domain/servers 

[applmgr@AM501AMERAP0006 servers]$ mkdir -p oacore_server3/logs 

[applmgr@AM501AMERAP0006 servers]$ cd /u01/install/APPS/fs2/FMW_Home/user_projects/domains/EBS_domain/servers 

[applmgr@AM501AMERAP0006 servers]$ mkdir -p oacore_server3/logs 

  • Adding Additional Oacore 

Command : 

perl $AD_TOP/patch/115/bin/adProvisionEBS.pl ebs-create-managedserver -contextfile=/u01/install/APPS/fs1/inst/apps/TEST_am501amerap0006/appl/admin/TEST_am501amerap0006.xml -managedsrvname=oacore_server3 -servicetype=oacore -managedsrvport=7203 

[applmgr@AM501AMERAP0006 Heema]$ perl $AD_TOP/patch/115/bin/adProvisionEBS.pl ebs-create-managedserver -contextfile=/u01/install/APPS/fs1/inst/apps/TEST_am501amerap0006/appl/admin/TEST_am501amerap0006.xml -managedsrvname=oacore_server3 -servicetype=oacore -managedsrvport=7203 -logfile=/u01/install/APPS/fs1/FMW_Home/user_projects/domains/EBS_domain/servers/oacore_server3/logs/oacore3.log 

Enter the APPS Schema password: 

Enter the WebLogic AdminServer password: 

The logfile for this session is located at /u01/install/APPS/fs1/FMW_Home/user_projects/domains/EBS_domain/servers/oacore_server3/logs/oacore3.log 

ManagedServer oacore_server3 created successfully. 

[applmgr@AM501AMERAP0006 Heema]$ pwd 

/home/applmgr/Heema 

[applmgr@AM501AMERAP0006 Heema]$ ls -ltr 

total 0 

Command : 

perl $FND_TOP/patch/115/bin/txkSetAppsConf.pl -contextfile=$CONTEXT_FILE -configoption=addMS -oacore=am501amerap0006.ad.global:7203 

[applmgr@AM501AMERAP0006 Heema]$ perl $FND_TOP/patch/115/bin/txkSetAppsConf.pl -contextfile=$CONTEXT_FILE -configoption=addMS -oacore=am501amerap0006.ad.global:7203 

Enter apps schema password : 

*** LOG FILE: /u01/install/APPS/fs1/inst/apps/TEST_am501amerap0006/logs/appl/rgf/TXK/txkSetAppsConf_05150052.log *** 

[applmgr@AM501AMERAP0006 Heema]$ 

am501amerap0005.ad.global:17001/console 

  • Add entry in adop_sync.drv 

$ cd $APPL_TOP_NE/ad/custom/ 

$ ls 

adop_sync.drv 

$ cp adop_sync.drv adop_sync.drv_backup 

Add below two lines in adop_sync.drv 

# Custom Application sync # 

rsync -az %s_current_base%/EBSapps/appl/xxcus/ %s_other_base%/EBSapps/appl/xxcus 

  • Update JVM size for OPP 

OPP Manager 

select DEVELOPER_PARAMETERS from apps.FND_CP_SERVICES where SERVICE_ID = (select MANAGER_TYPE from apps.FND_CONCURRENT_QUEUES where CONCURRENT_QUEUE_NAME = ‘FNDCPOPP’); 

                Output should be as below 

DEVELOPER_PARAMETERS 

J:oracle.apps.fnd.cp.gsf.GSMServiceController:-mx2048m 

If note, please perform below 

SQL> update FND_CP_SERVICES set DEVELOPER_PARAMETERS = ‘J:oracle.apps.fnd.cp.gsf.GSMServiceController:-mx2048m’ where SERVICE_ID =(select MANAGER_TYPE from FND_CONCURRENT_QUEUES where CONCURRENT_QUEUE_NAME = ‘FNDCPOPP’); 

1 row updated. 

SQL>  select DEVELOPER_PARAMETERS from apps.FND_CP_SERVICES where SERVICE_ID = (select MANAGER_TYPE from apps.FND_CONCURRENT_QUEUES where CONCURRENT_QUEUE_NAME = ‘FNDCPOPP’); 

DEVELOPER_PARAMETERS 

J:oracle.apps.fnd.cp.gsf.GSMServiceController:-mx2048m 

SQL> SQL> commit; 

Commit complete. 

[applmgr@am501amerap0005]echo $AFJSMARG 

                -server -Xmx384m -Doracle.apps.fnd.common.Pool.leak.mode=stderr:off -verbose:gc 

  • Switch to Framework menus 

“Framework” menus are mandatory in R12. 

Check the Profile Option at the Site level: 

Self Service Personal Home Page mode = Framework only 

Check that no other values exist for this profile other than ‘FWK’ or ‘NONE’ : 

SQL> select PROFILE_OPTION_ID from fnd_profile_options where PROFILE_OPTION_NAME = ‘APPLICATIONS_HOME_PAGE’; 

PROFILE_OPTION_ID 

             7496 

SQL>select distinct PROFILE_OPTION_VALUE from fnd_profile_option_values where PROFILE_OPTION_ID =’6963’; 

PROFILE_OPTION_VALUE 

FWK 

NONE 

If any ‘PHP’ values exist, update those rows to ‘FWK’. 

SQL> update fnd_profile_option_values set PROFILE_OPTION_VALUE=’FWK’ where PROFILE_OPTION_ID = ‘1003494’ and PROFILE_OPTION_VALUE=’PHP’; 

SQL> select distinct PROFILE_OPTION_VALUE from fnd_profile_option_values where PROFILE_OPTION_ID = ‘1003494’; 

Emtek 

SQL> select PROFILE_OPTION_ID from fnd_profile_options where PROFILE_OPTION_NAME = ‘APPLICATIONS_HOME_PAGE’; 

PROFILE_OPTION_ID 

             7496 

SQL> select distinct PROFILE_OPTION_VALUE from fnd_profile_option_values where PROFILE_OPTION_ID =’7496’; 

PROFILE_OPTION_VALUE 

FWK_TREE 

NONE 

SQL> create table fnd_profile_option_values_Moh as select * from fnd_profile_option_values; 

Table created. 

SQL> select count(*) from fnd_profile_option_values; 

  COUNT(*) 

      7990 

SQL> select count(*) from fnd_profile_option_values_Moh; 

  COUNT(*) 

      7990 

SQL> update fnd_profile_option_values set PROFILE_OPTION_VALUE=’FWK’ where PROFILE_OPTION_ID = ‘7496’ and PROFILE_OPTION_VALUE=’FWK_TREE’; 

1 row updated. 

SQL> commit; 

Commit complete. 

SQL> pwd 

Ls 

PROFILE_OPTION_VALUE 

FWK 

NONE 

SQL> 

  • Set XML Publisher TEMP directory  

Add, or remove the end-date from XML Publisher Administrator responsibility for the SYSADMIN user if this responsibility is not available. 

Navigate> XML Publisher Administrator > Home > Administration. 

Self-service screen appears. 

Open : Properties > General 

Set Temporary Directory = /u01/install/APPS/fs1/EBSapps/comn/temp 

Save 

Close Window 

  • CARD connector post clone steps 

IBY: ECAPP URL : https://ebs.erp.oci.assaabloy.net:4443/OA_HTML/ibyecapp 
ICX: Oracle Payment Server URL : https://ebs.erp.oci.assaabloy.net:4443/OA_HTML/ibyecapp 
Database Wallet Directory : /home/oracle/dbwallet 

IBY: HTTP Proxy  — blank 

  • Execute grants  

execute dbms_java.grant_permission( ‘APPS’, ‘SYS:java.io.FilePermission’, ‘/interface/TEST/ARLockbox’, ‘read’ ); 

execute dbms_java.grant_permission( ‘APPS’, ‘SYS:java.io.FilePermission’, ‘/interface/TEST/PO_PROMSE_DATE_UPD’, ‘read’ ); 

execute dbms_java.grant_permission( ‘APPS’, ‘SYS:java.io.FilePermission’, ‘/interface/TEST/CustShipAddrUpd’, ‘read’ ); 

execute dbms_java.grant_permission( ‘APPS’, ‘SYS:java.io.FilePermission’, ‘/interface/TEST/AutoReceipt’, ‘read’ ); 

execute dbms_java.grant_permission( ‘APPS’, ‘SYS:java.io.FilePermission’, ‘/interface/TEST/InvShortage’, ‘read’ ); 

execute dbms_java.grant_permission( ‘APPS’, ‘SYS:java.io.FilePermission’, ‘/interface/TEST/MassPO’, ‘read’ ); 

execute dbms_java.grant_permission( ‘APPS’, ‘SYS:java.io.FilePermission’, ‘/interface/TEST/SO_DFF_Upd’, ‘read’ ); 

execute dbms_java.grant_permission( ‘APPS’, ‘SYS:java.io.FilePermission’, ‘/interface/TEST/SubInvTransfer’, ‘read’ ); 

execute dbms_java.grant_permission( ‘APPS’, ‘SYS:java.io.FilePermission’, ‘/interface/TEST/UPSTrack’, ‘read’ ); 

execute dbms_java.grant_permission( ‘APPS’, ‘SYS:java.io.FilePermission’, ‘/interface/TEST/ASN_INV’, ‘read’ ); 

execute dbms_java.grant_permission( ‘APPS’, ‘SYS:java.io.FilePermission’, ‘/interface/TEST/PO_PROMSE_DATE_UPD/*’, ‘read,write’ ); 

execute dbms_java.grant_permission( ‘APPS’, ‘SYS:java.io.FilePermission’, ‘/interface/TEST/CustShipAddrUpd/*’, ‘read,write’ ); 

execute dbms_java.grant_permission( ‘APPS’, ‘SYS:java.io.FilePermission’, ‘/interface/TEST/ARLockbox/*’, ‘read,write’ ); 

execute dbms_java.grant_permission( ‘APPS’, ‘SYS:java.io.FilePermission’, ‘/interface/TEST/AutoReceipt/*’, ‘read,write’ ); 

execute dbms_java.grant_permission( ‘APPS’, ‘SYS:java.io.FilePermission’, ‘/interface/TEST/InvShortage/*’, ‘read,write’ ); 

execute dbms_java.grant_permission( ‘APPS’, ‘SYS:java.io.FilePermission’, ‘/interface/TEST/MassPO/*’, ‘read,write’ ); 

execute dbms_java.grant_permission( ‘APPS’, ‘SYS:java.io.FilePermission’, ‘/interface/TEST/SO_DFF_Upd/*’, ‘read,write’ ); 

execute dbms_java.grant_permission( ‘APPS’, ‘SYS:java.io.FilePermission’, ‘/interface/TEST/SubInvTransfer/*’, ‘read,write’ ); 

execute dbms_java.grant_permission( ‘APPS’, ‘SYS:java.io.FilePermission’, ‘/interface/TEST/UPSTrack/*’, ‘read,write’ ); 

execute dbms_java.grant_permission( ‘APPS’, ‘SYS:java.io.FilePermission’, ‘/interface/TEST/ASN_INV/*’, ‘read,write’ ); 

You can verify by running below SQLs. 

select * from XXCUS_ARLKBX_FNAME_V; 

select * from XXCUS_AR_CUSTADDRUPD_FNAME_V; 

select * from XXCUS_AUTORECEIPT_FNAME_V; 

select * from XXCUS_PO_PRMISE_DATE_FNAME_V; 

select * from XXCUS_SO_DFFUPD_FNAME_V; 

select * from XXCUS_UPS_TRACK_FNAME_V; 

select * from XXCUS_SUBINV_TRANSF_FNAME_V; 

select * from XXCUS_ASN_INV_FNAME_V; 

select * from XXCUS_PO_MASSCRE_FNAME_V; 

select * from XXCUS_INV_SHORTG_FNAME_V; 

Appendix A

Update dba_directories 

SQL> col OWNER for a30 

SQL> col DIRECTORY_NAME for a40 

SQL> col DIRECTORY_PATH for a60 

SQL> set lines 200 pages 200 

SQL> select OWNER,DIRECTORY_NAME,DIRECTORY_PATH from dba_directories; 

OWNER                          DIRECTORY_NAME                           DIRECTORY_PATH 

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

SYS                            ORACLE_HOME                              / 

SYS                            ORACLE_BASE                              / 

SYS                            OPATCH_LOG_DIR                           /u01/app/oracle/product/12.1.0.2/dbhome_1/QOpatch 

SYS                            OPATCH_SCRIPT_DIR                        /u01/app/oracle/product/12.1.0.2/dbhome_1/QOpatch 

SYS                            DBMS_OPTIM_ADMINDIR                      /u01/app/oracle/product/12.1.0/dbhome_1/rdbms/admin 

SYS                            DBMS_OPTIM_LOGDIR                        /u01/app/oracle/product/12.1.0/dbhome_1/cfgtoollogs 

SYS                            DATA_PUMP_DIR                            /u01/app/oracle/product/12.1.0.2/dbhome_1/rdbms/log/ 

SYS                            OPATCH_INST_DIR                          /u01/app/oracle/product/12.1.0.2/dbhome_1/OPatch 

SYS                            ECX_UTL_LOG_DIR_OBJ                      /usr/tmp 

SYS                            APPS_DATA_FILE_DIR                       /u01/app/oracle/product/12.1.0.2/dbhome_1/appsutil/outbound/ 

                                                                        TEST_am501amerdb0002 

SYS                            ECX_UTL_XSLT_DIR_OBJ                     /usr/tmp 

SYS                            FND_DIAG_DIR                             /u01/TEMP/12.1.0/rdbms/log 

SYS                            WORK_DIR                                 /devl/ohome/10.2.0/work 

SYS                            PREUPGRADE_DIR                           /prod/ohome/10.2.0/cfgtoollogs/PEMTKI/preupgrade/ 

SYS                            AUDIT_DIR                                /tmp/ 

SYS                            AW_FILES                                 /home/oraprdn/migration 

SYS                            ORACLE_OCM_CONFIG_DIR                    /devl/ohome/10.2.0/ccr/state 

SYS                            UTL_FEDEX                                /mnt/fedex 

SYS                            EX_FILES                                 /home/oraprdn/migration 

SYS                            INVOICE_PDF_PATH1                        /interface/PROD/invoice_pdf_path 

SYS                            CUST_CSV                                 /interface/PROD/custcsv 

SYS                            TNWORK                                   /interface/PROD/TNWorking 

SYS                            ESKERWORK                                /interface/PROD/Esker 

SYS                            WORK                                     /interface/PROD/Working 

SYS                            LABEL_PRINT                              /interface/PROD/LABEL_PRINT 

SYS                            ASSAWORK                                 /interface/PROD/ASSA 

SYS                            ESKER_CUST_ADDR                          /interface/PROD/Esker_Cust_Addr 

SYS                            PREUPG_OUTPUT_DIR                        /prod/ohome/12c/cfgtoollogs/dbua/PEMTKI/upgrade1 

SYS                            BACKUP                                   /interface/PROD/Backup 

SYS                            EDI810                                   /interface/PROD/EDI/810 

SYS                            EDI850                                   /interface/PROD/EDI/850 

SYS                            SHBWORK                                  /interface/PROD/SHBWorking 

SYS                            AUTORECEIPT                              /interface/PROD/AutoReceipt 

SYS                            ASSAWORK_EMTEK                           /interface/PROD/ASSA 

SYS                            PO_PROMSE_DATE                           /interface/PROD/PO_PROMSE_DATE_UPD 

SYS                            ASSAWORK_SCHAUB                          /interface/PROD/ASSA/Schaub 

SYS                            TABLEDUMP                                /backup/PEMTKI/TABLEDUMP 

SYS                            SQLT$STAGE                               /u01/TEMP/CRPTKI/oracle/diag/rdbms/crptki_trgt/PROD/trace 

SYS                            TRCA$STAGE                               /u01/TEMP/CRPTKI/oracle/diag/rdbms/crptki_trgt/PROD/trace 

SYS                            SQLT$UDUMP                               /u01/TEMP/CRPTKI/oracle/diag/rdbms/crptki_trgt/PROD/trace 

SYS                            SQLT$BDUMP                               /u01/TEMP/CRPTKI/oracle/diag/rdbms/crptki_trgt/PROD/trace 

SYS                            SQLT$DIAG                                /u01/TEMP/CRPTKI/oracle/diag/rdbms/crptki_trgt/PROD/trace 

SYS                            TRCA$INPUT1                              /u01/TEMP/CRPTKI/oracle/diag/rdbms/crptki_trgt/PROD/trace 

SYS                            TRCA$INPUT2                              /u01/TEMP/CRPTKI/oracle/diag/rdbms/crptki_trgt/PROD/trace 

SYS                            TRACE_DIR_SRC_4_TCB                      /prod/ohome/12c/diag/rdbms/pemtki/PEMTKI/trace 

SYS                            OPATCH_TEMP_DIR                          /u01/app/oracle/product/12.1.0.2/dbhome_1/QOpatch 

SYS                            MASSPO                                   /interface/PROD/MassPO 

SYS                            CSR_XML_TOP                              /u01/install/APPS/fs1/EBSapps/appl/csr/12.0.0/patch/115/xml 

SYS                            ODPDIR                                   /tmp 

SYS                            CUSTSHIPADDRUPD                          /interface/PROD/CustShipAddrUpd 

SYS                            ASN_INV                                  /interface/PROD/ASN_INV 

SYS                            CRC                                      /interface/PROD/CRC 

SYS                            CUSTCSV                                  /interface/PROD/custcsv 

SYS                            INVSHORTAGE                              /interface/PROD/InvShortage 

SYS                            SO_DFF_UPD                               /interface/PROD/SO_DFF_Upd 

SYS                            SUBINV                                   /interface/PROD/SubInvTransfer 

SYS                            UPSTRACK                                 /interface/PROD/UPSTrack 

SYS                            UPSTXT                                   /interface/PROD/upstxt 

58 rows selected. 

SQL> 

SQL> show pdbs 

    CON_ID CON_NAME                       OPEN MODE  RESTRICTED 

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

         2 PDB$SEED                       READ ONLY  NO 

         3 TEST                           READ WRITE NO 

SQL> alter session set container=TEST; 

Session altered. 

CREATE OR REPLACE DIRECTORY INVOICE_PDF_PATH1  AS’/interface/TEST/invoice_pdf_path’; 

CREATE OR REPLACE DIRECTORY INVOICE_PDF_PATH1  AS ‘/interface/TEST/invoice_pdf_path’; 

CREATE OR REPLACE DIRECTORY CUST_CSV AS ‘/interface/TEST/custcsv’; 

CREATE OR REPLACE DIRECTORY TNWORK AS ‘/interface/TEST/TNWorking’; 

CREATE OR REPLACE DIRECTORY ESKERWORK AS ‘/interface/TEST/Esker’; 

CREATE OR REPLACE DIRECTORY WORK AS ‘/interface/TEST/Working’; 

CREATE OR REPLACE DIRECTORY LABEL_PRINT AS ‘/interface/TEST/LABEL_PRINT’; 

CREATE OR REPLACE DIRECTORY ASSAWORK  AS ‘/interface/TEST/ASSA’; 

CREATE OR REPLACE DIRECTORY ESKER_CUST_ADDR  AS ‘/interface/TEST/Esker_Cust_Addr’; 

CREATE OR REPLACE DIRECTORY BACKUP  AS ‘/interface/TEST/Backup’; 

CREATE OR REPLACE DIRECTORY EDI810  AS ‘/interface/TEST/EDI/810’; 

CREATE OR REPLACE DIRECTORY EDI850  AS ‘/interface/TEST/EDI/850’; 

CREATE OR REPLACE DIRECTORY SHBWORK  AS ‘/interface/TEST/SHBWorking’; 

CREATE OR REPLACE DIRECTORY AUTORECEIPT  AS ‘/interface/TEST/AutoReceipt’; 

CREATE OR REPLACE DIRECTORY ASSAWORK_EMTEK  AS ‘/interface/TEST/ASSA’; 

CREATE OR REPLACE DIRECTORY PO_PROMSE_DATE  AS ‘/interface/TEST/PO_PROMSE_DATE_UPD’; 

CREATE OR REPLACE DIRECTORY ASSAWORK_SCHAUB  AS ‘/interface/TEST/ASSA/Schaub’; 

CREATE OR REPLACE DIRECTORY MASSPO  AS ‘/interface/TEST/MassPO’; 

CREATE OR REPLACE DIRECTORY CUSTSHIPADDRUPD  AS ‘/interface/TEST/CustShipAddrUpd’; 

CREATE OR REPLACE DIRECTORY ASN_INV AS ‘/interface/TEST/ASN_INV’; 

CREATE OR REPLACE DIRECTORY CRC AS ‘/interface/TEST/CRC’; 

CREATE OR REPLACE DIRECTORY CUSTCSV AS ‘/interface/TEST/custcsv’; 

CREATE OR REPLACE DIRECTORY INVSHORTAGE AS ‘/interface/TEST/InvShortage’; 

CREATE OR REPLACE DIRECTORY SO_DFF_UPD AS ‘/interface/TEST/SO_DFF_Upd’; 

CREATE OR REPLACE DIRECTORY SUBINV AS ‘/interface/TEST/SubInvTransfer’; 

CREATE OR REPLACE DIRECTORY UPSTRACK AS ‘/interface/TEST/UPSTrack’; 

CREATE OR REPLACE DIRECTORY UPSTXT AS ‘/interface/TEST/upstxt’; 

Match APPLTMP to /utl/file/ 

Match APPLTMP to /utl/file/ 

Validate APPLTMP values at AM501AMERAP0005 and AM501AMERAP0006 

[applmgr@AM501AMERAP0005 .ssh]$ echo $APPLPTMP 

/usr/tmp 

[applmgr@AM501AMERAP0005 .ssh]$ 

[applmgr@AM501AMERAP0006 ~]$ echo $APPLPTMP 

/usr/tmp 

[applmgr@AM501AMERAP0006 ~]$ 

Issue the following at both cdb & pdb level 

SQL> alter system set utl_file_dir=’/usr/tmp’ scope=spfile; 

System altered. 

Bounce EBS and DB. 

POST Clone steps 

Create softlinks in $OA_HTML as below. 

[applmgr@AM501AMERAP0006 html]$ pwd 

/u01/install/APPS/fs1/FMW_Home/Oracle_EBS-app1/applications/oacore/html 

[applmgr@AM501AMERAP0006 html]$ ls -ltr|grep lrwx 

lrwxrwxrwx  1 applmgr oinstall        22 Aug 12 04:13 Backup -> /interface/TEST/Backup 

lrwxrwxrwx  1 applmgr oinstall        23 Aug 12 04:13 Working -> /interface/TEST/Working 

lrwxrwxrwx  1 applmgr oinstall        25 Aug 12 04:13 SHBBackup -> /interface/TEST/SHBBackup 

lrwxrwxrwx  1 applmgr oinstall        26 Aug 12 04:13 SHBWorking -> /interface/TEST/SHBWorking 

lrwxrwxrwx  1 applmgr oinstall        23 Aug 12 04:13 ASN_INV -> /interface/TEST/ASN_INV 

lrwxrwxrwx  1 applmgr oinstall        27 Aug 12 04:13 SHBOriginal -> /interface/TEST/SHBOriginal 

lrwxrwxrwx  1 applmgr oinstall        24 Aug 12 04:13 Original -> /interface/TEST/Original 

lrwxrwxrwx  1 applmgr oinstall        19 Aug 12 04:13 CRC -> /interface/TEST/CRC 

lrwxrwxrwx  1 applmgr oinstall        22 Aug 12 04:13 MassPO -> /interface/TEST/MassPO 

lrwxrwxrwx  1 applmgr oinstall        31 Aug 12 04:13 CustShipAddrUpd -> /interface/TEST/CustShipAddrUpd 

lrwxrwxrwx  1 applmgr oinstall        32 Aug 12 04:13 emtek_user_files -> /interface/TEST/emtek_user_files 

lrwxrwxrwx  1 applmgr oinstall        24 Aug 12 04:13 UPSTrack -> /interface/TEST/UPSTrack 

lrwxrwxrwx  1 applmgr oinstall        26 Aug 12 04:13 SO_DFF_Upd -> /interface/TEST/SO_DFF_Upd 

lrwxrwxrwx  1 applmgr oinstall        27 Aug 12 04:13 LABEL_PRINT -> /interface/TEST/LABEL_PRINT 

lrwxrwxrwx  1 applmgr oinstall        27 Aug 12 04:13 InvShortage -> /interface/TEST/InvShortage 

lrwxrwxrwx  1 applmgr oinstall        31 Aug 12 04:13 Esker_Cust_Addr -> /interface/TEST/Esker_Cust_Addr 

lrwxrwxrwx  1 applmgr oinstall        21 Aug 12 04:13 Esker -> /interface/TEST/Esker 

lrwxrwxrwx  1 applmgr oinstall        19 Aug 12 04:13 EDI -> /interface/TEST/EDI 

lrwxrwxrwx  1 applmgr oinstall        20 Aug 12 04:13 ASSA -> /interface/TEST/ASSA 

lrwxrwxrwx  1 applmgr oinstall        22 Aug 12 04:13 upstxt -> /interface/TEST/upstxt 

lrwxrwxrwx  1 applmgr oinstall        27 Aug 12 04:13 AutoReceipt -> /interface/TEST/AutoReceipt 

lrwxrwxrwx  1 applmgr oinstall        30 Aug 12 04:13 SubInvTransfer -> /interface/TEST/SubInvTransfer 

lrwxrwxrwx  1 applmgr oinstall        23 Aug 12 04:13 custcsv -> /interface/TEST/custcsv 

lrwxrwxrwx  1 applmgr oinstall        34 Aug 12 04:13 PO_PROMSE_DATE_UPD -> /interface/TEST/PO_PROMSE_DATE_UPD 

lrwxrwxrwx  1 applmgr oinstall        25 Aug 12 04:13 ARLockbox -> /interface/TEST/ARLockbox 

lrwxrwxrwx  1 applmgr oinstall        26 Aug 12 04:13 TNOriginal -> /interface/TEST/TNOriginal 

lrwxrwxrwx  1 applmgr oinstall        25 Aug 12 04:13 TNWorking -> /interface/TEST/TNWorking 

lrwxrwxrwx  1 applmgr oinstall        25 Aug 12 04:13 riverhead -> /interface/TEST/riverhead 

lrwxrwxrwx  1 applmgr oinstall        32 Aug 12 04:13 invoice_pdf_path -> /interface/TEST/invoice_pdf_path 

Published by heemasatapathy

Heema is currently working as Manager, Infrastructure and Cloud Solutions at Computer Technology Resources, Inc and oversees a team of Infrastructure and Cloud Experts performing complex upgrades and migrations to various cloud flavors including but not limited to OCI, AWS, Azure. She is a seasoned IT professional having worked worldwide - India, Japan, Malaysia, Singapore, Switzerland, and USA. She holds an Oracle Ace status and loves to be part of the community group.

One thought on “R12210 Apps Clone between OCI Compute Nodes”

  1. Pingback: R12.2.10 Manual DB Clone between VMDBs – Orama.blog

Leave a Reply

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

Gravatar
WordPress.com Logo

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

Facebook photo

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

Cancel

Connecting to %s