Hi All,
Planning to upgrade 12c (two node) RAC database to 19c (two node) RAC through manual approach, here are the high level steps planned,
NAME="Oracle Linux Server"
VERSION="7.7"
Oracle version 19.7
Please let me know if there are any changes required.
1.srvctl config database -d <DBNAME>
2./u01/app/oracle/product/19.7/jdk/bin/java -jar /u01/app/oracle/product/19.7/rdbms/admin/preupgrade.jar TERMINAL TEXT
3.@/u01/app/oracle/products/preupgrade/preupgrade_fixups.sql
4.Take a cold backup
5.Copy/move files from old $OH/dbs to new $OH/dbs
6.Edit /etc/oratab to use new Oracle Home
7.Set environment again to use new Oracle Home
8.start it as single instance,
startup nomount
alter system set cluster_database=false scope=spfile;
ALTER SYSTEM SET COMPATIBLE = '19.0.0' SCOPE=SPFILE;
shutdown immediate;
9.startup upgrade;
10.cd /u01/app/oracle/product/19.7/bin/dbupgrade
11.Post upgrade steps.
12.alter system set cluster_database=true scope=spfile;
Shutdown immediate;
13.srvctl upgrade database -d <DBNAME> -o /u01/app/oracle/product/19.7
srvctl config database -d <DBNAME>
srvctl start database -d <DBNAME>
srvctl status database -d <DBNAME>
Thanks!