[Solved] Admin Server Startup Issue in EBS (R12.2) Must Run On Primary Node

This post covers the ‘adadminsrvctl.sh should be run only from the primary node <hostname>‘ issue and fix reported by one of our trainees from Oracle Apps DBA (R12.2) Install | Patch Clone training while starting Admin Server in Oracle E-Business Suite (R12.2).

Lets first understand basic concepts about Admin Server, Context File, Autoconfig, FND_NODES table in EBS R12.2.

Admin Server

Oracle introduced WebLogic Server with Oracle EBS  (R12.2).

Administration Server is a WebLogic Server instance that maintains configuration data for a Weblogic domain.

• There will always be only one and one Administration Server and a few Managed servers in a WebLogic domain.

To know more about Weblogic Admin Server, check HERE.

Context File

In Oracle Applications, 11i & R12 all the configuration parameters are captured in two context files:

a) Application context file called the <CONTEXT_NAME>.xml contains the configuration information for the application tier & is located in $INST_TOP/appl/admin for each node of application tier.

b) Database context file called the <CONTEXT_NAME>.xml contains the configuration information for the database tier & is located in $ORACLE_HOME/appsutil

To know more about Context File, check HERE.

AutoConfig

Autoconfig is tool/utility to reconfigure your Oracle Application configuration files using context (XML file) and template files. It is located in

• Application tier: $COMMON_TOP/admin/scripts/CONTEXT_NAME/adautoconfig.sh
• Database tier: $ORACLE_HOME/appsutil/scripts/CONTEXT_NAME/adautoconfig.sh

To know more about Autoconfig, check HERE.

FND_NODES Table 

If you want to check what services are running on which node, then we can check from FND_NODES table. It is present in the APPS schema.

SQL> conn apps/apps

SQL> select NODE_NAME,SUPPORT_CP,SUPPORT_FORMS,SUPPORT_WEB,SUPPORT_ADMIN from FND_NODES;

Issue: Error starting Admin Server

When we are starting Admin Server, getting below error

sh $ADMIN_SCRIPTS_HOME/adadminsrvctl.sh start

logs: $EBS_DOMAIN_HOME/servers/AdminServer/logs/AdminServer.log

adadminsrvctl.sh should be run only from the primary node 1706ecloud04

Note: Kindly refer to “Oracle Apps R12.2 Log Files Location every Apps DBA must know“ blog post and know more about log file location in R12.2. 

Cause: Wrong Entry in Context File 

In our case trainee accidentally changed the parameter s_web_admin_status value to disable in the context file.

Check Out: Our blog post on Oracle ADOP. Click here

Fix: Update context File and run autoconfig

1. Take backup of run context file

2. Manually updated this parameter and enabled it

<oa_service_group type=”web_admin” title=”Web Administration” services=”admin_server, tns_apps” requires=”root”>
<oa_service_group_status oa_var=”s_web_admin_status”>enabled</oa_service_group_status>
</oa_service_group>
<oa_service_group type=”web entry” title=”Web Entry Point Services” services=”ohs, opmn”>

3. Run Autoconfig on application tier

Configuring IES_TOP…….COMPLETED
Configuring OZF_TOP…….COMPLETED
Configuring CSD_TOP…….COMPLETED
Configuring IGC_TOP…….COMPLETED

AutoConfig completed successfully.

4. Restart Admin server

a) Make sure you are connected to application user i.e applmgr

b) Go to $ADMIN_SCRIPTS_HOME

cd $ADMIN_SCRIPTS_HOME

c) Start Admin Server

[applmgr@1706ecloud04 scripts]$ ./adadminsrvctl.sh start

You are running adadminsrvctl.sh version 120.10.12020000.10

Enter the WebLogic Admin password:
Enter the APPS Schema password:
Starting WLS Admin Server…
Refer /u01/oracle/PRD122/fs2/inst/apps/PRD122_1706ecloud04/logs/appl/admin/log/adadminsrvctl.txt for details

AdminServer logs are located at /u01/oracle/PRD122/fs2/FMW_Home/user_projects/domains/EBS_domain_PRD122/servers/AdminServer/logs

adadminsrvctl.sh: exiting with status 0

adadminsrvctl.sh: check the logfile /u01/oracle/PRD122/fs2/inst/apps/PRD122_1706ecloud04/logs/appl/admin/log/adadminsrvctl.txt for more information …

Also Read: Our previous blog post on Oracle EBS 12.2 File System. Click here

Related/Further Readings

• Recommended Browsers for Oracle E-Business Suite Release 12 [Doc ID 389422.1] 
• Oracle E-Business Suite Release 12.2 Information Center (Doc ID 1581299.1)
• Oracle E-Business Suite Release 12.2.9 Readme (Doc ID 2495027.1)
• Oracle E-Business Suite 12.2.9 Now Available
• [Troubleshooting] Forms Issue: FRM-92050 failed to connect to server:forms/servlet
• Oracle E-Business Suite (EBS) 12.2.9 Now Available & Its Upgrade Steps
• Oracle AppsDBA (R12.2) Training: Step by Step Activity Guides/Hands-On Lab Exercise
• Oracle AppsDBA (R12.2): Install | Patch | Clone | Maintain

Next Task For You

We cover Oracle E-Business R12.2 Architecture & concepts in our Oracle Apps DBA For Beginners Training along with the Installation, Patching, Cloning, and Troubleshooting and also, Database upgrade to 19c  and much more including the hands-on labs you must perform to upgrade your skills and get a good job with a high package.

Begin your journey towards becoming an Apps DBA by joining our FREE Masterclass on How To Learn Oracle Apps DBA (R12) & It’s New Features.