- 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
- 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
- Autoconfig
Run autoconfig post $CONTEXT_FILE changes
- Source Patch_fs
./EBSapps.ev patch
- Patch FS
Update the Patch $CONTEXT_FILE
- 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 ~]$
- Run fs_clone on “run” file system
adop phase=fs_clone
adop -status
- Start admin server on the run_fs
$INST_TOP/admin/scripts/adadminsrvctl.sh start
- Start the adminserver on the patch_fs
$INST_TOP/admin/scripts/adadminsrvctl.sh start forcepatchfs
- Preclone on RUN FS
$INST_TOP/admin/scripts/adpreclone.pl appsTier
- Preclone on PATCH FS
$INST_TOP/admin/scripts/adpreclone.pl appsTier
- Stop firewalld on AM501AMERAP0005 and AM501AMERAP0006
sudo systemctl status firewalld
sudo systemctl stop firewalld
- 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]$
- 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
- 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
- Prepare the pair file
/BACKUPS/TEST/TEST_am501amerap0005_run.txt
- 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
- 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]$
- 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
- 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
- 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]$
- Run Autoconfig in the following order only 5-6-5 (CM-WEB-CM)
- 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]$
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
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
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 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
Orama.blog 