oracle数据库从12C升级到19C

数据库从12.1.0.2.0升级到19.0.0.0.0

1. /u01/app/oracle/product/12.1.0/dbhome_1/jdk/bin/java -jar  /u01/app/oracle/product/12.1.0/dbhome_1/jdk/bin/java
2. @/u01/app/oracle/cfgtoollogs/rcat/preupgrade/preupgrade_fixups.sql
3. shutdown immediate
4. 修改/etc/oratab  

rcat:/u01/app/oracle/product/19.3.0/dbhome_1:N

1. cp /u01/app/oracle/product/12.1.0/dbhome_1/dbs/spfilercat.ora  /u01/app/oracle/product/19.3.0/dbhome_1/dbs/

cp /u01/app/oracle/product/12.1.0/dbhome_1/dbs/orapwrcat  /u01/app/oracle/product/19.3.0/dbhome_1/dbs/

1. SQL> startup upgrade
2. Dbupgrade -n 8
3. startup
4. @?/rdbms/admin/utlrp.sql
5. @/u01/app/oracle/cfgtoollogs/rcat/preupgrade/postupgrade_fixups.sql
6. Show parameter compatible
7. Alter system set compatible=’19.0.0’ scope=spfile;
8. Shutdown immediate
9. Startup
10. 升级结束-升级成功