Kevin Kempf's Blog

February 8, 2010

Congratulations to the team which won the big end-of-season football game which was held in South Florida!

Filed under: Uncategorized — Tags: — kkempf @ 2:14 pm

Not Fully Licensed

This is a brief aside from my normal techno babble.  I won’t be providing a breakdown of my (useless) analysis of the game, but I found it sad that the NFL makes it so hard to use the phrase “S**** B***”.  Thanks to lawyers and property rights held by the NFL, this post title is about all a big company with something to lose might be able to say in print.   It makes me fear for the freedom to post anything but doublespeak online, because of the fear of repercussions.

As a side note, am I the only one tired of “Who Dat” and “Geaux Saints”?    Who Dat sayin’ Geaux Saints?  Oh yeah – the guy with the 4th grade education!  Well that’s what it sounds and reads like to me…

January 21, 2010

Determining 11i Family Pack Versions

Filed under: 11i, Oracle — kkempf @ 1:49 pm

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 zso-oradev-02 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

Filed under: 10g, Oracle, Oracleisms, Utilities — kkempf @ 10:51 am

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.

January 20, 2010

Advanced Compression, Take 2

Filed under: 11g, 11i, Oracle, advanced compression — kkempf @ 9:14 am

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.

January 14, 2010

CPU Jan 2010 Available

Filed under: 11i, Oracle — kkempf @ 2:07 pm

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

January 8, 2010

SQL Developer 2.1

Filed under: Uncategorized — kkempf @ 10:07 am

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

December 31, 2009

SSL & Servlet

Filed under: 11i, Techstack — kkempf @ 1:45 pm

ssl

I just realized that something which I had put in draft in September was still sitting in draft today… the information is still valid…

Pursuing the goal of moving my 11i Ebusiness Suite techstack forward, last weekend I cut over the application server to use SSL and Forms Servlet.  This has been a long time coming, but really it just ended up being a few edits to the context file, landing the certificates on the server and running autoconfig.  This information is based upon 123718.1 and it’s worth noting that forms socket won’t support Native Java with SSL (290807.1).

SSL

  • First, land the certificates into $COMN_TOP/admin/certs/apache (cp -R)
  • Context file edits
  • set the %s_url_protocol variable to https
  • set the %s_local_url_protocol variable to https
  • set the %s_webentryurlprotocol variable to https
  • set the %s_frmConnectMode variable to https
  • set the %s_webssl_port variable to the Apache SSL port required
  • set the %s_active_webport variable to the same value as that for the %s_webssl_port variable
  • set the %s_webport variable to the same value as that for the %s_webssl_port variable
    Note: prior to  TXK (FND) AutoConfig Template Rollup Patch F (3104607   December 2003) this value was set to the non-ssl Apache Port.

  1. set the %s_web_ssl_directory variable to point to the full directory path of the directory that is to contain the .crt and .key files that you are using for Apache eg <$COMMON_TOP>/admin/certs/apache
  2. set the %s_web_ssl_keyfile variable to point to the server.key file that you are using for Apache eg <$COMMON_TOP>/admin/certs/apache/ssl.key/server.key
  3. set the %s_web_ssl_certfile variable to point to the server.crt file that you are using for Apache eg <$COMMON_TOP>/admin/certs/apache/ssl.crt/server.crt
  4. set the %s_web_ssl_certfile variable to point to the ca-bundle.crt file that you are using for Apache eg <$COMMON_TOP>/admin/certs/apache/ssl.crt/ca-bundle.crt
  5. set %s_apps_portal_url variable to https
  6. set s_forms_servlet_serverurl to /forms/formservlet
  7. set s_forms_servlet_comment to <null>
  8. s_f60map, s_chronosURL, s_external_url to https from http

run AutoConfig

Forms Servlet

Context file changes:

  • <forms_connect oa_var=”s_frmConnectMode”>https</forms_connect>           or http
  • <server_url oa_var=”s_forms_servlet_serverurl”>/forms/formservlet</server_url>
  • <servlet_comment oa_var=”s_forms_servlet_comment”/>          or <servlet_comment oa_var=”s_forms_servlet_comment”></servlet_comment>

Run autoconfig

dbms_session.reset_package

Filed under: 11g, PL/SQL — kkempf @ 11:51 am

Intermec 3400e

At a time which normally includes trips to the break room for Christmas cookies, half the staff being out on any given day and light traffic on the commute, I found myself exceptionally busy this week.  We’re in the midst of a regression cycle, and I’d revamped a mission critical PL/SQL package (4700 lines, to be exact!) which generates product and shipping labels (onto Intermec 3400e printers) for us in the manufacturing process.

