Step By Step Guide To Install Oracle 19C RAC With ASM & Version Upgrade

Step By Step Guide To Install Oracle 19C RAC With ASM

This document will guide you for a step by step Oracle 19C RAC installation with ASM on a Linux platform. Each and every step is discussed here. We will RAC installation with ASM and version upgrade.

Steps to Follow –

  • Server Configuration
  • Configure Oracle ASM
  • Precheck for RAC setup
  • Install GRID Infrastructure for RAC
  • Install Oracle 19C Database
  • Version Upgrade / PSU Patch Apply

Modify Server hosts File

The “/etc/hosts” file must contain a fully qualified name for the server. Please set the correct hostname in the “/etc/hostname” file as root user.

#Public IP

10.201.33.38 AUS-LNDBASMT-001.dbanalyser.com    AUS-LNDBASMT-001

10.201.33.39 AUS-LNDBASMT-002.dbanalyser.com    AUS-LNDBASMT-002

#Virtual IP

10.201.33.70    AUS-LNDBASMT-001-vip.dbanalyser.com     AUS-LNDBASMT-001-vip

10.201.33.71    AUS-LNDBASMT-002-vip.dbanalyser.com     AUS-LNDBASMT-002-vip

#Private IP

10.201.224.125    AUS-LNDBASMT-001-priv.dbanalyser.com   AUS-LNDBASMT-001-priv

10.201.224.126    AUS-LNDBASMT-002-priv.dbanalyser.com   AUS-LNDBASMT-002-priv

#Scan

10.201.33.72 AUS-LNDBASMT-scan.dbanalyser.com AUS-LNDBASMT-SCAN

10.201.33.73 AUS-LNDBASMT-scan.dbanalyser.com AUS-LNDBASMT-SCAN

10.201.33.74 AUS-LNDBASMT-scan.dbanalyser.com AUS-LNDBASMT-SCAN

Oracle Installation Prerequisite

Perform either automatic or manual setup to complete the basic prerequisite steps. An additional setup is required for all installations.

Automatic Setup

If you are using RHEL7 or CentOS7, you can pick up the PRM from the OL7 repository and install it. It will pull the dependencies from your normal repositories. 

# yum install -y https://yum.oracle.com/repo/OracleLinux/OL7/latest/x86_64/getPackage/oracle-database-preinstall-19c-1.0-1.el7.x86_64.rpm

 For RHEL8 or CentOS8 –

curl -o oracle-database-preinstall-19c-1.0-2.el8.x86_64.rpm https://yum.oracle.com/repo/OracleLinux/OL8/appstream/x86_64/getPackage/oracle-database-preinstall-19c-1.0-2.el8.x86_64.rpm 

yum -y localinstall oracle-database-preinstall-19c-1.0-2.el8.x86_64.rpm

Manual Server Configuration

Disabling Firewall

Firewall of the server needs to be disabled by following command.

systemctl stop firewalld 
systemctl disable firewalld

Add or Amend the following lines to the "/etc/sysctl.conf" File

fs.file-max = 6815744
kernel.sem = 250 32000 100 128
kernel.shmmni = 4096
kernel.shmall = 1073741824
kernel.shmmax = 4398046511104
kernel.panic_on_oops = 1
net.core.rmem_default = 262144
net.core.rmem_max = 4194304
net.core.wmem_default = 262144
net.core.wmem_max = 1048576
net.ipv4.conf.all.rp_filter = 2
net.ipv4.conf.default.rp_filter = 2
fs.aio-max-nr = 1048576
net.ipv4.ip_local_port_range = 9000 65500

Run one of the following commands to change the current kernel parameters.

/sbin/sysctl -p

Add following lines to the "/etc/security/limits.conf file"

oracle   soft   nofile    1024
oracle   hard   nofile    65536
oracle   soft   nproc    16384
oracle   hard   nproc    16384
oracle   soft   stack    10240
oracle   hard   stack    32768
oracle   hard   memlock    134217728
oracle   soft   memlock    134217728

Create User & Group

