Step by Step upgrade grid infrastructure from 12.2.0.1 to 19.12.0.0.0 on AIX

High level steps:

Source Version: 12.2.0.1.0

Target Version: 19.12.0.0.0

OS : AIX 7.1

Verify prerequisites and setup Kernel parameters & OS Packs on AIX server.
Apply Bundle Patch 27006180 on 12c grid home before upgrading to 19c
as a grid user run rootpre.sh as a root user

$ sh /u00/grid/oracle/product/19000/grid/clone/rootpre.sh
run gridSetup.sh with grid/oracle user from 19C Oracle HOME and select the required options in the GUI

run rootupgrade.sh as a root user

# sh /u00/grid/oracle/product/19000/grid/rootupgrade.sh

Upgrade from 19.3.0.0.0 to 19.12.0.0.0

Step 1) Connect as grid user(in this scenario it is oracle user) , create directory structure.

mkdir -p /u00/grid/oracle/product/19000/grid

Step 2)

export ORACLE_HOME=/u00/grid/oracle/product/19000/grid

export ORACLE_SID=+ASM

export DISPLAY=<remote Desktop IP>:0.0

xclock

Step 3:$ sh /u00/grid/oracle/product/19000/grid/clone/rootpre.sh

Step 4) cd /u00/grid/oracle/product/19000/grid

./gridSetup.sh

Step 5)

Step 6)

Checks shown in the screenshot have been ignored all.

root@AIXSRVR /u02/software/19C_AIX_GRID/27006180

# crsctl start has

CRS-4123: Oracle High Availability Services has been started.

root@AIXSRVR /u02/software/19C_AIX_GRID/27006180

# sh /u00/grid/oracle/product/19000/grid/rootupgrade.sh

Performing root user operation.

The following environment variables are set as:

ORACLE_OWNER= oracle

ORACLE_HOME= /u00/grid/oracle/product/19000/grid

Enter the full pathname of the local bin directory: [/usr/local/bin]:

The contents of “dbhome” have not changed. No need to overwrite.

The file “oraenv” already exists in /usr/local/bin. Overwrite it? (y/n) [n]:

The file “coraenv” already exists in /usr/local/bin. Overwrite it? (y/n) [n]:

Entries will be added to the /etc/oratab file as needed by

Database Configuration Assistant when a database is created

Finished running generic part of root script.

Now product-specific root actions will be performed.

Using configuration parameter file: /u00/grid/oracle/product/19000/grid/crs/install/crsconfig_params

The log of current session can be found at:

/u00/grid/oracle/crsdata/AIXSRVR/crsconfig/roothas_2022-03-02_09-49-50AM.log

2022/03/02 09:50:03 CLSRSC-595: Executing upgrade step 1 of 12: ‘UpgPrechecks’.

2022/03/02 09:50:13 CLSRSC-363: User ignored prerequisites during installation

2022/03/02 09:50:22 CLSRSC-595: Executing upgrade step 2 of 12: ‘GetOldConfig’.

2022/03/02 09:50:38 CLSRSC-595: Executing upgrade step 3 of 12: ‘GenSiteGUIDs’.

2022/03/02 09:50:38 CLSRSC-595: Executing upgrade step 4 of 12: ‘SetupOSD’.

2022/03/02 09:50:39 CLSRSC-595: Executing upgrade step 5 of 12: ‘PreUpgrade’.

ASM has been upgraded and started successfully.

2022/03/02 09:51:35 CLSRSC-595: Executing upgrade step 6 of 12: ‘UpgradeAFD’.

2022/03/02 09:51:36 CLSRSC-595: Executing upgrade step 7 of 12: ‘UpgradeOLR’.

clscfg: EXISTING configuration version 0 detected.

Creating OCR keys for user ‘oracle’, privgrp ‘dba’..

Operation successful.

2022/03/02 09:52:04 CLSRSC-595: Executing upgrade step 8 of 12: ‘UpgradeOCR’.

LOCAL ONLY MODE

Successfully accumulated necessary OCR keys.

Creating OCR keys for user ‘root’, privgrp ‘system’..

Operation successful.

CRS-4664: Node AIXSRVR successfully pinned.

2022/03/02 09:52:13 CLSRSC-595: Executing upgrade step 9 of 12: ‘CreateOHASD’.

2022/03/02 09:52:18 CLSRSC-595: Executing upgrade step 10 of 12: ‘ConfigOHASD’.

2022/03/02 09:52:19 CLSRSC-329: Replacing Clusterware entries in file ‘/etc/inittab’

2022/03/02 09:53:30 CLSRSC-595: Executing upgrade step 11 of 12: ‘UpgradeSIHA’.

AIXSRVR 2022/03/02 09:55:51 /u00/grid/oracle/crsdata/AIXSRVR/olr/backup_20220302_095551.olr 2676783881

