methods to find information of all nodes configured in EBS R 12.2
1. EBS application Dashboard
2. select * from fnd_nodes
3. select * from adop_valid_nodes
4. adop -status
5. grep s_shared_file_system $CONTEXT_FILE :verify application configured on shared storage or not for (internal and external)
5.1. ls -ltrh $INST_TOP/..
ls ltr
To find all EBS_web logs on all nodes:
find $IAS_ORACLE_HOME/instances -iname EBS_web*.log
ls ltr $IAS_ORACLE_HOME/instances/EBS_web*/diagnostics/logs/OHS/EBS_web/EBS_web*.log
in this case it is under:
find $IAS_ORACLE_HOME/instances/EBS_web_OHS -iname EBS_web*.log
[applmgr@ebsprodapp3 EBS_web]$
[applmgr@ebsprodapp3 EBS_web]$ ls -ltr $IAS_ORACLE_HOME/instances/EBS_web_OHS/diagnostics/logs/OHS/EBS_web/EBS_web.log <-- master node log file app3
-rw-r-----. 1 applmgr oinstall 561673 Nov 20 13:17 /u01/OCI/fs2/FMW_Home/webtier/instances/EBS_web_OHS/diagnostics/logs/OHS/EBS_web/EBS_web.log
[applmgr@ebsprodapp3 EBS_web]$
[applmgr@ebsprodapp3 EBS_web]$
[applmgr@ebsprodapp3 EBS_web]$ ls -ltr $IAS_ORACLE_HOME/instances/EBS_web_OHS0/diagnostics/logs/OHS/EBS_web/EBS_web.log <-- slave node-1 log file app4
-rw-r-----. 1 applmgr oinstall 12484 Nov 19 01:51 /u01/OCI/fs2/FMW_Home/webtier/instances/EBS_web_OHS0/diagnostics/logs/OHS/EBS_web/EBS_web.log
[applmgr@ebsprodapp3 EBS_web]$
[applmgr@ebsprodapp3 EBS_web]$ ls -ltr $IAS_ORACLE_HOME/instances/EBS_web_OHS1/diagnostics/logs/OHS/EBS_web/EBS_web.log <-- DMZ slave node-2 log file app1
-rw-r-----. 1 applmgr oinstall 4794 Nov 19 01:51 /u01/OCI/fs2/FMW_Home/webtier/instances/EBS_web_OHS1/diagnostics/logs/OHS/EBS_web/EBS_web.log
as we are providing access to only master node i.e app3 we will monitor this file behavior
[applmgr@ebsprodapp3 EBS_web]$
[applmgr@ebsprodapp3 ~]$ find
$IAS_ORACLE_HOME/instances -iname EBS_web.log
[applmgr@ebsprodapp3 ~]$ find
$IAS_ORACLE_HOME/instances -iname apps.conf
/u01/OCI/fs2/FMW_Home/webtier/instances/EBS_web_OHS/config/OHS/EBS_web/apps.conf
/u01/OCI/fs2/FMW_Home/webtier/instances/EBS_web_OHS0/config/OHS/EBS_web/apps.conf
/u01/OCI/fs2/FMW_Home/webtier/instances/EBS_web_OHS1/config/OHS/EBS_web/apps.conf
[applmgr@ebsprodapp3 ~]$
[applmgr@ebsprodapp3 ~]$ ls
–ltrh $IAS_ORACLE_HOME/instances/EBS_web_OHS/config/OHS/EBS_web/apps.conf
[applmgr@ebsprodapp3 ~]$
[applmgr@ebsprodapp3 ~]$ cd
$IAS_ORACLE_HOME/instances/EBS_web_OHS/config/OHS/EBS_web
[applmgr@ebsprodapp3 EBS_web]$
[applmgr@ebsprodapp3 EBS_web]$ cp
apps.conf apps.conf_bkp1
select * from fnd_nodes
[applmgr@ebsprodapp3 ~]$ adop
-status
Enter the APPS password:
Connected.
==============================================================
ADOP (C.Delta.12)
Session Id: 25
Command: status
Output: /u01/OCI/fs_ne/EBSapps/log/adop/25/20211030_191429/adzdshowstatus.out
===============================================================
Node Name Node Type Phase Status Started Finished Elapsed
--------------- ---------- --------------- --------------- -------------------- -------------------- ------------
ebsprodapp master APPLY ACTIVE 2021/05/15 07:29:38 2021/05/15 07:34:55 0:05:17
3
CLEANUP NOT STARTED
ebsprodapp slave APPLY NOT STARTED
4
CLEANUP NOT STARTED
ebsprodpub slave APPLY NOT STARTED
app1
CLEANUP NOT STARTED
File System Synchronization Type: None
adop exiting with status = 0 (Success)
[applmgr@ebsprodapp3 ~]$
[applmgr@ebsprodapp3 ~]$ cd
$AD_TOP/patch/115/bin
[applmgr@ebsprodapp3 bin]$ perl adProvisionEBS.pl ebs-delete-node -contextfile=/u01/OCI/fs1/inst/apps/PRODPDB_ebsprodapp4/appl/admin/PRODPDB_ebsprodapp4.xml -hostname=ebsprodpubapp1.areefdba.com.sa -logfile=del.log
Enter the APPS Schema password:
Enter the WebLogic AdminServer password:
ERROR: An error has occurred. Refer to the log file del.log for details.
[applmgr@ebsprodpubapp1 ~]$ hostname
–f (fqdn of removing
node)
ebsprodpubapp1.prdappsn.cloudprdvcn1.oraclevcn.com
[applmgr@ebsprodpubapp1 ~]$
[applmgr@ebsprodapp3 bin]$
[applmgr@ebsprodapp3 bin]$ perl adProvisionEBS.pl
ebs-delete-node -contextfile=$CONTEXT_FILE -hostname=ebsprodpubapp1.prdappsn.cloudprdvcn1.oraclevcn.com
-logfile=delapp1.log (Can
this execute?)
[applmgr@ebsprodapp3 bin]$
[applmgr@ebsprodapp3 bin]$ perl adProvisionEBS.pl
ebs-delete-node -contextfile=$INST_TOP/appl/admin/PRODPDB_ebsprodapp3.xml
-hostname=ebsprodpubapp1.prdappsn.cloudprdvcn1.oraclevcn.com -logfile=del.log (Can this execute?)
[applmgr@ebsprodapp3 bin]$ perl
adProvisionEBS.pl ebs-delete-node -contextfile=/u01/OCI/fs1/inst/apps/PRODPDB_ebsprodapp3/appl/admin/PRODPDB_ebsprodapp3.xml
-hostname=ebsprodpubapp1.prdappsn.cloudprdvcn1.oraclevcn.com -logfile=del.log
Enter the APPS Schema password:
Enter the WebLogic AdminServer password:
Node deleted successfully.
[applmgr@ebsprodapp3 bin]$
============---------#######---------==============
select * from fnd_nodes
[applmgr@ebsprodapp3 scripts]$ adop
-status
Enter the APPS password:
Connected.
==============================================================
ADOP (C.Delta.12)
Session Id: 25
Command: status
Output: /u01/OCI/fs_ne/EBSapps/log/adop/25/20211030_202746/adzdshowstatus.out
===============================================================
Node Name Node Type Phase Status Started Finished Elapsed
--------------- ---------- --------------- --------------- -------------------- -------------------- ------------
ebsprodapp master APPLY ACTIVE 2021/05/15 07:29:38 2021/05/15 07:34:55 0:05:17
3
CLEANUP NOT STARTED
ebsprodapp slave APPLY NOT STARTED
4
CLEANUP NOT STARTED
File System Synchronization Type: None
adop exiting with status = 0 (Success)
[applmgr@ebsprodapp3 scripts]$
###################################################################################################
###################################################################################################
[applmgr@ebsprodapp3 bin]$ ssh
ebsprodpubapp1.prdappsn.cloudprdvcn1.oraclevcn.com
The authenticity of host 'ebsprodpubapp1.prdappsn.cloudprdvcn1.oraclevcn.com (172.168.10.2)' can't be established.
ECDSA key fingerprint is SHA256:mLXnfEkDT3vUXx/IlYhyHyc8TDvxmvlX8yvLvFMKxQQ.
ECDSA key fingerprint is MD5:be:fb:95:42:8a:da:26:92:0e:e8:c6:55:5e:01:18:eb.
Are you sure you want to continue connecting (yes/no)? yes
Warning: Permanently added 'ebsprodpubapp1.prdappsn.cloudprdvcn1.oraclevcn.com' (ECDSA) to the list of known hosts.
Last login: Sat Oct 30 16:12:28 2021
Context file "" is not valid
EBSapps.env: exiting with status 1 (Fail)
[applmgr@ebsprodpubapp1 ~]$ exit
logout
Connection to ebsprodpubapp1.prdappsn.cloudprdvcn1.oraclevcn.com closed.
[applmgr@ebsprodapp3 bin]$
[applmgr@ebsprodapp3 OCI]$ . /u01/OCI/EBSapps.env patch
E-Business Suite Environment Information
----------------------------------------
RUN File System : /u01/OCI/fs1/EBSapps/appl
PATCH File System : /u01/OCI/fs2/EBSapps/appl
Non-Editioned File System : /u01/OCI/fs_ne
DB Host: prd-scan.prddbsn.cloudprdvcn1.oraclevcn.com Service/SID: PRODPDB
Sourcing the PATCH File System ...
[applmgr@ebsprodapp3 OCI]$ adadminsrvctl.sh
start forcepatchfs
You are running adadminsrvctl.sh version 120.10.12020000.11
Enter the WebLogic Admin password:
Enter the APPS Schema password:
Starting WLS Admin Server...
Refer /u01/OCI/fs2/inst/apps/PRODPDB_ebsprodapp3/logs/appl/admin/log/adadminsrvctl.txt for details
AdminServer logs are located at /u01/OCI/fs2/FMW_Home/user_projects/domains/EBS_domain/servers/AdminServer/logs
adadminsrvctl.sh: exiting with status 0
adadminsrvctl.sh: check the logfile /u01/OCI/fs2/inst/apps/PRODPDB_ebsprodapp3/logs/appl/admin/log/adadminsrvctl.txt for more information ...
[applmgr@ebsprodapp3 OCI]$
[applmgr@ebsprodapp3 ~]$ vi
$EBS_DOMAIN_HOME/config/config.xml
[applmgr@ebsprodapp3 config]$
perl $AD_TOP/patch/115/bin/txkWLSConnectionFilterManager.pl -contextfile=$CONTEXT_FILE -option=add-filter-rule -hostname=ebsprodpubapp1.prdappsn.cloudprdvcn1.oraclevcn.com (Can this execute?)
[applmgr@ebsprodapp3 config]$
[applmgr@ebsprodapp3 config]$
perl
$AD_TOP/patch/115/bin/txkWLSConnectionFilterManager.pl
-contextfile=$INST_TOP/appl/admin/PRODPDB_ebsprodapp3.xml
-option=add-filter-rule -hostname=ebsprodpubapp1.prdappsn.cloudprdvcn1.oraclevcn.com (Can
this execute?)
[applmgr@ebsprodapp3 config]$
[applmgr@ebsprodapp3 config]$
[applmgr@ebsprodapp3 config]$ perl
$AD_TOP/patch/115/bin/txkWLSConnectionFilterManager.pl
-contextfile=/u01/OCI/fs1/inst/apps/PRODPDB_ebsprodapp3/appl/admin/PRODPDB_ebsprodapp3.xml
-option=add-filter-rule -hostname=ebsprodpubapp1.prdappsn.cloudprdvcn1.oraclevcn.com
Enter WLS Admin Password:
[applmgr@ebsprodapp3 config]$ echo
$FILE_EDITION
run
[applmgr@ebsprodapp3 config]$
[applmgr@ebsprodapp3 config]$
[applmgr@ebsprodapp3 config]$
[applmgr@ebsprodapp3 config]$ sqlplus
apps/appspasswd @$FND_TOP/patch/115/sql/txkChangeProfH.sql SERVRESP
SQL*Plus: Release 10.1.0.5.0 - Production on Sat Oct 30 20:41:40 2021
Copyright (c) 1982, 2005, Oracle. All rights reserved.
Connected to:
Oracle Database 12c Enterprise Edition Release 12.1.0.2.0 - 64bit Production
With the Partitioning, Real Application Clusters, Automatic Storage Management, OLAP,
Advanced Analytics and Real Application Testing options
Changing the hierarchy type for the Profile APPS_WEB_AGENT
Profile APPS_WEB_AGENT hierarchy type has been
successfully changed to SERVRESP
Changing the hierarchy type for the Profile APPS_SERVLET_AGENT
Profile APPS_SERVLET_AGENT hierarchy type has been
successfully changed to SERVRESP
Changing the hierarchy type for the Profile APPS_JSP_AGENT
Profile APPS_JSP_AGENT hierarchy type has been
successfully changed to SERVRESP
Changing the hierarchy type for the Profile APPS_FRAMEWORK_AGENT
Profile APPS_FRAMEWORK_AGENT hierarchy type has been
successfully changed to SERVRESP
Changing the hierarchy type for the Profile ICX_FORMS_LAUNCHER
Profile ICX_FORMS_LAUNCHER hierarchy type has been
successfully changed to SERVRESP
Changing the hierarchy type for the Profile ICX_DISCOVERER_LAUNCHER
Profile ICX_DISCOVERER_LAUNCHER hierarchy type has been
successfully changed to SERVRESP
Changing the hierarchy type for the Profile ICX_DISCOVERER_VIEWER_LAUNCHER
Profile ICX_DISCOVERER_VIEWER_LAUNCHER hierarchy type has been
successfully changed to SERVRESP
Changing the hierarchy type for the Profile HELP_WEB_AGENT
Profile HELP_WEB_AGENT hierarchy type has been
successfully changed to SERVRESP
Changing the hierarchy type for the Profile APPS_PORTAL
Profile APPS_PORTAL hierarchy type has been
successfully changed to SERVRESP
Changing the hierarchy type for the Profile CZ_UIMGR_URL
Profile CZ_UIMGR_URL hierarchy type has been
successfully changed to SERVRESP
Changing the hierarchy type for the Profile QP_PRICING_ENGINE_URL
Profile QP_PRICING_ENGINE_URL hierarchy type has been
successfully changed to SERVRESP
Changing the hierarchy type for the Profile TCF:HOST
Profile TCF:HOST hierarchy type has been
successfully changed to SERVRESP
Disconnected from Oracle Database 12c Enterprise Edition Release 12.1.0.2.0 - 64bit Production
With the Partitioning, Real Application Clusters, Automatic Storage Management, OLAP,
Advanced Analytics and Real Application Testing options
[applmgr@ebsprodapp3 config]$
###################################################################################################
###################################################################################################
[applmgr@ebsprodapp3 bin]$ cd
$ADMIN_SCRIPTS_HOME
[applmgr@ebsprodapp3 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.25
Enter the APPS User Password:
Enter the Weblogic AdminServer password :
Checking the status of the Oracle WebLogic Administration Server....
Running perl /u01/OCI/fs1/EBSapps/appl/ad/12.0.0/patch/115/bin/adProvisionEBS.pl ebs-get-serverstatus -contextfile=/u01/OCI/fs1/inst/apps/PRODPDB_ebsprodapp3/appl/admin/PRODPDB_ebsprodapp3.xml -servername=AdminServer -promptmsg=hide
The Oracle WebLogic Administration Server is up.
wlsDomainName: EBS_domain
WLS Domain Name is VALID.
Running:
perl /u01/OCI/fs1/EBSapps/appl/ad/12.0.0/bin/adclone.pl java=/u01/OCI/fs1/EBSapps/comn/util/jdk64 mode=stage stage=/u01/OCI/fs1/EBSapps/comn/clone component=appsTier method= appctx=/u01/OCI/fs1/inst/apps/PRODPDB_ebsprodapp3/appl/admin/PRODPDB_ebsprodapp3.xml showProgress
Setting the wls environment
Beginning application tier Stage - Sat Oct 30 19:55:42 2021
/u01/OCI/fs1/EBSapps/comn/util/jdk64/bin/java -Xmx600M -Doracle.jdbc.autoCommitSpecCompliant=false -DCONTEXT_VALIDATED=false -Doracle.installer.oui_loc=/oui -classpath /u01/OCI/fs1/FMW_Home/webtier/lib/xmlparserv2.jar:/u01/OCI/fs1/FMW_Home/webtier/jdbc/lib/ojdbc6.jar:/u01/OCI/fs1/EBSapps/comn/java/classes:/u01/OCI/fs1/FMW_Home/webtier/oui/jlib/OraInstaller.jar:/u01/OCI/fs1/FMW_Home/webtier/oui/jlib/ewt3.jar:/u01/OCI/fs1/FMW_Home/webtier/oui/jlib/share.jar:/u01/OCI/fs1/FMW_Home/webtier/../Oracle_EBS-app1/oui/jlib/srvm.jar:/u01/OCI/fs1/FMW_Home/webtier/jlib/ojmisc.jar:/u01/OCI/fs1/FMW_Home/wlserver_10.3/server/lib/weblogic.jar:/u01/OCI/fs1/FMW_Home/oracle_common/jlib/obfuscatepassword.jar oracle.apps.ad.clone.StageAppsTier -e /u01/OCI/fs1/inst/apps/PRODPDB_ebsprodapp3/appl/admin/PRODPDB_ebsprodapp3.xml -stage /u01/OCI/fs1/EBSapps/comn/clone -tmp /tmp -method CUSTOM -showProgress -nopromptmsg
Log file located at /u01/OCI/fs1/inst/apps/PRODPDB_ebsprodapp3/admin/log/clone/StageAppsTier_10301955.log
/ 20% completed
Completed Stage...
Sat Oct 30 20:09:17 2021
[applmgr@ebsprodapp3 scripts]$
[applmgr@ebsprodapp3 admin]$
[applmgr@ebsprodapp3 admin]$ cd
$INST_TOP/appl/admin
[applmgr@ebsprodapp3 admin]$ cp PRODPDB_ebsprodapp3.txt
mypairs_dmz.txt
[applmgr@ebsprodapp3 admin]$ vi
mypairs_dmz.txt
[applmgr@ebsprodapp3 admin]$
[applmgr@ebsprodapp3 admin]$ cat
mypairs_dmz.txt
# $Header: pairs_file_dualfsclone_ux_txt.tmp 120.0.12020000.2 2015/07/29 19:36:02 jmajumde noship $
# Copyright (c) 2005, 2015 Oracle and/or its affiliates.
# All rights reserved.
# Version 12.0.0
#
# This is a sample pairs file generated by the autoconfig tool based on the
# context values set on the primary application tier node.
# This pairs file can be modified and used when adding additional
# application tier nodes. Some of the parameters set in this pairs file
# assume that you are using a shared file system.
[Base]
s_base=/u01/OCI
s_current_base=/u01/OCI/fs1
s_other_base=/u01/OCI/fs2
s_ne_base=/u01/OCI/fs_ne
[General]
s_applptmp=/usr/tmp
s_appsgroup=oinstall
s_appsuser=applmgr
s_dbuser=oracle
s_dbgroup=oinstall
s_dbdomain=prddbsn.cloudprdvcn1.oraclevcn.com
s_at=/u01/OCI/fs1/EBSapps/appl
s_com=/u01/OCI/fs1/EBSapps/comn
s_tools_oh=/u01/OCI/fs1/EBSapps/10.1.2
s_weboh_oh=/u01/OCI/fs1/FMW_Home/webtier
s_fmw_home=/u01/OCI/fs1/FMW_Home
s_dbGlnam=PRODPDB
s_dbSid=PRODPDB
s_dbhost=prd-scan
s_clonestage=/u01/OCI/fs1/EBSapps/comn/clone
s_dbport=1521
s_options_symlinks=Options -FollowSymLinks
s_proxyhost=
s_proxybypassdomain=prdappsn.cloudprdvcn1.oraclevcn.com
s_proxyport=80
s_nonproxyhosts=
s_javamailer_imapdomainname=0.100.131
s_javamailer_imaphost=192
s_javamailer_reply_to=itinfotest@areefdba.com.sa
s_javamailer_outbound_user=itinfotest
s_smtphost=192
s_smtpdomainname=0.100.131
s_file_edition_type=run
s_port_pool=0
patch_s_port_pool=10
s_admhost=ebsprodapp3
s_atName=ebsprodapp3
s_shared_file_system=true
[Web Entry Point Configuration]
s_webentryurlprotocol=https
s_webentryhost=ebsprodapp
s_webentrydomain=areefdba.com.sa
s_active_webport=443
s_endUserMonitoringURL=http://ebsprodapp3.prdappsn.cloudprdvcn1.oraclevcn.com:8000/oracle_smp_chronos/oracle_smp_chronos_sdk.gif
s_external_url=https://ebsprodapp.areefdba.com.sa
s_login_page=https://ebsprodapp.areefdba.com.sa/OA_HTML/AppsLogin
[Instance Specific]
# Please provide values for the context variables listed below. On the source
# instance they are instantiated as shown in the comment section below.
# These values should only be used as reference to fill out the instance
# values for the new node.
#s_temp=/u01/OCI/fs1/inst/apps/PRODPDB_ebsprodapp3/temp
#s_contextname=PRODPDB_ebsprodapp3
#s_hostname=ebsprodapp3
#s_domainname=prdappsn.cloudprdvcn1.oraclevcn.com
#s_cphost=ebsprodapp3
#s_webhost=ebsprodapp3
#s_config_home=/u01/OCI/fs1/inst/apps/PRODPDB_ebsprodapp3
#s_inst_base=/u01/OCI
#s_display=ebsprodapp3:0.0
#s_forms-c4ws_display=ebsprodapp3:0.0
#s_ohs_instance=EBS_web_OHS
#s_webport=8000
#s_http_listen_parameter=8000
#s_https_listen_parameter=4453
s_temp=/u01/OCI/fs1/inst/apps/PRODPDB_ebsprodpubapp1/temp
s_contextname=PRODPDB_ebsprodpubapp1
s_hostname=ebsprodpubapp1
s_domainname=prdappsn.cloudprdvcn1.oraclevcn.com
s_cphost=ebsprodapp3
s_webhost=ebsprodpubapp1
s_config_home=/u01/OCI/fs1/inst/apps/PRODPDB_ebsprodpubapp1
s_inst_base=/u01/OCI
s_display=ebsprodpubapp1:0.0
s_forms-c4ws_display=ebsprodpubapp1:0.0
s_ohs_instance=EBS_web_OHS
s_webport=8000
s_http_listen_parameter=8000
s_https_listen_parameter=4453
[Services]
# Please provide values for the context variables listed below .
# Enter "enabled" without the quotes to enable the service on the new node .
# Enter "disabled" without the quotes to disable the service on the new node .
# The Root service include the Node Manager .
# The Web Application Services include the Node Manager, Admin Server,
# Managed Servers ( oacore, forms, oafm, formsc4-ws).
# To enable the configuration of Node Manager and the Managed Servers,
# set s_web_applications_status to enabled
# The Web Entry Services include the OPMN and Oracle HTTP Server .
# To enable the configuration of OPMN,OHS , set s_webentry_status and s_apcstatus to enabled.
# The Batch Processing Services include the FNDFS Listener, Concurrent Mgr, ICSM# and JTF FullFillment Server
# To enable the configuration of Concurrent Manager# set s_batch_status to enabled.
# The Other Services group include the Forms Metric Server, Forms Metric Clients# Forms Server for the socket mode configuration and Mobile Web Application
# Server (MWA).
# s_adminserverstatus is set to disabled since this service can only be enabled
# on the primary application tier.
# The services enabled on the primary application tier node are as shown
# below in the comment section.
[Services Enabled on the Primary Application Tier Node]
#s_web_applications_status=enabled
#s_web_entry_status=enabled
#s_apcstatus=enabled
#s_root_status=enabled
#s_batch_status=enabled
#s_other_service_group_status=disabled
#s_adminserverstatus=enabled
#s_web_admin_status=enabled
[Services To be Enabled on the Secondary Application Tier Node]
s_web_applications_status=enabled
s_web_entry_status=enabled
s_apcstatus=enabled
s_root_status=enabled
s_batch_status=disabled
s_other_service_group_status=disabled
s_adminserverstatus=disabled
s_web_admin_status=disabled
# Additional variables can be added below as per your requirement.
[applmgr@ebsprodapp3 admin]$
###################################################################################################
###################################################################################################
[applmgr@ebsprodpubapp1 bin]$ pwd
/u01/OCI/fs1/EBSapps/comn/clone/bin
[applmgr@ebsprodpubapp1 bin]$
[applmgr@ebsprodpubapp1 bin]$ export
TIMEDPROCESS_TIMEOUT=-1
[applmgr@ebsprodpubapp1 bin]$ export
CONFIG_JVM_ARGS="-Xms1024m -Xmx2048m"
[applmgr@ebsprodpubapp1 bin]$
applmgr@ebsprodpubapp1 bin]$ perl adclonectx.pl addnode contextfile=$CONTEXT_FILE pairsfile=$INST_TOP/appl/admin/mypairs_dmz.txt dualfs=yes (this cannot execute from app1 as we
need master node xml)
applmgr@ebsprodpubapp1 bin]$
applmgr@ebsprodpubapp1 bin]$ perl adclonectx.pl
addnode contextfile=$INST_TOP/appl/admin/PRODPDB_ebsprodapp3.xml
pairsfile=$INST_TOP/appl/admin/mypairs_dmz.txt dualfs=yes (Can this execute?)
[applmgr@ebsprodpubapp1 bin]$ perl
adclonectx.pl addnode contextfile=/u01/OCI/fs1/inst/apps/PRODPDB_ebsprodapp3/appl/admin/PRODPDB_ebsprodapp3.xml
pairsfile=/u01/OCI/fs1/inst/apps/PRODPDB_ebsprodapp3/appl/admin/mypairs_dmz.txt
dualfs=yes
Copyright (c) 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/OCI/fs1/EBSapps/comn/clone/bin/../jre/bin/java -Xmx600M -Doracle.jdbc.autoCommitSpecCompliant=false -classpath /u01/OCI/fs1/EBSapps/comn/clone/bin/../jlib/ojdbc6.jar:/u01/OCI/fs1/EBSapps/comn/clone/bin/../jlib/xmlparserv2.jar:/u01/OCI/fs1/EBSapps/comn/clone/bin/../jlib/java::/u01/OCI/fs1/FMW_Home/wlserver_10.3/server/lib/weblogic.jar:/u01/OCI/fs1/EBSapps/comn/clone/bin/../jlib/wlfullclient.jar:/u01/OCI/fs1/EBSapps/comn/clone/bin/../jlib/wlclient.jar:/u01/OCI/fs1/EBSapps/comn/clone/bin/../jlib/wljmxclient.jar:/u01/OCI/fs1/EBSapps/comn/clone/bin/../jlib/ojmisc.jar:/u01/OCI/fs1/EBSapps/comn/clone/bin/../jlib/obfuscatepassword.jar:/u01/OCI/fs1/EBSapps/comn/clone/bin/../jlib/emCfg.jar oracle.apps.ad.clone.RCloneSFSAddNode -contextfile /u01/OCI/fs1/inst/apps/PRODPDB_ebsprodapp3/appl/admin/PRODPDB_ebsprodapp3.xml -configfile /u01/OCI/fs1/inst/apps/PRODPDB_ebsprodapp3/appl/admin/mypairs_dmz.txt -machinelistenaddress ebsprodpubapp1.prdappsn.cloudprdvcn1.oraclevcn.com -logdir /u01/OCI/fs1/EBSapps/comn/clone/bin/../FMW/logs/sfslog -promptmsg hide
Verifying: Apps schema password
Verifying:
pairsfile /u01/OCI/fs1/inst/apps/PRODPDB_ebsprodapp3/appl/admin/mypairs_dmz.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/OCI/fs1/EBSapps/comn/clone/bin/../FMW/logs/sfslog/run/RCloneSFSAddNode_10301815.log
Target System Base Directory set to /u01/OCI
Target System Current File System Base set to /u01/OCI/fs1
Target System Other File System Base set to /u01/OCI/fs2
Target System Fusion Middleware Home set to /u01/OCI/fs1/FMW_Home
Target System Other File System Fusion Middleware Home set to /u01/OCI/fs2/FMW_Home
Target System Web Oracle Home set to /u01/OCI/fs1/FMW_Home/webtier
Target System Other File System Web Oracle Home set to /u01/OCI/fs2/FMW_Home/webtier
Target System Appl TOP set to /u01/OCI/fs1/EBSapps/appl
Target System Other File System Appl TOP set to /u01/OCI/fs2/EBSapps/appl
Target System COMMON TOP set to /u01/OCI/fs1/EBSapps/comn
Target System Other File System COMMON TOP set to /u01/OCI/fs2/EBSapps/comn
Target System Current File System Instance Top set to /u01/OCI/fs1/inst/apps/PRODPDB_ebsprodpubapp1
Report file located at /u01/OCI/fs1/inst/apps/PRODPDB_ebsprodpubapp1/admin/out/portpool.lst
The new APPL_TOP context file has been created :
/u01/OCI/fs1/inst/apps/PRODPDB_ebsprodpubapp1/appl/admin/PRODPDB_ebsprodpubapp1.xml
contextfile=/u01/OCI/fs1/inst/apps/PRODPDB_ebsprodpubapp1/appl/admin/PRODPDB_ebsprodpubapp1.xml
Configuring: run fs add node...
Executing: patch clone context...
Log file located at /u01/OCI/fs1/EBSapps/comn/clone/bin/../FMW/logs/sfslog/patch/RCloneSFSAddNode_10301833.log
Target System Other File System Instance Top set to /u01/OCI/fs2/inst/apps/PRODPDB_ebsprodpubapp1
Report file located at /u01/OCI/fs2/inst/apps/PRODPDB_ebsprodpubapp1/admin/out/portpool.lst
The new APPL_TOP context file has been created :
/u01/OCI/fs2/inst/apps/PRODPDB_ebsprodpubapp1/appl/admin/PRODPDB_ebsprodpubapp1.xml
contextfile=/u01/OCI/fs2/inst/apps/PRODPDB_ebsprodpubapp1/appl/admin/PRODPDB_ebsprodpubapp1.xml
Configuring: patch fs add node...
-- Add node operation completed --
Node ebsprodpubapp1.prdappsn.cloudprdvcn1.oraclevcn.com has been added successfully
[applmgr@ebsprodpubapp1 bin]$
###################################################################################################
###################################################################################################
select
* from fnd_nodes
[applmgr@ebsprodapp3 config]$ adop
-status
Enter the APPS password:
Connected.
==============================================================
ADOP (C.Delta.12)
Session Id: 25
Command: status
Output: /u01/OCI/fs_ne/EBSapps/log/adop/25/20211030_225319/adzdshowstatus.out
===============================================================
Node Name Node Type Phase Status Started Finished Elapsed
--------------- ---------- --------------- --------------- -------------------- -------------------- ------------
ebsprodapp master APPLY ACTIVE 2021/05/15 07:29:38 2021/05/15 07:34:55 0:05:17
3
CLEANUP NOT STARTED
ebsprodapp slave APPLY NOT STARTED
4
CLEANUP NOT STARTED
ebsprodpub slave APPLY NOT STARTED
app1
CLEANUP NOT STARTED
File System Synchronization Type: None
adop exiting with status = 0 (Success)
[applmgr@ebsprodapp3 config]$
###################################################################################################
###################################################################################################
one step missing
[applmgr@ebsprodpubapp1 OCI]$ .
EBSapps.env patch
E-Business Suite Environment Information
----------------------------------------
RUN File System : /u01/OCI/fs1/EBSapps/appl
PATCH File System : /u01/OCI/fs2/EBSapps/appl
Non-Editioned File System : /u01/OCI/fs_ne
DB Host: prd-scan.prddbsn.cloudprdvcn1.oraclevcn.com Service/SID: PRODPDB
Sourcing the PATCH File System ...
[applmgr@ebsprodpubapp1 OCI]$ vi
$CONTEXT_FILE
[applmgr@ebsprodpubapp1 OCI]$
[applmgr@ebsprodpubapp1 OCI]$
cp
$CONTEXT_FILE ~ (Master node contextfile)
hostname
–f (Master node fqdn)
For Services need to b disabled on DMZ Server:
grep s_batch_status $CONTEXT_FILE
grep s_adminserverstatus $CONTEXT_FILE
grep s_web_admin_status $CONTEXT_FILE
For Weblogic Ports Check:
grep s_atName $CONTEXT_FILE
grep wls_oacoreport $CONTEXT_FILE
grep wls_oafmport $CONTEXT_FILE
grep wls_formsport $CONTEXT_FILE
grep wls_forms-c4wsport $CONTEXT_FILE
[applmgr@ebsprodpubapp1 OCI]$
[applmgr@ebsprodpubapp1 OCI]$ perl $FND_TOP/patch/115/bin/txkSetAppsConf.pl
-contextfile=$CONTEXT_FILE -configoption=removeMS -oacore=ebsprodapp3.prdappsn.cloudprdvcn1.oraclevcn.com:7211
-oafm=ebsprodapp3.prdappsn.cloudprdvcn1.oraclevcn.com:7611 -forms=ebsprodapp3.prdappsn.cloudprdvcn1.oraclevcn.com:7411
-formsc4ws=ebsprodapp3.prdappsn.cloudprdvcn1.oraclevcn.com:7811
Enter apps schema password :
*** LOG FILE: /u01/OCI/fs2/inst/apps/PRODPDB_ebsprodpubapp1/logs/appl/rgf/TXK/txkSetAppsConf_10302138.log ***
[applmgr@ebsprodpubapp1 OCI]$
[applmgr@ebsprodpubapp1 OCI]$
[applmgr@ebsprodpubapp1 OCI]$
[applmgr@ebsprodpubapp1 OCI]$
[applmgr@ebsprodpubapp1 OCI]$ .
EBSapps.env run
E-Business Suite Environment Information
----------------------------------------
RUN File System : /u01/OCI/fs1/EBSapps/appl
PATCH File System : /u01/OCI/fs2/EBSapps/appl
Non-Editioned File System : /u01/OCI/fs_ne
DB Host: prd-scan.prddbsn.cloudprdvcn1.oraclevcn.com Service/SID: PRODPDB
Sourcing the RUN File System ...
[applmgr@ebsprodpubapp1 OCI]$
[applmgr@ebsprodpubapp1 OCI]$
[applmgr@ebsprodpubapp1 OCI]$ perl
$FND_TOP/patch/115/bin/txkSetAppsConf.pl -contextfile=$CONTEXT_FILE
-configoption=removeMS -oacore=ebsprodapp3.prdappsn.cloudprdvcn1.oraclevcn.com:7201
-oafm=ebsprodapp3.prdappsn.cloudprdvcn1.oraclevcn.com:7601 -forms=ebsprodapp3.prdappsn.cloudprdvcn1.oraclevcn.com:7401
-formsc4ws=ebsprodapp3.prdappsn.cloudprdvcn1.oraclevcn.com:7801
Enter apps schema password :
*** LOG FILE: /u01/OCI/fs1/inst/apps/PRODPDB_ebsprodpubapp1/logs/appl/rgf/TXK/txkSetAppsConf_10302139.log ***
[applmgr@ebsprodpubapp1 OCI]$ perl $FND_TOP/patch/115/bin/txkSetAppsConf.pl -contextfile=$CONTEXT_FILE -configoption=removeMS -oacore=ebsprodapp3.prdappsn.cloudprdvcn1.oraclevcn.com:7201 -oafm=ebsprodapp3.prdappsn.cloudprdvcn1.oraclevcn.com:7601 -forms=ebsprodapp3.prdappsn.cloudprdvcn1.oraclevcn.com:7401 -formsc4ws=ebsprodapp3.prdappsn.cloudprdvcn1.oraclevcn.com:7801
Enter apps schema password :
*** LOG FILE: /u01/OCI/fs1/inst/apps/PRODPDB_ebsprodpubapp1/logs/appl/rgf/TXK/txkSetAppsConf_10302139.log ***
[applmgr@ebsprodpubapp1 OCI]$
###################################################################################################
###################################################################################################
run this sync command on all application nodes on first on run and then on patch filesystems like below:
[applmgr@ebsprodapp3 admin]$ echo
$FILE_EDITION
run
[applmgr@ebsprodapp3 admin]$ perl
$AD_TOP/bin/adSyncContext.pl contextfile=$CONTEXT_FILE
Enter the APPS user password:
Enter the WebLogic AdminServer password:
The log file is /u01/OCI/fs1/inst/apps/PRODPDB_ebsprodapp3/logs/appl/rgf/Sun_Oct_31_00_47_50_2021/adSyncContext.log
[applmgr@ebsprodapp3 admin]$
[applmgr@ebsprodapp3 OCI]$ .
/u01/OCI/EBSapps.env patch
E-Business Suite Environment Information
----------------------------------------
RUN File System : /u01/OCI/fs1/EBSapps/appl
PATCH File System : /u01/OCI/fs2/EBSapps/appl
Non-Editioned File System : /u01/OCI/fs_ne
DB Host: prd-scan.prddbsn.cloudprdvcn1.oraclevcn.com Service/SID: PRODPDB
Sourcing the PATCH File System ...
[applmgr@ebsprodapp3 OCI]$ perl
$AD_TOP/bin/adSyncContext.pl contextfile=$CONTEXT_FILE
Enter the APPS user password:
Enter the WebLogic AdminServer password:
The log file is /u01/OCI/fs2/inst/apps/PRODPDB_ebsprodapp3/logs/appl/rgf/Sun_Oct_31_00_49_01_2021/adSyncContext.log
[applmgr@ebsprodapp3 OCI]$
###################################################################################################
###################################################################################################
1) stop admin server on patch fs
2) stop application on node2 and node1
3) stop and start database to take parameter effect
4) run autoconfig on db node1 and then db node2 and then again on db node1
5) run autoconfig on app3(masternode) Run FS then on Patch FS
6) repeate step 5 for Slave nodes (app4 & app1 DMZ server)
7) ADOP Tables for node information configured with Single/Multi Apps Node:
1)select * from fnd_nodes; --(only 3:AUTHENTICATION, DBNODE, APPSNODE)
1.1.2) select * from ad_nodes_config_status; -- (prod apps entries
1.1.3) select * from fnd_oam_context_files;
###################################################################################################
Profile Value: Node
Trust Level
Server: ebsprodpubapp1
Value: External
[applmgr@ebsprodpubapp1 ~]$ grep
login $CONTEXT_FILE
<login_page oa_var="s_login_page">https://ebsprodpubapp.areefdba.com.sa/OA_HTML/AppsLogin</login_page>
[applmgr@ebsprodpubapp1 ~]$
[applmgr@ebsprodpubapp1 ~]$
[applmgr@ebsprodpubapp1 ~]$ grep
external $CONTEXT_FILE
<soa_external_url oa_var="s_soa_external_url">%s_soa_external_url%</soa_external_url>
<externURL oa_var="s_external_url">https://ebsprodpubapp.areefdba.com.sa</externURL>
[applmgr@ebsprodpubapp1 ~]$
[applmgr@ebsprodpubapp1 ~]$ grep s_shared_file_system $CONTEXT_FILE
<shared_file_system oa_var="s_shared_file_system">false</shared_file_system>
###################################################################################################
find $IAS_ORACLE_HOME/instances -type f \( -iname \apps.conf -o -iname \mod_wl_ohs.conf \)
[applmgr@ebsprodapp3 ~]$ find $IAS_ORACLE_HOME/instances -iname apps.conf
/u01/OCI/fs2/FMW_Home/webtier/instances/EBS_web_OHS/config/OHS/EBS_web/apps.conf
/u01/OCI/fs2/FMW_Home/webtier/instances/EBS_web_OHS0/config/OHS/EBS_web/apps.conf
/u01/OCI/fs2/FMW_Home/webtier/instances/EBS_web_OHS1/config/OHS/EBS_web/apps.conf
[applmgr@ebsprodapp3 ~]$
[applmgr@ebsprodapp3 ~]$ ls -ltrh $IAS_ORACLE_HOME/instances/EBS_web_*OHS*/config/OHS/EBS_web*/apps.conf
[applmgr@ebsprodapp3 ~]$
[applmgr@ebsprodapp3 ~]$ ls -ltrh $IAS_ORACLE_HOME/instances/EBS_web_*OHS*/config/OHS/EBS_web*/mod_wl_ohs.conf
[applmgr@ebsprodapp3 ~]$
[applmgr@ebsprodapp3 ~]$ grep ebsprodapp4 $IAS_ORACLE_HOME/instances/EBS_web_*OHS*/config/OHS/EBS_web*/apps.conf
[applmgr@ebsprodapp3 ~]$ grep ebsprodapp4 $IAS_ORACLE_HOME/instances/EBS_web_*OHS*/config/OHS/EBS_web*/mod_wl_ohs.conf
Apply Applications Technology Patch 32902510:R12.FND.C JWS and JRE (8u291 and later) Compatibility Patch.
###################################################################################################
Important sql Commands in EBS Multinode Architecture
###################################################################################################
col NODE_NAME for a25;
col HOW_MANY_USER_SESSIONS for a35;
select min(first_connect), count(*) from icx.icx_sessions;
select a.node_name, 'Number of user sessions : ' || count(distinct b.session_id) How_many_user_sessions
from apps.fnd_nodes a,apps.icx_sessions b
where disabled_flag != 'Y' and PSEUDO_FLAG = 'N'
and (last_connect + decode(apps.FND_PROFILE.VALUE('ICX_SESSION_TIMEOUT'),
NULL,limit_time, 0,limit_time,apps.FND_PROFILE.VALUE('ICX_SESSION_TIMEOUT')/60)/24) > sysdate
and a.node_id=b.node_id and counter < limit_connects group by a.node_name;
MIN(FIRST_CONNECT) COUNT(*)
-------------------- ----------
03-Jul-2024 11:23:30 11909
NODE_NAME HOW_MANY_USER_SESSIONS
------------------------- -----------------------------------
EBSPRODAPP3 Number of user sessions : 46
EBSPRODAPP4 Number of user sessions : 20
EBSPRODPUBAPP1 Number of user sessions : 11
###################################################################################################
