Oracle 18c Grid Infrastructure Upgrade
- Posted by Gavin Soorma
- On July 30, 2018
- 1 Comments
Upgrade Oracle 12.1.0.2 Grid Infrastructure to 18c
Download the 18c Grid Infrastructure software (18.3)
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>
1 Comments