groupadd -g 54321 oinstall
groupadd -g 54322 dba
groupadd -g 54323 oper 
groupadd -g 54324 backupdba
groupadd -g 54325 dgdba
groupadd -g 54326 kmdba
groupadd -g 54327 asmdba
groupadd -g 54328 asmoper
groupadd -g 54329 asmadmin
groupadd -g 54330 racdba
 
useraddoracle
usermod -g oinstall oracle
usermod -G dba asmoper,asmadmin.asmdba,oper,oracle

 

 

Install below RPM Packages

yum install -y bc    
yum install -y binutils
#yum install -y compat-libcap1
yum install -y compat-libstdc++-33
#yum install -y dtrace-modules
#yum install -y dtrace-modules-headers
#yum install -y dtrace-modules-provider-headers
#yum install -y dtrace-utils
yum install -y elfutils-libelf
yum install -y elfutils-libelf-devel
yum install -y fontconfig-devel
yum install -y glibc
yum install -y glibc-devel
yum install -y ksh
yum install -y libaio
yum install -y libaio-devel
#yum install -y libdtrace-ctf-devel
yum install -y libXrender
yum install -y libXrender-devel
yum install -y libX11
yum install -y libXau
yum install -y libXi
yum install -y libXtst
yum install -y libgcc
yum install -y librdmacm-devel
yum install -y libstdc++
yum install -y libstdc++-devel
yum install -y libxcb
yum install -y make
yum install -y net-tools # Clusterware
yum install -y nfs-utils # ACFS
yum install -y python # ACFS
yum install -y python-configshell # ACFS
yum install -y python-rtslib # ACFS
yum install -y python-six # ACFS
yum install -y targetcli # ACFS
yum install -y smartmontools
yum install -y sysstat
yum install -y unixODBC
 
# New for OL8
yum install -y libnsl
yum install -y libnsl.i686
yum install -y libnsl2
yum install -y libnsl2.i686

Network Configuration

vi /etc/sysconfig/network
# Recommended value for NOZEROCONF
NOZEROCONF=yes

Install Additional RPM’s For ASM Configuration

kmod-oracleasm-2.0.8-17.el7.x86_64
oracleasmlib-2.0.12-1.el7.x86_64.rpm
oracleasm-support-2.1.8-3.el7.x86_64.rpm

Configure Oracle ASM From Both Nodes

oracleasm configure -i 
Configuring the Oracle ASM library driver.
This will configure the on-boot properties of the Oracle ASM library driver.  The following questions will determine whether the driver is loaded on boot and what permissions it will have.  The current values will be shown in brackets (‘[]’).  Hitting <ENTER> without typing an answer will keep that current value.  Ctrl-C will abort.
Default user to own the driver interface []: oracle
Default group to own the driver interface []: oinstall
Scan for Oracle ASM disks on boot (y/n) [y]: y
Writing Oracle ASM library driver configuration: done

oracleasm start

Disk Creation in ASM

fdisk /dev/sdf 
Welcome to fdisk (util-linux 2.23.2).
C
hanges will remain in memory only, until you decide to write them. Be careful before using the write command. 
Command (m for help): n
Partition type:
p   primary (1 primary, 0 extended, 3 free) e   extended
Select (default p):
Using default response p
Partition number (2-4, default 2): d
Partition number (2-4, default 2): 2
No free sectors available
Command (m for help): d
Selected partition 1
Partition 1 is deleted
Command (m for help): n
Partition type:
p   primary (0 primary, 0 extended, 4 free) e   extended
Select (default p)
Using default response partition number (1-4, default 1):
First sector (2048-20971519, default 2048):
Last sector, +sectors or +size{K,M,G} (2048-20971519, default 20971519):
Using default value 20971519
Partition 1 of type Linux and of size 10 GiB is set
Command (m for help): w
The partition table has been altered!
Calling ioctl() to re-read partition table.
Syncing disks.

/etc/init.d/oracleasm status
Checking if ASM is loaded: yes
Checking if /dev/oracleasm is mounted: yes

/etc/init.d/oracleasm createdisk DATAVOL1 /dev/sdf1
Marking disk “DATAVOL1” as an ASM disk:                    [  OK  ]

/etc/init.d/oracleasm listdisks
DATAVOL1