AIXSRVR 2020/05/20 21:48:06 /u00/grid/oracle/product/12201/grid/cdata/AIXSRVR/backup_20200520_214806.olr 0

AIXSRVR 2020/05/19 23:33:15 /u00/grid/oracle/product/1120/grid/cdata/AIXSRVR/backup_20200519_233315.olr –

AIXSRVR 2020/05/19 23:30:33 /u00/grid/oracle/product/1120/grid/cdata/AIXSRVR/backup_20200519_233033.olr –

AIXSRVR 2013/01/27 07:04:43 /u00/grid/oracle/product/1120/grid/cdata/AIXSRVR/backup_20130127_070443.olr –

2022/03/02 09:55:52 CLSRSC-595: Executing upgrade step 12 of 12: ‘InstallACFS’.

2022/03/02 09:58:34 CLSRSC-327: Successfully configured Oracle Restart for a standalone server

root@AIXSRVR /u02/software/19C_AIX_GRID/27006180

Step 7:

oracle 35717628 1 0 01:21:54 – 0:00 asm_pmon_+ASM

root@AIXSRVR:/>crsctl stop has

CRS-2791: Starting shutdown of Oracle High Availability Services-managed resources on ‘AIXSRVR’

CRS-2673: Attempting to stop ‘ora.evmd’ on ‘AIXSRVR’

CRS-2673: Attempting to stop ‘ora.DATA.dg’ on ‘AIXSRVR’

CRS-2673: Attempting to stop ‘ora.FRA.dg’ on ‘AIXSRVR’

CRS-2673: Attempting to stop ‘ora.LISTENER.lsnr’ on ‘AIXSRVR’

CRS-2677: Stop of ‘ora.DATA.dg’ on ‘AIXSRVR’ succeeded

CRS-2677: Stop of ‘ora.FRA.dg’ on ‘AIXSRVR’ succeeded

CRS-2673: Attempting to stop ‘ora.asm’ on ‘AIXSRVR’

CRS-2677: Stop of ‘ora.LISTENER.lsnr’ on ‘AIXSRVR’ succeeded

CRS-2677: Stop of ‘ora.evmd’ on ‘AIXSRVR’ succeeded

CRS-2677: Stop of ‘ora.asm’ on ‘AIXSRVR’ succeeded

CRS-2673: Attempting to stop ‘ora.cssd’ on ‘AIXSRVR’

CRS-2677: Stop of ‘ora.cssd’ on ‘AIXSRVR’ succeeded

CRS-2793: Shutdown of Oracle High Availability Services-managed resources on ‘AIXSRVR’ has completed

CRS-4133: Oracle High Availability Services has been stopped.

root@AIXSRVR:/>

export ORACLE_HOME=/u00/grid/oracle/product/19000/grid

export PATH=$ORACLE_HOME/bin:$ORACLE_HOME/OPatch:$PATH

/u10/software/software/19C_AIX_GRID/32895426

$ORACLE_HOME/OPatch/opatchauto apply /u10/software/software/19C_AIX_GRID/32895426 -analyze -oh /u00/grid/oracle/product/19000/grid

opatchauto returns with error code = 2

root@AIXSRVR:/u00/grid/oracle/product/19000/grid>export ORACLE_HOME=/u00/grid/oracle/product/19000/grid

root@AIXSRVR:/u00/grid/oracle/product/19000/grid>export PATH=$ORACLE_HOME/bin:$ORACLE_HOME/OPatch:$PATH

root@AIXSRVR:/u00/grid/oracle/product/19000/grid>/32895426 -analyze -oh /u00/grid/oracle/product/19000/grid <

OPatchauto session is initiated at Sat Apr 23 01:53:48 2022

System initialization log file is /u00/grid/oracle/product/19000/grid/cfgtoollogs/opatchautodb/systemconfig2022-04-23_01-54-11AM.log.

Session log file is /u00/grid/oracle/product/19000/grid/cfgtoollogs/opatchauto/opatchauto2022-04-23_01-54-37AM.log

The id for this session is SJBZ

Executing OPatch prereq operations to verify patch applicability on home /u00/grid/oracle/product/19000/grid

Patch applicability verified successfully on home /u00/grid/oracle/product/19000/grid

Executing patch validation checks on home /u00/grid/oracle/product/19000/grid

Patch validation checks successfully completed on home /u00/grid/oracle/product/19000/grid

OPatchAuto successful.

——————————–Summary——————————–

Analysis for applying patches has completed successfully:

Host:AIXSRVR

SIHA Home:/u00/grid/oracle/product/19000/grid

Version:19.0.0.0.0

==Following patches were SUCCESSFULLY analyzed to be applied:

Patch: /u10/software/software/19C_AIX_GRID/32895426/32916816