Determining 11i Family Pack Versions

You’re trying to install a one-off functional fix, but the patch says you must be on AP.N or greater.  You could try to dig through notes, OAM, or some other method to determine what version you’re on.  Or you could go “old school”.  WARNING: requires command prompt knowledge! Just kidding there.  Seems that nobody wants you to use a command prompt anymore…

That said, go to some logical directory (or make one) on (one of) the applications tier of the environment in question.

$ wget ftp://ftp.oracle.com/support/outgoing/PATCHSET_COMPARE_TOOL/patchsets.sh

$ chmod +x patchsets.sh

$ ./patchsets.sh (provide apps/password@SID when it asks)

Sit back and watch it spool… it will create a text version of what you’re seeing on screen as Report_11i.txt.

$ cat Report_11i.txt

=============================================================================
 Report Generated: Thu Jan 21 13:31:58 EST 2010               Tool Version:  4.47
 Patchsets List Updated: Jan 20 22:30
 Machine/OS: Linux localhost 2.6.18-164.6.1.el5PAE #1 SMP Tue Oct 27 11:46:58 EDT 2009 i686 i686 i386 GNU/Linux
 Domain:
 applptch Source: Patch.csv
 Version from APPLPTCH: 11.5.10.2
 Database: TEST
 Limited Report to: APPLFULL and APPLSHAR products
 APPLFULL: AK ALR AMF AMS AP AR ASF AS ASL ASO ASP AST AX AZ BIC BIL BIM BIS BIV BIX BNE BOM CCT CE CHV CN CRP CSC CSE CS CSI CSS CUG CZ EC ECX EDR ENG FA FII FLM FND FRM FUN FV GHR GL GMA GMD GME GMF GMI GML GMP GR HRI HZ IBA IBC IBE IBY ICX IEB IEM IEO IES IEU IEX IGI INV ISC IZU JTF JTM MRP MSC MSD MSO OKC OKI OKS OKX ONT OPI OTA OZF PA PER PJM PMI PN POA PO PQH PSA PSB PV QA QOT QP RG SSP WIP WPS WSH XDO XNI XNP
 APPLSHAR: AD AMV ASG AU BEN CSD CSF CUA DT FF HXT IBU MFG OZP OZS PAY PSP RHX SHT XDP XLA
 Pseudo Products:  ADX AME AML BLC BPA CAC CDR CLE CSK CSZ CTB EDW EWS FTP FWK HCP HCT IGP IGR IPATCH IRC ISX ITA ITM JTA JTH JTO JTP JTT JTU JTY MSX OAM OCM OIE OIR OIT OWF PFT PJR POV RCM TXK UMX
 Written By: Oracle Support Services
 WARNING: DOWNLOAD CHANGING NOVEMBER 3rd, 2006
 Program Updates: ftp://ftp.oracle.com/support/outgoing/PATCHSET_COMPARE_TOOL
 Download Patchsets: Go to link below or click on Patches

http://metalink.oracle.com/metalink/plsql/dis_download.startup

=============================================================================

 FAMILY PACK PATCHES
Product    Baseline                  Running Version           Latest Available          Status                   
atg_pf                               11i.ATG_PF.H.7(6241631)   11i.ATG_PF.H.7(6241631)   Rel-By_Metal             
bis_pf                               11i.BIS_PF.D.1(4054609)   11i.BIS_PF.H(5565583)     Rel-By_Metal             
cc_pf      11i.CC_PF.Q(2644375)      11i.CC_PF.R(3202573)      11i.CC_PF.R(3202573)      Rel-By_Metal             
com_pf     11i.COM_PF.A(2036253)     11i.COM_PF.A(2036253)     11i.COM_PF.A(2036253)     Rel-By_Dev               
dmf_pf     11i.DMF_PF.I(2697753)     11i.DMF_PF.J(2771139)     11i.DMF_PF.J(2771139)     Rel-Not_Dist             
exchg_pf                                                       11i.EXCHG_PF.C(2147366)   Rel-By_Metal             
finap_pf                                                       11i.FINAP_PF.A(1712173)   Obs-By_Metal             
finar_pf                                                       11i.FINAR_PF.A(1712197)   Obs-By_Metal             
fingb_pf                                                       11i.FINGB_PF.B(1719741)   Obs-By_Metal             
fin_pf     11i.FIN_PF.D(2629235)     11i.FIN_PF.G(3653484)     11i.FIN_PF.G(3653484)     Rel-By_Metal             
hc_pf                                                          11i.HC_PF.E.3(5178799)    Rel-By_Metal             
hr_pf      11i.HR_PF.E(2803988)      11i.HR_PF.K.3(6699770)    11i.HR_PF.K.4(7666111)    Rel-By_Metal             
mas_pf                               11i.MAS_PF.A(3386886)     11i.MAS_PF.A(3386886)     Rel-By_Metal             
mkt_pf     11i.MKT_PF.B(2630927)     11i.MKT_PF.B(2630927)     11i.MKT_PF.B(2630927)     Rel-By_Metal             
ok_pf      11i.OK_PF.I(2661036)      11i.OK_PF.J(3195181)      11i.OK_PF.J(3195181)      Rel-Not_Dist             
om_pf      11i.OM_PF.I(2698175)      11i.OM_PF.J(3210616)      11i.OM_PF.J(3210616)      Rel-Not_Dist             
opm_pf     11i.OPM_PF.J(2433137)     11i.OPM_PF.L(2916642)     11i.OPM_PF.L(2916642)     Rel-Not_Dist             
pj_pf      11i.PJ_PF.K(2484626)      11i.PJ_PF.L.10(3397153)   11i.PJ_PF.M(3485155)      Rel-By_Metal             
plm_pf     11i.PLM_PF.A(2720739)     11i.PLM_PF.C(3298676)     11i.PLM_PF.E(4203793)     Rel-By_Metal             
prc_pf     11i.PRC_PF.I(2700001)     11i.PRC_PF.J(3219529)     11i.PRC_PF.J(3219529)     Rel-Not_Dist             
scm_pf                               11i.SCM_PF.J(3384350)     11i.SCM_PF.J(3384350)     Rel-By_Metal             
scp_pf     11i.SCP_PF.I(2696797)     11i.SCP_PF.J(3200668)     11i.SCP_PF.J(3200668)     Rel-Not_Dist             
sem_pf                                                         11i.SEM_PF.A(4020035)     Rel-By_Dev               
sls_pf     11i.SLS_PF.G(2645935)     11i.SLS_PF.G(2645935)     11i.SLS_PF.G(2645935)     Rel-By_Metal             
srv_pf     11i.SRV_PF.I(2713120)     11i.SRV_PF.J(3169650)     11i.SRV_PF.J(3169650)     Rel-Not_Dist             

