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.
Patch wizard.
Contact Oracle Support.
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