Why did I have to rewrite it, and why now?  It turns out our labeling solution, Optio (commercial software which writes to label printers) is all but dead from a support standpoint.  In shopping new vendors, we were unimpressed and figured we could use an existing product we owned (Bartender).  In looking at the existing PL/SQL, I believe every rule of good programming was violated.  It’s like a case study in how to write unmaintainable code.  Seriously, not to harp on consultants writing terrible code, but were you even aware that PL/SQL supported goto syntax?  So effectively, we’re required to regression test this code as if it were new.

As it turns out, I had some logic bugs in the rewritten code (not a big surprise) which required a little attention; after fixing the issue, when called from a trigger, the code would always return ORA-6508 (PL/SQL: could not find program unit being called) and ORA-4068 (existing state of packages discarded).  I fought this issue for quite some time, before a real programmer suggested I might try:

DBMS_SESSION.RESET_PACKAGE;

Wow it worked like a charm.  I attribute this to my use of global variables, of which there are numerous documented notes and references (Tom Kyte even calls them evil!)  After I dumped them things worked, more or less, as expected, and I was able to resume holiday pace…

Incidentally, in the course of running down this error, using the exception block of PL/SQL, I found this nifty bit of code which is now my new standard for error handling (in this case, writing to an error table):

insert into error_log(error_date
 ,module
 ,code_location
 ,error_code
 ,error_message
 ,description
 )
 values
 (sysdate
 ,v_module
 ,null
 ,p_error_code
 ,p_sqlerrm
 ,dbms_utility.format_error_stack || ' ' ||
 dbms_utility.format_call_stack
 )
 ;

What I’m really raving about here is the dbms_utility call.  It made it crystal clear what my error was, and if you’re not familiar with it I suggest you try it:

dbms_utility.format_error_stack || ' ' || dbms_utility.format_call_stack

December 16, 2009

Whats in your dbs directory?

Filed under: Uncategorized — kkempf @ 2:55 pm

I ran into an issue regarding SMR files in an 11g home, and I thought it might be interesting to take a moment and catalog what might be in a $ORACLE_HOME/dbs directory.  I believe this is almost the proverbial “junk drawer” folder of the software install, though it certainly contains some absolutely critical files.  They tend to be rather disparate, however, so I thought I would spell them out here.

initSID.ora

The human-readable and human-editable, clear text version of the parameter (or initialization) file for the database.  Well this one is obvious, it’s been living here ever since I started working with Oracle databases 9 years ago.

initSID.ora ifiles

In my case, I like ifiles for things which are instance specific.  So if I have 3 “like” instances, they can all use virtually the same init file, and have custom ifiles to accommodate them.  In the case of an ERP, the initfile is so standardized by running the database autoconfig, I find this is useful for things which are local customizations unrelated to the ERP, such as dataguard parameters.

spfileSID.ora

The binary version of the parameter (or initialization) file for the database, introduced in 9i which allows far more dynamic parameter changes to Oracle.

hc_SID.dat files

Healthcheck files, which seem to exist only to confound your efforts in enterprise manager.

Password files

For sys priveliges and remote password logins

lkSID files

Instance lock file.  It’s created at the first DB startup, opened when the DB is started, and closed when the DB is shut down.

snapcf_SID.f files

Snapshot controlfile

dr1SID.dat files

Dataguard broker configuration file

Upgrade logs, random sql scripts, backup copies of init files

This list, I’m sure, will be wide and varied, though none of this really belongs in the DBS directory…

Upgrading RDBMS 11.2 to Timezone Version 11

Filed under: 11g, Oracle — kkempf @ 10:15 am

After completing a slew of 10.2 to 11.2 RDBMS upgrades recently, I went back and did as the pre-upgrade analyzer (utlu1112.sql) suggested and updated the Timezone Version from 10 to 11 (per doc 944122.1).  The main take away from this is that Oracle has changed and to some degree simplified this process (at least for Version 11).  It still requires taking the database down several times, which is more than annoying.  I figured it may be easiest to just show my runtime log here, with commands I executed in bold.  I performed all of these upgrades on RHEL5.4 x86_64.

As a (perhaps not-so) interesting side-note, 11.2.0.1 is still only available for download on OTN on Sun & Linux platforms.

