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 (Register for a FREE MasterClass at How To Become Oracle Apps DBA (R12) Earn Lot More In 2019) 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.
Oracle introduced WebLogic Server with Oracle EBS (R12.2).
Administration Server is WebLogic Server instance that maintains configuration data for a Weblogic domain.
- There will always be only one and one Administration Server and few Managed server in a WebLogic domain.
To know more about Weblogic Admin Server, check HERE.
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 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.
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;
————— ——————- ——————– ——————– ——————–
Host 02 Y Y Y Y
Issue: Error starting Admin Server
When we are starting Admin Server, getting below error
sh $ADMIN_SCRIPTS_HOME/adadminsrvctl.sh start
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.
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 type=”web entry” title=”Web Entry Point Services” services=”ohs, opmn”>
3. Run Autoconfig on application tier
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
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 …
- Oracle E-Business Suite Concepts
- What Is WebLogic Server?
- Why should Oracle Apps (EBS) DBAs learn WebLogic Server ? Release 12.2 with FMW 11g
- AutoConfig in Oracle Apps
- [Video] Oracle Apps DBA (R12.2) Services: Start/Stop
- [Troubleshooting] Oracle Apps R12.2 Online Patching ADOP: Prepare Phase Issue
- [Blog] ADOP Patching Q/A
- Oracle AppsDBA (R12): Step by step Activity Guides
- Oracle AppsDBA (R12.2): Install | Patch | Clone | Maintain
This post is from our Oracle Apps DBA (R12.2) Training, in which we cover Architecture & Changes in Oracle E-Business Suite R12.2, Staging & Installation, File System & Important Files in R12.2, Start/Stop, Patching, AD Administration, Cloning, Concurrent Managers, AutoConfig, Password Management, and Troubleshooting and much more.
Next Task For You
Begin your journey towards becoming an Apps DBA by joining our FREE Masterclass on How To Become an Oracle Apps DBA (R12) & Earn A Lot More In 2020.