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!

▼
Monday, 29 February 2016

Error applying patch 10338643:R12.ONT.B. This patch is compatible with: entity 'icx' 'R12.ICX.C'

›
Issue: Error when trying to apply Patch 10338643:R12.ONT.B This patch is not compatible with your current codelines. This patch is co...
Friday, 26 February 2016

Gather Schema Statistics Is Failing With ORA-20000 Error For Tables Ending With _TAB

›
Issue:  FDPSTP failed due to ORA-20000: Unable to analyze TABLE "APPS"."COSTPARAMETERS1358_TAB", insufficient privile...
Thursday, 25 February 2016

How to run garbage collection in Weblogic

›
You can manually request that the JVM perform garbage collection. Make sure that full garbage collection is necessary before selecting it o...
Tuesday, 23 February 2016

Oracle E-Business Suite Applications 12.2.5 New Features

›
New Features in Oracle apps R12.2.5 This section contains details pertaining to the features that are new or changed since the pr...

ORA-00060: deadlock detected while waiting for RESOURCE DB PREP during Online Patching Enablement script (Database Preparation script) execution.

›
Error details: ORA-00060: deadlock detected while waiting for RESOURCE DB PREP begin APPS.ad_zd_mviews.upgrade('APPS','<M...

adop exits with the error "Unable to acquire lock on ad_adop_sessions table." Related to bug: 17650145

›
Issue: adop exits with the error "Unable to acquire lock on ad_adop_sessions table." Related to bug: 17650145. Error details:...

How To diagnose the "Root Cause" of OPP (java process) consuming High CPU

›
To find the " Root Cause" for OPP (java) processes consuming High CPU .  Most of the time it is due to un-optimized "Templat...
Sunday, 21 February 2016

What is ADOP in Oracle Apps R12.2

›
ADOP is Online Patching utility tool. It will Perform all the below tasks required to apply the patch in R12.2. *)  Reads the patch metad...
Saturday, 20 February 2016

Oracle Apps R12.2 File System Architecture

›
Below is the File System Architecture details in Oracle apps R12.2.

ISG Architecture in Oracle Apps R12.1 and R12.2

›
Below is the Architectural changes between Oracle Apps R12.1 and R12.2 for ISG (Integrated SOA Gateway) setup.

Patching procedure in oracle apps R12.2

›
From R12.2 onwards oracle has introduced online patching functionality. Phases of ADOP(online patching): In R12.2.0 we have ADOP –...
Thursday, 18 February 2016

Current Patchset level of oracle apps R12

›
Below script or steps to know the current Patchset level of oracle apps R12. Back-end: Step 1: Source the .env file of oracle applica...
Wednesday, 3 February 2016

Unexpected Error On R12.2 Home Page

›
Error Message: (WebAppServletContext.java:2181) at weblogic.servlet.internal.ServletRequestImpl.run(ServletRequestImpl.java:1491) at we...

R12: "FRM-92101:There was a failure in the Forms Server during startup" Error When Attempting to Launch Forms

›
We are facing an error when Attempting to launch forms in oracle application R12. Issue: FRM-92101 : There was a failure in the Forms S...
Friday, 29 January 2016

Script for concurrent request details using Request Id

›
Below script for running concurrent request details using Request Id. Script: set head off set verify off set echo off set pages 150...

Script for scheduled concurrent programs on particular date and time

›
Below script for scheduled concurrent details on exact date and time. Script: SELECT   fcr.request_id,          DECODE (fcpt.user_conc...
Thursday, 28 January 2016

Adadmin Fails after schema password has been changed through AFPASSWD

›
We are facing with adadmin fails after changing the password using AFPASSWD. Below is the issue and fix for solving the issue. Issue: A...
Wednesday, 27 January 2016

adopmnctl.sh exit with status 206 in oracle apps R12

›
We are facing issue while restarting opmnctl services. Issue: -bash-3.2$ cd $ADMIN_SCRIPTS_HOME -bash-3.2$ sh adopmnctl.sh startall ...

How to create a schema with existing schema permissions in oracle database

›
In my case existing schema is APPS and need to create a schema like CMSRC. Step 1: SQL> Set long 100000000 SQL> select dbms_meta...
Tuesday, 26 January 2016

How to run Autoconfig in TEST mode

›
When we run Autoconfig, It will update the existing configuration file. To prevent any unwanted changes, we can run the Autoconfig in TEST ...
‹
›
Home
View web version
Powered by Blogger.