Apply PSU on Oracle 11g Database

Steps to Apply PSU 5 on Oracle 11.2.0.3 Database

Oracle recommends to apply Latest available PSU-1

1) Download and install p6880880_112000_Linux-x86-64(Pre-Req patch)

a) Backup the $ORACLE_HOME/OPatch directory
b) Remove the contents of OPatch directory
c) cp the patch in p6880880_112000_Linux-x86-64.zip at $ORACLE_HOME and unzip the patch(unzip -o patchno)
d) Check Prereq pf patch
Go to patch 14727310 location
Run -> opatch prereq CheckConflictAgainstOHWithDetail -ph ./


e) Rollback patch 13004894
opatch rollback -id 13004894

f) Apply the patch 14727310
opatch apply

g) Apply patch 13004894
opatch apply

Change Override address in Workflow Mailer

Change Override address in Oracle workflow mailer from backend

1) Check current Override address
select fscpv.PARAMETER_VALUE from fnd_svc_comp_param_vals fscpv
where fscpv.parameter_id in (select fscpt.parameter_id
from fnd_svc_comp_params_tl fscpt
where fscpt.display_name = 'Test Address');


2) Update with new override address
update fnd_svc_comp_param_vals fscpv
set fscpv.PARAMETER_VALUE = 'vivek.bhutani@xyz.com'
where fscpv.parameter_id in (select fscpt.parameter_id
from fnd_svc_comp_params_tl fscpt
where fscpt.display_name = 'Test Address');


3) Confirm the new override address
select fscpv.PARAMETER_VALUE from fnd_svc_comp_param_vals fscpv
where fscpv.parameter_id in (select fscpt.parameter_id
from fnd_svc_comp_params_tl fscpt
where fscpt.display_name = 'Test Address');

How to disable maintenance mode in oracle apps

Disable the maintenance mode from sqlplus in Oracle ERP

$ cd $AD_TOP/patch/115/sql

$ sqlplus apps/apps

SQL> select fnd_profile.value('APPS_MAINTENANCE_MODE') from dual;

SQL> @adsetmmd.sql DISABLE

Drop Database

How to Drop Oracle 10g/11g Database

SQL> startup mount restrict
ORACLE instance started.

Total System Global Area 6413680640 bytes
Fixed Size 2240344 bytes
Variable Size 452985000 bytes
Database Buffers 5939134464 bytes
Redo Buffers 19320832 bytes
Database mounted.
SQL> select name from v$database;

SQL> drop database;