Like this way we need to create other disk as needed. 

Check The ASM Disks From Other Node

oracleasm scandisks

oracleasm listdisks

Create Directories & Change Permission

mkdir -p /d01/app/19c/grid 
mkdir -p /d01/app/oracle/product/19c/db_1
chown -R oracle:oinstall /d01
chmod -R 775 /d01/

SSH Setup Between Nodes

unzip /d01/app/19c/grid/LINUX.X64_193000_grid_home.zip 
cd $GRID_HOME/deinstall
./sshUserSetup.sh -user oracle -hosts " AUS-LNDBASMT-001 AUS-LNDBASMT-002" -noPromptPassphrase

Pre-Checking Using CLUVFY

Use CLUVFY command to check for cluster installation readiness along with rectification in case of any issue. 

cd $GRID_HOME 
./runcluvfy.sh stage -pre crsinst -n AUS-LNDBASMT-001,AUS-LNDBASMT-002

 

 

Installation of 19C GRID Infrastructure for RAC

cd /d01/app/19c/grid/ 
./gridSetup.sh

GRID infrastructure setup wizard launched…

Now follow the steps as described below –

Select the “Configure Oracle Grid Infrastructure for a New Cluster” option, then click the “Next” button.

1

Select the “Configure an Oracle Standalone Cluster” option by clicking the “Next” button.

2

Enter the cluster name, SCAN name and SCAN port, then click the “Next” button.

NOTECluster name should be within 15 characters long, otherwise installation will fail.

3

On the “Cluster Node Information” screen, click the “Add” button. Enter the details of the second node in the cluster, then click the “OK” button. Click the “SSH connectivity…” button and enter the password for the “oracle” user. Click the “Setup” button to configure SSH connectivity, and the “Test” button to test it once it is complete. Once the test is complete, click the “Next” button.

4th Step

Check the public and private networks are specified correctly. If the NAT interface is displayed, remember to mark it as “Do Not Use”. Click the “Next” button.

6

Select the “Use Oracle Flex ASM for storage” option by clicking the “Next” button.

7

Select “Yes” and click Next

8

Select “Yes”  if you want separate disk to be created for GIMR and click Next. Otherwise click “No”.  

NOTE : If you want GIMR to be created on a separate disk the disk size must be at least 32G of size.

9
8th

First Browse the path /dev/oracleasm/disks* using change discovery path. Set the redundancy to Normal, click the 5GB DISK for OCR and Voting disks configuration, then click the Next button

10

In case you need GIMR to be created. Please remember this is not mandatory.

11

Enter the credentials and click the “Next” button.

13

Accept the default IPMI option by clicking the “Next” button.

14

Don’t register with EM. Click the “Next” button.

15

We are using a single user and group manage both ASM add the database, so set the groups to “oinstall” and click the “Next” button. Accept the warnings on the subsequent dialog by clicking the “Yes” button.

16

Enter the Oracle Base location “/d01/app/oracle” and click the “Next” button. We have already pre-created directories for the later database installation, so ignore the subsequent warning about the Oracle Base not being empty by clicking the “Yes” button.

14th

Accept the default inventory directory by clicking the “Next” button.

15th

If you want the root scripts to run automatically, enter the relevant credentials. Click the “Next” button.

19

Wait while the prerequisite checks complete. If you have any issues use the “Fix & Check Again” button. Once possible fixes are complete, check the “Ignore All” checkbox and click the “Next” button. It is likely “Network Time Protocol (NTP)” tests will fail for this type of installation. This is OK. It can be Fixed.

If you are happy with the summary information, click the “Install” button.

20

Now the GRID installation is complete.

20th

Check the running processes by issuing the below command

ps -ef|grep d.bin
$GRID_HOME/crsctl stat res -t –> This command will show the running services for both the nodes

Install Oracle Software Binary

Unzip the software file in your DB home directory

unzip LINUX.X64_193000_db_home.zip

Run the below command post setting up DISPLAY

./runInstaller

Select the setup software only option, then click the Next button.

d1

Select the Oracle Real Application Clusters database installation option by clicking the Next button.

d2

Make sure both nodes are selected, then click the Next button.

24