FULLY INSTALLED PRODUCTS
Product    Baseline                  Running Version           Latest Available          Status                   
ak         11i.AK.G(3263645)         11i.AK.G(3263645)         11i.AK.G(3263645)         Rel-By_Metal             
alr        11i.ALR.G(3261254)        11i.ALR.G(3261254)        11i.ALR.G(3261254)        Rel-By_Metal             
amf        11i.AMF.C(3134002)        11i.AMF.C(3134002)        11i.AMF.C(3134002)        Rel-Not_Dist             
ams        11i.AMS.I(3025816)        11i.AMS.I(3025816)        11i.AMS.I(3025816)        Rel-Not_Dist             
ap         11i.AP.M(3151444)         11i.AP.N(3617668)         11i.AP.O(4551936)         Rel-By_Metal             
ar         11i.AR.N(3151465)         11i.AR.O(3617855)         11i.AR.O(3617855)         Rel-Not_Dist             
asf        11i.ASF.H(3046985)        11i.ASF.H(3046985)        11i.ASF.H(3046985)        Rel-Not_Dist             
as         11i.AS.I(3046981)         11i.AS.I(3046981)         11i.AS.I(3046981)         Rel-Not_Dist             
asl        11i.ASL.I(3780558)        11i.ASL.I(3780558)        11i.ASL.J(4111404)        Rel-By_Metal             
aso        11i.ASO.M(2937137)        11i.ASO.M(2937137)        11i.ASO.M(2937137)        Rel-By_Metal             
asp        11i.ASP.B(2212166)        11i.ASP.B(2212166)        11i.ASP.C(4111409)        Rel-By_Metal             
ast        11i.AST.H(3046996)        11i.AST.H(3046996)        11i.AST.H(3046996)        Rel-Not_Dist             
ax         11i.AX.I(3151359)         11i.AX.J(3617516)         11i.AX.J(3617516)         Rel-Not_Dist             
az         11i.AZ.F(3251003)         11i.AZ.F(3251003)         11i.AZ.H.2(7293818)       Rel-By_Metal             
bic        11i.BIC.S(3367777)        11i.BIC.T(4016830)        11i.BIC.T(4016830)        Rel-By_Metal             
bil        11i.BIL.O(3061845)        11i.BIL.O(3061845)        11i.BIL.O(3061845)        Rel-Not_Dist             
bim        11i.BIM.O(3025758)        11i.BIM.O(3025758)        11i.BIM.O(3025758)        Rel-Not_Dist             
bis        11i.BIS.J(3673034)        11i.BIS.L.4(5212746)      11i.BIS.L.9(5912291)      Rel-By_Metal             
biv        11i.BIV.S(3014204)        11i.BIV.S(3014204)        11i.BIV.S(3014204)        Rel-Not_Dist             
bix        11i.BIX.T(3112625)        11i.BIX.T(3112625)        11i.BIX.T(3112625)        Rel-By_Dev               
bne        11i.BNE.C(2819091)        11i.BNE.D(3218526)        11i.BNE.D(3218526)        Rel-By_Metal             
bom        11i.BOM.J(2768762)        11i.BOM.J(2768762)        11i.BOM.J(2768762)        Rel-Not_Dist             
cct        11i.CCT.R(2687381)        11i.CCT.R(2687381)        11i.CCT.R(2687381)        Rel-By_Dev               
ce         11i.CE.J(3151412)         11i.CE.K(3617940)         11i.CE.K(3617940)         Rel-Not_Dist             
chv        11i.CHV.F(3212221)        11i.CHV.F(3212221)        11i.CHV.F(3212221)        Rel-Not_Dist             
cn         11i.CN.H(3061842)         11i.CN.H(3061842)         11i.CN.H(3061842)         Rel-By_Metal             
crp        11i.CRP.F(2770107)        11i.CRP.F(2770107)        11i.CRP.F(2770107)        Rel-Not_Dist             
csc        11i.CSC.Q(3014206)        11i.CSC.Q(3014206)        11i.CSC.Q(3014206)        Rel-Not_Dist             
cse        11i.CSE.P(3195218)        11i.CSE.P(3195218)        11i.CSE.P(3195218)        Rel-Not_Dist             
cs         11i.CS.Q(3022934)         11i.CS.Q(3022934)         11i.CS.Q(3022934)         Rel-Not_Dist             
csi        11i.CSI.P(3195214)        11i.CSI.P(3195214)        11i.CSI.P(3195214)        Rel-Not_Dist             
css        11i.CSS.J(3214922)        11i.CSS.J(3214922)        11i.CSS.J(3214922)        Rel-Not_Dist             
cug        11i.CUG.Q(3014213)        11i.CUG.Q(3014213)        11i.CUG.Q(3014213)        Rel-Not_Dist             
cz         11i.CZ.J(2770105)         11i.CZ.J(2770105)         11i.CZ.J(2770105)         Rel-Not_Dist             
ec         11i.EC.G(3261243)         11i.EC.G(3261243)         11i.EC.G(3261243)         Rel-By_Metal             
ecx        11i.ECX.C(2440710)        11i.ECX.C(2440710)        11i.ECX.C(2440710)        Rel-By_Metal             
edr        11i.EDR.C(2922221)        11i.EDR.C(2922221)        11i.EDR.C(2922221)        Rel-Not_Dist             
eng        11i.ENG.I(2769980)        11i.ENG.I(2769980)        11i.ENG.I(2769980)        Rel-Not_Dist             
fa         11i.FA.O(3151587)         11i.FA.P(3616017)         11i.FA.P(3616017)         Rel-Not_Dist             
fii        11i.FII.G(2864462)        11i.FII.G(2864462)        11i.FII.G(2864462)        Rel-By_Metal             
flm        11i.FLM.I(2768757)        11i.FLM.I(2768757)        11i.FLM.I(2768757)        Rel-Not_Dist             
fnd        11i.FND.H(3262159)        11i.FND.H(3262159)        11i.FND.H(3262159)        Rel-By_Metal             
frm        11i.FRM.F(2682790)        11i.FRM.H(4206794)        11i.FRM.H(4206794)        Rel-By_Metal             
fun                                                            fun has no patchsets!     -                        
fv         11i.FV.J(3151594)         11i.FV.K(3617912)         11i.FV.K(3617912)         Rel-Not_Dist             
ghr        11i.GHR.J(3418292)        11i.GHR.L.3(6964735)      11i.GHR.L.4(8207904)      Rel-Not_Dist             
gl         11i.GL.J(3151409)         11i.GL.K(3617593)         11i.GL.K(3617593)         Rel-Not_Dist             
gma        11i.GMA.L(2916578)        11i.GMA.L(2916578)        11i.GMA.L(2916578)        Rel-Not_Dist             
gmd        11i.GMD.L(2916585)        11i.GMD.L(2916585)        11i.GMD.L(2916585)        Rel-Not_Dist             
gme        11i.GME.L(2916589)        11i.GME.L(2916589)        11i.GME.L(2916589)        Rel-Not_Dist             
gmf        11i.GMF.L(2916592)        11i.GMF.L(2916592)        11i.GMF.L(2916592)        Rel-Not_Dist             
gmi        11i.GMI.L(2916596)        11i.GMI.L(2916596)        11i.GMI.L(2916596)        Rel-Not_Dist             
gml        11i.GML.L(2916602)        11i.GML.L(2916602)        11i.GML.L(2916602)        Rel-Not_Dist             
gmp        11i.GMP.L(2916603)        11i.GMP.L(2916603)        11i.GMP.L(2916603)        Rel-Not_Dist             
gr         11i.GR.L(2916605)         11i.GR.L(2916605)         11i.GR.L(2916605)         Rel-Not_Dist             
hri        11i.HRI.F(3177666)        11i.HRI.F(3177666)        11i.HRI.G(4001448)        Rel-By_Metal             
hz         11i.HZ.I(2239222)         11i.HZ.N(3618299)         11i.HZ.N(3618299)         Rel-By_Metal             
iba        11i.IBA.C(1491331)        11i.IBA.C(1491331)        11i.IBA.D(1903260)        Rel-By_Dev               
ibc        11i.IBC.C(3025788)        11i.IBC.C(3025788)        11i.IBC.C(3025788)        Rel-By_Metal             
ibe        11i.IBE.P(3071058)        11i.IBE.P(3071058)        11i.IBE.P(3071058)        Rel-By_Metal             
iby        11i.IBY.P(3151563)        11i.IBY.Q(3616207)        11i.IBY.Q(3616207)        Rel-By_Dev               
icx        11i.ICX.I(3212296)        11i.ICX.I(3212296)        11i.ICX.I(3212296)        Rel-Not_Dist             
ieb        11i.IEB.R(3103016)        11i.IEB.R(3103016)        11i.IEB.R(3103016)        Rel-By_Dev               
iem        11i.IEM.Q(2688479)        11i.IEM.Q(2688479)        11i.IEM.R(3105039)        Rel-Not_Dist             
ieo        11i.IEO.R(3112614)        11i.IEO.R(3112614)        11i.IEO.R(3112614)        Rel-By_Dev               
ies        11i.IES.R(3105044)        11i.IES.R(3105044)        11i.IES.R(3105044)        Rel-By_Dev               
ieu        11i.IEU.R(3101379)        11i.IEU.R(3101379)        11i.IEU.R(3101379)        Rel-By_Dev               
iex        11i.IEX.G(3274195)        11i.IEX.G(3274195)        11i.IEX.H(3999182)        Rel-By_Metal             
igi        11i.IGI.N(3151665)        11i.IGI.O(3615915)        11i.IGI.O(3615915)        Rel-Not_Dist             
inv        11i.INV.J(2770966)        11i.INV.J(2770966)        11i.INV.J(2770966)        Rel-Not_Dist             
isc        11i.ISC.B(2695944)        11i.ISC.B(2695944)        11i.ISC.B(2695944)        Rel-Not_Dist             
izu                                                            izu has no patchsets!     -                        
jtf        11i.JTF.D(1746626)        11i.JTF.D(1746626)        11i.JTF.D(1746626)        Rel-By_Dev               
jtm        11i.JTM.F(3263420)        11i.JTM.F(3263420)        11i.JTM.F(3263420)        Rel-By_Metal             
mrp        11i.MRP.I(2769918)        11i.MRP.I(2769918)        11i.MRP.I(2769918)        Rel-Not_Dist             
msc        11i.MSC.I(3200649)        11i.MSC.I(3200649)        11i.MSC.I(3200649)        Rel-Not_Dist             
msd        11i.MSD.I(3200658)        11i.MSD.I(3200658)        11i.MSD.I(3200658)        Rel-Not_Dist             
mso        11i.MSO.I(3200659)        11i.MSO.I(3200659)        11i.MSO.I(3200659)        Rel-Not_Dist             
okc        11i.OKC.N(3195187)        11i.OKC.N(3195187)        11i.OKC.N(3195187)        Rel-Not_Dist             
oki        11i.OKI.J(3195201)        11i.OKI.J(3195201)        11i.OKI.J(3195201)        Rel-Not_Dist             
oks        11i.OKS.O(3195193)        11i.OKS.O(3195193)        11i.OKS.O(3195193)        Rel-Not_Dist             
okx        11i.OKX.N(3195204)        11i.OKX.N(3195204)        11i.OKX.N(3195204)        Rel-Not_Dist             
ont        11i.ONT.J(2770166)        11i.ONT.J(2770166)        11i.ONT.J(2770166)        Rel-Not_Dist             
opi        11i.OPI.B(2695953)        11i.OPI.B(2695953)        11i.OPI.B(2695953)        Rel-Not_Dist             
ota        11i.OTA.I(3291795)        11i.OTA.I(3291795)        11i.OTA.J.4(8207995)      Rel-Not_Dist             
ozf        11i.OZF.D(3073155)        11i.OZF.D(3073155)        11i.OZF.D.1(7340510)      Rel-By_Metal             
pa         11i.PA.L(2991508)         11i.PA.L(2991508)         11i.PA.M(3409392)         Rel-Not_Dist             
per        11i.PER.N(3418216)        11i.PER.P.3(6964755)      11i.PER.P.4(8207918)      Rel-Not_Dist             
pjm        11i.PJM.H(2770116)        11i.PJM.H(2770116)        11i.PJM.H(2770116)        Rel-Not_Dist             
pmi        11i.PMI.H(3416752)        11i.PMI.H(3416752)        11i.PMI.H(3416752)        Rel-Not_Dist             
pn         11i.PN.K(3151458)         11i.PN.L(3618077)         11i.PN.M(5591144)         Rel-By_Metal             
poa        11i.POA.F(3212251)        11i.POA.F(3212251)        11i.POA.F(3212251)        Rel-Not_Dist             
po         11i.PO.I(3212265)         11i.PO.I(3212265)         11i.PO.I(3212265)         Rel-Not_Dist             
pqh        11i.PQH.J(3418295)        11i.PQH.L.3(6964759)      11i.PQH.L.4(8207921)      Rel-Not_Dist             
psa        11i.PSA.I(3153659)        11i.PSA.J(3618203)        11i.PSA.J(3618203)        Rel-Not_Dist             
psb        11i.PSB.J(3151556)        11i.PSB.K(3617407)        11i.PSB.K(3617407)        Rel-Not_Dist             
pv         11i.PV.H(3025814)         11i.PV.H(3025814)         11i.PV.H.1(6429776)       Rel-By_Metal             
qa         11i.QA.I(2769925)         11i.QA.I(2769925)         11i.QA.I(2769925)         Rel-Not_Dist             
qot        11i.QOT.D(2937175)        11i.QOT.D(2937175)        11i.QOT.D(2937175)        Rel-By_Metal             
qp         11i.QP.J(2770137)         11i.QP.J(2770137)         11i.QP.J(2770137)         Rel-Not_Dist             
rg         11i.RG.H(3151391)         11i.RG.I(3559501)         11i.RG.I(3559501)         Rel-Not_Dist             
ssp        11i.SSP.J(3418312)        11i.SSP.L.3(6964764)      11i.SSP.L.4(8207937)      Rel-Not_Dist             
wip        11i.WIP.I(2768748)        11i.WIP.I(2768748)        11i.WIP.I(2768748)        Rel-Not_Dist             
wps        11i.WPS.H(2768755)        11i.WPS.H(2768755)        11i.WPS.H(2768755)        Rel-Not_Dist             
wsh        11i.WSH.J(2770367)        11i.WSH.J(2770367)        11i.WSH.J(2770367)        Rel-Not_Dist             
xdo        11i.XDO.H(3263588)        11i.XDO.H(3263588)        11i.XDO.H(3263588)        Rel-By_Metal             
xni        11i.XNI.K(3195219)        11i.XNI.K(3195219)        11i.XNI.K(3195219)        Rel-Not_Dist             
xnp        11i.XNP.X(3214804)        11i.XNP.X(3214804)        11i.XNP.X(3214804)        Rel-Not_Dist             

