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!

▼
Thursday, 31 March 2016

Adop Phase=prepare Failed After Creating the Custom Application

›
Issue: The adop phase=prepare failed with error.  The unexpected error occurred while executing txkADOPPreparePhaseSynchronize.pl. In t...

Creating a Custom Application in Oracle E-Business Suite Release 12.2

›
Section 1: Create A Custom Application Using adsplice: 1. Download Patch 3636980 "Support Diagnostics (IZU) patch for AD Splice...
Wednesday, 30 March 2016

Upgrade interview questions oracle database

›
1. Oracle database upgrade from version to version. * Direct upgrade to Oracle 10g is only supported if your database is running one of th...

Opatch interview questions in oracle database

›
1. What is Opactch in Oracle? The Opatch utility is a tool that allows the application and rollback of interim patches to Oracle products....

ADOP (Online Patching) Interview question in oracle apps R12.2

›
1.What is ADOP concept in oracle apps? Online patching is the most important new feature in Oracle E-Business Suite Release 12.2. It is th...
Tuesday, 29 March 2016

Interview questions related to patching in oracle apps

›
1.What is a one-off patch? An one-off patch is a small patch (of without any pre-requisites) to fix a bug. 2.What is a mini pack? A min...
Monday, 21 March 2016

SYSADMIN Responsibility is not showing after instance refresh

›
We are unable to see the SYSADMIN responsibilities after instance refresh. We followed the below steps to resolve this issue. Updating wf...
Tuesday, 15 March 2016

ADOP phase=prepare is failing at adconfig on the adgenjky.sh script while upgrade

›
Issue: While trying to apply E-Business Suite 12.2.3 Release Update Pack, the ADOP phase=prepare is failing at adconfig and adconfig is f...

Online patching cycle over view in oracle apps R12.2

›
Below is the detailed over view of online patching cycle activity. Adop Phases: Phase 1- Prepare: Phase 2- Apply: ...
Thursday, 10 March 2016

How to assign responsibilities of one user to another user without using front end oracle apps

›
In this post we will get to know how to assign all the responsibilities of one user to another user without opening form sessions. Here...

Restore INST_TOP if it is deleted or corrupted accidently?

›
Below steps to restore the INST_TOP if it is deleted or corrupted without using adcfgclone. Step 1:   If we have CONTEXT_FILE backu...
Wednesday, 9 March 2016

Important FND Tables in Oracle Application

›
Below are the important FND Tables in Oracle Application. FND_APPLICATION_TL:  Stores translated information about all the applications ...

How to find all responsibilities of a user in oracle apps

›
Below script to know about the all responsibilities of a user in oracle apps. Script: SELECT fu.user_name                "User Nam...

How to find which user have SYSADMIN responsibility in oracle apps

›
Below script to know the users who have SYSADMIN responsibility in oracle apps. Script: SELECT fu.* FROM fnd_user_resp_groups_direct f...
Monday, 7 March 2016

RMAN-00600 [8546] Trying To Duplicate Database.

›
Error: Duplicating database - control files are restored, data files are stamped, memory script is displayed and then error occurs. RMA...
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...
‹
›
Home
View web version
Powered by Blogger.