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!

▼
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....
Thursday, 23 March 2017

adop fs_clone phase fails after upgrading FMW to 11.1.1.7

›
The adop fs_clone phase fails after upgrading FMW to 11.1.1.7 with the following error: Error: Log file located at /u01/ebs/apps/fs1/in...

URL validation failed. The error could have been caused through the use of the browser's navigation buttons ( the browser Back button or refresh, for example). If the error persists, Please contact system administrator.

›
When we are trying to access the Oracle E-Business Suite R12.2.5 forms in Internet Explorer 10, we are getting below error. Error: ...
Wednesday, 22 March 2017

ORA-06512: at "APPS.HR_API_USER_HOOKS_UTILITY", line 891

›
When attempting to apply 12.2.6 patch: 21900901:oracle e-business suite 12.2.6 release update pack the following error occurs. ERROR:...
Sunday, 19 March 2017

Oracle E-Business Suite R12.2 major technology components

›
Oracle E-Business Suite uses the following major technology components in Release 12.2:

Oracle E-Business Suite R12.2.6 New and Changed Features

›
Oracle E-Business Suite Technology Stack and Oracle E-Business Suite Applications DBA contain the following new or changed features in Rel...
‹
›
Home
View web version
Powered by Blogger.