Month: January 2023

January 20, 2023 Adding a New Managed Server on Oracle APPS R12.2

APPS DBA

Today We are going to Explore how to Ddd Managed Server on Oracle E-Business Suite R12.2. By default, every application tier node contains only a single instance of the OACORE, OAFM, FORMS and FORMS-C4WS Services.

To increase the Web logic performance, we need to add up managed servers. For example, we are going to add an OACORE Managed Server.

Step 1: Execute the following command to add a new managed server.

$ perl $AD_TOP/patch/115/bin/adProvisionEBS.pl

ebs-create-managedserver -contextfile=

-managedsrvname= -servicetype=

-managedsrvport= -logfile=

For example, to add a managed server ‘oacore_server2‘ of type ‘oacore‘ with port 7205, run the following command:

$ perl $AD_TOP/patch/115/bin/adProvisionEBS.pl

ebs-create-managedserver -contextfile=$CONTEXT_FILE

-managedsrvname=oacore_server2 -servicetype=oacore

-managedsrvport=7205 -logfile=$APPLRGF/TXK/addMS_oacoreserver2.log

Step 2: Source the Run File System.

Step 3: Now, perform the following steps on all application tier nodes participating in the same cluster where this managed server is added

Execute the following command to add details of the newly added managed servers into the OHS configuration files mod_wl_ohs.conf and apps.conf on the current node:

$ perl $FND_TOP/patch/115/bin/txkSetAppsConf.pl

-contextfile= <context_file>

-configoption=addMS

-oacore=<host>.<domain>:port

-oafm=<host>.<domain>:port

-forms=<host>.<domain>:port

-formsc4ws=<host>.<domain>:port

For example, if the managed server oacore_server2 has been added on host ‘ebsapps‘ and domain ‘prod.com‘ with port 7207, the following command should be executed:

$ perl $FND_TOP/patch/115/bin/txkSetAppsConf.pl -contextfile=$CONTEXT_FILE

-configoption=addMS -oacore=ebsapps.prod.com:7207

Step – 4: Run Context File Synchronization

perl $AD_TOP/bin/adSyncContext.pl contextfile=$CONTEXT_FILE

Step 5: Starting the Newly Added Managed Server

On Unix:
$ sh ./admanagedsrvctl.sh start <managedserver_name>

Example:

$ sh ./admanagedsrvctl.sh start oacore_server2

Step 6: Bounce apache(adapcctl.sh stopall/startall)

sh<ADMIN_SCRIPTS_HOME>/adapcctl.sh stopall

sh<ADMIN_SCRIPTS_HOME>/adapcctl.sh startall

Reference:

Managing Configuration of Oracle HTTP Server and Web Application Services in Oracle E-Business Suite Release 12.2

(Doc ID 1905593.1)

January 13, 2023 Routine FND_DCP.REQUEST_SESSION_LOCK received a result code of 1 from the call to DBMS_LOCK.Request

APPS DBAErrors/Workarounds-Applications

ERROR

The Concurrent Manager fails to start with the Error:

The ICM is already running. Contact you system administrator for further assistance.

(more…)

January 6, 2023 How to clean FND_NODES table in Oracle Applications

APPS DBAErrors/Workarounds-ApplicationsOracle APPS DBA

How to clean FND_NODES table in Oracle Applications

[edsanimate_start entry_animation_type= “fadeIn” entry_delay= “0” entry_duration= “1.5” entry_timing= “linear” exit_animation_type= “” exit_delay= “” exit_duration= “” exit_timing= “” animation_repeat= “infinite” keep= “yes” animate_on= “load” scroll_offset= “” custom_css_class= “”]

Note: Remember That All the Latest Cloning Patches Should Be Applied to avoid Any Ambiguity.

[edsanimate_end]

Step 1: Login to Database with Apps User

$ sqlplus apps/apps

SQL> EXEC FND_CONC_CLONE.SETUP_CLEAN;

SQL>COMMIT;

SQL>EXIT;

It will delete all old data from the table.

Step 2: Run AutoConfig on all tiers, first on the DataBase Tier and then on APPS Tier to repopulate the required system tables.

January 5, 2023 How to Change Weblogic Password in Oracle APPS R12.2

APPS DBA

How to Change Weblogic Password in Oracle APPS R12.2

Today we will explore how to change Weblogic Admin Password in Oracle E-Business Suite 12.2.x, we will explore 2 different scenarios according to the Patch Level available in the System.

Scenario 1: You are on R12.AD.C.Delta.7 and R12.TXK.C.Delta.7 or later, we can change the Weblogic admin server password using the below script.

A) Shutdown the Application Services using below:

$ADMIN_SCRIPTS_HOME/adstpall.sh

B) Start Weblogic Admin Server. Do not start any other services

$. ./EBSapps.env RUN
$ cd $ADMIN_SCRIPTS_HOME
$adadminsrvctl.sh start

C) Run the below Script to Update the Password

perl $FND_TOP/patch/115/bin/txkUpdateEBSDomain.pl -action=updateAdminPassword

^{[The script will prompt for Current and New Weblogic Password and restarts the Weblogic Admin Server.]}

D) Start the Application MiddleWare services using

$ADMIN_SCRIPTS_HOME/adstrtal.sh

E) Login to the Weblogic Admin Console to verify that the new WebLogic user password works.

F) Run fs_clone to Propagate the changes to the file system (Patch File system).

$adop phase=fs_clone

Scenario 2: You are on Earlier than R12.AD.C.Delta.7 and R12.TXK.C.Delta.7 , we can change the Weblogic admin server password using the below method.

A) Log into the WebLogic Administrative Console.

B) Click Lock & Edit and click Domain.

C) Click on the Security tab and click on the Advanced tab.

D) Enter the New password you want for the WebLogic Admin User in the Node Manager Password.

E) Click Save and verify that the settings were updated successfully. Then click on Activate Changes.

F) Click Security Realms and Click Myrealm.

G) Select Users and Groups, select Weblogic User, and enter the new password for the WebLogic user.

H) Make sure that the settings have been updated successfully.