Upgrading from 10204 to 11203.docx

Upgrading from 10204 to 11203.docx

《Upgrading from 10204 to 11203.docx》由会员分享，可在线阅读，更多相关《Upgrading from 10204 to 11203.docx（20页珍藏版）》请在冰点文库上搜索。

Upgradingfrom10204to11203

Upgradingfrom10.2.0.4to11.2.0.3

There'saearlierblogabout upgradingfrom10gto11gR2. Thisblogistoaddsomemissingpointsinthe previous blogandadditionalinformationwithregardtoupgradingfrom10.2.0.4to11.2.0.3.

Followingmetalinknotesareusefulforthisupgradeprocesses.

UpgradeAdvisor:

Databasefrom10.2to11.2 [ID251.1]

CompleteChecklisttoUpgradetheDatabaseto11gR2usingDBUA [ID870814.1]

CompleteChecklistforManualUpgradesto11gR2 [ID837570.1]

OracleDatabaseUpgradePathReferenceList [ID730365.1]

Thedatabasetoupgradeisa10.2.0.4withCPU2009JulybeingthelatestCPUthathasbeenappliedonit.InotherwordsnoCPUorPSUreleasedafterJuly2009hasbeenappliedonthisdatabase.

Secondlyit'sastandardeditiondatabasewiththefollowingregistrycomponents.

COMP_NAMESTATUS

------------------------------------------

OLAPAnalyticWorkspaceINVALID

OLAPCatalogINVALID

OracleOLAPAPIINVALID

JServerJAVAVirtualMachineVALID

OracleDataMiningVALID

OracleDatabaseCatalogViewsVALID

OracleDatabaseJavaPackagesVALID

OracleDatabasePackagesandTypesVALID

OracleEnterpriseManagerVALID

OracleExpressionFilterVALID

OracleRulesManagerVALID

OracleTextVALID

OracleWorkspaceManagerVALID

OracleXDKVALID

OracleXMLDatabaseVALID

OracleinterMediaVALID

SpatialVALID

Running utlrp.sql givesthefollowingoutputasthenumberofinvalidobjects

OBJECTSWITHERRORS

-------------------

8

DOC>Thefollowingqueryreportsthenumberoferrorscaughtduring

..

ERRORSDURINGRECOMPILATION

---------------------------

0

4OLAPSYSpackagesand4publicrolesynonymsaretheobjectswitherrorsinthiscase.

OLAP*andseveralothercomponentsarenotvalidoptionsonastandardeditiondatabase.InthiscaseonlyOLAP*componentsareinvalidbutspatial,intermedia,dataminingareallnotvalidforastandardeditiondatabase.ButtheregistrywillbevalidonafreshinstallationbutafterinstallingCPUorrevokingexecuteonutl*packagesforpublicandetcsomeofthesewillbecomeinvalid.The earlierblog wasofsuchafreshinstallationof10gR2thatdidn'thaveanycomponentsinvalid. 

Followingmetalinknotescouldbeusedtoinstall/deinstallvariouscomponentsthatarenotvalidinstandardedition（iftheywereinstallinitially）.

HowToFindOutIfOLAPIsBeingUsedAndHowToRemoveOLAP [ID739032.1]

RemoveInvalidOLAPObjectsFromSYSAndOLAPSYSSchemas [ID565773.1]

StepsforManualDe-installationofOracleSpatial [ID179472.1]

RemovedSpatialOptionButSpatialStillAppearsInV$Option [ID273573.1]

WheretoFindtheInformationtoInstall,Upgrade,DowngradeandDeinstallinterMedia/OracleMultimedia?

 [ID337415.1]（on10gR2deinstall$OH/ord/im/admin/imdinst.sql,on11gR2$OH/rdbms/admin/catcmprm.sqlORDIM）

Tryingtouninstallallnonvalidcomponentscouldresultinmoreobjectswitherrorswhichcausedproblemsduringatestupgradeandmadetheupgradetofail.Ifitisdecidedtoremoveallthecomponentsthatarenotvalidinstandardeditionitisadvisabletomakesurethattherearenoinvalidobjectspriortoupgrade.InthiscasetheupgradewillcontinuewiththesethreeOLAP*componentsinvalid.

Thepre-upgradeinformationtool'soutputisasfollows

SQL>@utlu112i.sql

OracleDatabase11.2Pre-UpgradeInformationTool11-29-201116:

14:

13

ScriptVersion:

11.2.0.3.0Build:

001

.

**********************************************************************

Database:

**********************************************************************

-->name:

stdb1

-->version:

10.2.0.4.0

-->compatible:

10.2.0.3.0

-->blocksize:

8192

-->platform:

Linuxx8664-bit

-->timezonefile:

V4

.

**********************************************************************

Tablespaces:

[makeadjustmentsinthecurrentenvironment]

**********************************************************************

-->SYSTEMtablespaceisadequatefortheupgrade.

....minimumrequiredsize:

725MB

-->UNDOTBS1tablespaceisadequatefortheupgrade.

....minimumrequiredsize:

400MB

-->SYSAUXtablespaceisadequatefortheupgrade.

....minimumrequiredsize:

461MB

-->TEMPtablespaceisadequatefortheupgrade.

....minimumrequiredsize:

60MB

.

**********************************************************************

Flashback:

OFF

**********************************************************************

**********************************************************************

UpdateParameters:

[UpdateOracleDatabase11.2init.oraorspfile]

Note:

Pre-upgradetoolwasrunonalowerversion64-bitdatabase.

**********************************************************************

-->IfTargetOracleis32-Bit,referhereforUpdateParameters:

--Noupdateparameterchangesarerequired.

.

-->IfTargetOracleis64-Bit,referhereforUpdateParameters:

--Noupdateparameterchangesarerequired.

.

**********************************************************************

RenamedParameters:

[UpdateOracleDatabase11.2init.oraorspfile]

**********************************************************************

--Norenamedparametersfound.Nochangesarerequired.

.

**********************************************************************

Obsolete/DeprecatedParameters:

[UpdateOracleDatabase11.2init.oraorspfile]

**********************************************************************

-->background_dump_dest11.1DEPRECATEDreplacedby"diagnostic_dest"

-->user_dump_dest11.1DEPRECATEDreplacedby"diagnostic_dest"

.

**********************************************************************

Components:

[Thefollowingdatabasecomponentswillbeupgradedorinstalled]

**********************************************************************

-->OracleCatalogViews[upgrade]VALID

-->OraclePackagesandTypes[upgrade]VALID

-->JServerJAVAVirtualMachine[upgrade]VALID

-->OracleXDKforJava[upgrade]VALID

-->OracleWorkspaceManager[upgrade]VALID

-->OLAPAnalyticWorkspace[upgrade]INVALID

-->OLAPCatalog[upgrade]INVALID

-->EMRepository[upgrade]VALID

-->OracleText[upgrade]VALID

-->OracleXMLDatabase[upgrade]VALID

-->OracleJavaPackages[upgrade]VALID

-->OracleinterMedia[upgrade]VALID

-->Spatial[upgrade]VALID

-->DataMining[upgrade]VALID

-->ExpressionFilter[upgrade]VALID

-->RuleManager[upgrade]VALID

-->OracleOLAPAPI[upgrade]INVALID

.

**********************************************************************

MiscellaneousWarnings

**********************************************************************

WARNING:

-->Databaseisusingatimezonefileolderthanversion14.

....Afterthereleasemigration,itisrecommendedthatDBMS_DSTpackage

....beusedtoupgradethe10.2.0.4.0databasetimezoneversion

....tothelatestversionwhichcomeswiththenewrelease.

WARNING:

-->DatabasecontainsINVALIDobjectspriortoupgrade.

....ThelistofinvalidSYS/SYSTEMobjectswaswrittento

....registry$sys_inv_objs.

....Thelistofnon-SYS/SYSTEMobjectswaswrittento

....registry$nonsys_inv_objs.

....Useutluiobj.sqlaftertheupgradetoidentifyanynewinvalid

....objectsduetotheupgrade.

....USEROLAPSYShas4INVALIDobjects.

....USERPUBLIChas4INVALIDobjects.

WARNING:

-->EMDatabaseControlRepositoryexistsinthedatabase.

....DirectdowngradeofEMDatabaseControlisnotsupported.Refertothe

....UpgradeGuideforinstructionstosavetheEMdatapriortoupgrade.

WARNING:

-->Yourrecyclebinisturnedonandcurrentlycontainsnoobjects.

....BecauseitisREQUIREDthattherecyclebinbeemptypriortoupgrading

....andyourrecyclebinisturnedon,youmayneedtoexecutethecommand:

PURGEDBA_RECYCLEBIN

....priortoexecutingyourupgradetoconfirmtherecyclebinisempty.

.

**********************************************************************

Recommendations

**********************************************************************

Oraclerecommendsgatheringdictionarystatisticspriorto

upgradingthedatabase.

Togatherdictionarystatisticsexecutethefollowingcommand

whileconnectedasSYSDBA:

EXECUTEdbms_stats.gather_dictionary_stats;

**********************************************************************

Oraclerecommendsreviewinganydefinedeventspriortoupgrading.

Toviewexistingnon-defaulteventsexecutethefollowingcommands

whileconnectedASSYSDBA:

Events:

SELECT（translate（value,chr（13）||chr（10）,''））FROMsys.v$parameter2

WHEREUPPER（name）='EVENT'ANDisdefault='FALSE'

TraceEvents:

SELECT（translate（value,chr（13）||chr（10）,''））fromsys.v$parameter2

WHEREUPPER（name）='_TRACE_EVENTS'ANDisdefault='FALSE'

Changeswillneedtobemadeintheinit.oraorspfile.

**********************************************************************

Carryoutthestepsrecommendedbythistoolsuchasgatheringdictionaryandschemastatisticsandetc.Morestepsavailableon 837570.1 whicharenotrelevantonthisupgradesotheyarenotlisted.

Anotherkeydifferenceisthat11.2.0.3providesawaytoupgradethetimezoneatthesametimethedatabaseisupgrade.Whichwasnotthereonthebase11gR2release.Comparethe5thpictureonthe previousblog withthepicturebelowwhichgivestheoptiontoupgradethetimezone.

Thereareseveralmetalinknotesrelatedtotimezoneupgrade.

UpdatingtheRDBMSDSTversionin11gR2（11.2.0.1andup）usingDBMS_DST [ID977512.1]

ActionsForDSTUpdatesWhenUpgradingToOrApplyingThe11.2.0.3Patchset [ID1358166.1]

Beforetheupgradethetimezonefileversionwas

upgrade

SQL>selectversionfromv$timezone_file;

VERSION

----------

4

Keypointsrelevanttothisare（quotingfromthemetalinknote 1358166