SHARED INSTALL PRODUCTS
Product    Baseline                  Running Version           Latest Available          Status                   
ad         11i.AD.I.1(4038964)       11i.AD.I.7(7429271)       11i.AD.I.7(7429271)       Rel-By_Metal             
amv        11i.AMV.I(3134012)        11i.AMV.I(3134012)        11i.AMV.I(3134012)        Rel-Not_Dist             
asg        11i.ASG.R(3263401)        11i.ASG.R(3263401)        11i.ASG.R(3263401)        Rel-By_Metal             
au                                                             au has no patchsets!      -                        
ben        11i.BEN.M(3418234)        11i.BEN.O.3(6964718)      11i.BEN.O.4(8207863)      Rel-Not_Dist             
csd        11i.CSD.S(3215147)        11i.CSD.S(3215147)        11i.CSD.S(3215147)        Rel-Not_Dist             
csf        11i.CSF.S(3132186)        11i.CSF.S(3132186)        11i.CSF.S(3132186)        Rel-Not_Dist             
cua        11i.CUA.B(1422989)        11i.CUA.B(1422989)        11i.CUA.B(1422989)        Rel-By_Metal             
dt         11i.DT.H(3418248)         11i.DT.J.3(6964728)       11i.DT.J.4(8207867)       Rel-Not_Dist             
ff         11i.FF.I(3418286)         11i.FF.K.3(6964733)       11i.FF.K.4(8207892)       Rel-Not_Dist             
hxt        11i.HXT.H(3530830)        11i.HXT.H(3530830)        11i.HXT.J.4(9214263)      Rel-Not_Dist             
ibu        11i.IBU.P(3215243)        11i.IBU.P(3215243)        11i.IBU.P(3215243)        Rel-Not_Dist             
mfg                                                            mfg has no patchsets!     -                        
ozp                                                            ozp has no patchsets!     -                        
ozs                                                            ozs has no patchsets!     -                        
pay        11i.PAY.M(3418225)        11i.PAY.O.3(6964746)      11i.PAY.O.4(8207913)      Rel-Not_Dist             
psp        11i.PSP.I(3418306)        11i.PSP.K.3(6964762)      11i.PSP.K.4(8207934)      Rel-Not_Dist             
rhx        11i.RHX.A(1354061)        11i.RHX.A(1354061)        11i.RHX.A(1354061)        Obs-By_Metal             
sht        11i.SHT.A(1392476)        11i.SHT.A(1392476)        11i.SHT.A(1392476)        Rel-Not_Dist             
xdp        11i.XDP.X(3214732)        11i.XDP.X(3214732)        11i.XDP.X(3214732)        Rel-Not_Dist             
xla        11i.XLA.H(3151394)        11i.XLA.I(3615242)        11i.XLA.I(3615242)        Rel-Not_Dist             