$ sqlplus / as sysdba
SQL*Plus: Release 11.2.0.1.0 Production on Tue Dec 15 11:06:31 2009
Copyright (c) 1982, 2009, Oracle.  All rights reserved.
Connected to:
Oracle Database 11g Release 11.2.0.1.0 - 64bit Production
SQL> shutdown immediate;
Database closed.
Database dismounted.
ORACLE instance shut down.
SQL> startup upgrade
ORACLE instance started.
Total System Global Area  167014400 bytes
Fixed Size                  2211528 bytes
Variable Size             113246520 bytes
Database Buffers           46137344 bytes
Redo Buffers                5419008 bytes
Database mounted.
Database opened.
SQL> set serveroutput on
SQL> exec dbms_dst.begin_upgrade(11);
An upgrade window has been successfully started.
PL/SQL procedure successfully completed.
SQL> shutdown immediate;
Database closed.
Database dismounted.
ORACLE instance shut down.
SQL> startup
ORACLE instance started.
Total System Global Area  167014400 bytes
Fixed Size                  2211528 bytes
Variable Size             113246520 bytes
Database Buffers           46137344 bytes
Redo Buffers                5419008 bytes
Database mounted.
Database opened.

SQL> select property_name, substr(property_value, 1, 30) value from database_properties where property_name like 'DST_%' order by property_name;

PROPERTY_NAME                  VALUE
------------------------------ ------------------------------
DST_PRIMARY_TT_VERSION         11
DST_SECONDARY_TT_VERSION       10
DST_UPGRADE_STATE              UPGRADE
SQL> select owner, table_name, upgrade_in_progress from all_tstz_tables;
OWNER                          TABLE_NAME                     UPG
------------------------------ ------------------------------ ---
SYS                            AQ$_AQ_PROP_TABLE_S            NO
SYS                            TSM_DST$                       NO
SYS                            SCHEDULER_FILEWATCHER_QT       NO
SYS                            SCHEDULER$_STEP_STATE          NO
SYS                            SCHEDULER$_JOB_DESTINATIONS    NO
SYS                            SCHEDULER$_EVENT_LOG           NO
SYS                            KET$_CLIENT_TASKS              NO
SYS                            SCHEDULER$_JOB                 NO
SYS                            SCHEDULER$_FILEWATCHER_HISTORY NO
SYS                            WRI$_ALERT_OUTSTANDING         NO
SYS                            AQ$_SUBSCRIBER_TABLE           NO
OWNER                          TABLE_NAME                     UPG
------------------------------ ------------------------------ ---
SYS                            AQ$_SCHEDULER_FILEWATCHER_QT_L NO
SYS                            AQ$_KUPC$DATAPUMP_QUETAB_L     NO
SYS                            ALERT_QT                       NO
SYS                            AQ$_AQ$_MEM_MC_L               NO
SYS                            SCHEDULER$_WINDOW              NO
SYS                            SCHEDULER$_EVENT_QTAB          NO
SYS                            WRI$_OPTSTAT_HISTHEAD_HISTORY  NO
SYS                            AQ$_SCHEDULER$_REMDB_JOBQTAB_S NO
SYS                            FGR$_FILE_GROUP_VERSIONS       NO
SYS                            OPTSTAT_USER_PREFS$            NO
SYS                            KET$_CLIENT_CONFIG             NO
OWNER                          TABLE_NAME                     UPG
------------------------------ ------------------------------ ---
SYS                            AQ$_AQ$_MEM_MC_S               NO
SYS                            SCHEDULER$_WINDOW_DETAILS      NO
SYS                            SCHEDULER$_REMDB_JOBQTAB       NO
SYS                            SCHEDULER$_LIGHTWEIGHT_JOB     NO
SYS                            SCHEDULER$_GLOBAL_ATTRIBUTE    NO
SYS                            SCHEDULER$_FILE_WATCHER        NO
SYS                            WRI$_OPTSTAT_IND_HISTORY       NO
SYS                            AQ$_SCHEDULER_FILEWATCHER_QT_S NO
SYS                            SCHEDULER$_JOB_RUN_DETAILS     NO
SYS                            WRI$_OPTSTAT_OPR               NO
SYS                            AQ$_SYS$SERVICE_METRICS_TAB_L  NO
OWNER                          TABLE_NAME                     UPG
------------------------------ ------------------------------ ---
SYS                            FGR$_FILE_GROUP_FILES          NO
SYS                            TSM_SRC$                       NO
SYS                            SCHEDULER$_REMOTE_JOB_STATE    NO
SYS                            WRI$_OPTSTAT_HISTGRM_HISTORY   NO
SYS                            WRI$_OPTSTAT_AUX_HISTORY       NO
SYS                            REG$                           NO
SYS                            AQ$_SYS$SERVICE_METRICS_TAB_S  NO
SYS                            FGR$_FILE_GROUPS               NO
SYS                            AQ$_ALERT_QT_S                 NO
SYS                            WRR$_REPLAY_DIVERGENCE         NO
SYS                            SCHEDULER$_SCHEDULE            NO
OWNER                          TABLE_NAME                     UPG
------------------------------ ------------------------------ ---
SYS                            WRI$_OPTSTAT_TAB_HISTORY       NO
SYS                            WRI$_ALERT_HISTORY             NO
SYS                            AQ$_SCHEDULER$_REMDB_JOBQTAB_L NO
SYS                            AQ$_SCHEDULER$_EVENT_QTAB_S    NO
SYS                            AQ$_KUPC$DATAPUMP_QUETAB_S     NO
SYS                            OPTSTAT_HIST_CONTROL$          NO
SYS                            KET$_AUTOTASK_STATUS           NO
SYS                            AQ$_AQ_PROP_TABLE_L            NO
SYS                            AQ$_ALERT_QT_L                 NO
SYS                            SCHEDULER$_FILEWATCHER_RESEND  NO
SYS                            AQ$_SCHEDULER$_EVENT_QTAB_L    NO
OWNER                          TABLE_NAME                     UPG
------------------------------ ------------------------------ ---
DBSNMP                         MGMT_DB_FEATURE_LOG            NO
WMSYS                          WM$VERSIONED_TABLES            NO
WMSYS                          AQ$_WM$EVENT_QUEUE_TABLE_S     NO
WMSYS                          AQ$_WM$EVENT_QUEUE_TABLE_L     NO
SYSMAN                         MGMT_PROV_NET_CONFIG           YES
SYSMAN                         MGMT_PROV_IP_RANGE             YES
SYSMAN                         AQ$_MGMT_NOTIFY_QTABLE_L       YES
SYSMAN                         AQ$_MGMT_LOADER_QTABLE_S       YES
SYSMAN                         AQ$_MGMT_LOADER_QTABLE_L       YES
SYSMAN                         MGMT_PROV_SUITE_INST_MEMBERS   YES
SYSMAN                         MGMT_PROV_BOOTSERVER           YES
OWNER                          TABLE_NAME                     UPG
------------------------------ ------------------------------ ---
SYSMAN                         AQ$_MGMT_NOTIFY_QTABLE_S       YES
SYSMAN                         MGMT_PROV_STAGING_DIRS         YES
SYSMAN                         MGMT_PROV_OPERATION            YES
SYSMAN                         MGMT_PROV_ASSIGNMENT           YES
SYSMAN                         MGMT_CONFIG_ACTIVITIES         YES
SYSMAN                         MGMT_PROV_CLUSTER_NODES        YES
SYSMAN                         MGMT_PROV_RPM_REP              YES
SYSMAN                         MGMT_PROV_DEFAULT_IMAGE        YES
74 rows selected.
SQL> set serveroutput on;
SQL> declare
num_of_failures number;
begin
dbms_dst.upgrade_database(num_of_failures);
dbms_output.put_line(num_of_failures);
dbms_dst.end_upgrade(num_of_failures);
dbms_output.put_line(num_of_failures)
end
;
/

