Knowledge is Power – share IT



Notes on how to upgrade Oracle Grid Infrastructure 12c Release 2 to 18c Download Oracle 18c Grid Infrastructure Software the 20 GB /u02 mount point for the 18c Grid Infrastructure software home Note – we perform the same steps shown above on rac02 as wellCreate the partition [root@rac01 ~]# fdisk -l /dev/sd* |grep "GB"Disk /dev/sda: 42.9 GB, 42949672960 bytesDisk /dev/sda2: 42.4 GB, 42424336384 bytesDisk /dev/sdb: 42.9 GB, 42949672960 bytesDisk /dev/sdb1: 42.9 GB, 42944154624 bytesDisk /dev/sdf: 10.7 GB, 10737418240 bytesDisk /dev/sdf1: 10.7 GB, 10733958144 bytesDisk /dev/sdg: 10.7 GB, 10737418240 bytesDisk /dev/sdg1: 10.7 GB, 10733958144 bytesDisk /dev/sdm: 21.5 GB, 21474836480 bytes[root@rac01 ~]# fdisk /dev/sdmDevice contains neither a valid DOS partition table, nor Sun, SGI or OSF disklabelBuilding a new DOS disklabel with disk identifier 0xf54d0f29.Changes will remain in memory only, until you decide to write them.After that, of course, the previous content won't be recoverable.Warning: invalid flag 0x0000 of partition table 4 will be corrected by w(rite)WARNING: DOS-compatible mode is deprecated. It's strongly recommended to switch off the mode (command 'c') and change display units to sectors (command 'u').Command (m for help): nCommand action e extended p primary partition (1-4)pPartition number (1-4): 1First cylinder (1-2610, default 1): Using default value 1Last cylinder, +cylinders or +size{K,M,G} (1-2610, default 2610): Using default value 2610Command (m for help): wThe partition table has been altered!Calling ioctl() to re-read partition table.Syncing disks.[root@rac01 ~]# mkfs -t ext4 /dev/sdm1 mke2fs 1.43-WIP (20-Jun-2013)Filesystem label=OS type: LinuxBlock size=4096 (log=2)Fragment size=4096 (log=2)Stride=0 blocks, Stripe width=0 blocks1310720 inodes, 5241198 blocks262059 blocks (5.00%) reserved for the super userFirst data block=0Maximum filesystem blocks=4294967296160 block groups32768 blocks per group, 32768 fragments per group8192 inodes per groupSuperblock backups stored on blocks: 32768, 98304, 163840, 229376, 294912, 819200, 884736, 1605632, 2654208, 4096000Allocating group tables: done Writing inode tables: done Creating journal (32768 blocks): doneWriting superblocks and filesystem accounting information: done [root@rac01 ~]#Create the directory structure for 18c GI [root@rac01 ~]# cd /[root@rac01 /]# mkdir u02[root@rac01 /]# mount -t ext4 /dev/sdm1 /u02[root@rac01 /]# cd /u02[root@rac01 u02]# mkdir app[root@rac01 u02]# chown grid:oinstall app[root@rac01 u02]# vi /etc/fstab/dev/sdm1 /u02 ext4 defaults 0 0Note: Apply patch 21255373 – if upgrading from 12.1.0.2 to 18c Add these entries to /etc/security/limits.conforacle soft stack 10240grid?? soft stack 10240[root@rac01 app]# mkdir grid[root@rac01 app]# chown grid:oinstall grid[root@rac01 app]# ssh root@rac02root@rac02's password: Last login: Wed Aug 29 02:14:42 2018 from rac01.localdomain[root@rac02 ~]# cd /u02/app [root@rac02 app]# mkdir grid[root@rac02 app]# chown grid:oinstall grid[root@rac02 app]# exitlogoutConnection to rac02 closed. [root@rac01 app]# su – grid[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]$ unzip -q /media/sf_software/LINUX.X64_180000_grid_home.zip[grid@rac01 grid]$ ssh grid@rac02Last 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 Run gridSetup.sh to upgrade Grid Infrastraucture [grid@rac01 18.0.0]$ export DISPLAY=:0.0[grid@rac01 18.0.0]$ ./gridSetup.shEncountered this error Fixed by using the 12.2 new feature Online Data File Move to relocate a datafile from +MGMT to +DATASQL> show pdbs CON_ID CON_NAME OPEN MODE RESTRICTED---------- ------------------------------ ---------- ---------- 2 PDB$SEED READ ONLY NO 3 GIMR_DSCREP_10 READ WRITE NOSQL> alter session set container=GIMR_DSCREP_10; Session altered.SQL> select name from v$datafile;NAME--------------------------------------------------------------------------------+MGMT/_MGMTDB/72B54AEAEF2E7399E0536438A8C094CF/DATAFILE/system.271.983370361+MGMT/_MGMTDB/72B54AEAEF2E7399E0536438A8C094CF/DATAFILE/sysaux.272.983370361+MGMT/_MGMTDB/72B54AEAEF2E7399E0536438A8C094CF/DATAFILE/undotbs1.270.983370361+MGMT/_MGMTDB/72B54AEAEF2E7399E0536438A8C094CF/DATAFILE/users.274.983370387+MGMT/_MGMTDB/72B54AEAEF2E7399E0536438A8C094CF/DATAFILE/sysgridhomedata.275.983370401+MGMT/_MGMTDB/72B54AEAEF2E7399E0536438A8C094CF/DATAFILE/syscalogdata.276.983370401+MGMT/_MGMTDB/72B54AEAEF2E7399E0536438A8C094CF/DATAFILE/sysmgmtdata.277.98337040NAME--------------------------------------------------------------------------------9+MGMT/_MGMTDB/72B54AEAEF2E7399E0536438A8C094CF/DATAFILE/sysmgmtdatadb.278.983370423+MGMT/_MGMTDB/72B54AEAEF2E7399E0536438A8C094CF/DATAFILE/sysmgmtdatachafix.279.983370517+MGMT/_MGMTDB/72B54AEAEF2E7399E0536438A8C094CF/DATAFILE/sysmgmtdataq.280.98337057710 rows selected.SQL> alter database move datafile '+MGMT/_MGMTDB/72B54AEAEF2E7399E0536438A8C094CF/DATAFILE/system.271.983370361' to '+DATA';Database altered.SQL>Note that a rolling upgrade is being performed [root@rac01 trace]# cd /u02/app/18.0.0/grid/bin[root@rac01 bin]# ./crsctl check crs CRS-4638: Oracle High Availability Services is onlineCRS-4537: Cluster Ready Services is onlineCRS-4529: Cluster Synchronization Services is onlineCRS-4533: Event Manager is online[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 -allOracle 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]#[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 -allOracle Clusterware version on node [rac01] is [18.0.0.0.0]Oracle Clusterware version on node [rac02] is [18.0.0.0.0][root@rac01 trace]# cd /u02/app/grid/diag/rdbms/_mgmtdb/[root@rac01 _mgmtdb]# cd -- -MGMTDB/[root@rac01 -MGMTDB]# cd trace[root@rac01 trace]# tail -f alert_-MGMTDB.log2018-07-29T21:54:32.536159+08:00GIMR_DSCREP_10(3):Completed: CREATE BIGFILE TABLESPACE SYSGRIDHOMEDATA DATAFILE SIZE 500M LOGGING EXTENT MANAGEMENT LOCAL UNIFORM SIZE 1M SEGMENT SPACE MANAGEMENT AUTOGIMR_DSCREP_10(3):CREATE BIGFILE TABLESPACE SYSCALOGDATA DATAFILE SIZE 1G LOGGING EXTENT MANAGEMENT LOCAL UNIFORM SIZE 1M SEGMENT SPACE MANAGEMENT AUTO2018-07-29T21:54:39.291676+08:00GIMR_DSCREP_10(3):Completed: CREATE BIGFILE TABLESPACE SYSCALOGDATA DATAFILE SIZE 1G LOGGING EXTENT MANAGEMENT LOCAL UNIFORM SIZE 1M SEGMENT SPACE MANAGEMENT AUTOGIMR_DSCREP_10(3):CREATE BIGFILE TABLESPACE SYSMGMTDATA DATAFILE SIZE 2G LOGGING EXTENT MANAGEMENT LOCAL UNIFORM SIZE 1M SEGMENT SPACE MANAGEMENT AUTO2018-07-29T21:54:54.166082+08:00GIMR_DSCREP_10(3):Completed: CREATE BIGFILE TABLESPACE SYSMGMTDATA DATAFILE SIZE 2G LOGGING EXTENT MANAGEMENT LOCAL UNIFORM SIZE 1M SEGMENT SPACE MANAGEMENT AUTOGIMR database has been upgraded to 18c as well[grid@rac01 bin]$ export ORACLE_SID=-MGMTDB[grid@rac01 bin]$ pwd/u02/app/18.0.0/grid/bin[grid@rac01 bin]$ ./sqlplus sys as sysdbaSQL*Plus: Release 18.0.0.0.0 - Production on Sun Jul 29 22:09:17 2018Version 18.3.0.0.0Copyright (c) 1982, 2018, Oracle. All rights reserved.Enter password: Connected to:Oracle Database 18c Enterprise Edition Release 18.0.0.0.0 - ProductionVersion 18.3.0.0.0SQL> select name,open_mode from v$pdbs;NAME--------------------------------------------------------------------------------OPEN_MODE----------PDB$SEEDREAD ONLYGIMR_DSCREP_10READ WRITESQL> alter session set container=GIMR_DSCREP_10;Session altered.SQL> select tablespace_name from dba_tablespaces;TABLESPACE_NAME------------------------------SYSTEMSYSAUXUNDOTBS1TEMPUSERSSYSGRIDHOMEDATASYSCALOGDATASYSMGMTDATASYSMGMTDATADBSYSMGMTDATACHAFIXSYSMGMTDATAQ11 rows selected. ................
................

In order to avoid copyright disputes, this page is only a partial summary.

Google Online Preview   Download