Select the Enterprise Edition option, then click the Next button.

d3

Enter /u01/app/orabase as the Oracle base and /u01/app/oracle/product/19c/db_1 as the software location, then click the Next button.

d5
d6

Automatically run configuration script – leave it blank.

d7

Then click on the install button. When prompted, run the root.sh for both the node. Now 19C software binary installation has been completed.

Database Creation

As we have already created the required disk groups like DATA and FRA, now we are proceeding with database creation.

cd $ORACLE_HOME/bin

./dbca

Please follow as per the screen shot.

Select create a database and click on “Next” 

21

Choose Advanced configuration and click “Next”

22

Choose General Purpose or Transaction Processing and click on “Next” 

23

Make sure both node selected

24

Provide the database name, SID and click on “Next”

d8

Select the database file location and click on “Next”

26

Select the FRA location, size and click on “Next”

27

Allocate the proper memory and other necessary details and click on “Next”

28

Select below and click on “Next”

29

Provide same password for all user and click on “Next”

30
31

Click on the next and database will be created.

Post Installation Checks for RAC Setup

Check the Status of the RAC by firing the below commands –

$GRID_HOME/crsctl stat res -t
srvctl config database -d infra
srvctl status database -d infra
srvctl config scan

Database Upgrade from 19.3 to 19.5

For version upgrade we need to apply patch on both nodes one by one.


srvctl stop instance -db POCDB -node aus-lndbasmt-001

srvctl status database -db pocdb

Instance POCDB1 is not running on node aus-lndbasmt-001

Instance POCDB2 is running on node aus-lndbasmt-002

./Opatch version

OPatch Version: 12.2.0.1.17

OPatch succeeded.

[oracle@AUS-LNDBASMT-001 OPatch]$ ./Opatch lsinventory -oh /oracle/Oracle_Software/19cDB

Oracle Interim Patch Installer version 12.2.0.1.17

Copyright (c) 2020, Oracle Corporation.  All rights reserved.

Oracle Home       : /oracle/Oracle_Software/19cDB

Central Inventory : /oracle/u01/app/oraInventory

   from           : /oracle/Oracle_Software/19cDB/oraInst.loc

OPatch version    : 12.2.0.1.17

OUI version       : 12.2.0.7.0

Log file location : /oracle/Oracle_Software/19cDB/cfgtoollogs/opatch/opatch2020-07-31_12-19-31PM_1.log

Lsinventory Output file location : /oracle/Oracle_Software/19cDB/cfgtoollogs/opatch/lsinv/lsinventory2020-07-31_12-19-31PM.txt

——————————————————————————–

Local Machine Information::

Hostname: AUS-LNDBASMT-001.wiley.com

ARU platform id: 226

ARU platform description:: Linux x86-64

Installed Top-level Products (1):

Oracle Database 19c                                                  19.0.0.0.0

There are 1 products installed in this Oracle Home.

Interim patches (2) :

Patch  29585399     : applied on Thu Apr 18 03:21:33 EDT 2019

Unique Patch ID:  22840393

Patch description:  “OCW RELEASE UPDATE 19.3.0.0.0 (29585399)”

   Created on 9 Apr 2019, 19:12:47 hrs PST8PDT

   Bugs fixed:

     27222128, 27572040, 27604329, 27760043, 27877830, 28302580, 28470673

     28621543, 28642469, 28699321, 28710663, 28755846, 28772816, 28785321

     28800508, 28808652, 28815557, 28847541, 28847572, 28870496, 28871040

     28874416, 28877252, 28881191, 28881848, 28888083, 28911140, 28925250

     28925460, 28935956, 28940472, 3, 28942694, 28951332, 28963036, 28968779

     28980448, 28995287, 29003207, 29003617, 29016294, 29018680, 29024876

     29026154, 29027933, 29047127, 29052850, 29058476, 29111631, 29112455

     29117337, 29123444, 29125708, 29125786, 29129476, 29131772, 29132456

     29139727, 29146157, 29147849, 29149170, 29152603, 29152752, 29154631

     29154636, 29154829, 29159216, 29159661, 29160462, 29161923, 29169540

     29169739, 29170717, 29173618, 29181568, 29182920, 29183298, 29186091

     29191827, 29201143, 29201695, 29209545, 29210577, 29210610, 29210624

     29210683, 29213641, 29219627, 29224294, 29225861, 29229839, 29235934

     29242906, 29243749, 29244495, 29244766, 29244968, 29248723, 29249583

     29251564, 29255616, 29260224, 29261695, 29271019, 29273360, 29282090

     29282666, 29285453, 29285621, 29290235, 29292232, 29293806, 29294753

     29299830, 29307090, 29307109, 29311336, 29329675, 29330791, 29339299

     29357821, 29360467, 29360775, 29367971, 29368725, 29379299, 29379381

     29380527, 29381000, 29382296, 29391301, 29393649, 29402110, 29411931

     29413360, 29457319, 29465047

