Syed Saad Ali

Oracle ACE Pro

Oracle Solution Architect

Oracle E-Business Suite

Oracle Cloud Infrastructure

Oracle Fusion Middleware

Oracle Database Administration

Oracle Weblogic Administration

Syed Saad Ali

Oracle ACE Pro

Oracle Solution Architect

Oracle E-Business Suite

Oracle Cloud Infrastructure

Oracle Fusion Middleware

Oracle Database Administration

Oracle Weblogic Administration

AppsDBA CV Download CV Contact Me

Author: Syed Saad Ali

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.

December 23, 2022 Redo Transport Services fails with ORA-16198

Errors/Workarounds19c

Redo Transport Services fails with ORA-16198

At the alert log, we received this error message on the production database for the 19c Data Guard.

The primary alert log file showed:

LGWR: Attempting destination LOG_ARCHIVE_DEST_2 network reconnect (16198)
LGWR: Destination LOG_ARCHIVE_DEST_2 network reconnect abandoned
Fri Jan 4 12:00:36 2023
Errors in file //bdump/.trc:
ORA-16198: Timeout incurred on internal channel during remote archival
LGWR: Network asynch I/O wait error 16198 log 2 service ‘(DESCRIPTION=(ADDRESS_LIST=(ADDRESS=(PROTOCOL=tcp)(HOST=)(PORT=1522)))(CONNECT_DATA=(SERVICE_NAME=)(INSTANCE_NAME=)(SERVER=dedicated)))’

After investigating the issue, we noticed that our network is too slow. We encountered this error when the primary database attempted to send a large logfile to the standby database.

The NET_TIMEOUT attribute in the LOG_ARCHIVE_DEST_2 at the primary database is either not set or set to a low value (such as 5-10 seconds), causing the LNS (Log Network Services) to be unable to complete the sending of redo blocks within the specified time.

To resolve this issue, you should increase the NET_TIMEOUT value in the LOG_ARCHIVE_DEST_2 at the primary database to at least 15 to 20 seconds, depending on the speed of your network.

In our specific case, we have already set the NET_TIMEOUT value in the LOG_ARCHIVE_DEST_2 at the primary database to 60 seconds.

ALTER SYSTEM SET LOG_ARCHIVE_DEST_2 SERVICE= LGWR SYNC DB_UNIQUE_NAME= NET_TIMEOUT=60 VALID_FOR=(ONLINE_LOGFILES,PRIMARY_ROLE)

Reference:
Redo Transport Services fails with ORA-16198 when using SYNC (synchronous) mode (Doc ID 808469.1)

December 16, 2022 ORA-04063: package body “APPS.AP_ACCTG_DATA_FIX_PKG” has errors

APPS DBAErrors/Workarounds-ApplicationsOracle APPS DBA

ERROR

ORA-04063: package body “APPS.AP_ACCTG_DATA_FIX_PKG” has errors
ORA-06508: PL/SQL: could not find program unit being called:
“APPS.AP_ACCTG_DATA_FIX_PKG”
ORA-06512: at line 38
(more…)

December 9, 2022 The persistent store “_WLS_AdminServer” could not be deployed: weblogic.store.PersistentStoreException

APPS DBAErrors/Workarounds-Applications

ERROR

<Error> <Store> <BEA-280061><The persistent store “_WLS_AdminServer” could not be deployed: weblogic.store.PersistentStoreException:
[Store:280105]The persistent file store “_WLS_AdminServer” cannot open file _WLS_ADMINSERVER000000.DAT.