Oracle 18c Grid Infrastructure Upgrade

Upgrade Oracle 12.1.0.2 Grid Infrastructure to 18c

Download the 18c Grid Infrastructure software (18.3)

https://www.oracle.com/technetwork/database/enterprise-edition/downloads/oracle18c-linux-180000-5022980.html

Prerequisites

• Apply the patch 21255373 to the 12.1.0.2 Grid Infrastructure software home
• Edit the /etc/security/limits.conf file and add the lines:

oracle soft stack 10240
grid   soft stack 10240

Notes

• Need to have at least 10 GB of free space in the $ORACLE_BASE directory
• The unzipped 18c Grid Infrastructure software occupies around 11 GB of disk space – a big increase on the earlier versions
• The Grid Infrastructure upgrade can be performed in rolling fashion -configure Batches for this
• We can see the difference in the software version between the RAC nodes while GI upgrade is in progress ….

During Upgrade:

[root@rac01 trace]# cd /u02/app/18.0.0/grid/bin

[root@rac01 bin]# ./crsctl query crs softwareversion

Oracle Clusterware version on node [rac01] is [18.0.0.0.0]

[root@rac01 bin]# ./crsctl query crs softwareversion -all

Oracle Clusterware version on node [rac01] is [18.0.0.0.0]

Oracle Clusterware version on node [rac02] is [12.1.0.2.0]

[root@rac01 bin]# ./crsctl query crs activeversion

Oracle Clusterware active version on the cluster is [12.1.0.2.0]

[root@rac01 bin]#

After Upgrade:

[root@rac01 bin]# ./crsctl query crs activeversion

Oracle Clusterware active version on the cluster is [18.0.0.0.0]

[root@rac01 bin]# ./crsctl query crs softwareversion -all

Oracle Clusterware version on node [rac01] is [18.0.0.0.0]

Oracle Clusterware version on node [rac02] is [18.0.0.0.0]

• The minimum memory requirements is 8 GB – same as 12c Release 2
• Got an error PRVF-5600 related to /etc/resolv.conf stating the file cannot be parsed as some lines are in an improper format   – ignored the error because the format of the file is correct.

[grid@rac01 grid]$ cat /etc/resolv.conf
# Generated by NetworkManager
search localdomain  rac.localdomain

nameserver 192.168.56.102

options timeout:3
options retries:1

Create the directory structure on both RAC nodes

[root@rac01 app]# su – grid

[grid@rac01 ~]$ cd /u02/app/18.1.0/

[grid@rac01 ~]$ cd /u02/app

[grid@rac01 app]$ mkdir 18.1.0

[grid@rac01 app]$ cd 18.1.0/

[grid@rac01 18.0.0]$ mkdir grid

[grid@rac01 18.0.0]$ cd grid

[grid@rac01 grid]$ ssh grid@rac02

Last login: Sun Jul 29 11:22:38 2018 from rac01.localdomain

[grid@rac02 ~]$ cd /u02/app

[grid@rac02 app]$ mkdir 18.1.0

[grid@rac02 app]$ cd 18.1.0/

[grid@rac02 18.0.0]$ mkdir grid

Unzip the 18c GI Software

[grid@rac01 ~]$ cd /u02/app/18.1.0/grid

[grid@rac01 grid]$ unzip -q /media/sf_software/LINUX.X64_180000_grid_home.zip

Execute gridSetup.sh

[grid@rac01 18.0.0]$ export DISPLAY=:0.0

[grid@rac01 18.0.0]$ ./gridSetup.sh

ASM Configuration Assistant 18c

GIMR pluggable database upgraded to 18c

[grid@rac01 bin]$ export ORACLE_SID=-MGMTDB
[grid@rac01 bin]$ pwd
/u02/app/18.0.0/grid/bin
[grid@rac01 bin]$ ./sqlplus sys as sysdba

SQL*Plus: Release 18.0.0.0.0 - Production on Sun Jul 29 22:09:17 2018
Version 18.3.0.0.0

Copyright (c) 1982, 2018, Oracle.  All rights reserved.

Enter password: 

Connected to:
Oracle Database 18c Enterprise Edition Release 18.0.0.0.0 - Production
Version 18.3.0.0.0

SQL> select name,open_mode from v$pdbs;

NAME
--------------------------------------------------------------------------------
OPEN_MODE
----------
PDB$SEED
READ ONLY

GIMR_DSCREP_10
READ WRITE


SQL> alter session set container=GIMR_DSCREP_10;

Session altered.

SQL> select tablespace_name from dba_tablespaces;

TABLESPACE_NAME
------------------------------
SYSTEM
SYSAUX
UNDOTBS1
TEMP
USERS
SYSGRIDHOMEDATA
SYSCALOGDATA
SYSMGMTDATA
SYSMGMTDATADB
SYSMGMTDATACHAFIX
SYSMGMTDATAQ

11 rows selected.


SQL> select file_name from dba_data_files where tablespace_name='SYSMGMTDATA';

FILE_NAME
--------------------------------------------------------------------------------
+OCR/_MGMTDB/7224A7DF6CB92239E0536438A8C03F3A/DATAFILE/sysmgmtdata.281.982792479

SQL>