Database Blog

R12 E-Business Suite Output Post Processor (OPP) Fails To Pick Up Concurrent Requests With Error ‘Unable to find an Output Post Processor service to post-process request nnnnn’

Requests fail during Post Processing with the following errors: ‘Unable to find an Output Post Processor service to post-process request xxxxx. Check that the Output Post Processor service is running’…

Read More

Using sql_profile to force a execution plan

Often, we face an issue where developers shout on us that their query was performing good and now it is behaving bad. There can be many cause for this lag…

Read More

No Write Permission on ACFS Mount Point

We managed to create the ACFS Mount Point after resolving the issue “ACFS-9459: ASVM/ACFS is not supported on this os version”. But, after creating the ACFS Mount Point, I’m unable…

Read More

How To Purge FND_AQ Tables

Symptoms(Doc ID 1156523.1) 1. The Internal standard manager take a long time to startup 2. The table AQ$_FND_CP_GSM_OPP_AQTBL table grow up enormously and has a lot of records 3. The…

Read More

AutoConfig Encounters ORA- errors in a fresh physical standby database for EBS 12.2.7

           For the past few days, i was making my hands dirty on setting up a physical standby database for EBS 12.2.7. Once i had created…

Read More

Untitled

How To Allow ADOP To Continue As If It Were Successful After Hitting An Error While Applying Patch(es) We can skip patches when there are multiple patches in a cycle…

Read More

ORA-15067: command or option incompatible with diskgroup redundancy

When dropping an online disk from a diskgroup why is ORA-15067 error returned? SQL> alter diskgroup data01 drop disk data01_01; alter diskgroup data01 drop disk data01_01 * ERROR at line…

Read More

Untitled

                                         Data dictionary corruption details – Timestamp mismatch Time stamp mismatched…

Read More

Untitled

Timeout Error Encountered for pasteBinary.sh While Running “adop phase=fs_clone” While running fs_clone phase in 12.2.2, we have faced  the following issue. Error: Enabling EBS_LOGON trigger Error while executing [filesystem]/fs2/inst/apps/[context_name]/appltmp/alter_ebs_logon_trigger.sql Failed to…

Read More

expdp job still executing even after killed from OS level

I killed a expdp job from OS level but I saw that the job still executing. I started the job as background like below: $ nohup expdp “/ as sysdba”…

Read More