Patch  29517242     : applied on Thu Apr 18 03:21:17 EDT 2019

Unique Patch ID:  22862832

Patch description:  “Database Release Update : 19.3.0.0.190416 (29517242)”

   Created on 17 Apr 2019, 23:27:10 hrs PST8PDT

   Bugs fixed:

     29515240, 14735102, 19697993, 20313356, 21965541, 25806201, 25883179

     25986062, 26476244, 26611353, 26872233, 27369515, 27423500, 27666312

     27710072, 27846298, 27957203, 28064977, 28072567, 28129791, 28181021

     28210681, 28279456, 28313275, 28350595, 28371123, 28379065, 28431445

     28463226, 28489419, 28502773, 28513333, 28534475, 28561704, 28569897

     28572533, 28572544, 28587723, 28593682, 28594086, 28597221, 28601957

     28605066, 28606598, 28625862, 28627033, 28636532, 28643718, 28644549

     28645570, 28646200, 28646939, 28649388, 28655209, 28663782, 28673945

     28692275, 28694872, 28696373, 28705231, 28710385, 28710734, 28714461

     28718469, 28730079, 28740708, 28760206, 28772390, 28774416, 28777214

     28789531, 28791852, 28795551, 28802734, 28804517, 28810381, 28811560

     28815123, 28815355, 28819640, 28824482, 28833912, 28835937, 28862532

     28863432, 28873575, 28876253, 28876639, 28884931, 28888327, 28892794

     28897512, 28899663, 28901126, 28905457, 28907196, 28912691, 28915561

     28917080, 28918429, 28919145, 28922227, 28922532, 28922608, 28925634

     28925880, 28933158, 28936114, 28937717, 28938698, 28940179, 28940281

     28941901, 28942455, 28945421, 28945994, 28951533, 28952168, 28954762

     28955606, 28957292, 28957723, 28962775, 28965231, 28966444, 28974083

     28977322, 28983095, 28983486, 28986326, 28986481, 28988482, 28989306

     28993295, 28994307, 28996376, 29000000, 29001888, 29002927, 29003738

     29006318, 29006621, 29007321, 29007775, 29008035, 29011936, 29013475

     29014076, 29015118, 29017265, 29018655, 29019121, 29021063, 29021352

     29024552, 29026582, 29026606, 29027456, 29027694, 29027940, 29031575

     29031600, 29032234, 29032457, 29032607, 29033052, 29033145, 29033200

     29033280, 29034587, 29037290, 29038528, 29039089, 29039510, 29043554

     29043651, 29043725, 29044763, 29044954, 29047850, 29048289, 29048498

     29048605, 29050560, 29050765, 29051702, 29052726, 29053783, 29056024

     29056270, 29056560, 29059011, 29061959, 29062692, 29062848, 29062860

     29062868, 29110526, 29110783, 29110790, 29110797, 29110802, 29110805

     29111598, 29113282, 29113305, 29117526, 29117642, 29119077, 29120223

     29122224, 29122254, 29123297, 29123432, 29123482, 29124368, 29125380

     29126345, 29127957, 29128935, 29129450, 29129497, 29129712, 29130219

     29131539, 29132938, 29134447, 29136111, 29138641, 29141316, 29141341

     29141685, 29142667, 29144995, 29145214, 29145730, 29149829, 29150338

     29151520, 29152357, 29155099, 29157389, 29158680, 29158899, 29159909

     29159936, 29160174, 29162095, 29163415, 29163437, 29163524, 29163567

     29167111, 29167342, 29167374, 29167940, 29168219, 29168433, 29169073

     29169215, 29171942, 29172618, 29172826, 29173140, 29173373, 29173817

     29174004, 29176318, 29177466, 29177543, 29177886, 29178385, 29180313

     29180455, 29180559, 29180893, 29181153, 29181231, 29181620, 29181743

     29181923, 29182019, 29183912, 29184297, 29184666, 29185193, 29186456

     29189302, 29189307, 29189889, 29190235, 29190474, 29190740, 29191541

     29192419, 29192468, 29192685, 29193207, 29194205, 29194367, 29194493

     29194827, 29195279, 29195337, 29195758, 29196725, 29199635, 29199733

     29200316, 29200700, 29201494, 29201539, 29202104, 29202850, 29203122

     29203166, 29203425, 29203443, 29203604, 29205281, 29205323, 29205419

     29205463, 29205767, 29205918, 29206109, 29206605, 29207073, 29208260

     29208732, 29211457, 29211724, 29212012, 29212433, 29212611, 29213351

     29213775, 29213850, 29213879, 29214561, 29214960, 29216746, 29216984

     29217294, 29217472, 29217828, 29217848, 29218570, 29219205, 29219273

     29220079, 29221248, 29221891, 29222031, 29222784, 29223833, 29223859

     29223967, 29224065, 29224605, 29225076, 29227602, 29228869, 29229164

     29229754, 29229844, 29229955, 29230252, 29230565, 29231133, 29232117

     29232154, 29234123, 29237538, 29240307, 29241345, 29242017, 29242884

     29243958, 29245137, 29245160, 29246163, 29247415, 29247712, 29247906

     29248552, 29248835, 29248858, 29249991, 29250059, 29251259, 29253184

     29253871, 29254031, 29254930, 29255178, 29255273, 29255431, 29255435

     29256426, 29259119, 29259320, 29261906, 29262512, 29262887, 29265448

     29266248, 29266899, 29267292, 29268412, 29269171, 29270585, 29273539

     29273735, 29273847, 29274428, 29274564, 29274627, 29275461, 29278218

     29279658, 29279751, 29279854, 29282898, 29285503, 29285788, 29285956

     29286037, 29287130, 29287705, 29292837, 29293072, 29297863, 29297915

     29298220, 29299049, 29299082, 29299844, 29301566, 29302963, 29303918

     29304781, 29311588, 29312310, 29312734, 29312753, 29313347, 29313417

     29313525, 29314539, 29318410, 29319441, 29321489, 29323946, 29324568

     29325087, 29325105, 29325257, 29325993, 29327044, 29329087, 29331209

     29331380, 29331493, 29332771, 29333500, 29337310, 29338315, 29338453

     29338780, 29338913, 29339155, 29341209, 29343086, 29346943, 29347620

     29348176, 29350052, 29351386, 29351716, 29351749, 29352867, 29353271

     29355654, 29356547, 29356752, 29358828, 29360672, 29361801, 29363151

     29364171, 29364177, 29367019, 29367561, 29368253, 29373418, 29373588

     29374179, 29377986, 29378029, 29379978, 29382784, 29385652, 29386502

     29386635, 29386660, 29387274, 29388094, 29388524, 29388830, 29389889

     29390435, 29394140, 29394749, 29397954, 29398863, 29399100, 29399121

     29405012, 29405651, 29412066, 29412269, 29417884, 29423826, 29429264

     29429566, 29431485, 29435652, 29438736, 29439522, 29450421, 29451386

     29452576, 29452953, 29457807, 29460252, 29462957, 29486181, 29507616

     29521748, 29530812, 29531654, 29557336, 29558975, 29601461

