Category Archives: Patch

Determining if Maintenance Mode is Running

Posted on January 1, 2012 by digappsdba

A quick way to verify if the Environment is on Maintenance Mode or not, is by checking the value of this Profile Option as follows: sqlplus apps/apps SQL> select fnd_profile.value(‘APPS_MAINTENANCE_MODE’) from dual; If the query returns ‘MAINT’, then Maintenance Mode … Continue reading →

Posted in APPS DBA, Patch | Leave a comment

ce8509466.sql || patch 9239090

Posted on May 20, 2010 by digappsdba

Below error while applying 9239090 or any patch : Facing below error while applying 9239090. sqlplus -s APPS/***** @/apps/apps_st/appl/ce/12.0.0/patch/115/sql/ce8509466.sql Connected. DECLARE * ERROR at line 1: ORA-29282: invalid file ID ORA-06512: at “SYS.UTL_FILE”, line 878 ORA-06512: at line 72 ORA-29283: … Continue reading →

Posted in Patch | Leave a comment