Table list: SYSMAN.AQ$_MGMT_NOTIFY_QTABLE_S
Number of failures: 0
Table list: SYSMAN.AQ$_MGMT_NOTIFY_QTABLE_L
Number of failures: 0
Table list: SYSMAN.AQ$_MGMT_LOADER_QTABLE_S
Number of failures: 0
Table list: SYSMAN.AQ$_MGMT_LOADER_QTABLE_L
Number of failures: 0
Table list: SYSMAN.MGMT_PROV_SUITE_INST_MEMBERS
Number of failures: 0
Table list: SYSMAN.MGMT_PROV_STAGING_DIRS
Number of failures: 0
Table list: SYSMAN.MGMT_PROV_RPM_REP
Number of failures: 0
Table list: SYSMAN.MGMT_PROV_OPERATION
Number of failures: 0
Table list: SYSMAN.MGMT_PROV_NET_CONFIG
Number of failures: 0
Table list: SYSMAN.MGMT_PROV_IP_RANGE
Number of failures: 0
Table list: SYSMAN.MGMT_PROV_DEFAULT_IMAGE
Number of failures: 0
Table list: SYSMAN.MGMT_PROV_CLUSTER_NODES
Number of failures: 0
Table list: SYSMAN.MGMT_PROV_BOOTSERVER
Number of failures: 0
Table list: SYSMAN.MGMT_PROV_ASSIGNMENT
Number of failures: 0
Table list: SYSMAN.MGMT_CONFIG_ACTIVITIES
Number of failures: 0
0
An upgrade window has been successfully ended.
0
PL/SQL procedure successfully completed.
SQL> select * from all_tstz_tables where upgrade_in_progress = 'YES';
no rows selected
SQL> select property_name, substr(property_value, 1, 30) value from database_properties where property_name like 'DST_%'
order by property_name;
PROPERTY_NAME                  VALUE
------------------------------ ------------------------------
DST_PRIMARY_TT_VERSION         11
DST_SECONDARY_TT_VERSION       0
DST_UPGRADE_STATE              NONE

Older Posts »

Blog at WordPress.com.