Kiran Dalvi
28 Nov, 2023
0 Comments
2 Mins Read

Oracle RAC 12C to 19C ASM Upgradation

PREREQUISITE FOR UPGRADE:

Apply required patches on grid home and oracle home. To apply patch on RAC Database , refer this blog : https://learnomate.org/rac-19c-patching/

STEP:1 Create 19C Directory on Both Node

mkdir -p /u02/app/grid/product/19C/dbhome

chown -R grid:oinstall /u02

chmod -R 775 /u02

STEP 2: Copy the 19c grid software to the first node of RAC and unzip it:

cd u02/app/grid/product/19C/dbhome

Unzip LINUX.X64_193000_grid_home.zip-------------------------on Node 1

Step 3. Run cluvfy utility to pre-check any errors On 1st node only run the pre-upgrade script from the new home and generate a fix script if generated. as grid user.

su - grid
cd  /u02/app/grid/product/19C/dbhome -- 19c grid home 
./runcluvfy.sh stage -pre crsinst -upgrade -rolling -src_crshome /u02/app/grid/product/12C/dbhome -dest_crshome p /u02/app/grid/product/19C/dbhome -dest_version 19.3.0.0.0 -fixup –verbose

Note: Make sure the cluvfy is executed successfully. If any error occurs, take action before going to the GRID 12c upgrade.

Step 4. Using Dry-Run Upgrade Mode to Check System Upgrade Readiness

cd  /u02/app/grid/product/19C/dbhome
gridsetup.sh –dryRunForUpgrade