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