Oracle Application Blog

TXK Delta 13 failed due to missing files

TXK Delta 13(32392507) plus critical TXK patches 33550674, 33535778 failed because of missing files adsign.txt and adkeystore.dat under $APPL_TOP_NE/ad/admin The Solution: The apply phase failed twice, once when looking for…

Read More

Adop Phase=cutover Failing With AutoPatch – AidafoGetFileDbVersion: INFO: ORA-01403: No Data Found

AutoPatch – aidafoGetFileDbVersion: INFO: ORA-01403: no data found when apply adop phase=cutover failing with AutoPatch Please follow below steps to overcome this issue Confirm that value for READ_ONLY_FLAG and ENABLED_FLAG…

Read More

Deep Dive – Data Dictionary Views

Introduction:-  The current topic should be very familiar to the freshers and DBA’S as we know earlier. In general, The data dictionary is structured in tables and views, just like…

Read More

Role of Global Names in Database Links

ROLE OF GLOBAL NAMES IN DATABASE LINKS Introduction:-  This is mainly for Oracle DBA’S who are widely seen about Database links in their organizations, Let us understand closely about the…

Read More

How to run SQL tuning advisor manually in Oracle Database

Step 1:  Get the hash value of the SQL using the SQL ID. Enter the SQL ID select a.plan_hash_value from v$sql a where sql_id=’&a’;   Step 2: Create a tuning…

Read More

EBS Workflow Mailer Command Line Java Diagnostic Tests for Office365,GMail,On-Premises Email Servers

EBS Workflow Mailer Command Line Java Diagnostic Tests for Office365,GMail,On-Premises Email Servers  Very often in Workflow service requests, one will be requested to run Workflow Mailer Command Line Java Test…

Read More

E Business Suite AccessGate Redirect To Non SSL URL’s in External Tier

Oracle E-Business Suite 12.1.3 Access Manager, Access Manager issues Actual Behavior In E-Business Suite integrated with OAM, accessing iSupplier will redirect from https to http URL in log in page. …

Read More

SYS and SYSTEM Password no longer needed in E-Business Suite

Introduction: R12.2 is being modernized with many new functionalities and changes in architecture. We, as a DBA, rely on SYS and SYSTEM passwords for any activities like patching/cloning and upgrading.…

Read More

fs_clone fails with ETCC not run in the database node

Introduction: This blog discusses about ADOP fs_clone error in E-Business suite. The intended audience of this blog are E-Business suite DBA’s On running fs_clone it may fail with error as…

Read More

ADOP Prepare fails with ORA-20001

Introduction:   This blog discusses about ADOP error in E-Business suite. The intended audience of this blog are E-Business suite DBA’s While running ADOP Prepare phase as a part of…

Read More