Minimum Baseline for Extended Support are you Ready ?

Posted by gadi.chen on Oracle Blogs See other posts from Oracle Blogs or by gadi.chen
Published on Mon, 21 Feb 2011 16:15:33 +0200 Indexed on 2011/02/21 15:30 UTC
Read the original article Hit count: 404

Filed under:

As you all know the Premier support for 11i was ended last year.
The extended support is available, but to use it you are advised to be at a minimum patch level as describe in note: 883202.1.

So how you can know if you are in the minimum patch level?
So, there are few ways.


  1. Patch wizard.

  2. Contact Oracle Support.

  3. Upload me


Patch wizard
Easy to use, very intuitive, required installing patch 9803629.
Check MOS note: 1178133.1

Oracle Support
You can log an SR thru My Oracle Support a.k.a MOS.

Upload me
In this option you will need to run simple sql statement (attached below or you can download it from here
patchinfo.sql ) via sql*plus and upload/mail me the output and I will mail you back as soon as I can a detailed report of the required patches to be installed in order to be supported.


Gadi Chen
Oracle Core Technology Consultant
[email protected]


-------------------------------- Start from Here ---------------------------------
set pagesize 0 echo off feedback off trimspool on timing off
col prod format a8
col patchset format a15
spool patchinfo.txt
select instance_name, version from v$instance;
select bug_number from ad_bugs;
prompt EOS
select decode(nvl(a.APPLICATION_short_name,'Not Found'),
'SQLAP','AP','SQLGL','GL','OFA','FA',
'Not Found','id '||to_char(fpi.application_id),
a.APPLICATION_short_name) prod,
fpi.status, nvl(fpi.patch_level,'Unknown') patchset
from fnd_application a, fnd_product_installations fpi
where fpi.application_id = a.application_id(+)
and fpi.status != 'N'
and fpi.patch_level is not null
order by 2,1;
spool off;
exit


© Oracle Blogs or respective owner