PSEUDO PRODUCTS
Product    Baseline                  Running Version           Latest Available          Status                   
adx                                  11i.ADX.F(3453499)        11i.ADX.F(3453499)        Rel-By_Metal             
ame                                  11i.AME.B.1(6975336)      11i.AME.B.2(8208648)      Rel-Not_Dist             
aml        11i.AML.A(2728964)        11i.AML.B(3236242)        11i.AML.B(3236242)        Rel-Not_Dist             
blc                                                            11i.BLC.B(4594554)        Rel-By_Dev               
bpa                                  11i.BPA.B(3388258)        11i.BPA.C(4017028)        Rel-By_Metal             
cac                                  11i.CAC.C(3995315)        11i.CAC.C(3995315)        Rel-By_Metal             
cdr                                                            11i.CDR.D.1(8904380)      Rel-By_Metal             
cle                                                            11i.CLE.B(5251736)        Obs-By_Metal             
csk                                  11i.CSK.B(3215230)        11i.CSK.B(3215230)        Rel-Not_Dist             
csz                                                            11i.CSZ.A(4378713)        Rel-By_Metal             
ctb                                                            11i.CTB.E.3(5178840)      Rel-Not_Dist             
edw        11i.EDW.C(2700670)        11i.EDW.D(3295042)        11i.EDW.D(3295042)        Rel-By_Dev               
ews        11i.EWS.C(2700672)        11i.EWS.D(3295045)        11i.EWS.D(3295045)        Rel-By_Dev               
ftp                                                            11i.FTP.A.4(6711509)      Rel-By_Metal             
fwk                                  11i.FWK.H(3262919)        11i.FWK.H(3262919)        Rel-By_Metal             
hcp                                                            11i.HCP.A.3(5178876)      Rel-Not_Dist             
hct                                                            11i.HCT.E.3(5178908)      Rel-Not_Dist             
igp                                                            11i.IGP.A(3570941)        Rel-By_Metal             
igr                                  11i.IGR.A(4233605)        11i.IGR.A.2(5837572)      Rel-By_Metal             
ipatch                                                         11i.IPATCH.B(2495518)     Rel-By_Dev               
irc        11i.IRC.A(2385730)        11i.IRC.E.3(6964709)      11i.IRC.E.4(8208171)      Rel-Not_Dist             
isx                                                            11i.ISX.B(2284575)        Obs-By_Metal             
ita                                                            11i.ITA.A(3904312)        Rel-By_Metal             
itm                                                            11i.ITM.A(4189546)        Rel-Not_Dist             
jta        11i.JTA.E(2640247)        11i.JTA.F(3262486)        11i.JTA.F(3262486)        Rel-By_Metal             
jth                                  11i.JTH.R(3100686)        11i.JTH.R(3100686)        Rel-By_Metal             
jto                                  11i.JTO.R(3105667)        11i.JTO.R(3105667)        Rel-By_Metal             
jtp                                                            11i.JTP.A(2014756)        Obs-By_Metal             
jtt        11i.JTT.D(2420923)        11i.JTT.E(3127042)        11i.JTT.E(3127042)        Rel-By_Metal             
jtu                                                            11i.JTU.C(2917386)        Rel-By_Metal             
jty                                  11i.JTY.C(3495600)        11i.JTY.C(3495600)        Rel-By_Metal             
msx                                                            11i.MSX.A(2122893)        Rel-Not_Dist             
oam        11i.OAM.G(2737099)        11i.OAM.H(3258830)        11i.OAM.H(3258830)        Rel-By_Metal             
ocm                                  11i.OCM.C(3620763)        11i.OCM.D(4594570)        Rel-By_Metal             
oie        11i.OIE.E(1960506)        11i.OIE.J(3618125)        11i.OIE.K(4165000)        Rel-By_Metal             
oir        11i.OIR.A(2065564)        11i.OIR.G(3618333)        11i.OIR.G(3618333)        Rel-By_Metal             
oit        11i.OIT.C(1707487)        11i.OIT.D(2397276)        11i.OIT.D(2397276)        Rel-By_Metal             
owf        11i.OWF.G(2728236)        11i.OWF.H(3258819)        11i.OWF.H(3258819)        Rel-By_Metal             
pft                                                            11i.PFT.A.7(6402392)      Rel-By_Metal             
pjr        11i.PJR.C(2034194)        11i.PJR.C(2034194)        11i.PJR.D(2185783)        Rel-Not_Dist             
pov                                                            11i.POV.A(2120440)        Rel-Not_Dist             
rcm                                                            11i.RCM.B(4017563)        Rel-Not_Dist             
txk        11i.TXK.A(2668469)        11i.TXK.B(3219567)        11i.TXK.B(3219567)        Rel-By_Metal             
umx                                  11i.UMX.H(3264818)        11i.UMX.H(3264818)        Rel-By_Metal             

