Oracle12C升級至19Crcat從12.0.升級至19.3.0.01、確認(rèn)一下未升級前當(dāng)前版本su–oracle.oraenvrcatsqlplus/assysdbastartup;查看一下當(dāng)前版本select*fromv$version;升級完成后需要提升一下showparametercompatible;這時看到版本是12.1.0.02、升級前需要做以下預(yù)檢查/u01/app/oracle/product/12.1.0/dbhome_1/jdk/bin/java-jar/u01/app/oracle/product/19.3.0/dbhome_1/rdbms/admin/preupgrade.jar執(zhí)行下面腳本.oraenvrcatsqlplus/assysdba@/u01/app/oracle/cfgtoollogs/rcat/preupgrade/preupgrade_fixups.sql;3、接下來升級數(shù)據(jù)字典shutdownimmediate;su–vi/etc/oratabrcat:/u01/app/oracle/product/19.3.0/dbhome_1:N將12.1.0.0修改為19.3.04、將老的spfile文件復(fù)制到新的路徑下su-oraclecd/u01/app/oracle/product/19.3.0/dbhome_1/dbs/cp/u01/app/oracle/product/12.1.0/dbhome_1/dbs/spfilercat.ora./cp/u01/app/oracle/product/12.1.0/dbhome_1/dbs/orapwrcat./5、通過19.3.0啟動rcat.oraenvrcatecho$ORACLE_HOME，這時已經(jīng)達(dá)到19.3.0sqlplus/assysdbastartupupgrade注意：如果是跟容器,下邊有插件數(shù)據(jù)庫的話，需要將跟容器下的所有插件數(shù)據(jù)庫都打開，否則跟容器升級后，插件數(shù)據(jù)庫沒有升級，會很麻煩我們這個是跟容器，沒有插件數(shù)據(jù)庫，所以不需要執(zhí)行下面這句alterpluggabledatabaseallopen;exit；6、開始升級dbupgrade-n8shutdownimmediate;startupnomount; 7、修改版本號showparametercomp;altersystemsetcompatible='19.0.0.0'scope=spfile;shutdownimmediate;startupupgrade;8、執(zhí)行以下腳本@?/rdbms/admin/utlirp.sqlshutdownimmediate;startup; @?/rdbms/admin/utlrp.sql另開一個窗口su–oracle.oraenvrcatsqlplus/assysdbaSELECTCOUNT(*)FROMobj$WHEREstatusIN(4,5,6);查詢值降到0，rcat升級完成@/u01/app/orac