How to configure Isupplier on External node in R12

Introduction:- In this post we will discuss how to ‘configure Isupplier’ on external node on shared file system.

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

Configuration in a DMZ:

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

Internal Server:-

External Server:-

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.


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/,sync)restart nfs service:-

#service nfs restart

#chkconfig nfs on

mkdir /oracle/apps

Edit /etc/fstab on destination Server( /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

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

#mount -t nfs  /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 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

[email protected] scripts]$ perl $COMMON_TOP/clone/bin/

Copyright (c) 2002 Oracle Corporation
                        Redwood Shores, California, USA

                        Oracle Applications Rapid Clone

                                 Version 12.0.0

                      adclonectx Version 120.23.12010000.1

/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  -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 [] :

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 :

The new APPL_TOP context file has been created :

Log file located at /data01/GSTUAT_8026/apps/inst/apps/UAT_aceapps/admin/scripts/CloneContext_0804113428.log
Check Clone Context logfile /data01/GSTUAT_8026/apps/inst/apps/UAT_aceapps/admin/scripts/CloneContext_0804113428.log for details.
$perl $AD_TOP/bin/  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 file(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...

2 thoughts on “How to configure Isupplier on External node in R12”

  1. Thanks for such important information.keep up the good work.Ethical Hacking training is based on current industry standards that helps attendees to secure placements in their dream jobs at MNCs. Indian Cyber Army Provides Best Ethical Hacking Training in India.Indian Cyber Army credibility in Ethical hacking training & Cybercrime investigation training is acknowledged across nation as we offer hands on practical knowledge and full assistance with basic as well as advanced level ethical hacking & cybercrime investigation courses


Leave a Comment