Skip to Main Content

Database Software

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Checks before upgrade RAC 12c to 19c

LauryAug 6 2020

Hi,

We are preparing the upgrade van Oracle RAC 12c naar Oracle RAC 19c.

It is a two-nodes cluster.

Grid Home and RDBMS Home software is installed on each node.

We have and NFS disks (redundant disks) where are stored: ASM database files, OCR file, en spfile.

De chosen strategy is to perform the upgrade with DBUA in two steps (in this order):

1) The clustereware

2) The RDBMS

De strategie gekozen is het te doen met de DBUA.

The Oracle documentation mention a list of checks:

https://docs.oracle.com/en/database/oracle/oracle-database/19/cwlin/preugrade-oracle-grid-infrastructure-checklist.html#GUID-1FA85454-69E7-4376-833F-7BB3F015388B

For instance:

1) Check space for GIMR

Task:

When upgrading to Oracle Grid Infrastructure 19c, a new GIMR is created only if the source Grid home has a GIMR configured. Allocate additional storage space as described in Oracle Clusterware Storage Space Requirements.

When upgrading from Oracle Grid Infrastructure 12c Release 2 (12.2), the GIMR is preserved with its contents.

=> The sasme NFS disks will be used as we upgrade - in place - an existing RAC. What additional storage can be needed?

At first sight, we don't see the point to as we have in place the same datafiles, OCR, spfile.

2) Oracle ASM password file

Task:

When upgrading from Oracle Grid Infrastructure 12c Release 1 (12.1), Oracle Grid Infrastructure 12c Release 2 (12.2), or Oracle Grid Infrastructure 18c to Oracle Grid Infrastructure 19c, move the Oracle ASM password file from file system to Oracle ASM, before proceeding with the upgrade using pwcopy.

=> Is it possible to copy that way the password file to a regular filesystem? Oracle Doc ID 2575530.1) mention that it should be on ASM.

3) Check system upgrade readiness with dry-run upgrade

Task:

Run Oracle Grid Infrastructure installation wizard, gridSetup.sh, in dry-run upgrade mode to perform system readiness checks for Oracle Grid Infrastructure upgrades.

=> What is a "dry-run upgrade mode"? Is that a simulation of the upgrade? Can we do it safely?

Thanks by advance for sharing your experience.

Kind Regards

Comments
Post Details
Added on Aug 6 2020
0 comments
533 views