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
Index
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 oinstallgroupadd -g 54322 dbagroupadd -g 54323 oper groupadd -g 54324 backupdbagroupadd -g 54325 dgdbagroupadd -g 54326 kmdbagroupadd -g 54327 asmdbagroupadd -g 54328 asmopergroupadd -g 54329 asmadmingroupadd -g 54330 racdba useraddoracleusermod -g oinstall oracleusermod -G dba asmoper,asmadmin.asmdba,oper,oracle
Install below RPM Packages
yum install -y bc yum install -y binutils#yum install -y compat-libcap1yum 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-utilsyum install -y elfutils-libelfyum install -y elfutils-libelf-develyum install -y fontconfig-develyum install -y glibcyum install -y glibc-develyum install -y kshyum install -y libaioyum install -y libaio-devel#yum install -y libdtrace-ctf-develyum install -y libXrenderyum install -y libXrender-develyum install -y libX11yum install -y libXauyum install -y libXiyum install -y libXtstyum install -y libgccyum install -y librdmacm-develyum install -y libstdc++yum install -y libstdc++-develyum install -y libxcbyum install -y makeyum install -y net-tools # Clusterwareyum install -y nfs-utils # ACFSyum install -y python # ACFSyum install -y python-configshell # ACFSyum install -y python-rtslib # ACFSyum install -y python-six # ACFSyum install -y targetcli # ACFSyum install -y smartmontoolsyum install -y sysstatyum install -y unixODBC # New for OL8yum install -y libnslyum install -y libnsl.i686yum install -y libnsl2yum install -y libnsl2.i686Network 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 startDisk Creation in ASM
fdisk /dev/sdf
Welcome to fdisk (util-linux 2.23.2).
Changes 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.
Select the “Configure an Oracle Standalone Cluster” option by clicking the “Next” button.
Enter the cluster name, SCAN name and SCAN port, then click the “Next” button.
NOTE – Cluster name should be within 15 characters long, otherwise installation will fail.
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.
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.
Select the “Use Oracle Flex ASM for storage” option by clicking the “Next” button.
Select “Yes” and click Next
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.
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
In case you need GIMR to be created. Please remember this is not mandatory.
Enter the credentials and click the “Next” button.
Accept the default IPMI option by clicking the “Next” button.
Don’t register with EM. Click the “Next” button.
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.
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.
Accept the default inventory directory by clicking the “Next” button.
If you want the root scripts to run automatically, enter the relevant credentials. Click the “Next” button.
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.
Now the GRID installation is complete.
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.
Select the Oracle Real Application Clusters database installation option by clicking the Next button.
Make sure both nodes are selected, then click the Next button.
Select the Enterprise Edition option, then click the Next button.
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.
Automatically run configuration script – leave it blank.
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”
Choose Advanced configuration and click “Next”
Choose General Purpose or Transaction Processing and click on “Next”
Make sure both node selected
Provide the database name, SID and click on “Next”
Select the database file location and click on “Next”
Select the FRA location, size and click on “Next”
Allocate the proper memory and other necessary details and click on “Next”
Select below and click on “Next”
Provide same password for all user and click on “Next”
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.
You didn’t even mention to configure network, DNS, NTP and shared storages. Do I miss anything?
Hi Jack,
The DNS, NTP and storage sharing generally done by some other teams in Real Life / Production scenarios. I have focused on the things as a DBA you need to perform.