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!

▼
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...
Monday, 4 December 2017

How to move RAC Database ORACLE_HOME from one location to another location

›
Below are the steps to move the RAC database ORACLE_HOME from one location(filesystem) to another location. This post for database home o...
Monday, 16 October 2017

ORA-00304: requested INSTANCE_NUMBER is busy

›
ORA-00304: requested INSTANCE_NUMBER is busy On starting upon instance  in 2 Node RAC Database,We got the below error message. SQL> ...
Monday, 4 September 2017

How to find the Weblogic Admin Console URL Location in Oracle OEM?

›
 We can find the details from setupinfo.txt file. This file is created during the installation time.   Location : $ORACLE_HOME/oms/insta...
Tuesday, 1 August 2017

How to find the OPP log file location in oracle application 11i/R12.1 and R12.2

›
Below script to find the OPP log file location in oracle E-Business Suite. Script: SELECT fcpp.concurrent_request_id req_id, fcp.node_n...
Wednesday, 26 July 2017

Growth of oracle database size in day, week and month wise

›
Below query to get the database size growth in day, week and month wise. Query: set linesize 210 set linesize 210 COL "Database ...

Query to get the Custom Tables List in oracle application

›
Below query to get the list of custom tables in oracle application. Query: select object_name,    object_type from all_objects where...

Query to get list of Custom Form List in oracle application

›
Below query to get the list of Custom Form List in oracle application. Query: SELECT  DISTINCT forms.form_name,          formstl.user_...

Query to get list of Custom Concurrent Programs in oracle applications

›
Below query to get the list of Custom Concurrent Programs in oracle applications. Query: SELECT   DISTINCT fcp.user_concurrent_program_...
Thursday, 8 June 2017

Primary database error ORA-07217: sltln: environment variable cannot be evaluated

›
Error: Primary database throw below error while trying to transport archive log to standby database ALTER SYSTEM SET log_archive_dest_s...

ORA-04024: self-deadlock detected while trying to mutex pin cursor

›
Error: Database errors when trying to open with the following: SQL> alter database open; alter database open * ERROR at line 1: ...
Thursday, 27 April 2017

fs_clone Error 1 occurred while Executing txkADOPValidation script

›
Error: Lines #(73-77):     [PROCEDURE] Calling: /u01/app/applmgr/TEST/fs1/EBSapps/appl/ad/12.0.0/patch/115/bin/txkADOPValidations.pl   ...
Wednesday, 26 April 2017

Oracle Application R12 forms not opening in Linux

›
When we are trying to access forms in Oracle apps R12.1 in Linux got the below error. Error: Fix: When you done with the plu...

error while loading shared libraries: libXtst.so.6: cannot open shared object file: No such file or directory

›
Error: Concurrent program error with the following message. error while loading shared libraries: libXtst.so.6: cannot open shared obje...

GConf Error: Failed to contact configuration server; some possible causes are that you need to enable TCP/IP networking for ORBi

›
Error: GConf Error: Failed to contact configuration server; some possible causes are that you need to enable TCP/IP networking for ORBit,...
Sunday, 23 April 2017

RC-50004: Fatal: Error occurred in ApplyDatabase:

›
While installing application R12.1.1, we got the below error. Error: RC-50004: Fatal: Error occurred in ApplyDatabase: Control file c...
Friday, 21 April 2017

IO Error: Got minus one from a read call vendor code 17002

›
When we are trying to connect database by using Sql developer, we got below error. Error: IO Error: Got minus one from a read call vend...
Tuesday, 4 April 2017

License Manager Showing Asia/Pacific Localizations (JA) as 'Not Licensed'?

›
License Manager Showing Asia/Pacific Localizations (JA) as 'Not Licensed'. How to get it Licensed ? Please do the following:...

How to find Asia/Pacific Localizations (JA) Installed or not in Oracle E-Business Suite (R12.1 / R12.2)

›
Below script to find the Asia/Pacific Localizations (JA) Installed or not in Oracle E-Business Suite instance. Script: SELECT SUBSTR(a....
‹
›
Home
View web version
Powered by Blogger.