1. Home
  2. Knowledge Base
  3. Real Application Clusters
  4. Oracle 18c Grid Infrastructure Upgrade

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>
Updated on June 2, 2021

Was this article helpful?

Related Articles

Comments

  1. Hi Gavin,

    Thanks for this! One question: after upgrading GRID to 18c, do I need to upgrade RDBMS also? Or it is also updated at the same time?

Reply to Jay Cancel