Oracle12C升级至19C RCAT-ORACLE OCP认证考试.docx

《Oracle12C升级至19C RCAT-ORACLE OCP认证考试.docx》由会员分享，可在线阅读，更多相关《Oracle12C升级至19C RCAT-ORACLE OCP认证考试.docx（6页珍藏版）》请在第一文库网上搜索。

1、Orac1e12C升级至19C一、rcat从12.0.升级至19.3.0.01、确认一下未升级前当前版本Su-orac1e.oraenvrcatsq1p1us/assysdbastartup;查看一下当前版本se1ect*fromv$version;升级完成后需要提升一下showparametercompatib1e;这时看到版本是12.1.0.0Copyright(C)1982,20141Orac1e.A11rightsreserved.connectedoanId1eInstance.SQ1SQ1sq1startup;ORAC1Einstancestarted.Tota1SystemFix

2、edsizeG1oba1Area2147483648variab1esizeDatabaseBuffersRedoBuffersDatabasemounted.Databaseopened.SQ1se1ectParanUseiectparameter(2926472132540223280530636813848576bytesbytesbyesbytesbyesetercompatib1e;compatib1eERRORatHne1:ORA-00923:FROMkeywordnotfoundwhereexpectedSQ1a-restof1ineignored.sq1042:unknownc

3、ommandSQ1se1ectparameterfromcCtnpatib1e;se1ectparameterfrcmcompatib1eERRORat1ine1:OA-00942:ab1eorviewdoesnotexistSQ1showparametercompatib1e;NAMETYPEVA1UEaIpatib1estringboo1ean12.1.0.2.0FA1SE2、升级前需要做以下预检查01apporac1eproduct12.1.0dbhome-1jdkbinjava-jar01apporac1eproduct19.3.0dbhome-1rdbmsadminpreupgrad

4、e.jarForac1eOdborac1edb1orac1eOdbORAC1EeSIDTheorac1eForac1eddb1orac1eOdborac1edbscr1ptsS$oraenv?rcat+.baseremainsunchangedvhva1ueu01apporac1escrptsSscr1ptsjSu_.ScriptSjiu1appOraC1e/product/12.1.0/dbhomee1/jdk/bin/java-jar01apporac1eproduct19.3.Odbho,e1rdbmsach1preupgrade.jarPREUPGRADESUMMARYu01appor

5、ac1e/cfgtoo11ogs/rcatpreupgrade/preupgrade.1ogu01apporac1ecfgooHogsrcarpreugradepreugrade-fVxups.Executefixupscriptsasindicatedbe1ow:Beforeupgrade:1og1rorhedatabaseandexecuterhepreupgradefixups/uO1/app/orac1e/cfgtoo11ogs/rcatpreupgrade/preupgrade_f1xups.sq1Aftertheupgrade:1ogintothedatabaseandexecut

6、ethepostupqradefixups0u01aporac1ecfgoo11ogsrcatreupgradepostupgradef5xups.sq1preupgradecomp1ete:2O23-O5-31T13:52:10oracIeMbscripts$执行下面脚本.oraenvrcatsq1p1us/assysdba/u01/app/orac1e/cfgtoo11ogs/rcat/preupgrade/preupgrade_fixups.sq1;2032042052062072082092102112122132142152162172182192202212222232242252

7、26227228229230231232233234235236237238239240*-ThecaItorun_r1xupbe1owwi11testwhether- -thefo11ov1ngIssueorigina11yidentifiedby- thepreupgraetoo1issti11present- and1fsof1wi11aemttoperformheaction-necessarytoreso1veit.ORIGINA1PREUPGRADEISSUE：7.checktheorac1eBackupandRecoveryuser,sGuideforInformationonh

8、ow-tomanageanRMANrecoverycata1ogschema.-Ifyouareusingaversionofrherecoverycata1ogschemaha15o1der一thanthatrequiredbytheRMANc11entversion,thenyoumustupgradethe-cata1ogschema.x1sgoodpracticetohavexhecata1ogschemathesameorh1gherversion-thantneRMANc1ientversionyouareusing.fixup-resu1:dbms-preup.run-fixup

9、(,rman-recovery-version,7)andfixup-resu1;一c1eanrecyc1eb1n1ncaseanyoftheabovef1ups1eftstuffthere.recyc1ebinc1eaned:=dbmsoreup.rurcfiupon1y(,purge-recyc1ebin,.checkeresu1t-xm1);sdbmadbma嘿urutut5utututuutuutur_o_o_o_o_o_o_o_o_o_o_o.oSsssssssssssSu1跳跳霞舐舐戢A111m111111Fzzzzzz=黑器器器案案PpppppppppppTHENCThefixu

10、pscriptshavebeenrunandreso1vedwhattheycan.However);Cthereares11Issuesorigina11yidentifiedbythepreupgradethat);1havenotbeenremediedandaresti11presentinthedatabase.);Dependingontheseverityofthespecificissue,andthenatureof);theIssue1se1fthacou1dmeanthatyourdatabase1snotready);,forupgrade.Toreso1vetheou

11、tstandingissues,startbyreviewing*);rhepreupgrade-f5xups.sq1andSeardTIng1rforrhenameof);,theran1eaCHECKnameorPreupgradeActionNunber1istedabove.,);Thereyouwi11findXheorigina1correspondingdiagnosticmessage):,frcmtnepreupgradewhichexp1ainsinmoredetai1watsti11needs*);,tobedone.,):END：3、接下来升级数据字典shutdowni

12、mmediate;su-vietcoratabrcat:/u01/app/orac1e/product/19.3.0/dbhome_1：N将12.1.0,0修改为19304、将老的spfi1e文件复制到新的路径下Su-orac1ecdu01apporac1eproduct19.3.0dbhome-1dbscpu01apporac1eproduct12.1.0dbhome-1dbsspfi1ercat.ora./cpu01apporac1eproduct12.1.0dbhome-1dbsorapwrcat./5、通过19.3.0启动rcat.oraenvrcatecho$ORAC1E_HOME,

13、这时已经达到1930sqip1us/assysdbastartupupgrade,跟容器内话,需要将跟我们这个是跟容器,没有插件数据,所以不需要执行下面这句a1terp1uggab1edatabasea11openexit；6、开始升级dbupgrade-n8RestartPhase#:90rcatFi1es:1Time:4sSeria1Phase7:91rcatFi1es:2Time:233RestartPhase#:92frcatFi1es:1Time:5sseria1Phase7:93(rearJFi1es:1Time:35RestartPhase+：X(rcatJFi1es:1Time

14、:4s*rCf4Seria1upgradingOMPhase*:95frcatEXF,RU1,Fi1es:1XOQ,Time:*3*M*38sRestartPhase#:96rcatFi1es:1Time:5SFinacomponentscriptsseria1Phase#:97rcatFIIeS:1*3JWTime:6s*wsmtF1naIoradescritsseria1Phase#:98rcatFi1esi1Time:473sw*,yWCf*fy*wcrMIarat1Wervfy口wWseria1Phase4:99frcatFi1es:1Time:83sdPDBApp11car1onupqradePre-Shurdown*Seria1Phase#:100rcatFi1es:1Time:Bsseria1phase*:101rcatF1IgS:1Time:OSSeria1Phase，：102rcatF