WARNING on Family Packs and Patchsets:
 The patchsets included in a Family Pack are not all distributed as standalone, but
 should show up in ad_bugs as an included patch.  These were not included
 in the Report because they were not downloadable directly from Metalink. This has
 caused some confusion in the real Baseline or Running patchsets because you had to
 determine that based on the readme of your Family Packs that have been applied.
 This has been changed and the patchsets in /tmp/11i_patchsets.txt now includes all
 the patchsets even if they are not standalone and you cannot get them as one offs.
 See the new Status field in the Latest Available column. or check /tmp/11i_patchsets.txt.

Please check Metalink for final patchset availability questions and Distribution Status issues:

Note1:
 Latest Available:  This may be Distributed via Metalink as standalone or only by a Family Pack.
 Until release 3.3 of this script, the Installed Version only included Standalone release patchesets
 and not any of the patchsets included in Family Packs.

Note2: (as of v.4.14)
 Latest Available shows all patchsets even if NOT AVAILABLE for download on
 Metalink. An optional flag to limit Latest Available to patches only available
 on metailink has been provided. ie. Add: available=metalink to command line.

Note3:
 TXK patches are delivered by 11i.ATG_PF. RUPxyz and no longer as
 patchsets, but as one off rollups. ie. Only TXK.A and TXK.B were
 delivered as patchsets.

 TXK Autoconfig Template Rollups - As of Mar 2006
 TXK-B : 2682076
 TXK-C : 2682863
 TXK-D : 2757379
 TXK-E : 2902755
 TXK-F : 3104607
 TXK-G : 3239694 (Feb-2004)
 TXK-H : 3416234 (May-2004)
 TXK-I : 3594604 (Oct-2004)
 TXK-J : 3950067 (Feb-2005)
 TXK-J.1 : 4367673
 TXK-K : 4104924 (May-2005)
 TXK-L : 4489303 (Nov-2005)
 TXK-M : 4717668 (Mar-2006)

 New Status Field:
 ##############################################################################
 PATCHSET STATUS:
 Rel=Released, Sup=Superseded, Obs=Obsoleted
 DISTRIBUTION STATUS:
 By_Metal=On Metalink, Not_Dist=Not Available, By_Dev=Available from Development only

 By_Dev often means only available by a Family Pack and no one off patchsets available.
 Not_Dist typically means only available by a Family Pack or not released yet.
 By_Metal patches can be downloaded by Metalink or by ftp to updates.oracle.com

