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

Month: December 2022

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.

(more…)

December 2, 2022 How to Get Apps Password From Backend
APPS DBAAppsDBA ScriptsInstallations/Configurations-ApplicationsOracle APPS DBAScripts

How to Get Apps Password From Backend

 

STEP 1.  First login to Database through Command Prompt

sqlplus / as sysdba

 

STEP 2 : Create Function From Below Script to decrypt the encrypted password

create FUNCTION apps.decrypt_pin_func(in_chr_key IN VARCHAR2,
in_chr_encrypted_pin IN VARCHAR2)  
RETURN VARCHAR2 AS
LANGUAGE JAVA NAME ‘oracle.apps.fnd.security.WebSessionManagerProc.decrypt(java.lang.String,java.lang.String) return java.lang.String’;

 

STEP 3 : Run the Below Query for Retrieving AppsPassword

SQL> select ENCRYPTED_FOUNDATION_PASSWORD from apps.fnd_user where USER_NAME=’GUEST’;

ENCRYPTED_FOUNDATION_PASSWORD
——————————————————————————–
ZHA49B7AB1BB637F7A4347721229CF2F31A95DEC86B3CCFAEF9B40D4EB9AA8F0030EDDFC2324D873
AB2FFFA3B302AEE6EBD1

 

 

STEP 4:  Run the Below Query to get the Password

SELECT apps.decrypt_pin_func(‘GUEST/ORACLE123′,’ZHA49B7AB1BB637F7A4347721229CF2F31A95DEC86B3CCFAEF9B40D4EB9AA8F0030EDDFC2324D873AB2FFFA3B302AEE6EBD1’) from dual;

APPS.DECRYPT_PIN_FUNC(‘GUEST/ORACLE’,’ZHA49B7AB1BB637F7A4347721229CF2F31A95DEC86B3CCFAEF9B40D4EB9AA8F0030EDDFC2324D873AB2FFFA3B302AEE6EBD1′)
——————————————————————————–
APPS

 

STEP 5:  Now Login With the Password Retrieved.

SQL> conn apps/APPS;
Connected.