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

升级至Oracle12C19C

一、从升级至rcat

12.

0.确认一下未升级前当前版本L su-oracle.oraenvrcatsqlplus/as sysdbastartup;查看一下当前版本select*from v$version;升级完成后需要提升一下show parametercompatible;这时看到版本是copyrighrc1982,2014,oracle.Al1rightsreserved,connectedtoanidleinstance.SQLSQLSQLstartup;ORACLEinstancestarted.Total emGlobalArea2147483648Fixed29264721325402232variablesizeDatabase805306368BuffersRedoBuffers13848576Databasemounted.Databaseopened.SQLselectparametercompatible;selectparametercompatibleERRORatline1:ORA-00923:FROMkeywordnotfoundwhereexpectedSQLA[[A-restoflineignored.SQL042:unknowncommandSQLselectparameterfromcompatible;selectparameterfromcompatible*ERRORatline1:ORA-00942:tableorviewdoesnotexistSQLshowparametercompatible;NAME TYPEVALUEnoncdb-compatible booleanFALSE、升级前需要做以下预检查2[oracle@db scriptsscripts]!scripts.[oracle@db oraenv=[+ASM]neat[Tohraecle©dbOracle baseremains unchangedO[oRraAcCleL@Ed_bSID withvalue/uOl/app/oracle[oracle@db scripts]$foracle@db scripts]$_scripts]!/u01/app/oracle/product/

12.

1.0/dbhome_l/jdk/bin/java-jar/uOl/app/oracle/product/

19.

3.O/dbhorre_l/rdbms/admin/preupgrade.jarPREUPGRADESUMMARY/uOl/app/oracle/cfgtool1ogs/rcat/preupgrade/preupgrade.1og/uOl/app/oracle/cfgtool1ogs/rcat/preupgrade/preupgrade_fixups.sql/uOl/app/oracle/cfgtool1ogs/rcat/preupgrade/postupgrade_fixups.sqlExecutefixupscriptsasindicatedbelow:Beforeupgrade:Logintothedatabaseandexecutethepreupgradefixups@/u01/app/oracle/cfgtool1ogs/rcat/preupgrade/preupgrade_fixups.sqlAftertheupgrade:Logintothedatabaseandexecutethepostupgradefixups©/uOl/app/oracle/cfgtoollogs/rcat/preupgrade/postupgrade_fixups.sqlPreupgradecomplete:2O23-O5-31T13:52:10bbbbb ytytytytyt66ss5ss666[oracIe@dbscriptslS执行下面脚本.oraenv rcatsqlplus/as sysdba@/u01/app/oracle/cfgtoollogs/rcat/preupgrade/preupgrade_fixups.sql;202--Thecalltorun_fixupbelowwilltestwhether203--thefollowingissueoriginallyidentified by204-thepreupgradetoolisstillpresent205-andifso,itwillattempttoperform theaction206——necessarytoresolveit.207—208—ORIGINALPREUPGRADEISSUE209--

7.checktheoracleBackupandRecoveryusersGuideforinformationonhow210--tomanageanRMANrecoverycatalogschema.2H—212―ifyouareusingaversionoftherecoverycatalog schemathatis older213--thanthat requiredbytheRMANclientversion,thenyou mustupgradethe214―catalogschema.215—216―Itisgoodpracticetohavethecatalogschema thesame orhigherversion217--thantneRMANclientversionyouareusing.218—219fixup_result:=dbms_preup.run_fixuprman_recovery_version,7ANDfixup_result;220221—222―cleanrecyclebinincaseanyoftheabovefixupsleftstuffthere.223—224recyclebin_cleaned:=dbms_preup.run_fixup_onlypurge-recyclebin,check_result_xml;225226IFfixup_result=FALSETHEN227dbms_output.put_line;228dbms_output.put_lineThefixup scriptshavebeenrunandresolvedwhattheycan.However,;229dbms_output.put_l1nethereare stillissues originallyidentifiedbythepreupgradethat;230dbms_output.put.l1nehavenotbeenremediedandarestillpresentinthedatabase.231dbms.output.put_lineDepending ontheseverityofthespecificissue,andthenatureof232dbms_output.put_linetheissue itself,that couldmeanthatyourdatabaseisnotready;233dbms_output.put.lineforupgrade,TOresolveTheoutstandingissues,startbyreviewing;234dbms_ouTput.put_l1neQ*thepreupgrade_fixups.sqlandsearchingitforthenameof235dbms_output.put_linethefailedCHECKNAMEorPreupgradeActionNumberlistedabove.;236dbms_output.put_l1neThereyouwillfindtheoriginalcorrespondingdiagnosticmessage;237dbms_output.put_Hnefromtnepreupgradewhichexplainsinmoredetailwhat stillneeds238dbms_output.put.lineCtobedone.239ENDIF；240*END；5QL、接下来升级数据字典3shutdown immediate;一suvi/etc/oratab修改为rcat:/u01/app/oracle/product/

19.

3.0/dbhome_l:N W

12.

1.

0.

0、将老的文件复制到新的路径下4spfilesu-oracle、通过启动5rcat这时已经达到.oraenv rcatecho$ORACLE_HOME,

19.

3.0sqlplus/as sysdbastartup upgrade注意如果是跟容器，下边有插件数据库的话，需要将跟容器下的所有插件数据库都打开，否则跟容器升级后，插件数据库没有升级，会很麻烦我们这个是跟容器，没有插件数据库，所以不需要执行下面这句alter pluggabledatabase allopen;；exit、开始升级6dbupgrade-n8Restart Phase#:90[rcitl Files:1Time:4sserial Phase#:91[rear Files:2Time:23sRestart Phase#:92[rear]Files:1Time:5sserial Phase#:93[rcat]Files:1Time:3sRestart Phase#:94[rcat]Files:1Time:4supgradingODM,WK,,EXF,RUL,XOQserial Phase#:95[rcat]Files:1Time:38sRestart Phase#96[rcat]Files:1Time:5s****,*****F^inalcomponentscriptsserial Phase#:97[rear Files:1Time:6sFinal upgradescripts%骨之%Htrik骨骨*骨serial Phase*98[rearJ Files:1Time:473sMigrat‘ion4kqserial Phase#99[rcat]Files:1Time:83s***EndPDBApplicationupgradePre-Shutdownserial Phase#:100Year.Files:1Time:3sserial Phase#:101；rcar；Files:1Time:0sserial Phase#:102rcat Files:1Time:69svwkwwxwtUkWk PostUtDCserialPhase*103[rcat]fFiles:l Time:69skai4m4HwwSummaryrsport3,之百%,有1k口%百%口有“之serialPhase#:104[rcat]Files:1Time:3sEndPDBApplicationupgradePost-shutdownserial Phase#:105[rcat Files:1Time:3ssserial Phase#:106[rear-Files:1Time:0sSerial Phase#:107[rcatFiles:1Time35sPhases[0-107]EndTime:[2O23_O5_3115:01:20]GrandTotalTime:3853s1k.logupgradeSummaryReportLocatedin:GrandTotalupgradeTime:[0d:lh:4m:13s][oracle@dbdbsl$sqlplus/assysdbashutdown immediate;startup nomount;、修改版本号7show parametercomp;alter systemset compatible=

19.

0.

0.0scope=spfile;shutdown immediate;startup upgrade;TotalSystemGlobalArea2147481656FixedSize8898616variableSize1375731712DatabaseBuffers754974720RedoBuffers7876608三SQLshowparametercompaitble;SQLshowparametercomp;户NAM TY井PE VALUEEcell_off1oad_compact1on stringADAPTIVEcompatible string

12.

1.

0.

2.0db_index_compression_inheritance stringNONE1nmemory_prefer_xmem_jnemcompress stringnls_comp stringBINARYnoncdb-compatible booleanFALSEplsql_v2_compafibi1ity booleanFALSESQLaltersystemsetcompafible=

19.

0.

0.Oscope=spfile;Systemaltered.SQLSQLSQLshutdownimmediate;ORA-01507:databasenotmountedORACLEinstanceshutdown.SQLstartupupgrade;ORACLEinstancestarted.户Total emGlobalArea2147481656户三Fixed8898616variablesizeDatabase1375731712BuffersRedoBuffers754974720Databasemounted.7876608Databaseopened.、执行以下脚本8@/rdbms/admin/utlirp.sqlshutdown immediate;startup;@/rdbms/admin/utlrp.sqlRem risgupta05/08/17-Bug26001269AddSQL_FILE_METADATA02/03/12-bugRem aramappa13653782:validatelbac_evenTspackageRem aramappa02/03/12-createdRemSET ECHOONDECLAREObjidNUMBER；BEGINIFdbms_registry.is_loadedOLSisNOTNULLTHENBEGINSELECTobiect_idintoobjidfromdba_objectsWHEREobject_name=LBAC_EVENTSANDstatus=INVALIDANDobject_type=PACKAGEBODY;dbms_ut1lity.val1dateobj1d;EXCEPTIONWHENOTHERSTHENRETURN；END；ENDIF；END；/PL/SQLproceduresuccessfullycompIeted.SQLSQLDOCDO#######################################################################DOOurlirp.sqlcompletedsuccessfully.AllPL/SQLobjectsintheDOCdatabasehavebeeninvalidated.DOCDOCshutdownandrestartthedatabaseinnormalmodeandrunutlrp.sqltoDOCrecompileinvalidobjects.DOC#654321O98765432LLLL1111111QQQQytbbbbbeeeeRbsbsbsbsbsryty6660sssss6671WHENNO_SUCH_TABLETHENCLOSEreg_cursor;72WHENOTHERSTHENCLOSEreg_cursor;raise;73END；7475ENDIF；7677EXECUTEIMMEDIATEDROPTABLEsys.enabled$1ndexes,;7879EXCEPTION80WHENNO_DATA_FOUNDTHENNULL；8182END；83/PL/SQLproceduresuccessfullycompleted.SQLSQLDROPfunction1ocal_enquote_name;Functiondropped.SQLSETserveroutputoffSQLSQLSQLRum=====================================================================SQLRemRuncomponentvalidationprocedureSQLRem=====================================================================SQLSQLSETserveroutputonSQLEXECUTEdbms_registry_sys.validate_components;PL/SQLproceduresuccessfullycompleted.SQLSETserveroutputoffSQLSQLSQLRem===========================================================================SQLRemENDutlrp.sqlSQLRem===========================================================================另开一个窗口su-oracle.oraenvrcatsqlplus/as sysdbaSELECTCOUNTS FROMobj$WHERE statusIN4,5,6;查询值降到升级完成0,rcatLogintoThedatabaseandexecutethepostupgradefixups@/u01/app/oracle/cfgtoollogs/rcat/preupgrade/postupgrade_fixups.sqlPreupgrade complete:2O23-O5-31T13:52:10[oracle©db scriptsAC[oracle@db scripts.oraenvORACLE_SID=[rear]rearThe oraclebaseremainsunchangedwithvalue/u01/app/oraclescripts]$sqlplus/assysdba[oracle@dbCopyrightc1982,2019,Oracle.Allrightsreserved.Connectedto:oracleDatabase19cEnterpriseEditionRelease

19.

0.

0.

0.0-ProductionSQLSELECTCOUNT*FROMobj$WHEREStatusIN4,5,6；COUNT*10980SQL/COUNT10980SQL/COUNT10860180SQL/COUNT*180SQL/COUNT180SQL/COUNT*180SQL/COUNT*180SQL/COUNT180SQL/@/u01/app/oracle/cfgtoollogs/rcat/preupgrade/postupgrade_fixups.sqlNo errors.Executing oraclePOST-upgrade FixupscriptAuto-Generated by:oracle Preupgradescript version:

19.

0.

0.

0.0Build:12023-05-31Generated on:13:52:10For sourceDatabase:source RCATDatabaseversion:Forupgrade toversion:Preup PreupgradeActionissue isNumberPreupgrade CheckName RemediedFurther DBAActiondepend_usr_tables None.old_tIme_zones_exist Manualfixup recommended.dir_symlinks None.post_dictionary None.post_f1xed_obj ectsInformational only.Further actionis optional.The fixupscripts havebeen runand resolvedwhat theycan.However,there aresti11issuesoriginallyidentifiedby thepreupgrade thathave notbeen remediedand arestill presentin thedatabase.Depending onthe severityof thespecific issue,and thenature ofthe issueItself,that couldmean thatyourdatabase upgradeis notfully complete,TO resolvethe outstandingissues,start byreviewing thepostupgrade_fixups.sql andsearching itfor thename ofthe failedCHECK NAMEor PreupgradeActionNumber listedabove.There youwill findthe originalcorresponds ngdiagnostic messagefrom thepreupgradewhich explainsin moredetail whatstill needsto bedone.PL/SQL proceduresuccessfully completed.sessnon aItered.SjL-升级至Oracle12C19C11189012。