How to configure Isupplier on External node in R12

In this post we will discuss how to configure DMZ (Isupplier on external node) on shared file system. To add external node, we must follow the below steps.

Steps to Add Node to a Shared Application Tier File System for Oracle E-Business Suite R12

Configuring DMZ in R12.

Here we will know ‘how to configure isupplier (dmz) in oracle apps in r12‘.

Internal Server:- 192.168.11.15

External Server:- 192.168.11.10

Here I am going to discuss about steps involved in Adding a node with Shared Application Tier FileSystem. Mount Share Application Tier File System on External node.

Prerequisites:-

If you have not installed both nfs client and nfs server. first of all install them.yum install nfsservice nfs statusEdit exports file on source server:-Add Application Tier File system in /etc/exports as below./oracle/apps/ 192.168.11.10(rw,sync)restart nfs service:-

#service nfs restart

#chkconfig nfs on

mkdir /oracle/apps

Edit /etc/fstab on destination Server(192.168.11.10):-

192.168.11.15:/oracle/apps /oracle/apps               nfs     rw,intr,bg,hard,timeo=600,wsize=32768,rsize=32768,nfsvers=3,tcp,nolock,acregmin=0,acregmax=0       0 0

Check/verify the shared file system from destination server:-

showmount -e 192.168.11.15

Mount the shared filesystem(External node) that you are going to add and the following Shared Top’s must be visible from all application nodes involved in configuration.

#mount -a

or
#mount -t nfs 192.168.11.15:/oracle/apps  /oracle/apps

check if /oracle/apps mounted at destination server

#df -h

Steps to Add Node to a Shared Applicaton Tier File System

Adding a node to Shared Application Tier File System.

Step 1: Run rapid clone on the existing node(source node)

$ cd $INST_TOP/admin/scripts

$ perl adpreclone.pl appsTier

Shared Top’s

COMMON_TOP: /u01/share/apps/apps_st/ramcomn

APPL_TOP: /u01/share/apps/apps_st/ramappl

Tools ORACLE_HOME: /u01/share/apps/tech_st/ramora/10.1.2

Web ORACLE_HOME: /u01/share/apps/tech_st/ramora/10.1.3

Step 2: Create new Context Files for the External node:

– On internal server

abctest –Internal Node

abcapps —External Node

appltest@abcapps scripts]$ perl $COMMON_TOP/clone/bin/adclonectx.pl


contextfile=/appsebs/inst/apps/PROD_isupplier/appl/admin/Internal.xml
Copyright (c) 2002 Oracle Corporation
                        Redwood Shores, California, USA


                        Oracle Applications Rapid Clone

                                 Version 12.0.0

                      adclonectx Version 120.23.12010000.1


Running:
/data01/GSTUAT_8026/apps/apps_st/comn/clone/bin/../jre/bin/java -Xmx600M -classpath /acedata01/GSTUAT_8026/apps/apps_st/comn/clone/bin/../jlib/ojdbc14.jar:/acedata01/GSTUAT_8026/apps/apps_st/comn/clone/bin/../jlib/xmlparserv2.jar:/acedata01/GSTUAT_8026/apps/apps_st/comn/clone/bin/../jlib/java oracle.apps.ad.context.CloneContext  -e /data01/GSTUAT_8026/apps/inst/apps/UAT_aceapps/appl/admin/UAT_aceapps.xml
Enter the APPS password : apps


Log file located at /data01/GSTUAT_8026/apps/inst/apps/UAT_aceapps/admin/scripts/CloneContext_0804113428.log


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


Target System Hostname (virtual or normal) [abcapps] : abctest


Target System Database SID : UAT


Target System Database Server Node [abctest] :


Target System Database Domain Name [abc-test.com] :


Target System Base Directory : /data01/GSTUAT_8026


Target System Tools ORACLE_HOME Directory [/data01/GSTUAT_8026/apps/tech_st/10.1.2] :


Target System Web ORACLE_HOME Directory [/data01/GSTUAT_8026/apps/tech_st/10.1.3] :


Target System APPL_TOP Directory [/data01/GSTUAT_8026/apps/apps_st/appl] :


Target System COMMON_TOP Directory [/data01/GSTUAT_8026/apps/apps_st/comn] :


Target System Instance Home Directory [/data01/GSTUAT_8026/inst] : /data01/GSTUAT_8026/apps/inst


Username for the Applications File System Owner [appltest] :


Group for the Applications File System Owner [dba] :


Target System Root Service [enabled] :


Target System Web Entry Point Services [enabled] :


Target System Web Application Services [enabled] :


Target System Batch Processing Services [enabled] : disabled


Target System Other Services [disabled] :


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


Target System Display [abctest:0.0] :


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


Target System Port Pool [0-99] : 26
Report file located at /data01/GSTUAT_8026/apps/inst/apps/UAT_abctest/temp/portpool.lst
Complete port information available at /data01/GSTUAT_8026/apps/inst/apps/UAT_abctest/temp/portpool.lst
UTL_FILE_DIR on database tier consists of the following directories.


1. /usr/tmp
2. /usr/tmp
3. /acedata03/UAT_8026/orahome/appsutil/outbound/UAT_abctest
4. /usr/tmp
Choose a value which will be set as APPLPTMP value on the target node [1] : 1


New context path and file name [UAT_abctest.xml] :


Creating the new APPL_TOP Context file from :
  /data01/GSTUAT_8026/apps/apps_st/appl/ad/12.0.0/admin/template/custom/adxmlctx.tmp


The new APPL_TOP context file has been created :
  /data01/GSTUAT_8026/apps/inst/apps/UAT_aceapps/admin/scripts/UAT_abctest.xml


Log file located at /data01/GSTUAT_8026/apps/inst/apps/UAT_aceapps/admin/scripts/CloneContext_0804113428.log
contextfile=/acedata01/GSTUAT_8026/apps/inst/apps/UAT_aceapps/admin/scripts/UAT_abctest.xml
Check Clone Context logfile /data01/GSTUAT_8026/apps/inst/apps/UAT_aceapps/admin/scripts/CloneContext_0804113428.log for details.

$perl $AD_TOP/bin/adconfig.pl  contextfile=/oracle/PROD/inst/apps/PROD_isupplier/External.xml

Step 3: Run the txkChangeProfH.sql under $FND_TOP/patch/115/sql using apps user.

SQL>@txkChangeProfH.sql SERVRESP

After new context (external) then run autoconfig on internal server and then run autoconfig on external server to add node in fnd_nodes table.

After that start the services.

Step 4: Set below profile as per configuration.

•POS: External URL

• POS: Internal URL

Query for %NODE%TRUST%. You will see a profile option named 'Node Trust Level'

Set the value of this profile option to External at the server level to external node only

Once set the profile option . Hope you will able to login in External URL accordingly...

• If want to check another post related to DMZ configuration, you may check at ‘Oracle E-Business Suite Release 12.2 Configuration in a DMZ (Doc ID 1375670.1)’.
  
  
• Apart from isupplier configuration, you may also check another post related to ‘Login To External Node Gets Redirected To Internal Node‘.