——————————————————————————–

OPatch succeeded.

cd /oracle/patch/30125133/

/oracle/Oracle_Software/19cDB/OPatch/opatch query -is_rolling_patch

Oracle Interim Patch Installer version 12.2.0.1.17

Copyright (c) 2020, Oracle Corporation.  All rights reserved.

Oracle Home       : /oracle/Oracle_Software/19cDB

Central Inventory : /oracle/u01/app/oraInventory

   from           : /oracle/Oracle_Software/19cDB/oraInst.loc

OPatch version    : 12.2.0.1.17

OUI version       : 12.2.0.7.0

Log file location : /oracle/Oracle_Software/19cDB/cfgtoollogs/opatch/opatch2020-07-31_12-21-23PM_1.log

——————————————————————————–

 Patch is a rolling patch: true

 Patch is a FMW rolling patch: false

OPatch succeeded.

/oracle/Oracle_Software/19cDB/OPatch/opatch apply

Oracle Interim Patch Installer version 12.2.0.1.17

Copyright (c) 2020, Oracle Corporation.  All rights reserved.

Oracle Home       : /oracle/Oracle_Software/19cDB

Central Inventory : /oracle/u01/app/oraInventory

   from           : /oracle/Oracle_Software/19cDB/oraInst.loc

OPatch version    : 12.2.0.1.17