Fun with OPatch

Since the January 2010 CPU patch came out recently, I began to apply the various pieces to my non-Production environments, as usual, just to ensure the process worked as normal.   OPatch is such a clumsy little tool, though I suppose it’s better than in the past when you had to manually pull about 20 readme’s and work for hours on the command line to apply security patches.  If you’re a glutton for bad memories, check out the application of Security Alert #68 or more specifically the database piece. It does make the current CPUs seem well polished by comparison.  But still, nothing ever goes as planned…

I go to apply PSU January 2010 (aka 10.2.0.4.3) on Linux x86-64 against a 10.2.0.4 database home  and I receive this error:

OPatch: ApplySession failed: Patch ID is null.

SEVERE:OPatch invoked as follows: 'apply '
INFO:
Oracle Home       : /u01/highjump/highjumpdb/10.2.0
Central Inventory : /opt/oracle/oraInventory
from           : /etc/oraInst.loc
OPatch version    : 10.2.0.4.2
OUI version       : 10.2.0.4.0
OUI location      : /u01/highjump/highjumpdb/10.2.0/oui
Log file location : /u01/highjump/highjumpdb/10.2.0/cfgtoollogs/opatch/opatch2010-01-20_09-48-35AM.log

INFO:Starting ApplySession at Wed Jan 20 09:48:36 EST 2010
INFO:Starting Apply Session at Wed Jan 20 09:48:36 EST 2010
SEVERE:OUI-67073:ApplySession failed: Patch ID is null.
INFO:System intact, OPatch will not attempt to restore the system
INFO:Finishing ApplySession at Wed Jan 20 09:48:36 EST 2010
INFO:Total time spent waiting for user-input is 0 seconds.  Finish at Wed Jan 20 09:48:36 EST 2010
INFO:Stack Description: java.lang.RuntimeException: Patch ID is null.
INFO:StackTrace: oracle.opatch.PatchObject.getPatchID(PatchObject.java:543)
INFO:StackTrace: oracle.opatch.ApplySession.loadAndInitPatchObject(ApplySession.java:1485)
INFO:StackTrace: oracle.opatch.ApplySession.process(ApplySession.java:5189)
INFO:StackTrace: oracle.opatch.OPatchSession.main(OPatchSession.java:1588)
INFO:StackTrace: oracle.opatch.OPatch.main(OPatch.java:619)

