Upgrading from 10204 to 11203.docx
- 文档编号:18567026
- 上传时间:2023-08-19
- 格式:DOCX
- 页数:20
- 大小:920.93KB
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
- 配套讲稿:
如PPT文件的首页显示word图标,表示该PPT已包含配套word讲稿。双击word图标可打开word文档。
- 特殊限制:
部分文档作品中含有的国旗、国徽等图片,仅作为作品整体效果示例展示,禁止商用。设计者仅对作品中独创性部分享有著作权。
- 关 键 词:
- Upgrading from 10204 to 11203
![提示](https://static.bingdoc.com/images/bang_tan.gif)