Krishna Sudagani (Oracle Application DBA, OCI Admin, and Middleware Expertise)

Over a decade of expertise as an Oracle DBA, Application DBA, OCI Admin, and Fusion Middleware specialist, I’ve solved complex challenges, optimized systems, and led innovations across diverse Oracle platforms. Now, I’m passionate about sharing insights to bridge the gap between theory and practice. From database optimization to middleware best practices, join me as we explore Oracle technologies and grow together. Stay tuned for expert tips and resources!

▼
Friday, 11 February 2022

OEM 13c - emctl start oms failing with error - java.io.IOException: Cannot run program "null/common/bin/wlst.sh": error=2, No such file or directory

›
After the abnormal server reboot, we are unable to startup the OEM services and encounter the below error. Error: [oracle@krishna bin]$ ./em...
Wednesday, 16 June 2021

Auto Extend Tablespace scripts

›
1 - A script for summation of datafiles in tablespaces, ie a tablespace space usage script. select a.tablespace_name, SUM(a.bytes)/1024/1024...

APP-FND-01564: ORACLE error 1455 in afpodbinit

›
 The issue started after cloning the Oracle Database from an earlier release of 12.1.0.2 to 12.1.0.2 [ODA to ODA] This issue was caused by t...
Sunday, 4 April 2021

RMAN Duplicate Fails ORA-38862: Flashback Database Logs Are In Use

›
 RMAN backup restore is failing with the following error when the flashback is turned on in the source database. Error: Errors in memory scr...
Monday, 1 July 2019

How to Synchronize the AD tables FND_NODES, ADOP_VALID_NODES, and FND_OAM_CONTEXT_FILES in 12.2 when adop fails.

›
Adop failing with the Error adop exiting with status = 255 (Fail), due to fnd_nodes table has NULL for domain entry of this valid server. ...

How to create the patch file system in oracle apps R12.2

›
Below is an action plan to recreate the patch file system. You will need to make sure to have a valid backup of your system before you exec...
Tuesday, 29 January 2019

OEM 12c: ORA-28001: the password has expired The Connect Descriptor was (DESCRIPTION=(ADDRESS_LIST = (ADDRESS=(PROTOCOL=tcp)(HOST=)(PORT=)))(CONNECT_DATA=(SID=)(SERVER=DEDICATED)))

›
This error occurred on DB home page in OEM 12c. ORA-28001: the password has expired The Connect Descriptor was (DESCRIPTION=(ADDRESS_LIST ...
Wednesday, 5 September 2018

Disconnected: No supported authentication methods available (server sent: publickey, gssapi-with-mic)

›
When we trying to connect to an Oracle Cloud Linux/UNIX-Like Instance through Open SSH, the SSH client returns one of the following errors:...
Thursday, 19 July 2018

Unable to create an Oracle ASM database lower than 12.1.0.2

›
Unable to create an Oracle ASM database lower than 12.1.0.2.17814 PSU (12.1.2.12). Hardware Models: Oracle Database Appliance X6-2-HA, ...

Error when upgrading virtualized platforms to 12.2.1.4.0 in ODA

›
When upgrading Oracle Database Appliance hardware models with virtualized platforms to 12.2.1.4.0, perform these manual steps before upgrad...
Tuesday, 3 July 2018

ODA: 'oakcli update -patch --database' Does Not Run Datapatch

›
Upon running /opt/oracle/oak/bin/oakcli update -patch 12.1.2.6.0 -database, some of the databases do not receive the update. The database h...
Wednesday, 4 April 2018

ORA-16018: cannot use LOG_ARCHIVE_DEST with LOG_ARCHIVE_DEST_n or DB_RECOVERY_FILE_DEST

›
Below error occurred while changing the destination of archive log files in oracle database. Error: SQL> ALTER SYSTEM SET log_archiv...
Monday, 19 February 2018

Errors while applying 12.2.7 RUP Patch (24690690) in Oracle E-Business Suite 12.2

›
System got hanged while applying 12.2.7 RUP Patch (24690690) and adop exits with the errors. Error: 1) All workers are failed with the ...
Thursday, 15 February 2018

ORA-04063: package body "SYS.DBMS_STATS" has errors ORA-06508: PL/SQL: could not find program unit being called: "SYS.DBMS_STATS"

›
After applying the patch (26925311: DATABASE PATCH SET UPDATE 12.1.0.2.180116)  in Oracle Database 12.1.0.2. We have faced below errors whi...

ORA-29548: Java system class reported: release of Java system classes in the database (12.1.0.2.0 1.6) does not match that of the oracle executable (12.1.0.2.180116 1.6)

›
We have faced the below error while applying the below patch in Oracle E-Business Suite 12.2.7 (Upgrade). Patch:  adop phase=apply patche...
Sunday, 11 February 2018

Exception in thread "main" java.lang.OutOfMemoryError: GC overhead limit exceeded : bsu.sh

›
We have faced java memory issue while applying weblogic patches in Oracle E-Business Suite R12.2.7 Error: [applmgr@test bsu]$ ./bsu.sh -...
Wednesday, 7 February 2018

Kernel of proper version is not found on node "test" [Expected = "2.6.39" ; Found = "2.6.32-300.3.1.el6uek.x86_64"]

›
The following error occurred while installing Oracle E-Business Suite 12.2.7 (Database pre-install checks failed). Error: ERROR: [Resul...
Tuesday, 6 February 2018

libmawt.so: libXtst.so.6: cannot open shared object file: No such file or directory at java.lang.ClassLoader$NativeLibrary.load(Native Method)

›
This error occur while trying to  ./rapidwiz-version in Oracle linux 6, and resulting the Wrong package version. Issue: Rapid Install W...
Wednesday, 24 January 2018

RMAN-06059: expected archived log not found, loss of archived log compromises recoverability

›
RMAN backup failed with the below error message and its require archive log files to complete the RMAN backup. Error: RMAN-00571: =====...
Wednesday, 3 January 2018

How to Rotate or Purge Listener Log Data to Avoid Large listener.log File?

›
How to rotate or backup or rename listener.log or purge listener log data to avoid large listener.log file? Below are the possible ways t...
›
Home
View web version
Powered by Blogger.