Super.  What a nice, descriptive error.  A little hunting on MOS reveals that my OPatch version in the $ORACLE_HOME isn’t up to date.  Why couldn’t the error message be “Your version of OPatch is too old to support this patchset”??  Well this was remedied easily enough by downloading/upgrading to the latest version of 10.X OPatch.

Now the patch (9119284) progresses far enough to hit   a new issue:

Patch 7580744:
Archive Action: Source file "/u01/highjump/highjumpdb/10.2.0/.patch_storage/7580744_Dec_10_2008_23_06_23/files/lib/libcore10.a/ldm.o" does not exist.
'oracle.oracore.rsf, 10.2.0.4.0': Cannot update file '/u01/highjump/highjumpdb/10.2.0/lib/libcore10.a' with '/ldm.o'
Archive Action: Source file "/u01/highjump/highjumpdb/10.2.0/.patch_storage/7580744_Dec_10_2008_23_06_23/files/lib/libcore10.a/sldigpts.o" does not exist.
'oracle.oracore.rsf, 10.2.0.4.0': Cannot update file '/u01/highjump/highjumpdb/10.2.0/lib/libcore10.a' with '/sldigpts.o'
Archive Action: Source file "/u01/highjump/highjumpdb/10.2.0/.patch_storage/7580744_Dec_10_2008_23_06_23/files/lib32/libcore10.a/ldm.o" does not exist.
'oracle.oracore.rsf, 10.2.0.4.0': Cannot update file '/u01/highjump/highjumpdb/10.2.0/lib32/libcore10.a' with '/ldm.o'
Archive Action: Source file "/u01/highjump/highjumpdb/10.2.0/.patch_storage/7580744_Dec_10_2008_23_06_23/files/lib32/libcore10.a/sldigpts.o" does not exist.
'oracle.oracore.rsf, 10.2.0.4.0': Cannot update file '/u01/highjump/highjumpdb/10.2.0/lib32/libcore10.a' with '/sldigpts.o'
Copy Action: Source file "/u01/highjump/highjumpdb/10.2.0/.patch_storage/7580744_Dec_10_2008_23_06_23/files/oracore/zoneinfo/timezone.dat" does not exist.
'oracle.oracore.rsf, 10.2.0.4.0': Cannot copy file from 'timezone.dat' to '/u01/highjump/highjumpdb/10.2.0/oracore/zoneinfo/timezone.dat'
Copy Action: Source file "/u01/highjump/highjumpdb/10.2.0/.patch_storage/7580744_Dec_10_2008_23_06_23/files/oracore/zoneinfo/timezlrg.dat" does not exist.
'oracle.oracore.rsf, 10.2.0.4.0': Cannot copy file from 'timezlrg.dat' to '/u01/highjump/highjumpdb/10.2.0/oracore/zoneinfo/timezlrg.dat'
Copy Action: Source file "/u01/highjump/highjumpdb/10.2.0/.patch_storage/7580744_Dec_10_2008_23_06_23/files/oracore/zoneinfo/readme.txt" does not exist.
'oracle.oracore.rsf, 10.2.0.4.0': Cannot copy file from 'readme.txt' to '/u01/highjump/highjumpdb/10.2.0/oracore/zoneinfo/readme.txt'
Archive Action: Source file "/u01/highjump/highjumpdb/10.2.0/.patch_storage/7580744_Dec_10_2008_23_06_23/files/lib/libserver10.a/prm.o" does not exist.
'oracle.rdbms, 10.2.0.4.0': Cannot update file '/u01/highjump/highjumpdb/10.2.0/lib/libserver10.a' with '/prm.o'

DST10

Prerequisite check "CheckRollbackable" on auto-rollback patches failed.

Super.  Now my inventory of Rollbackable (wtf is that a word?) patches is messed up.  I chose option 3 from Doc 751107.1 and just copied the stupid files from another Oracle Home on the server:

$ cd /u01/highjump/highjumpdb/10.2.0/.patch_storage/
$cp -R /u01/labworks/labworksdb/10.2.0/.patch_storage/7580744_Dec_10_2008_23_06_23 .

Finally, OPatch grudgingly applied the PSU patch.  Cranked up the database, ran $OH/rdbms/admin/catbundle.sql psu apply I was done.

Advanced Compression, Take 2

Throw Away Hours of Work

It’s been almost a year, and I have an SR open that long to prove it.  It’s been in “Waiting on Customer” status for quite some time now.  In fact, they tend to ping me every month or two, in hopes of  closing the ticket.  Fair play, I’d say, since I was waiting on Oracle for a fix for months while they officially acknowledged they even had a problem.  I continue to tell them that once I have a viable environment in which to test this problem and their fix, I will do so.

