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 MoreEBS 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 MoreE 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 MoreSYS 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 Morefs_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 MoreADOP 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 MoreFailure of Web Server bridge: No backend server available for connection: timed out after 10 seconds or idempotent set to OFF or method not idempotent.
ERROR ———————– Failure of Web Server bridge: No backend server available for connection: timed out after 10 seconds or idempotent set to OFF or method not idempotent. Cause —————————– We…
Read MoreAPP-AR-11526: ORA-00054: resource busy and acquire with NOWAIT specified or timeout
The issue reproduced when AutoInvoice is run in parallel by 2 different users and from 2 different machines in apps R12.1.3. IMPACT: Due to this issue, users cannot run autoinvoice…
Read MoreResolving autoconfig issue with patch file system “adgendbc.sh INSTE8_SETUP”
Problem: In the execution of autoconfig in the patch file system. we faced the following error. [SETUP PHASE] AutoConfig could not successfully execute the following scripts: Directory: /u01/apps/fs2/inst/apps/TEST_TESTEBSSYS01/admin/install adgendbc.sh INSTE8_SETUP…
Read MoreControlling Diagnostic and Tuning Pack
In this blog, we will see what controls Automatic Workload Repository in Oracle. For those who arrived to this blog and new, you will need to know more about Controlling…
Read More