DEV Community

Discussion on: Oracle Database AutoUpgrade now for RAC!!

Collapse
 
project42 profile image
Project-42

Hi, Yes.
In Oracle, GRID Version should be always At least the same than your newest Database version.. Meaning, if you want to install Oracle DB 12.2, your Grid should be 12.2 or newer.

Right now, there is not GRID Autoupgrade tool (but I'm sure is in the pipeline) so this asume you already have your GRID at a proper version

In my case, I have Grid 19.3 and then different DBs versions installed there
[oracle@rac1-node1 ~]$ cat /etc/oratab

Backup file is /u01/app/grid/crsdata/rac1-node1/output/oratab.bak.rac1-node1.oracle line added by Agent

[.....]

ASM

+ASM1:/u01/app/19.3.0/grid:N

DB 11.2

db1121:/u01/app/oracle/product/11.2.0/dbhome_1:N

DB 12.1

cdb1211:/u01/app/oracle/product/12.1.0/dbhome_1:N
db1211:/u01/app/oracle/product/12.1.0/dbhome_1:N

DB 12.2

cdb1221:/u01/app/oracle/product/12.2.0/dbhome_1:N
db1221:/u01/app/oracle/product/12.2.0/dbhome_1:N

DB 18.0

cdb181:/u01/app/oracle/product/18.0.0/dbhome_1:N
db181:/u01/app/oracle/product/18.0.0/dbhome_1:N

DB 19.3

cdb191:/u01/app/oracle/product/19.3.0/dbhome_1:N
db191:/u01/app/oracle/product/19.3.0/dbhome_1:N

[oracle@rac1-node1 ~]$

Is very easy now days to get your own RAC Cluster at home, if you are not sure how, please go to oracle-base.com/articles/19c/oracl... and give it a try.
I'm trying to do something similar with KVM+Ansible so I can learn Ansible in the process, but Tim's tutorials are the best around and mine will take some time to be completed :)

Hope this help you and dont doubt in "ping me" if you have more questions, will be happy to help :)