Turns out, the time has arrived.  We’ve finished regression testing database patch 8277580; this is what support told me to apply last August.  The real problem with testing this patch is twofold.  First, I don’t have the luxury ($) of a TEST environment which includes a physical standby database.  On top of that, making the actual corruption happen is problematic.  The table which was corrupted, every time, on the standby was  BOM.CST_ITEM_COST_DETAILS.  There simply isn’t enough traffic/volume of work going on in any but my non production environment, to cause the corruption to happen in anywhere but PROD.  If money were no object, perhaps I could use some kind of load simulator (Oracle’s or otherwise) to reproduce this failure, but realistically, how much money do I want to spend to implement this product?  So my solution is pretty simple.  Apply the patch on both sides (Primary/Standby) of my PROD system, and wait and see what happens to the standby.  Like clockwork, I always had alert log entries, followed by the database shutdown within 24 hours of compressing this table.  If I continue to get corruption, I don’t know what I’ll do, besides have a long, unpleasant talk with my sales rep.

Regardless, I hope to apply the patch during the next maintenance window in February, which means within a month I should have some solid results to report on this issue.

CPU Jan 2010 Available

There must be a catch

The quarterly CPU is out; to my complete amazement, Oracle actually did something to make my life easier:

This CPU announces new cumulative patches for Oracle E-Business Suite Release 11i10 CU2 customers. With this Oracle E-Business Suite Release 11i10 CU2 customers on ATG RUP 6 or ATG RUP 7 can apply a single patch that contains all CPU patches for the current Critical Patch Update and includes all fixes from previous Oracle security alerts and Critical Patch Updates released earlier.

When I upgraded to 11.5.10.2 a few years ago, I think I had to apply 75+ CPU patches to “re-secure” the 11i environment.  Now it’s simplified, and retro-active, regardless of where your patch level falls:

Oracle E-Business Suite Release 11i10 CU2 Patches, in all the three cases:

• You have applied all Critical patches released for 11i10 CU2.
• You have applied some Critical patches released for 11i10 CU2.
• You have applied none of the Critical patches released for 11i10 CU2.

You can apply the cumulative patch listed in Table 5, Oracle E-Business Suite Release 11i10 CU2 Patches, in all the three cases

Between the RDBMS PSU’s coming out last summer (consolidated recommended/security patches for the RDBMS) and cumulative 11i security patches, life has gotten a lot easier, for an 11i DBA, in the past year.  For once I can say, “Thanks Oracle!”.

edit:

Oh, silly me for singing the praises of Oracle before browsing the README for the cumulative patch.  It reads like a never-ending if-then-else statement; it’s definitely an improvement, but far less impressive now…

1) Applicable only after applying patch - 9077775.

2) Apply the following patches only if your application system doesn't have
it. There is no need to re-apply the patch if the application system has the
following patches or it's superseded patches.


a) If you have implemented "Lease Management (OKL)" and

If you are at 11i.OKL.F level, apply patch 6126121
If you are at 11i.OKL.G level, apply patch 6657385
If you are at 11i.OKL.H level, apply patch 6672497

b) If you have implemented "Human Resources (PER)", apply following patches:
       - 4582839
       - 3832113

c) If you have implemented "Human Resources Suite" and
If you are at 11i.HR_PF.G and above, apply patch 5973651
If you are at 11i.HR_PF.K.delta.1, apply patch 6204551

d) If you have implemented "Financials" and
If you are at 11i.FIN_PF.G (3653484) level, apply patches 4155556 and 5307530
If you are at 11i.FIN_PF.F (3153675) level, apply patch 4058603
If you are at 11i.FIN_PF.E (2842697) or 11i.FIN_PF.D (2629235), apply patch
4317421

e) If you have implemented Internet Expenses (OIE) and 11i.OIE.I (3376648)
level, apply patch#6117954


f) If you have implemented "Oracle Web Applications Desktop Integrator (BNE)"
and 11i.BNE.C (2819091) level, apply patch 3758012

g) If you have implemented "CRM Gateway for Mobile Devices (ASG)", apply
patch#5483388


h) If you have implemented "Trading Community (HZ)" and

If you are at 11i.HZ.G or 11i.HZ.H level, apply patches 5661618 and 5521537
If you are at 11i.HZ.I to 11i.HZ.L level, apply patches 3748840 and 3748842
If you are at 11i.HZ.M level, apply patches 5661619 and 5521476
If you are at 11i.HZ.N level, apply patches 5661617 and 5526897

SQL Developer 2.1

Froglike?

OTN had made SQL Developer 2.1 available late last year; I finally got around to updating my version from 1.5 something.  Can’t say I use many of the advanced feature set it offers such as code versioning, unit testing or data modeling, but I do use it regularly.  If you aren’t aware of the product, or haven’t tried it yet, I’d encourage you to take a look.  It feels suspiciously like the (DBA universally despised) TOAD, but since it’s free, I gave it a pass and found it useful on occasion.

• It’s really easy to display table contents, and edit or export the data.
• When one of the analysts at the Oracle Support brain trust tells you in your SR that they need a csv version of some random query, it can easily be accommodated via SQL Devleoper.
• It’s hard to cite a good example, but there’s times when I’m not sure exactly what I’m looking for in the database, I may only know an object name or schema name.  This tool is a great way to “browse” the database, especially with it’s filtering capability.

Browsing a table in SQL Developer