OUI version       : 12.2.0.7.0

Log file location : /oracle/Oracle_Software/19cDB/cfgtoollogs/opatch/opatch2020-07-31_12-22-07PM_1.log

Verifying environment and performing prerequisite checks…

OPatch continues with these patches:   30125133 

Do you want to proceed? [y|n]

y

User Responded with: Y

All checks passed.

Please shutdown Oracle instances running out of this ORACLE_HOME on the local system.

(Oracle Home = ‘/oracle/Oracle_Software/19cDB’)

Is the local system ready for patching? [y|n]

y

User Responded with: Y

Backing up files…

Applying interim patch ‘30125133’ to OH ‘/oracle/Oracle_Software/19cDB’

ApplySession: Optional component(s) [ oracle.network.gsm, 19.0.0.0.0 ] , [ oracle.rdbms.ic, 19.0.0.0.0 ] , [ oracle.network.cman, 19.0.0.0.0 ] , [ oracle.net.cman, 19.0.0.0.0 ] , [ oracle.options.olap.awm, 19.0.0.0.0 ] , [ oracle.oraolap.mgmt, 19.0.0.0.0 ] , [ oracle.assistants.usm, 19.0.0.0.0 ] , [ oracle.assistants.asm, 19.0.0.0.0 ] , [ oracle.tfa, 19.0.0.0.0 ]  not present in the Oracle Home or a higher version is found.

Patching component oracle.rdbms, 19.0.0.0.0…

Patching component oracle.rdbms.rsf, 19.0.0.0.0…

Patching component oracle.assistants.acf, 19.0.0.0.0…

Patching component oracle.assistants.deconfig, 19.0.0.0.0…

Patching component oracle.assistants.server, 19.0.0.0.0…

Patching component oracle.buildtools.rsf, 19.0.0.0.0…

Patching component oracle.ctx, 19.0.0.0.0…

Patching component oracle.ldap.rsf, 19.0.0.0.0…

Patching component oracle.network.rsf, 19.0.0.0.0…

Patching component oracle.rdbms.dbscripts, 19.0.0.0.0…

Patching component oracle.sdo, 19.0.0.0.0…

Patching component oracle.sqlplus, 19.0.0.0.0…

Patching component oracle.ldap.rsf.ic, 19.0.0.0.0…

Patching component oracle.rdbms.rman, 19.0.0.0.0…

Patching component oracle.ctx.atg, 19.0.0.0.0…

Patching component oracle.rdbms.oci, 19.0.0.0.0…

Patching component oracle.rdbms.util, 19.0.0.0.0…

Patching component oracle.xdk, 19.0.0.0.0…

Patching component oracle.ovm, 19.0.0.0.0…

Patching component oracle.network.listener, 19.0.0.0.0…

Patching component oracle.rdbms.install.plugins, 19.0.0.0.0…

Patching component oracle.dbjava.jdbc, 19.0.0.0.0…

Patching component oracle.dbdev, 19.0.0.0.0…

Patching component oracle.rdbms.deconfig, 19.0.0.0.0…

Patching component oracle.nlsrtl.rsf, 19.0.0.0.0…

