How to add new node and configure Shared APPL_TOP in Oracle Applications

Here is a quick guide on adding a new node and configureing a shared $APPL_TOP in Oracle Applications R12 environment. For creating this I have tested the scenario on a Vision Instance running on Linux. The vision instance
is running on . For configuring this I have followed Sharing The Application Tier File System in Oracle E-Business Suite Release 12 [ID 384248.1]. But, lots of things I need to change or reconfigure to successfully adding new node on shared APPL Top in my environment.

Step 1

First source the env file. Then execute the following command with current context file.

$ cd $COMMON_TOP/clone/bin
$ perl addnode contextfile=/d01/Vision/inst/apps/VIS_flinux01/appl/admin/VIS_flinux01.xml

The most important part is that give the following inputs next. Otherwise you may face database connection exception or other type of issues.

Enter the APPS password : apps
Log file located at /d01/Vision/apps/apps_st/comn/clone/bin/CloneContext_0407163810.log
Provide the values required for creation of the new APPL_TOP Context file.
Target System Hostname (virtual or normal) [flinux01] :
It is recommended that your inputs are validated by the program.
However you might choose not to validate them under following circumstances:
-If cloning a context on source system for a remote system.
-If cloning a context on a machine where the ports are taken and
you do not want to shutdown the services at this point.
-If cloning a context but the database it needs to connect is not available.
Do you want the inputs to be validated (y/n) [n] ? : y
Target System Root Service [enabled] :
Target System Web Entry Point Services [enabled] :
Target System Web Application Services [enabled] :
Target System Batch Processing Services [enabled] :
Target System Other Services [disabled] :
Do you want to preserve the Display [flinux01:0.0] (y/n) ? : n
Target System Display [flinux01:0.0] : shared:0.0
RC-00217: Warning: Configuration home directory (s_config_home) evaluates to /d01/Vision/inst/apps/VIS_flinux01. A directory with this name already exists and is not empty.
Do you want to continue (y/n) ? : y
Database port is 1523
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] : 5
Checking the port pool 5RC-50221: Warning: Port Pool 5 is not free. Please check logfile /d01/Vision/apps/apps_st/comn/clone/bin/CloneContext_0407163810.log for conflicts.
RC-40201: Unable to connect to Database VIS.

Enter the Database listener port [1526] : 1523
Database port is 1523
Target System Port Pool [0-99] : 6

Checking the port pool 6
done: Port Pool 6 is free
RC-40201: Unable to connect to Database VIS.

Enter the Database listener port [1527] : 1523
Database port is 1523
Report file located at /d01/Vision/inst/apps/VIS_flinux01/temp/portpool.lst
Complete port information available at /d01/Vision/inst/apps/VIS_flinux01/temp/portpool.lst

UTL_FILE_DIR on database tier consists of the following directories.
1. /usr/tmp
2. /usr/tmp
Choose a value which will be set as APPLPTMP value on the target node [1] : 1
New context path and file name [/d01/Vision/inst/apps/VIS_flinux01/appl/admin/VIS_flinux01.xml] : /d01/virtualext/VIS_shared.xml
Creating the new APPL_TOP Context file from :
The new APPL_TOP context file has been created :

Log file located at /d01/Vision/apps/apps_st/comn/clone/bin/CloneContext_0407163810.log
Check Clone Context logfile /d01/Vision/apps/apps_st/comn/clone/bin/CloneContext_0407163810.log for details.

Step 2

Find all the old inst top directory replace it using a new inst top directory in new context file.
In my case I have replaced all entry "/d01/Vision/inst" to new instance top "/d01/virtualext/inst".

Step 3

Run the following command.
$grep s_contextname /d01/virtualext/VIS_shared.xml
<oa_context_name oa_var="s_contextname">VIS_flinux01</oa_context_name>

Replace all the entry with VIS_flinux01 with VIS_Shared in the new context file.

Step 4

The next step is run the following command to know s_config_home.

$grep s_config_home /d01/virtualext/VIS_shared.xml
<config_home oa_var="s_config_home">/d01/virtualext/inst/apps/VIS_Shared</config_home>
Create a directory structure as per the above command output.

Step 5

Now run adconfig using newly created context file.

$ perl $AD_TOP/bin/
Enter the full file path to the Context file: /d01/virtualext/VIS_shared.xml

Step 6

Source the new environment file. Start the server using $ADMIN_SCRIPTS_HOME/

Finally access Oracle Applications using url

See related article here

No comments :