pairs file in R12.2.5

[guddhati]

Hi,

Can you please clarify on below information.

Found this command on support note id,command to add a node during apps refresh

perl ./adclonectx.pl \
addnode contextfile= \
pairsfile=FS_base/pairsfile/run/myrunpairsfile.txt \
dualfs=yes

This will configure both run and patch filesystems.do we input patch port pool and run port pool in pairs file.can you please update some sample pairs file which we can give it in above command that successfully configures both run and patch fs

Thanks in advance

[ErmanArslansOracleBlog]

Hi,

As documented in Oracle Support;
"A sample" pairsfile for the run/patch file system is instantiated into the instance home on the primary application tier node. The file is called <SID>_<primary_node_name>_.txt, and located in the <inst_top>/appl/admin/ directory.

Example: For a configuration with an instance name of VIS, the pairsfile will be /u01/12.2/fs1/inst/apps/VIS_appstier1/appl/admin/VIS_appstier1.txt.

Review that file and update me if you have any more questions on this.

thx

[Vithal]

Hi,

Regarding the pairs file in R12.2

We are having a primary node application server with shared NFS for apps tier directories.

We are planning to add a secondary node to the same.
However i had a doubt regarding the pairs file entry.

[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=/a01/oracle/tsldev/fs1/inst/apps/tsldev_tslaptdev01/temp
#s_contextname=tsldev_tslaptdev01
#s_hostname=tslaptdev01
#s_domainname=tsl.com
#s_cphost=tslaptdev01
#s_webhost=tslaptdev01
#s_config_home=/a01/oracle/tsldev/fs1/inst/apps/tsldev_tslaptdev01
#s_inst_base=/a01/oracle/tsldev
#s_display=tslaptdev01:0.0
#s_forms-c4ws_display=tslaptdev01:0.0
#s_ohs_instance=EBS_web_tsldev_OHS1
#s_webport=8010
#s_http_listen_parameter=8010
#s_https_listen_parameter=4453

##Vithal : Above entries are for primary node , right ?
##Vithal : We are planning to use the second node for running concurrent services.
##Vithal : So what changes do i need to make on above Primary Node entries and below Secondary node  entries?

s_temp=
s_contextname=
s_hostname=
s_domainname=
s_cphost=
s_webhost=
s_config_home=
s_inst_base=
s_display=
s_forms-c4ws_display=
s_ohs_instance=
s_webport=
s_http_listen_parameter=
s_https_listen_parameter=

[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=enabled
#s_adminserverstatus=enabled
#s_web_admin_status=enabled

[Services To be Enabled on the Secondary Application Tier Node]

s_web_applications_status=
s_web_entry_status=
s_apcstatus=
s_root_status=
s_batch_status=
s_other_service_group_status=
s_adminserverstatus=disabled
s_web_admin_status=disabled


Regards,
Vithal.

[ErmanArslansOracleBlog]

You need to update the following in that pairsfile: (you need to update only the secondary node related lines, primary node related lines are already commented out as you see ->#)

[Instance Specific] and [Services] sections of pairsfile:

Example for Services section (you need to set "enabled" for the services that you want to have on secondary 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=enabled
s_adminserverstatus=disabled
s_web_admin_status=disabled

Example for Instance specific section: (you need to update the values according to your second node)

s_temp=/a01/oracle/tsldev/fs1/inst/apps/tsldev_tslaptdev02/temp
s_contextname=tsldev_tslaptdev02
s_hostname=tslaptdev02
...
.....
etc.....
.......

[Vithal]

Thanks,

Since in our case we want to enable concurrent manager ( batch services ) on secondary node , we will enable only the "s_batch_status=enabled " in pairs file.

However i suppose we will also need to make the same valuie as disabled on the primary node ?
Meaning we don't want the batch services to run on both nodes , as it would defeat our purpose in the first place , i.e of distributing the load on secondary node.

If so , how do we change the "s_batch_status=enabled "on the primary node , and where ? is this is in the context file of both fs1 and fs2 ?

Regards,
Vihtal.

[ErmanArslansOracleBlog]

as for disabling the services on a node, editing  the apps tier context file on that node + running autoconfig should be enough..

Example ;

-->
<oa_service_group_status oa_var="s_batch_status">disabled</oa_service_group_status>

-->
Run AutoConfig .


Reference:

see:
Business Continuity for Oracle E-Business Suite Release 12.2 Using Oracle 12c (12.1.0.2) Physical Standby Database (Doc ID 1963472.1) -> "5.2 Configuration 2: Standby Application Tier(s) Connected to the Primary Database"-> Step 5 : "Disable the services on standby application tier nodes in order to avoid having the services startup whenever cutover is run . In the run and patch file system context files, set the services to a disabled state on all of the standby slave nodes."