How to configure Isupplier on External node in R12

How to configure Isupplier (DMZ) on External node in R12 :-

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 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 File

System.

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 nfs

service nfs status

Edit 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 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 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...