Readmeout Oracle DBA Blog

Users Notification Preference Becomes Disabled In FND_USER_PREFERENCES Table| Lets understand why notification_preferencefor recipients to become DISABLED. If your email server crashed andcaused an outage of several hours, then it’s caused the recipients notification_preference to change to DISABLEDin the FND_USER_PREFERENCESand WF_LOCAL_ROLEStables.   Steps to troubleshoot Users Notification Preference Becomes Disabled   We can find out those users that … Read more

IAS component OC4JGroupdefault_group OC4Joacore stopped failed automatically in EBS| To resolve the above issue, need to be modify/increase the JVM processes as below in context file:  In our production instance IAS component “oacore” frequently down/failed. IAS component OC4JGroupdefault_group OC4Joacore stopped failed Check the services in case of oacore failure. $sh adapcctl.sh status You are running … Read more

adop phase=prepare ORA-20008: No Concurrent Manager is running that can run concurrent program| To resolve the issue, truncate table applsys.ad_nodes_config_status and rerun the adop cycle. Adop phase=prepare ORA-20008: No Concurrent Manager is running. Below error coming while executing dop phase=prepare.       Solution:-   Set the Run filesystem / environment and run command: FNDLOAD … Read more

How To Purge E-Mail workflow notifications From the EBS workflow queue. | Sometimes we need to purge the huge workflow notifications queue in EBS workflow, because of mailer services got failed and giving an error while starting or while refreshing/cloning new instance.  How To Purge E-Mail workflow notifications? As we know that old e-mail workflow … Read more

How to check database is running with spfile or pfile | In oracle database there is couple of way to find out whether database is running with spfile or pfile. Parameter File How to check database is running with spfile or pfile. 1.SQL> show parameter spfile;   After executing above returns blank then database was … Read more

Difference between physical and logical backup in oracle | In this post, we will discuss the about differences between physical (RMAN) and logical backup(expdp). Difference between physical and logical backup. Physical backup is backup of the physical files such as datafiles, control files, and archived redo logs. Ultimately, every physical backup is a copy of files … Read more

Introduction: – Here will cover to fix POCFH Fill Employee Hierarchy. The file poxpofeh.sql appear to be missing. To resolve it we need to apply the required patch. Error:-Routine fdpsql cannot read the file /data01/apps/apps_st/appl/po/12.0.0/sql/poxpofeh.sql.   How to POCFH Fill Employee Hierarchy?   Check if the file exists under correct product directory. Check if the … Read more

Here we will discuss ‘what is control file in oracle’ and ‘how to multiplex control files on separate disk’.       What is control file in oracle.     Control file is a binary file which stores Database name, associated data files, redo files, DB creation time and current log sequence number. Without control … Read more

In this post we will covers ‘How to resolve ORA-12514: TNS:listener does not currently know of service requested in connect descriptor. How to fix ORA-12514 TNSlistener does not currently know of service? ERROR DESCRIPTION:(*******FATAL ERROR*******PROGRAM : (*******/fs1/EBSapps/appl/fnd/12.0.0/patch/115/bin/txkPrepareACTables.pl)TIME    : Sat Sep  8 10:25:42 2018FUNCTION: TXK::SQLPLUS::_doExecute [ Level 3 ]MESSAGES:Invalid Connect string – cannot connect to … Read more