Patching component oracle.oraolap.dbscripts, 19.0.0.0.0…

Patching component oracle.install.deinstalltool, 19.0.0.0.0…

Patching component oracle.dbjava.ic, 19.0.0.0.0…

Patching component oracle.sdo.locator, 19.0.0.0.0…

Patching component oracle.rdbms.scheduler, 19.0.0.0.0…

Patching component oracle.rdbms.dv, 19.0.0.0.0…

Patching component oracle.ons, 19.0.0.0.0…

Patching component oracle.ldap.security.osdt, 19.0.0.0.0…

Patching component oracle.ctx.rsf, 19.0.0.0.0…

Patching component oracle.duma, 19.0.0.0.0…

Patching component oracle.ldap.owm, 19.0.0.0.0…

Patching component oracle.oracore.rsf, 19.0.0.0.0…

Patching component oracle.rdbms.install.seeddb, 19.0.0.0.0…

Patching component oracle.odbc, 19.0.0.0.0…

Patching component oracle.sdo.locator.jrf, 19.0.0.0.0…

Patching component oracle.network.client, 19.0.0.0.0…

Patching component oracle.sqlplus.ic, 19.0.0.0.0…

Patching component oracle.dbjava.ucp, 19.0.0.0.0…

Patching component oracle.xdk.rsf, 19.0.0.0.0…

Patching component oracle.marvel, 19.0.0.0.0…

Patching component oracle.xdk.parser.java, 19.0.0.0.0…

Patching component oracle.rdbms.rsf.ic, 19.0.0.0.0…

Patching component oracle.nlsrtl.rsf.core, 19.0.0.0.0…

Patching component oracle.precomp.common, 19.0.0.0.0…

Patching component oracle.precomp.lang, 19.0.0.0.0…

Patch 30125133 successfully applied.

Sub-set patch [29517242] has become inactive due to the application of a super-set patch [30125133].

Please refer to Doc ID 2161861.1 for any possible further required actions.

Log file location: /oracle/Oracle_Software/19cDB/cfgtoollogs/opatch/opatch2020-07-31_12-22-07PM_1.log

OPatch succeeded.

srvctl start instance -db POCDB -node aus-lndbasmt-001

srvctl status database -db pocdb

Instance POCDB1 is not running on node aus-lndbasmt-001

Instance POCDB2 is not running on node aus-lndbasmt-002

[oracle@AUS-LNDBASMT-001 30125133]$ sqlplus “/ as sysdba”

SQL*Plus: Release 19.0.0.0.0 – Production on Fri Jul 31 12:30:38 2020

Version 19.5.0.0.0

Copyright (c) 1982, 2019, Oracle.  All rights reserved.

Connected to:

Oracle Database 19c Enterprise Edition Release 19.0.0.0.0 – Production

Version 19.5.0.0.0

SQL> select * from v$version;

BANNER

——————————————————————————–

BANNER_FULL

—————————————————————————————————————————————————————-

BANNER_LEGACY                                                                                                                                      CON_ID

——————————————————————————– ———-

Oracle Database 19c Enterprise Edition Release 19.0.0.0.0 – Production

Oracle Database 19c Enterprise Edition Release 19.0.0.0.0 – Production

Version 19.5.0.0.0

Oracle Database 19c Enterprise Edition Release 19.0.0.0.0 – Production                                  0

SQL> exit

Disconnected from Oracle Database 19c Enterprise Edition Release 19.0.0.0.0 – Production

Version 19.5.0.0.0

After perform the above steps in both nodes, if any invalid objects found then should have utlrp.sql run to revalidate those objects.

cd $ORACLE_HOME/rdbms/admin
sqlplus /nolog
SQL> CONNECT / AS SYSDBA
SQL> @utlrp.sql

Download Software

Oracle Database 19c Release 3 Linux x86-64 Software Download Link –

https://www.oracle.com/database/technologies/oracle-database-software-downloads.html 

This is step by step guide to install Oracle 19C RAC with ASM & version Upgrade. Hope this document will help you to build a two node RAC and upgrade it further.

Leave a Comment

Your email address will not be published. Required fields are marked *