#######################################################################################################################
installation of Grid Infrastructure 19.32 on Oracle Linux 9.8 with
- ASM Disk Creation (DATA, RECO)
- EREG Database installation
- importing Backup
OS/Linux team pre-req for 19c 19.32PSU grid installation on OL9.8
-- OS 7,8,9
-- internet access for yum
-- Storage disk for ASM
-- Swap memory min 30GB
-- /u01 mount point size
-- /u02/ and /ext-backup mount points
-- 2 network adapter (ifcofig)
-- ip address allocations
-- dns entries
-- root access
--- Dedicated DISKS for OCR (min 3 if redundency level is normal)
sdi 8:128 0 100G 0 disk
└─sdi1 8:129 0 100G 0 part
sdj 8:144 0 100G 0 disk
└─sdj1 8:145 0 100G 0 part
sdn 8:208 0 100G 0 disk
└─sdn1 8:209 0 100G 0 part
https://my-orcl.blogspot.com/2017/03/installation-guide-for-rac-11201-on.html
===============================================================
#####--- Server Configuration (User/Directories)
#####--- for both nodes
===============================================================
[root@EREGDB01 ~]# hostnamectl
Static hostname: EREGDB01.areef.com
Operating System: Oracle Linux Server 9.8
CPE OS Name: cpe:/o:oracle:linux:9:8:server
Kernel: Linux 6.12.0-204.92.4.4.3.el9uek.x86_64
Architecture: x86-64
[root@EREGDB01 ~]#
userdel grid
groupdel dba
groupdel asmdba
groupdel asmadmin
groupdel asmoper
groupadd -g 1007 dba
groupadd -g 1008 asmdba
groupadd -g 1009 asmadmin
groupadd -g 1010 asmoper
useradd -u 1101 -g oinstall -G dba,asmdba,asmadmin,asmoper grid
passwd oracle
mkdir -p /u01/app/grid
mkdir -p /u01/app/19.0.0/grid
mkdir -p /u01/app/oracle/product/19.0.0/dbhome_1
chown -R oracle:oinstall /u01/app/oracle
#####--- Central Inventory Configuration
#####--- for both nodes
===============================================================
[root@EREGDB01 ~]#
[root@EREGDB01 ~]#
[root@EREGDB01 ~]# chmod -R 777 /u01/app/oraInventory
[root@EREGDB01 ~]# vi /etc/oraInst.loc
i#Central Inventory Location
inventory_loc=/u01/app/oraInventory
inst_group=oinstall
#####--- services to disable
#####--- for both nodes
===============================================================
systemctl status firewalld
systemctl stop firewalld
systemctl disable firewalld
systemctl status firewalld
firewall-cmd --state
systemctl stop avahi-daemon
systemctl disable avahi-daemon
systemctl stop avahi-daemon
systemctl stop chronyd
ls -ltrh /etc/chrony.conf
mv /etc/chrony.conf /etc/chrony.conf.bkp
grep SELINUX /etc/selinux/config
SELINUX=disabled
#####--- RPMS installations
#####--- for both nodes
===============================================================
[root@EREGDB01 ~]# yum search tigervnc-server
Last metadata expiration check: 0:36:48 ago on Thu 26 Mar 2026 11:59:19 AM +03.
=============================================================== Name Exactly Matched: tigervnc-server ===============================================================
tigervnc-server.x86_64 : A TigerVNC server
=================================================================== Name Matched: tigervnc-server ===================================================================
tigervnc-server-minimal.x86_64 : A minimal installation of TigerVNC server
tigervnc-server-module.x86_64 : TigerVNC module to Xorg
[root@EREGDB01 ~]# yum install tigervnc-server.x86_64
Last metadata expiration check: 0:32:52 ago on الأربعاء 12 أغسطس 2026 9:12:07.
============================================================= Name Matched: oracle-database-preinstall ==============================================================
oracle-database-preinstall-19c.src : Oracle Database Preinstallation RPM
oracle-database-preinstall-19c.x86_64 : Oracle Database Preinstallation RPM
oracle-database-preinstall-23ai.src : Oracle Database Preinstallation RPM
oracle-database-preinstall-23ai.x86_64 : Oracle Database Preinstallation RPM
[root@EREGDB01 dbhome_1]# yum install oracle-database-preinstall-19c.x86_64
Last metadata expiration check: 0:33:16 ago
on الأربعاء 12 أغسطس 2026 9:12:07.
Dependencies resolved.
=====================================================================================================================================================================
Total download size: 11 M
Installed size: 31 M
Is this ok [y/N]: y
Downloading Packages:
=====================================================================================================================================================================
Total download size: 11 M
Installed size: 31 M
Is this ok [y/N]: y
Downloading Packages:
Complete!
[root@EREGDB01 ~]# cat /etc/security/limits.d/oracle-database-preinstall-19c.conf
# oracle-database-preinstall-19c setting for
nofile soft limit is 1024
oracle soft nofile 1024
[root@EREGDB01 ~]# grep kernel.sem /etc/sysctl.conf
# oracle-database-preinstall-19c setting for kernel.sem is '250 32000 100 128'
kernel.sem = 250 32000 100 128
[root@EREGDB01 ~]# yum search oracleasm-support
Last metadata expiration check: 0:34:05 ago on الأربعاء 12 أغسطس 2026 9:12:07.
No matches found.
[root@EREGDB01 ~]# grep -iA 4 addons /etc/yum.repos.d/*
/etc/yum.repos.d/oracle-linux-ol9.repo:[ol9_addons]
/etc/yum.repos.d/oracle-linux-ol9.repo:name=Oracle Linux 9 Addons ($basearch)
/etc/yum.repos.d/oracle-linux-ol9.repo:baseurl=https://yum$ociregion.$ocidomain/repo/OracleLinux/OL9/addons/$basearch/
/etc/yum.repos.d/oracle-linux-ol9.repo-gpgkey=file:///etc/pki/rpm-gpg/RPM-GPG-KEY-oracle
/etc/yum.repos.d/oracle-linux-ol9.repo-gpgcheck=1
/etc/yum.repos.d/oracle-linux-ol9.repo-enabled=0
/etc/yum.repos.d/oracle-linux-ol9.repo-
[root@EREGDB01 ~]# vi /etc/yum.repos.d/oracle-linux-ol9.repo
Oracle Linux 9 Addons (x86_64) 1.1 MB/s | 936 kB 00:00
Last metadata expiration check: 0:00:01 ago on الأربعاء 12 أغسطس 2026 9:47:41.
============================================================== Name Exactly Matched: oracleasm-support ==============================================================
oracleasm-support.src : The Oracle Automatic Storage Management support programs.
oracleasm-support.x86_64 : The Oracle Automatic Storage Management support programs.
[root@EREGDB01 dbhome_1]# yum install oracleasm-support.x86_64
Oracle Linux 9 BaseOS Latest
Total download size: 131 k
Installed size: 319 k
Is this ok [y/N]: y
Downloading Packages:
oracleasm-support-3.1.1-5.el9.x86_64
Complete!
==============================================================
https://www.oracle.com/linux/downloads/linux-asmlib-v9-downloads.html
==============================================================
[root@EREGDB01 ~]# ls -lthr /u02/19cSW/oracleasm*el9*
-rw-r--r--. 1 root root 53K مارس 26 12:04 /u02/19cSW/oracleasmlib-3.1.1-1.el9.x86_64.rpm
[root@EREGDB01 ~]# rpm -ivh /u02/19cSW/oracleasmlib-3.1.1-1.el9.x86_64.rpm
Verifying... ################################# [100%]
يجري التّحضير... ################################# [100%]
1:oracleasmlib-3.1.1-1.el9 ################################# [100%]
[root@EREGDB01 ~]#
[root@EREGDB01 ~]# rpm -ivh /u02/19cSW/cvuqdisk-1.0.10-1.rpm
[root@EREGDB02 ~]# rpm -ivh /u02/19cSW/cvuqdisk-1.0.10-1.rpm
[root@EREGDB01 ~]# rpm -qa | grep -e oracleasm -e cvuqdisk -e preinstall
oracle-database-preinstall-19c-1.0-3.el9.x86_64
oracleasm-support-3.1.1-5.el9.x86_64
oracleasmlib-3.1.1-1.el9.x86_64
cvuqdisk-1.0.10-1.x86_64
===============================================================
#####--- Configure ORACLE ASM
#####--- for both nodes
===============================================================
[root@EREGDB01 ~]# oracleasm status
oracleasm.service not started
Please run 'systemctl start oracleasm.service' to start oracleasm
[root@EREGDB01 ~]# oracleasm configure -i
Configuring the Oracle ASM system service.
This will configure the on-boot properties of
the Oracle ASM system
service. The following questions will determine whether the service
is started 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 ASM disk devices []: grid
Default group to own the ASM disk devices []: asmadmin
Start Oracle ASM system service on boot (y/n) [y]: y
Scan for Oracle ASM disks when starting the oracleasm service (y/n) [y]: y
Maximum number of ASM disks that can be used on system [2048]:
Enable iofilter if kernel supports it (y/n) [y]:
Writing Oracle ASM system service configuration: done
Configuration changes only come into effect
after the Oracle ASM
system service is restarted. Please run 'systemctl restart oracleasm'
after making changes.
WARNING: All of your Oracle and ASM instances
must be stopped prior
to restarting the oracleasm service.
[root@EREGDB01 ~]# systemctl start oracleasm.service
[root@EREGDB01 ~]# oracleasm status
Checking if the oracleasm kernel module is loaded: no (not required with UEK8)
Checking if /dev/oracleasm is mounted: no (not required with UEK8)
Checking which I/O Interface is in use: io_uring (KABI_V3)
Checking if ASMLIB can be loaded: yes
Checking if io_uring is enabled: yes
Checking if io_uring is accessible to the configured DB user: yes
Checking if io_uring supports integrity passthrough: yes
Checking if ASM disks have the correct ownership and permissions: yes
Checking if ASM I/O filter is set up: yes
[root@EREGDB01 ~]#
===============================================================
#####--- cvuqdisk rpm installation
#####--- for both nodes
===============================================================
[root@EREGDB01 ~]# rpm -qa | grep -e oracleasm -e cvuqdisk -e preinstall
[grid@EREGDB01 ~]$ time unzip -q /u02/19cSW/LINUX.X64_193000_grid_home.zip -d /u01/app/19.0.0/grid/
[root@EREGDB01 ~]# ls -ltrh /u01/app/19.0.0/grid/cv/rpm/cvuqdisk-1.0.10-1.rpm
-rw-r--r--. 1 grid oinstall 12K مارس 13 2019 /u01/app/19.0.0/grid/cv/rpm/cvuqdisk-1.0.10-1.rpm
[root@EREGDB01 ~]#
[root@EREGDB01 rpm]# rpm -ivh /u02/19cSW/cvuqdisk-1.0.10-1.rpm
يجري التّحضير... ################################# [100%]
1:cvuqdisk-1.0.10-1 ################################# [100%]
[root@EREGDB01 rpm]# rpm -qa | grep -e oracleasm -e cvuqdisk -e preinstall
oracle-database-preinstall-19c-1.0-3.el9.x86_64
oracleasm-support-3.1.1-5.el9.x86_64
oracleasmlib-3.1.1-1.el9.x86_64
cvuqdisk-1.0.10-1.x86_64
[root@EREGDB01 rpm]#
[root@EREGDB02 ~]# rpm -ivh /u02/19cSW/cvuqdisk-1.0.10-1.rpm
يجري التّحضير... ################################# [100%]
1:cvuqdisk-1.0.10-1 ################################# [100%]
[root@EREGDB02 ~]#
[root@EREGDB02 ~]#
[root@EREGDB02 ~]# rpm -qa | grep -e oracleasm -e cvuqdisk -e preinstall
oracle-database-preinstall-19c-1.0-3.el9.x86_64
oracleasm-support-3.1.1-5.el9.x86_64
oracleasmlib-3.1.1-1.el9.x86_64
cvuqdisk-1.0.10-1.x86_64
[root@EREGDB02 ~]#
===============================================================
#####--- ASM Disk creation with gpt format
For both methods on OL9
https://my-orcl.blogspot.com/2021/09/installation-guide-for-rac-12102-on.html
===============================================================
[root@EREGDB01 ~]# lsblk /dev/sdg
NAME MAJ:MIN RM SIZE RO TYPE MOUNTPOINTS
sdg 8:96 0 100G 0 disk
[root@EREGDB01 ~]#
[root@EREGDB01 ~]# parted -s -a optimal /dev/sdg mklabel gpt
[root@EREGDB01 ~]# fdisk -l /dev/sdg
Disk /dev/sdg: 100 GiB, 107374182400 bytes, 209715200 sectors
Disk model: Virtual disk
Units: sectors of 1 * 512 = 512 bytes
Sector size (logical/physical): 512 bytes / 512 bytes
I/O size (minimum/optimal): 512 bytes / 512 bytes
Disklabel type: gpt
Disk identifier: F0FDA5AB-2BBB-4E2E-91B5-AA1FCC06C5E0
[root@EREGDB01 ~]#
[root@EREGDB01 ~]# parted -s -a optimal /dev/sdX mkpart primary 1MiB 100%
[root@EREGDB01 ~]# lsblk /dev/sdg
NAME MAJ:MIN RM SIZE RO TYPE MOUNTPOINTS
sdg 8:96 0 100G 0 disk
└─sdg1 8:97 0 100G 0 part
[root@EREGDB01 ~]# partprobe /dev/sdg
[root@EREGDB01 ~]#
[root@EREGDB01 ~]# fdisk –l /dev/sdc
Disk model: Virtual disk
Units: sectors of 1 * 512 = 512 bytes
Sector size (logical/physical): 512 bytes / 512 bytes
I/O size (minimum/optimal): 512 bytes / 512 bytes
Disklabel type: gpt
Disk identifier: F0FDA5AB-2BBB-4E2E-91B5-AA1FCC06C5E0
Device
Start End Sectors
Size Type
/dev/sdg1 2048 209713151 209711104 100G Linux filesystem
[root@EREGDB01 ~]#
oracleasm createdisk OCR001 /dev/sdg1
oracleasm createdisk DATA001 /dev/sdh1
oracleasm createdisk RECO001 /dev/sdi1
oracleasm listdisks
find /dev -iname ocr*
####--- no issue if partion got different
point (Partuuid should match with each other)
[grid@EREGDB01 patches]$ blkid | grep asm
/dev/sdg1: LABEL="OCR001" TYPE="oracleasm"
[grid@EREGDB01 patches]$ lsblk -o NAME,SIZE,TYPE,FSTYPE,PARTUUID /dev/sdg
NAME SIZE TYPE FSTYPE PARTUUID
sdg 100G disk
└─sdg1 100G part oracleasm 1ab32289-04bb-472d-ae26-9f8d54ace7a1
[grid@EREGDB01 patches]$
[root@EREGDB02 ~]# blkid | grep asm
/dev/sdf1: LABEL="OCR001" TYPE="oracleasm" PARTLABEL="primary" PARTUUID="1ab32289-04bb-472d-ae26-9f8d54ace7a1"
[root@EREGDB02 ~]#
if partition does not reflect on node 2 then
###--- node 2 sdc1 partion detect
[root@EREGDB02 ~]# blkid /dev/sdc1
[root@EREGDB02 ~]# partprobe /dev/sdc
[root@EREGDB02 ~]# blkid /dev/sdc1
/dev/sdc1: LABEL="OCR001" TYPE="oracleasm" PARTUUID="83543d9a-42b9-a149-82a1-5f8bf6480153"
[root@EREGDB01 ~]# lsblk /dev/sdc
NAME MAJ:MIN RM SIZE RO TYPE MOUNTPOINTS
sdg 8:96 0 100G 0 disk
└─sdg1 8:97 0 100G 0 part
[root@EREGDB02 ~]#
[root@EREGDB02 ~]# oracleasm scandisks
[root@EREGDB02 ~]# oracleasm listdisks
OCR001
[root@EREGDB02 ~]#
[grid@EREGDB01 patches]$ ls -ltrh /dev/disk/by-label/*
lrwxrwxrwx 1 root root 10 Aug 13 13:21 /dev/disk/by-label/OCR001 -> ../../sdg1
[grid@EREGDB01 patches]$
###--- check from both the nodes partuuid
should be same
# blkid /dev/sdc1
# blkid | grep asm
# lsblk -o NAME,SIZE,TYPE,FSTYPE,PARTUUID /dev/sdc
$ORACLE_HOME/bin/kfed read /dev/sdc1 | grep -E "kfbh.type|dskname|grpname"
$ORACLE_HOME/bin/kfod op=DISKS label=TRUE disks=ALL name=TRUE status=true
===============================================================
#####--- untar 19c binaries
===============================================================
su - grid
[grid@EREGDB01 ~]$ vi grid.env
[grid@EREGDB01 ~]$ cat grid.env
export TMP=/tmp
export TMPDIR=$TMP
export ORACLE_HOME=/u01/app/19.0.0/grid
export ORACLE_BASE=/u01/app/grid
export PATH=$ORACLE_HOME/bin:$PATH
export ORACLE_SID=+ASM1
export ORACLE_TERM=xterm
export BASE_PATH=/usr/sbin:$PATH
export LD_LIBRARY_PATH=$ORACLE_HOME/lib:/lib:/usr/lib
export CLASSPATH=$ORACLE_HOME/JRE:$ORACLE_HOME/jlib:$ORACLE_HOME/rdbms/jlib
#asmcmd lsdg
[grid@EREGDB01 ~]$
[grid@EREGDB01 ~]$ . grid.env
[grid@EREGDB01 ~]$ time unzip -q /u02/19cSW/LINUX.X64_193000_grid_home.zip -d
/u01/app/19.0.0/grid/
[grid@EREGDB01 ~]$ mv /u01/app/19.0.0/grid/OPatch /u01/app/19.0.0/grid/OPatch_19.3
[grid@EREGDB01 ~]$ unzip -q '/u02/19cSW/p6880880_190000_Linux-x86-64 (3).zip' -d /u01/app/19.0.0/grid/
OPatch Version: 12.2.0.1.52
OPatch succeeded.
[grid@EREGDB01 ~]$
[grid@EREGDB01 patches]$ unzip -q /u02/19cSW/19cGI_32PSU_with_OJVM/p39618711_190000_Linux-x86-64.zip -d /u01/patches/
===============================================================
#####--- rda checks
===============================================================
[root@EREGDB01 ~]# rpm -qa | grep -e oracleasm -e cvuqdisk -e preinstall
[root@EREGDB01 ~]# nslookup scan-nereg
Server: 10.98.192.1
Address: 10.98.192.1#53
Name:
scan-ereg.areef.com
Address: 10.98.132.167
Name: scan-ereg.areef.com
Address: 10.98.132.169
Name: scan-ereg.areef.com
Address: 10.98.132.168
[root@rac1 ~]$ unzip –q /u02/applmgr/p21769913_204201020_Linux-x86-64.zip
[root@EREGDB01 ~]# cd /u02/applmgr/rda
[root@EREGDB01 rda]# ./rda.sh -T hcve
Processing HCVE tests ...
Available Pre-Installation Rule Sets:
8. Oracle Database 19c Preinstallation (Linux)
Enter the HCVE rule set number or 0 to cancel
the test
Press Return to accept the default (0)
> 8
Performing HCVE checks ...
Enter value for < Planned ORACLE_HOME location >
> /u01/app/19.0.0/grid
Test "Oracle Database 19c
Preinstallation (Linux)" executed at 13-Aug-2026 12:45:23
Test Results
~~~~~~~~~~~~
(Note : Current Health Check rulesets do not have logic to support checks against Oracle Cloud or Exadata environments. If your product is installed in such an environment some test results will be erroneous. Refer instead to the product documentation rather than rely on the data below.)
ID
NAME RESULT VALUE
====== ==================== ======= ==========================================
A00100 OS Certified? FAILED Release check failed
A01020 User in /etc/passwd? PASSED userOK
A01040 Group in /etc/group? PASSED GroupOK
A01050 Enter ORACLE_HOME RECORD /u01/app/19.0.0/grid
A01060 ORACLE_HOME Valid? PASSED OHexists
A01070 O_H Permissions OK? PASSED CorrectPerms
A01410 oraInventory Permiss PASSED oraInventoryOK
A01420 Other OUI Up? PASSED NoOtherOUI
A01430 Got Software Tools? FAILED LdElsewhere
A01440 Other O_Hs in PATH? PASSED NoneFound
A02010 Umask Set to 022? PASSED UmaskOK
A02030 Limits Processes PASSED Adequate
A02040 Limits Stacksize FAILED SoftLow HardHigh
A02050 Limits Descriptors PASSED Adequate
A02100 LDLIBRARYPATH Unset? PASSED UnSet
A02170 JAVA_HOME Unset? PASSED UnSet
A03100 RAM (in MB) PASSED 31634
A02210 Kernel Parameters OK PASSED KernelOK
A02300 Tainted Kernel? PASSED NotVerifiable
A03010 Temp Adequate? PASSED TempSpaceOK
A03020 Disk Space OK? PASSED DiskSpaceOK
A03050 Swap (in MB) RECORD 36591
A03100 RAM (in MB) PASSED 31634
A03150 SwapToRam OK? PASSED SwapToRamOK
A03500 Network PASSED Connected
A03510 IP Address RECORD 10.98.132.76
A03530 Domain Name RECORD psau.edu.sa
A03540 /etc/hosts Format PASSED Adequate IPv4 entry
A03550 DNS Lookup PASSED Host correctly registered in DNS
A03600 ip_local_port_range PASSED RangeOK
A04306 OL8 Server RPMs OK? SKIPPED NotOL8
A04305 OL7 Server RPMs OK? SKIPPED NotOL7
A04315 RHEL7 Server RPMs OK SKIPPED NotRedHat
A04335 RHEL8 Server RPMs OK SKIPPED NotRedHat
A04321 SLES12 Server RPMs O SKIPPED NotSuSE
A04325 SLES15 Server RPMs O SKIPPED NotSuSE
Result file: output/collect/DB_HCVE_A_DB19c_lin_res.htm
[root@EREGDB01 rda]#
===============================================================
#####--- installation of GI 19.32 with OCR disk
===============================================================
[root@EREGDB01 ~]# reboot
[root@EREGDB02 ~]# reboot
[root@EREGDB01 grid]# lsblk -o NAME,SIZE,TYPE,FSTYPE,PARTUUID,WWN,SERIAL | grep oracleasm
└─sde1 100G part oracleasm 1ab32289-04bb-472d-ae26-9f8d54ace7a1
[root@EREGDB01 grid]# blkid | grep asm
/dev/sde1: LABEL="OCR001" TYPE="oracleasm" PARTLABEL="primary" PARTUUID="1ab32289-04bb-472d-ae26-9f8d54ace7a1"
[root@EREGDB01 grid]#
[root@EREGDB02 ~]# lsblk -o NAME,SIZE,TYPE,FSTYPE,PARTUUID,WWN,SERIAL | grep oracleasm
└─sdf1 100G part oracleasm 1ab32289-04bb-472d-ae26-9f8d54ace7a1
[root@EREGDB02 ~]#
[root@EREGDB02 ~]# blkid | grep asm
/dev/sdf1: LABEL="OCR001" TYPE="oracleasm" PARTLABEL="primary" PARTUUID="1ab32289-04bb-472d-ae26-9f8d54ace7a1"
[root@EREGDB02 ~]#
[root@EREGDB01 ~]# chown -R grid:oinstall /u01/app/19.0.0/grid
xhost+
export CV_ASSUME_DISTID=OEL7.8
su -grid
à mobaxterm with grid user
[grid@EREGDB01 ~]$ xhost +
access control disabled, clients can connect from any host
[grid@EREGDB01 ~]$ export CV_ASSUME_DISTID=OEL7.8
[grid@EREGDB01 ~]$ cd /u01/app/19.0.0/grid
[grid@EREGDB01 grid]$ ./gridSetup.sh -applyRU /u01/patches/39618711/39467003
Preparing the home to patch...
Applying the patch /u01/patches/39618711/39467003...
Successfully applied the patch.
The log can be found at: /u01/app/oraInventory/logs/GridSetupActions2026-08-13_01-48-42PM/installerPatchActions_2026-08-13_01-48-42PM.log
Launching Oracle Grid Infrastructure Setup Wizard...
[root@EREGDB01 ~]# cat /etc/security/limits.d/oracle-database-preinstall-19c.conf
oracle soft nofile 1024
[root@EREGDB01 ~]# grep kernel.sem /etc/sysctl.conf
# oracle-database-preinstall-19c setting for kernel.sem is '250 32000 100 128'
kernel.sem = 250 32000 100 128
[root@EREGDB01 ~]# yum search oracleasm-support
Last metadata expiration check: 0:34:05 ago on الأربعاء 12 أغسطس 2026 9:12:07.
No matches found.
[root@EREGDB01 ~]# grep -iA 4 addons /etc/yum.repos.d/*
/etc/yum.repos.d/oracle-linux-ol9.repo:[ol9_addons]
/etc/yum.repos.d/oracle-linux-ol9.repo:name=Oracle Linux 9 Addons ($basearch)
/etc/yum.repos.d/oracle-linux-ol9.repo:baseurl=https://yum$ociregion.$ocidomain/repo/OracleLinux/OL9/addons/$basearch/
/etc/yum.repos.d/oracle-linux-ol9.repo-gpgkey=file:///etc/pki/rpm-gpg/RPM-GPG-KEY-oracle
/etc/yum.repos.d/oracle-linux-ol9.repo-gpgcheck=1
/etc/yum.repos.d/oracle-linux-ol9.repo-enabled=0
/etc/yum.repos.d/oracle-linux-ol9.repo-
[root@EREGDB01 ~]# vi /etc/yum.repos.d/oracle-linux-ol9.repo
Oracle Linux 9 Addons (x86_64) 1.1 MB/s | 936 kB 00:00
Last metadata expiration check: 0:00:01 ago on الأربعاء 12 أغسطس 2026 9:47:41.
============================================================== Name Exactly Matched: oracleasm-support ==============================================================
oracleasm-support.src : The Oracle Automatic Storage Management support programs.
oracleasm-support.x86_64 : The Oracle Automatic Storage Management support programs.
[root@EREGDB01 dbhome_1]# yum install oracleasm-support.x86_64
Oracle Linux 9 BaseOS Latest
Installed size: 319 k
Is this ok [y/N]: y
Downloading Packages:
oracleasm-support-3.1.1-5.el9.x86_64
==============================================================
https://www.oracle.com/linux/downloads/linux-asmlib-v9-downloads.html
==============================================================
[root@EREGDB01 ~]# ls -lthr /u02/19cSW/oracleasm*el9*
-rw-r--r--. 1 root root 53K مارس 26 12:04 /u02/19cSW/oracleasmlib-3.1.1-1.el9.x86_64.rpm
[root@EREGDB01 ~]# rpm -ivh /u02/19cSW/oracleasmlib-3.1.1-1.el9.x86_64.rpm
Verifying... ################################# [100%]
يجري التّحضير... ################################# [100%]
1:oracleasmlib-3.1.1-1.el9 ################################# [100%]
[root@EREGDB01 ~]#
[root@EREGDB01 ~]# rpm -ivh /u02/19cSW/cvuqdisk-1.0.10-1.rpm
[root@EREGDB02 ~]# rpm -ivh /u02/19cSW/cvuqdisk-1.0.10-1.rpm
oracle-database-preinstall-19c-1.0-3.el9.x86_64
oracleasm-support-3.1.1-5.el9.x86_64
oracleasmlib-3.1.1-1.el9.x86_64
cvuqdisk-1.0.10-1.x86_64
#####--- Configure ORACLE ASM
#####--- for both nodes
===============================================================
oracleasm.service not started
Please run 'systemctl start oracleasm.service' to start oracleasm
[root@EREGDB01 ~]# oracleasm configure -i
Configuring the Oracle ASM system service.
service. The following questions will determine whether the service
is started 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 group to own the ASM disk devices []: asmadmin
Start Oracle ASM system service on boot (y/n) [y]: y
Scan for Oracle ASM disks when starting the oracleasm service (y/n) [y]: y
Maximum number of ASM disks that can be used on system [2048]:
Enable iofilter if kernel supports it (y/n) [y]:
Writing Oracle ASM system service configuration: done
system service is restarted. Please run 'systemctl restart oracleasm'
after making changes.
to restarting the oracleasm service.
[root@EREGDB01 ~]# oracleasm status
Checking if the oracleasm kernel module is loaded: no (not required with UEK8)
Checking if /dev/oracleasm is mounted: no (not required with UEK8)
Checking which I/O Interface is in use: io_uring (KABI_V3)
Checking if ASMLIB can be loaded: yes
Checking if io_uring is enabled: yes
Checking if io_uring is accessible to the configured DB user: yes
Checking if io_uring supports integrity passthrough: yes
Checking if ASM disks have the correct ownership and permissions: yes
Checking if ASM I/O filter is set up: yes
[root@EREGDB01 ~]#
#####--- cvuqdisk rpm installation
#####--- for both nodes
===============================================================
[root@EREGDB01 ~]# rpm -qa | grep -e oracleasm -e cvuqdisk -e preinstall
[grid@EREGDB01 ~]$ time unzip -q /u02/19cSW/LINUX.X64_193000_grid_home.zip -d /u01/app/19.0.0/grid/
[root@EREGDB01 ~]# ls -ltrh /u01/app/19.0.0/grid/cv/rpm/cvuqdisk-1.0.10-1.rpm
-rw-r--r--. 1 grid oinstall 12K مارس 13 2019 /u01/app/19.0.0/grid/cv/rpm/cvuqdisk-1.0.10-1.rpm
[root@EREGDB01 ~]#
[root@EREGDB01 rpm]# rpm -ivh /u02/19cSW/cvuqdisk-1.0.10-1.rpm
يجري التّحضير... ################################# [100%]
1:cvuqdisk-1.0.10-1 ################################# [100%]
[root@EREGDB01 rpm]# rpm -qa | grep -e oracleasm -e cvuqdisk -e preinstall
oracle-database-preinstall-19c-1.0-3.el9.x86_64
oracleasm-support-3.1.1-5.el9.x86_64
oracleasmlib-3.1.1-1.el9.x86_64
cvuqdisk-1.0.10-1.x86_64
[root@EREGDB01 rpm]#
[root@EREGDB02 ~]# rpm -ivh /u02/19cSW/cvuqdisk-1.0.10-1.rpm
يجري التّحضير... ################################# [100%]
1:cvuqdisk-1.0.10-1 ################################# [100%]
[root@EREGDB02 ~]#
[root@EREGDB02 ~]#
[root@EREGDB02 ~]# rpm -qa | grep -e oracleasm -e cvuqdisk -e preinstall
oracle-database-preinstall-19c-1.0-3.el9.x86_64
oracleasm-support-3.1.1-5.el9.x86_64
oracleasmlib-3.1.1-1.el9.x86_64
cvuqdisk-1.0.10-1.x86_64
[root@EREGDB02 ~]#
#####--- ASM Disk creation with gpt format
For both methods on OL9
https://my-orcl.blogspot.com/2021/09/installation-guide-for-rac-12102-on.html
===============================================================
[root@EREGDB01 ~]# lsblk /dev/sdg
NAME MAJ:MIN RM SIZE RO TYPE MOUNTPOINTS
sdg 8:96 0 100G 0 disk
[root@EREGDB01 ~]#
[root@EREGDB01 ~]# parted -s -a optimal /dev/sdg mklabel gpt
[root@EREGDB01 ~]# fdisk -l /dev/sdg
Disk /dev/sdg: 100 GiB, 107374182400 bytes, 209715200 sectors
Disk model: Virtual disk
Units: sectors of 1 * 512 = 512 bytes
Sector size (logical/physical): 512 bytes / 512 bytes
I/O size (minimum/optimal): 512 bytes / 512 bytes
Disklabel type: gpt
Disk identifier: F0FDA5AB-2BBB-4E2E-91B5-AA1FCC06C5E0
[root@EREGDB01 ~]#
[root@EREGDB01 ~]# parted -s -a optimal /dev/sdX mkpart primary 1MiB 100%
[root@EREGDB01 ~]# lsblk /dev/sdg
NAME MAJ:MIN RM SIZE RO TYPE MOUNTPOINTS
sdg 8:96 0 100G 0 disk
└─sdg1 8:97 0 100G 0 part
[root@EREGDB01 ~]# partprobe /dev/sdg
[root@EREGDB01 ~]#
[root@EREGDB01 ~]# fdisk –l /dev/sdc
Disk model: Virtual disk
Units: sectors of 1 * 512 = 512 bytes
Sector size (logical/physical): 512 bytes / 512 bytes
I/O size (minimum/optimal): 512 bytes / 512 bytes
Disklabel type: gpt
Disk identifier: F0FDA5AB-2BBB-4E2E-91B5-AA1FCC06C5E0
/dev/sdg1 2048 209713151 209711104 100G Linux filesystem
[root@EREGDB01 ~]#
oracleasm createdisk DATA001 /dev/sdh1
oracleasm createdisk RECO001 /dev/sdi1
oracleasm listdisks
find /dev -iname ocr*
[grid@EREGDB01 patches]$ blkid | grep asm
/dev/sdg1: LABEL="OCR001" TYPE="oracleasm"
[grid@EREGDB01 patches]$ lsblk -o NAME,SIZE,TYPE,FSTYPE,PARTUUID /dev/sdg
NAME SIZE TYPE FSTYPE PARTUUID
sdg 100G disk
└─sdg1 100G part oracleasm 1ab32289-04bb-472d-ae26-9f8d54ace7a1
[grid@EREGDB01 patches]$
[root@EREGDB02 ~]# blkid | grep asm
/dev/sdf1: LABEL="OCR001" TYPE="oracleasm" PARTLABEL="primary" PARTUUID="1ab32289-04bb-472d-ae26-9f8d54ace7a1"
[root@EREGDB02 ~]#
###--- node 2 sdc1 partion detect
[root@EREGDB02 ~]# blkid /dev/sdc1
[root@EREGDB02 ~]# partprobe /dev/sdc
[root@EREGDB02 ~]# blkid /dev/sdc1
/dev/sdc1: LABEL="OCR001" TYPE="oracleasm" PARTUUID="83543d9a-42b9-a149-82a1-5f8bf6480153"
[root@EREGDB01 ~]# lsblk /dev/sdc
NAME MAJ:MIN RM SIZE RO TYPE MOUNTPOINTS
sdg 8:96 0 100G 0 disk
└─sdg1 8:97 0 100G 0 part
[root@EREGDB02 ~]#
[root@EREGDB02 ~]# oracleasm scandisks
[root@EREGDB02 ~]# oracleasm listdisks
OCR001
[root@EREGDB02 ~]#
[grid@EREGDB01 patches]$ ls -ltrh /dev/disk/by-label/*
lrwxrwxrwx 1 root root 10 Aug 13 13:21 /dev/disk/by-label/OCR001 -> ../../sdg1
[grid@EREGDB01 patches]$
# blkid /dev/sdc1
# blkid | grep asm
# lsblk -o NAME,SIZE,TYPE,FSTYPE,PARTUUID /dev/sdc
$ORACLE_HOME/bin/kfed read /dev/sdc1 | grep -E "kfbh.type|dskname|grpname"
$ORACLE_HOME/bin/kfod op=DISKS label=TRUE disks=ALL name=TRUE status=true
#####--- untar 19c binaries
===============================================================
su - grid
[grid@EREGDB01 ~]$ cat grid.env
export TMP=/tmp
export TMPDIR=$TMP
export ORACLE_HOME=/u01/app/19.0.0/grid
export ORACLE_BASE=/u01/app/grid
export PATH=$ORACLE_HOME/bin:$PATH
export ORACLE_SID=+ASM1
export ORACLE_TERM=xterm
export BASE_PATH=/usr/sbin:$PATH
export LD_LIBRARY_PATH=$ORACLE_HOME/lib:/lib:/usr/lib
export CLASSPATH=$ORACLE_HOME/JRE:$ORACLE_HOME/jlib:$ORACLE_HOME/rdbms/jlib
#asmcmd lsdg
[grid@EREGDB01 ~]$
[grid@EREGDB01 ~]$ . grid.env
[grid@EREGDB01 ~]$ mv /u01/app/19.0.0/grid/OPatch /u01/app/19.0.0/grid/OPatch_19.3
[grid@EREGDB01 ~]$ unzip -q '/u02/19cSW/p6880880_190000_Linux-x86-64 (3).zip' -d /u01/app/19.0.0/grid/
OPatch Version: 12.2.0.1.52
[grid@EREGDB01 ~]$
[grid@EREGDB01 patches]$ unzip -q /u02/19cSW/19cGI_32PSU_with_OJVM/p39618711_190000_Linux-x86-64.zip -d /u01/patches/
#####--- rda checks
===============================================================
[root@EREGDB01 ~]# rpm -qa | grep -e oracleasm -e cvuqdisk -e preinstall
[root@EREGDB01 ~]# nslookup scan-nereg
Server: 10.98.192.1
Address: 10.98.192.1#53
Address: 10.98.132.167
Name: scan-ereg.areef.com
Address: 10.98.132.169
Name: scan-ereg.areef.com
Address: 10.98.132.168
[root@EREGDB01 ~]# cd /u02/applmgr/rda
[root@EREGDB01 rda]# ./rda.sh -T hcve
Processing HCVE tests ...
Available Pre-Installation Rule Sets:
8. Oracle Database 19c Preinstallation (Linux)
Press Return to accept the default (0)
> 8
Enter value for < Planned ORACLE_HOME location >
> /u01/app/19.0.0/grid
~~~~~~~~~~~~
(Note : Current Health Check rulesets do not have logic to support checks against Oracle Cloud or Exadata environments. If your product is installed in such an environment some test results will be erroneous. Refer instead to the product documentation rather than rely on the data below.)
====== ==================== ======= ==========================================
A00100 OS Certified? FAILED Release check failed
A01020 User in /etc/passwd? PASSED userOK
A01040 Group in /etc/group? PASSED GroupOK
A01050 Enter ORACLE_HOME RECORD /u01/app/19.0.0/grid
A01060 ORACLE_HOME Valid? PASSED OHexists
A01070 O_H Permissions OK? PASSED CorrectPerms
A01410 oraInventory Permiss PASSED oraInventoryOK
A01420 Other OUI Up? PASSED NoOtherOUI
A01430 Got Software Tools? FAILED LdElsewhere
A01440 Other O_Hs in PATH? PASSED NoneFound
A02010 Umask Set to 022? PASSED UmaskOK
A02030 Limits Processes PASSED Adequate
A02040 Limits Stacksize FAILED SoftLow HardHigh
A02050 Limits Descriptors PASSED Adequate
A02100 LDLIBRARYPATH Unset? PASSED UnSet
A02170 JAVA_HOME Unset? PASSED UnSet
A03100 RAM (in MB) PASSED 31634
A02210 Kernel Parameters OK PASSED KernelOK
A02300 Tainted Kernel? PASSED NotVerifiable
A03010 Temp Adequate? PASSED TempSpaceOK
A03020 Disk Space OK? PASSED DiskSpaceOK
A03050 Swap (in MB) RECORD 36591
A03100 RAM (in MB) PASSED 31634
A03150 SwapToRam OK? PASSED SwapToRamOK
A03500 Network PASSED Connected
A03510 IP Address RECORD 10.98.132.76
A03530 Domain Name RECORD psau.edu.sa
A03540 /etc/hosts Format PASSED Adequate IPv4 entry
A03550 DNS Lookup PASSED Host correctly registered in DNS
A03600 ip_local_port_range PASSED RangeOK
A04306 OL8 Server RPMs OK? SKIPPED NotOL8
A04305 OL7 Server RPMs OK? SKIPPED NotOL7
A04315 RHEL7 Server RPMs OK SKIPPED NotRedHat
A04335 RHEL8 Server RPMs OK SKIPPED NotRedHat
A04321 SLES12 Server RPMs O SKIPPED NotSuSE
A04325 SLES15 Server RPMs O SKIPPED NotSuSE
Result file: output/collect/DB_HCVE_A_DB19c_lin_res.htm
[root@EREGDB01 rda]#
#####--- installation of GI 19.32 with OCR disk
===============================================================
[root@EREGDB01 ~]# reboot
[root@EREGDB02 ~]# reboot
[root@EREGDB01 grid]# lsblk -o NAME,SIZE,TYPE,FSTYPE,PARTUUID,WWN,SERIAL | grep oracleasm
└─sde1 100G part oracleasm 1ab32289-04bb-472d-ae26-9f8d54ace7a1
[root@EREGDB01 grid]# blkid | grep asm
/dev/sde1: LABEL="OCR001" TYPE="oracleasm" PARTLABEL="primary" PARTUUID="1ab32289-04bb-472d-ae26-9f8d54ace7a1"
[root@EREGDB01 grid]#
[root@EREGDB02 ~]# lsblk -o NAME,SIZE,TYPE,FSTYPE,PARTUUID,WWN,SERIAL | grep oracleasm
└─sdf1 100G part oracleasm 1ab32289-04bb-472d-ae26-9f8d54ace7a1
[root@EREGDB02 ~]#
[root@EREGDB02 ~]# blkid | grep asm
/dev/sdf1: LABEL="OCR001" TYPE="oracleasm" PARTLABEL="primary" PARTUUID="1ab32289-04bb-472d-ae26-9f8d54ace7a1"
[root@EREGDB02 ~]#
export CV_ASSUME_DISTID=OEL7.8
à mobaxterm with grid user
access control disabled, clients can connect from any host
[grid@EREGDB01 ~]$ export CV_ASSUME_DISTID=OEL7.8
[grid@EREGDB01 ~]$ cd /u01/app/19.0.0/grid
[grid@EREGDB01 grid]$ ./gridSetup.sh -applyRU /u01/patches/39618711/39467003
Preparing the home to patch...
Applying the patch /u01/patches/39618711/39467003...
Successfully applied the patch.
The log can be found at: /u01/app/oraInventory/logs/GridSetupActions2026-08-13_01-48-42PM/installerPatchActions_2026-08-13_01-48-42PM.log
Launching Oracle Grid Infrastructure Setup Wizard...
GUI options for Installation of GRID Infrastructure 19.32
- Configure Oracle Grid infrastructure for New Cluster
- Create ASM Disk Group (Change the discovery path to OCRL:*)
- Privileged Operating System Groups
-> Oracle ASM Administrator (OSASM) Group asmadmin
-> Oracle ASM DBA (OSDBA for ASM) Group asmdba
-> Oracle ASM Operator (OSOPER for ASM) Group (Optional) asmoper
- Oracle Base (/u01/app/grid)
Automatic detected of
Disk group name:DATA
Select Disks /dev/sde1
Discovery Path:'/dev/sd*'
Run fix and check again
[root@EREGDB01 ~]# /tmp/GridSetupActions2026-08-13_01-48-42PM/CVU_19_grid_2026-08-13_13-55-19_9301/runfixup.sh
[root@EREGDB02 ~]# /tmp/GridSetupActions2026-08-13_01-48-42PM/CVU_19_grid_2026-08-13_13-55-19_9301/runfixup.sh
Performing root user operation.
ORACLE_OWNER= grid
ORACLE_HOME= /u01/app/19.0.0/grid
Copying dbhome to /usr/local/bin ...
Copying oraenv to /usr/local/bin ...
Copying coraenv to /usr/local/bin ...
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.
Relinking oracle with rac_on option
Using configuration parameter file: /u01/app/19.0.0/grid/crs/install/crsconfig_params
The log of current session can be found at:
/u01/app/grid/crsdata/EREGdb01/crsconfig/rootcrs_EREGdb01_2026-08-13_02-35-13PM.log
2026/08/13 14:35:19 CLSRSC-594: Executing installation step 1 of 19: 'ValidateEnv'.
2026/08/13 14:35:19 CLSRSC-594: Executing installation step 2 of 19: 'CheckFirstNode'.
2026/08/13 14:35:21 CLSRSC-594: Executing installation step 3 of 19: 'GenSiteGUIDs'.
2026/08/13 14:35:21 CLSRSC-594: Executing installation step 4 of 19: 'SetupOSD'.
Redirecting to /bin/systemctl restart rsyslog.service
2026/08/13 14:35:22 CLSRSC-594: Executing installation step 5 of 19: 'CheckCRSConfig'.
2026/08/13 14:35:22 CLSRSC-594: Executing installation step 6 of 19: 'SetupLocalGPNP'.
2026/08/13 14:35:31 CLSRSC-594: Executing installation step 7 of 19: 'CreateRootCert'.
2026/08/13 14:35:34 CLSRSC-594: Executing installation step 8 of 19: 'ConfigOLR'.
2026/08/13 14:35:48 CLSRSC-594: Executing installation step 9 of 19: 'ConfigCHMOS'.
2026/08/13 14:35:49 CLSRSC-594: Executing installation step 10 of 19: 'CreateOHASD'.
2026/08/13 14:35:53 CLSRSC-594: Executing installation step 11 of 19: 'ConfigOHASD'.
2026/08/13 14:35:53 CLSRSC-330: Adding Clusterware entries to file 'oracle-ohasd.service'
2026/08/13 14:36:12 CLSRSC-594: Executing installation step 12 of 19: 'SetupTFA'.
2026/08/13 14:36:12 CLSRSC-594: Executing installation step 13 of 19: 'InstallAFD'.
2026/08/13 14:36:12 CLSRSC-594: Executing installation step 14 of 19: 'InstallACFS'.
2026/08/13 14:36:24 CLSRSC-594: Executing installation step 15 of 19: 'InstallKA'.
2026/08/13 14:36:29 CLSRSC-594: Executing installation step 16 of 19: 'InitConfig'.
2026/08/13 14:37:14 CLSRSC-4002: Successfully installed Oracle Trace File Analyzer (TFA) Collector.
CRS-4256: Updating the profile
Successful addition of voting disk 2c6a1451a15d4fd4bf046e496ceaca8f.
Successfully replaced voting disk group with +OCR.
CRS-4256: Updating the profile
CRS-4266: Voting file(s) successfully replaced
## STATE File Universal Id File Name Disk group
-- ----- ----------------- --------- ---------
1. ONLINE 2c6a1451a15d4fd4bf046e496ceaca8f (ORCL:OCR001) [OCR]
Located 1 voting disk(s).
2026/08/13 14:38:14 CLSRSC-594: Executing installation step 17 of 19: 'StartCluster'.
2026/08/13 14:39:08 CLSRSC-343: Successfully started Oracle Clusterware stack
2026/08/13 14:39:08 CLSRSC-594: Executing installation step 18 of 19: 'ConfigNode'.
2026/08/13 14:39:55 CLSRSC-594: Executing installation step 19 of 19: 'PostConfig'.
2026/08/13 14:40:10 CLSRSC-325: Configure Oracle Grid Infrastructure for a Cluster ... succeeded
[root@EREGDB01 ~]#
Performing root user operation.
ORACLE_OWNER= grid
ORACLE_HOME= /u01/app/19.0.0/grid
Copying dbhome to /usr/local/bin ...
Copying oraenv to /usr/local/bin ...
Copying coraenv to /usr/local/bin ...
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.
Relinking oracle with rac_on option
Using configuration parameter file: /u01/app/19.0.0/grid/crs/install/crsconfig_params
The log of current session can be found at:
/u01/app/grid/crsdata/EREGdb02/crsconfig/rootcrs_EREGdb02_2026-08-13_02-40-24PM.log
2026/08/13 14:40:27 CLSRSC-594: Executing installation step 1 of 19: 'ValidateEnv'.
2026/08/13 14:40:27 CLSRSC-594: Executing installation step 2 of 19: 'CheckFirstNode'.
2026/08/13 14:40:28 CLSRSC-594: Executing installation step 3 of 19: 'GenSiteGUIDs'.
2026/08/13 14:40:28 CLSRSC-594: Executing installation step 4 of 19: 'SetupOSD'.
Redirecting to /bin/systemctl restart rsyslog.service
2026/08/13 14:40:28 CLSRSC-594: Executing installation step 5 of 19: 'CheckCRSConfig'.
2026/08/13 14:40:28 CLSRSC-594: Executing installation step 6 of 19: 'SetupLocalGPNP'.
2026/08/13 14:40:29 CLSRSC-594: Executing installation step 7 of 19: 'CreateRootCert'.
2026/08/13 14:40:29 CLSRSC-594: Executing installation step 8 of 19: 'ConfigOLR'.
2026/08/13 14:40:40 CLSRSC-594: Executing installation step 9 of 19: 'ConfigCHMOS'.
2026/08/13 14:40:40 CLSRSC-594: Executing installation step 10 of 19: 'CreateOHASD'.
2026/08/13 14:40:41 CLSRSC-594: Executing installation step 11 of 19: 'ConfigOHASD'.
2026/08/13 14:40:41 CLSRSC-330: Adding Clusterware entries to file 'oracle-ohasd.service'
2026/08/13 14:40:57 CLSRSC-594: Executing installation step 12 of 19: 'SetupTFA'.
2026/08/13 14:40:57 CLSRSC-594: Executing installation step 13 of 19: 'InstallAFD'.
2026/08/13 14:40:57 CLSRSC-594: Executing installation step 14 of 19: 'InstallACFS'.
2026/08/13 14:41:06 CLSRSC-594: Executing installation step 15 of 19: 'InstallKA'.
2026/08/13 14:41:07 CLSRSC-594: Executing installation step 16 of 19: 'InitConfig'.
2026/08/13 14:41:14 CLSRSC-594: Executing installation step 17 of 19: 'StartCluster'.
2026/08/13 14:41:44 CLSRSC-343: Successfully started Oracle Clusterware stack
2026/08/13 14:41:44 CLSRSC-594: Executing installation step 18 of 19: 'ConfigNode'.
2026/08/13 14:41:52 CLSRSC-594: Executing installation step 19 of 19: 'PostConfig'.
2026/08/13 14:41:56 CLSRSC-325: Configure Oracle Grid Infrastructure for a Cluster ... succeeded
[root@EREGDB02 ~]# 2026/08/13 14:41:56 CLSRSC-4002: Successfully installed Oracle Trace File Analyzer (TFA) Collector.
39526364;OCW RELEASE UPDATE 19.32.0.0.0 (39526364)
39503034;ACFS RELEASE UPDATE 19.32.0.0.0 (39503034)
39472050;Database Release Update : 19.32.0.0.260721 (39472050)
39107855;TOMCAT RELEASE UPDATE 19.0.0.0.0 (39107855)
39107825;DBWLM RELEASE UPDATE 19.0.0.0.0 (39107825)
[grid@EREGDB01 ~]$
[grid@EREGDB01 ~]$ $ORACLE_HOME/jdk/bin/java -version
java version "1.8.0_491"
Java(TM) SE Runtime Environment (build 1.8.0_491-b10)
Java HotSpot(TM) 64-Bit Server VM (build 25.491-b10, mixed mode)
[grid@EREGDB01 ~]$
Oracle Clusterware release patch level is [3004609525] and the complete list of patches [39107825 39107855 39472050 39503034 39526364 ] have been applied on the local node. The release patch string is [19.32.0.0.0].
[grid@EREGDB01 ~]$
[grid@EREGDB01 ~]$ $ORACLE_HOME/bin/crsctl query crs softwarepatch
Oracle Clusterware patch level on node EREGdb01 is [3004609525].
[grid@EREGDB01 ~]$
[grid@EREGDB01 ~]$ $ORACLE_HOME/bin/crsctl query crs activeversion -f
Oracle Clusterware active version on the cluster is [19.0.0.0.0]. The cluster upgrade state is [NORMAL]. The cluster active patch level is [3004609525].
[grid@EREGDB01 ~]$
#####--- untar 19c RDBMS binaries and install
===============================================================
su - oracle
[oracle@EREGDB01 ~]$ cat ereg.env
export TMP=/tmp
export TMPDIR=$TMP
export ORACLE_BASE=/u01/app/oracle
export DB_HOME=$ORACLE_BASE/product/19.0.0/dbhome_1
export ORACLE_HOME=$DB_HOME
export ORACLE_SID=EREG1
export ORACLE_TERM=xterm
export BASE_PATH=/usr/sbin:$PATH
export PATH=$ORACLE_HOME/bin:$BASE_PATH
export LD_LIBRARY_PATH=$ORACLE_HOME/lib:/lib:/usr/lib
export CLASSPATH=$ORACLE_HOME/JRE:$ORACLE_HOME/jlib:$ORACLE_HOME/rdbms/jlib
[oracle@EREGDB01 ~]$
[oracle@EREGDB01 ~]$ . ereg.env
[oracle@EREGDB01 dbhome_1]$ unzip -q /u02/19cSW/LINUX.X64_193000_db_home.zip -d /u01/app/oracle/product/19.0.0/dbhome_1
OPatch Version: 12.2.0.1.17
[oracle@EREGDB01 ~]$
[oracle@EREGDB01 ~]$ unzip -q '/u02/19cSW/p6880880_190000_Linux-x86-64 (3).zip' -d /u01/app/oracle/product/19.0.0/dbhome_1
[oracle@EREGDB01 ~]$ $ORACLE_HOME/OPatch/opatch version
OPatch Version: 12.2.0.1.52
[oracle@EREGDB01 ~]$
access control disabled, clients can connect from any host
[oracle@EREGDB01 ~]$
[oracle@EREGDB01 ~]$ . ereg.env
[oracle@EREGDB01 ~]$ cd /u01/app/oracle/product/19.0.0/dbhome_1/
[oracle@EREGDB01 dbhome_1]$
[oracle@EREGDB01 dbhome_1]$
[oracle@EREGDB01 dbhome_1]$
39526364 -> OCW Release Update 19.32.0.0.260721
39222882 - Oracle JavaVM Component Release Update 19.32.0.0.260721
- run the root.sh scripts on both nodes
[oracle@EREGDB01 ~]$ $ORACLE_HOME/OPatch/opatch lspatches
39222882;OJVM RELEASE UPDATE: 19.32.0.0.260721 (39222882)
39526364;OCW RELEASE UPDATE 19.32.0.0.0 (39526364)
39472050;Database Release Update : 19.32.0.0.260721 (39472050)
[oracle@EREGDB01 ~]$
[oracle@EREGDB01 ~]$
[oracle@EREGDB01 ~]$ $ORACLE_HOME/jdk/bin/java -version
java version "1.8.0_491"
Java(TM) SE Runtime Environment (build 1.8.0_491-b10)
Java HotSpot(TM) 64-Bit Server VM (build 25.491-b10, mixed mode)
[oracle@EREGDB01 ~]$
#####--- Add ASM Disks (DATA,RECO)
===============================================================
[root@EREGDB01 ~]# lsblk
NAME MAJ:MIN RM SIZE RO TYPE MOUNTPOINTS
sda 8:0 0 200G 0 disk
├─sda1 8:1 0 600M 0 part /boot/efi
├─sda2 8:2 0 1G 0 part /boot
└─sda3 8:3 0 198.4G 0 part
├─ol-root 252:0 0 70G 0 lvm /
├─ol-swap 252:1 0 15.7G 0 lvm [SWAP]
└─ol-home 252:2 0 112.7G 0 lvm /home
sdb 8:16 0 300G 0 disk
sdc 8:32 0 500G 0 disk
└─sdc1 8:33 0 500G 0 part
└─u01-lvol0 252:3 0 500G 0 lvm /u01
sdd 8:48 0 300G 0 disk
sde 8:64 0 100G 0 disk
└─sde1 8:65 0 100G 0 part
sdf 8:80 0 300G 0 disk
sdg 8:96 0 300G 0 disk
sr0 11:0 1 1024M 0 rom
ofsctl 249:0 0 0B 0 disk
[root@EREGDB01 ~]# blkid | grep asm
/dev/sde1: LABEL="OCR001" TYPE="oracleasm" PARTLABEL="primary" PARTUUID="1ab32289-04bb-472d-ae26-9f8d54ace7a1"
NAME MAJ:MIN RM SIZE RO TYPE MOUNTPOINTS
sda 8:0 0 300G 0 disk
sdb 8:16 0 300G 0 disk
sdc 8:32 0 300G 0 disk
sdd 8:48 0 200G 0 disk
├─sdd1 8:49 0 600M 0 part /boot/efi
├─sdd2 8:50 0 1G 0 part /boot
└─sdd3 8:51 0 198.4G 0 part
├─ol-root 252:0 0 70G 0 lvm /
├─ol-swap 252:1 0 15.7G 0 lvm [SWAP]
└─ol-home 252:2 0 112.7G 0 lvm /home
sde 8:64 0 300G 0 disk
sdf 8:80 0 100G 0 disk
└─sdf1 8:81 0 100G 0 part
sdg 8:96 0 500G 0 disk
└─sdg1 8:97 0 500G 0 part
└─u01-lvol0 252:3 0 500G 0 lvm /u01
sr0 11:0 1 13.5G 0 rom
ofsctl 249:0 0 0B 0 disk
[root@EREGDB02 ~]# blkid | grep asm
/dev/sdf1: LABEL="OCR001" TYPE="oracleasm" PARTLABEL="primary" PARTUUID="1ab32289-04bb-472d-ae26-9f8d54ace7a1"
parted -s -a optimal /dev/sdX mkpart primary 1MiB 100%
partprobe /dev/sdX
[root@EREGDB01 ~]# fdisk -l /dev/sdb
Disk /dev/sdb: 300 GiB, 322122547200 bytes, 629145600 sectors
Disk model: Virtual disk
Units: sectors of 1 * 512 = 512 bytes
Sector size (logical/physical): 512 bytes / 512 bytes
I/O size (minimum/optimal): 512 bytes / 512 bytes
Disklabel type: gpt
Disk identifier: 0C178C3E-5574-4C13-8A2F-424F1639DFF4
[root@EREGDB01 ~]# parted -s -a optimal /dev/sdb mkpart primary 1MiB 100%
[root@EREGDB01 ~]#
[root@EREGDB01 ~]#
[root@EREGDB01 ~]# fdisk -l /dev/sdb
Disk /dev/sdb: 300 GiB, 322122547200 bytes, 629145600 sectors
Disk model: Virtual disk
Units: sectors of 1 * 512 = 512 bytes
Sector size (logical/physical): 512 bytes / 512 bytes
I/O size (minimum/optimal): 512 bytes / 512 bytes
Disklabel type: gpt
Disk identifier: 0C178C3E-5574-4C13-8A2F-424F1639DFF4
/dev/sdb1 2048 629143551 629141504 300G Linux filesystem
[root@EREGDB01 ~]# lsblk -o NAME,SIZE,TYPE,FSTYPE,START,MOUNTPOINT /dev/sdb
lsblk: unknown column: START,MOUNTPOINT
[root@EREGDB01 ~]#
[root@EREGDB01 ~]# parted -s -a optimal /dev/sdf mklabel gpt
[root@EREGDB01 ~]# parted -s -a optimal /dev/sdg mklabel gpt
[root@EREGDB01 ~]# parted -s -a optimal /dev/sdd mkpart primary 1MiB 100%
[root@EREGDB01 ~]# parted -s -a optimal /dev/sdf mkpart primary 1MiB 100%
[root@EREGDB01 ~]# parted -s -a optimal /dev/sdg mkpart primary 1MiB 100%
[root@EREGDB01 ~]# lsblk
NAME MAJ:MIN RM SIZE RO TYPE MOUNTPOINTS
sda 8:0 0 200G 0 disk
├─sda1 8:1 0 600M 0 part /boot/efi
├─sda2 8:2 0 1G 0 part /boot
└─sda3 8:3 0 198.4G 0 part
├─ol-root 252:0 0 70G 0 lvm /
├─ol-swap 252:1 0 15.7G 0 lvm [SWAP]
└─ol-home 252:2 0 112.7G 0 lvm /home
sdb 8:16 0 300G 0 disk
└─sdb1 8:17 0 300G 0 part
sdc 8:32 0 500G 0 disk
└─sdc1 8:33 0 500G 0 part
└─u01-lvol0 252:3 0 500G 0 lvm /u01
sdd 8:48 0 300G 0 disk
└─sdd1 8:49 0 300G 0 part
sde 8:64 0 100G 0 disk
└─sde1 8:65 0 100G 0 part
sdf 8:80 0 300G 0 disk
└─sdf1 8:81 0 300G 0 part
sdg 8:96 0 300G 0 disk
└─sdg1 8:97 0 300G 0 part
sr0 11:0 1 1024M 0 rom
ofsctl 249:0 0 0B 0 disk
[root@EREGDB01 ~]# oracleasm createdisk DATA001 /dev/sdb1
Writing disk header: done
Instantiating disk: done
[root@EREGDB01 ~]# oracleasm createdisk DATA002 /dev/sdd1
Writing disk header: done
Instantiating disk: done
[root@EREGDB01 ~]# oracleasm createdisk DATA003 /dev/sdf1
Writing disk header: done
Instantiating disk: done
[root@EREGDB01 ~]# oracleasm createdisk RECO001 /dev/sdg1
Writing disk header: done
Instantiating disk: done
[root@EREGDB01 ~]# oracleasm listdisks
DATA001
DATA002
DATA003
OCR001
RECO001
[root@EREGDB01 ~]#
/dev/sde1: LABEL="OCR001" TYPE="oracleasm" PARTLABEL="primary" PARTUUID="1ab32289-04bb-472d-ae26-9f8d54ace7a1"
/dev/sdb1: LABEL="DATA001" TYPE="oracleasm" PARTLABEL="primary" PARTUUID="a9605027-10b9-48b7-bb8c-676e043f0cbf"
/dev/sdd1: LABEL="DATA002" TYPE="oracleasm" PARTLABEL="primary" PARTUUID="08abbc61-2890-49c6-a255-efe91b9e923d"
/dev/sdf1: LABEL="DATA003" TYPE="oracleasm" PARTLABEL="primary" PARTUUID="daf20710-af22-4085-811f-b84825ea9e17"
/dev/sdg1: LABEL="RECO001" TYPE="oracleasm" PARTLABEL="primary" PARTUUID="683cbf6c-a330-485e-a26e-bf2027dea689"
[root@EREGDB01 ~]#
[root@EREGDB01 ~]# /u01/app/19.0.0/grid/bin/kfod op=groups
--------------------------------------------------------------------------------
Group Size Free Redundancy Name
================================================================================
1: 102396 MB 102032 MB EXTERN OCR
[root@EREGDB01 ~]#
OCR001
[root@EREGDB02 ~]# oracleasm scandisks
Reloading disk partitions: done
Cleaning any stale ASM disks...
Setting up iofilter map for ASM disks: done
Scanning system for ASM disks...
[root@EREGDB02 ~]#
[root@EREGDB02 ~]# oracleasm listdisks
OCR001
[root@EREGDB02 ~]# partprobe
Warning: Error fsyncing/closing /dev/sdf1: Input/output error
Warning: Unable to open /dev/sr0 read-write (Read-only file system). /dev/sr0 has been opened read-only.
[root@EREGDB02 ~]# oracleasm listdisks
DATA001
DATA002
DATA003
OCR001
RECO001
[root@EREGDB02 ~]#
[root@EREGDB02 ~]# blkid | grep asm
/dev/sdf1: LABEL="OCR001" TYPE="oracleasm" PARTLABEL="primary" PARTUUID="1ab32289-04bb-472d-ae26-9f8d54ace7a1"
/dev/sdb1: LABEL="DATA001" TYPE="oracleasm" PARTLABEL="primary" PARTUUID="a9605027-10b9-48b7-bb8c-676e043f0cbf"
/dev/sde1: LABEL="DATA002" TYPE="oracleasm" PARTLABEL="primary" PARTUUID="08abbc61-2890-49c6-a255-efe91b9e923d"
/dev/sdc1: LABEL="DATA003" TYPE="oracleasm" PARTLABEL="primary" PARTUUID="daf20710-af22-4085-811f-b84825ea9e17"
/dev/sda1: LABEL="RECO001" TYPE="oracleasm" PARTLABEL="primary" PARTUUID="683cbf6c-a330-485e-a26e-bf2027dea689"
[root@EREGDB02 ~]#
[root@EREGDB01 ~]# crsctl stop crs
[root@EREGDB01 ~]# reboot
[root@EREGDB02 ~]# reboot
[root@EREGDB01 ~]# crsctl check cluster -all
**************************************************************
EREGdb01:
CRS-4537: Cluster Ready Services is online
CRS-4529: Cluster Synchronization Services is online
CRS-4533: Event Manager is online
**************************************************************
EREGdb02:
CRS-4537: Cluster Ready Services is online
CRS-4529: Cluster Synchronization Services is online
CRS-4533: Event Manager is online
**************************************************************
[root@EREGDB01 ~]# su - grid
[grid@EREGDB01 ~]$ !sq
sqlplus / as sysasm
bash: sqlplus: command not found...
^C
[grid@EREGDB01 ~]$ . grid.env
[grid@EREGDB01 ~]$ sqlplus / as sysasm
col PATH for a15;
select name, state, type, total_mb,
free_mb
from v$asm_diskgroup;
select path, header_status,
mode_status, state, disk_number
from v$asm_disk
order by path;
------------------------------ ----------- ------ ---------- ----------
OCR MOUNTED EXTERN 102396 102032
SQL>
PATH HEADER_STATU MODE_ST STATE DISK_NUMBER
--------------- ------------ ------- -------- -----------
ORCL:DATA001 PROVISIONED
ONLINE NORMAL 3
ORCL:DATA002 PROVISIONED
ONLINE NORMAL 0
ORCL:DATA003 PROVISIONED
ONLINE NORMAL 1
ORCL:OCR001 MEMBER ONLINE
NORMAL 0
ORCL:RECO001 PROVISIONED
ONLINE NORMAL 2
------------------------------ ----------- ------ ---------- ----------
OCR MOUNTED EXTERN 102396 102032
DATA MOUNTED EXTERN 921588 921424
RECO MOUNTED EXTERN 307196 307056
--------------- ------------ ------- -------- -----------
ORCL:DATA001 MEMBER ONLINE NORMAL 0
ORCL:DATA002 MEMBER ONLINE NORMAL 1
ORCL:DATA003 MEMBER ONLINE NORMAL 2
ORCL:OCR001 MEMBER ONLINE NORMAL 0
ORCL:RECO001 MEMBER ONLINE NORMAL 0
--------------------------------------------------------------------------------
Group Size Free Redundancy Name
================================================================================
1: 307196 MB 307056 MB EXTERN RECO
3: 102396 MB 102032 MB EXTERN OCR
5: 921588 MB 921424 MB EXTERN DATA
[grid@EREGDB01 ~]$
#####--- installalation of Database
===============================================================
[oracle@EREGDB01 ~]$ cat ereg.env
export TMP=/tmp
export TMPDIR=$TMP
export ORACLE_BASE=/u01/app/oracle
export DB_HOME=$ORACLE_BASE/product/19.0.0/dbhome_1
export ORACLE_HOME=$DB_HOME
export ORACLE_SID=EREG1
export ORACLE_TERM=xterm
export BASE_PATH=/usr/sbin:$PATH
export PATH=$ORACLE_HOME/bin:$BASE_PATH
export LD_LIBRARY_PATH=$ORACLE_HOME/lib:/lib:/usr/lib
export CLASSPATH=$ORACLE_HOME/JRE:$ORACLE_HOME/jlib:$ORACLE_HOME/rdbms/jlib
[oracle@EREGDB01 ~]$ . ereg.env
[oracle@EREGDB01 ~]$ dbca
GUI options for Installation of DB 19.32
-> Db_unique_name
#####--- next step verify configuration ad CRD files
===============================================================
[oracle@EREGDB01 ~]$ cat $TNS_ADMIN/sqlnet.ora
[oracle@EREGDB02 ~]$ cat $TNS_ADMIN/sqlnet.ora
NAMES.DIRECTORY_PATH=(TNSNAMES, ONAMES,
HOSTNAME, EZCONNECT)
SQLNET.ALLOWED_LOGON_VERSION_SERVER=11
SQLNET.INBOUND_CONNECT_TIMEOUT=60
SQLNET.EXPIRE_TIME= 10
#SQLNET.ALLOWED_LOGON_VERSION_SERVER=8
[oracle@EREGDB01 ~]$
[oracle@EREGDB01 ~]$ srvctl config database
EREG
[oracle@EREGDB01 ~]$ srvctl config database -d EREG
SQLNET.ALLOWED_LOGON_VERSION_SERVER=11
SQLNET.INBOUND_CONNECT_TIMEOUT=60
SQLNET.EXPIRE_TIME= 10
#SQLNET.ALLOWED_LOGON_VERSION_SERVER=8
[oracle@EREGDB01 ~]$
EREG
[oracle@EREGDB01 ~]$ srvctl config database -d EREG
Database unique name: EREG
Database name: EREG
Oracle home: /u01/app/oracle/product/19.0.0/dbhome_1
Oracle user: oracle
Spfile: +DATA/EREG/PARAMETERFILE/spfile.268.1241438749
Password file: +DATA/EREG/PASSWORD/pwdereg.256.1241437899
Domain:
Start options: open
Stop options: immediate
Database role: PRIMARY
Management policy: AUTOMATIC
Server pools:
Disk Groups: RECO,DATA
Mount point paths:
Services:
Type: RAC
Start concurrency:
Stop concurrency:
OSDBA group: oinstall
OSOPER group: oinstall
Database instances: EREG1,EREG2
Configured nodes: EREGdb01,EREGdb02
CSS critical: no
CPU count: 0
Memory target: 0
Maximum memory: 0
Default network number for database services:
Database is administrator managed
[oracle@EREGDB01 ~]$
SQL>
SQL> show parameter spfile;
NAME TYPE VALUE
------------------------------------ ----------- ------------------------------
spfile string +DATA/EREG/PARAMETERFILE/spfil
e.268.1241438749
SQL>SQL> select name from v$controlfile;
NAME
--------------------------------------------------------------------------------
+DATA/EREG/CONTROLFILE/current.261.1241438037
+RECO/EREG/CONTROLFILE/current.256.1241438037
SQL>
set linesize 200 pagesize 200
col MEMBER for a50
SELECT * FROM V$LOGFILE;
select GROUP#,THREAD#,SEQUENCE#,bytes/1024/1024,MEMBERS,STATUS from v$log;
GROUP# STATUS TYPE MEMBER IS_ CON_ID
---------- ------- ------- -------------------------------------------------- --- ----------
2 ONLINE +DATA/EREG/ONLINELOG/group_2.263.1241438039 NO 0
2 ONLINE +RECO/EREG/ONLINELOG/group_2.257.1241438039 YES 0
1 ONLINE +DATA/EREG/ONLINELOG/group_1.262.1241438039 NO 0
1 ONLINE +RECO/EREG/ONLINELOG/group_1.258.1241438039 YES 0
3 ONLINE +DATA/EREG/ONLINELOG/group_3.266.1241438747 NO 0
3 ONLINE +RECO/EREG/ONLINELOG/group_3.259.1241438747 YES 0
4 ONLINE +DATA/EREG/ONLINELOG/group_4.267.1241438747 NO 0
4 ONLINE +RECO/EREG/ONLINELOG/group_4.260.1241438749 YES 0
8 rows selected.
SQL>
GROUP# THREAD# SEQUENCE# BYTES/1024/1024 MEMBERS STATUS
---------- ---------- ---------- --------------- ---------- ----------------
1 1 13 200 2 INACTIVE
2 1 14 200 2 CURRENT
3 2 1 200 2 INACTIVE
4 2 2 200 2 CURRENT
SQL>
col TABLESPACE_NAME for a20;
col FILE_NAME for a45;
select TABLESPACE_NAME, FILE_NAME,STATUS from dba_data_files;
SQL>
TABLESPACE_NAME FILE_NAME STATUS
-------------------- --------------------------------------------- ---------
SYSTEM +DATA/EREG/DATAFILE/system.257.1241437921 AVAILABLE
SYSAUX +DATA/EREG/DATAFILE/sysaux.258.1241437957 AVAILABLE
UNDOTBS2 +DATA/EREG/DATAFILE/undotbs2.265.1241438661 AVAILABLE
USERS +DATA/EREG/DATAFILE/users.260.1241437983 AVAILABLE
UNDOTBS1 +DATA/EREG/DATAFILE/undotbs1.259.1241437981 AVAILABLE
SQL>
SQL> show parameter name
NAME TYPE VALUE
------------------------------------ ----------- ------------------------------
cdb_cluster_name string
cell_offloadgroup_name string
db_file_name_convert string
db_name string EREG
db_unique_name string EREG
global_names boolean FALSE
instance_name string EREG1
lock_name_space string
log_file_name_convert string
mfa_sender_email_displayname string
pdb_file_name_convert string
NAME TYPE VALUE
------------------------------------ ----------- ------------------------------
processor_group_name string
service_names string EREG
SQL>
SQL> archive log list;
Database log mode Archive Mode
Automatic archival Enabled
Archive destination USE_DB_RECOVERY_FILE_DEST
Oldest online log sequence 14
Next log sequence to archive 15
Current log sequence 15
SQL>
SQL> set linesize 300;
col HOST_NAME for a9;
col OPEN_MODE for a10;
select INSTANCE_NUMBER,INSTANCE_NAME,HOST_NAME,STATUS,DATABASE_STATUS,INSTANCE_ROLE,ACTIVE_STATE,INSTANCE_MODE from gv$instance;SQL> SQL> SQL>
INSTANCE_NUMBER INSTANCE_NAME HOST_NAME STATUS DATABASE_STATUS INSTANCE_ROLE ACTIVE_ST INSTANCE_MO
--------------- ---------------- --------- ------------ ----------------- ------------------ --------- -----------
1 EREG1 EREG OPEN ACTIVE PRIMARY_INSTANCE NORMAL REGULAR
DB01.areef
.com
2 EREG2 EREG OPEN ACTIVE PRIMARY_INSTANCE NORMAL
REGULAR
DB02.areef
.com
SQL>
SQL> set linesize 200;
select name,open_mode,LOG_MODE,FLASHBACK_ON,FORCE_LOGGING from v$database;
NAME
OPEN_MODE LOG_MODE FLASHBACK_ON FORCE_LOGGING
--------- ---------- ------------ ------------------ ---------------------------------------
EREG READ WRITE ARCHIVELOG NO NO
SQL>
SQL> SELECT VERSION FROM V$TIMEZONE_FILE;-- verify soure and target and upgrade appropriate( eles import will fail)
VERSION
----------
32
SQL>
===============================================================
#####--- change unique name EREG to EREGP
===============================================================
[oracle@EREGDB01 ~]$ srvctl stop database -d EREG
[oracle@EREGDB01 ~]$ srvctl remove database -d EREG
Remove the database EREG? (y/[n]) y
[oracle@EREGDB01 ~]$ sqlplus / as sysdba
SQL*Plus: Release 19.0.0.0.0 - Production on
Sun Aug 16 12:57:13 2026
Version 19.32.0.0.0
Copyright (c) 1982, 2026, Oracle. All rights reserved.
Connected to an idle instance.
SQL> startup nomount;
ORA-01078: failure in processing system parameters
LRM-00109: could not open parameter file '/u01/app/oracle/product/19.0.0/dbhome_1/dbs/initEREG1.ora'
SQL> exit
Disconnected
[oracle@EREGDB01 ~]$ cd $ORACLE_HOME/dbs
[oracle@EREGDB01 dbs]$ ls -ltrh
total 27M
-rw-r--r-- 1 oracle oinstall 3.1K May 14 2015 init.ora
-rw-r----- 1 oracle asmadmin 19M Aug 16 12:17 snapcf_EREG1.f
-rw-r----- 1 oracle asmadmin 8.0M Aug 16 12:56 id_EREG1.dat
-rw-rw---- 1 oracle asmadmin 1.6K Aug 16 12:56 hc_EREG1.dat
[oracle@EREGDB01 dbs]$ vi initEREG1.ora
[oracle@EREGDB01 dbs]$ cat initEREG1.ora
spfile='+DATA/EREG/PARAMETERFILE/spfile.268.1241438749'
[oracle@EREGDB01 dbs]$
[oracle@EREGDB01 dbs]$ sqlplus / as sysdba
SQL*Plus: Release 19.0.0.0.0 - Production on
Sun Aug 16 12:58:35 2026
Version 19.32.0.0.0
Copyright (c) 1982, 2026, Oracle. All rights reserved.
Connected to an idle instance.
SQL> startup nomount;
ORACLE instance started.
Total System Global Area 1.5703E+10 bytes
Fixed Size 18424064 bytes
Variable Size 2113929216 bytes
Database Buffers 1.3556E+10 bytes
Redo Buffers 15126528 bytes
SQL> alter system set db_unique_name='EREGP' scope=spfile sid='*';
System altered.
SQL> shutdown immediate;
ORA-01507: database not mounted
ORACLE instance shut down.
SQL> exit
Disconnected from Oracle Database 19c Enterprise Edition Release 19.0.0.0.0 - Production
Version 19.32.0.0.0
[oracle@EREGDB01 dbs]$ cat initEREG1.ora
spfile='+DATA/EREG/PARAMETERFILE/spfile.268.1241438749'
[oracle@EREGDB01 dbs]$
Register the Database
[oracle@EREGDB01 dbs]$ srvctl add database -db EREGP -dbname EREG \
-oraclehome /u01/app/oracle/product/19.0.0/dbhome_1 \
-spfile +DATA/EREG/PARAMETERFILE/spfile.268.1241438749 \
-pwfile +DATA/EREG/PASSWORD/pwdereg.256.1241437899 \
-role PRIMARY -diskgroup "RECO,DATA" \
-dbtype RAC
[oracle@EREGDB01 dbs]$
[oracle@EREGDB01 dbs]$ srvctl config database
EREGP
[oracle@EREGDB01 dbs]$ srvctl add instance -db EREGP -instance EREG1 -node EREGdb01
[oracle@EREGDB01 dbs]$ srvctl add instance -db EREGP -instance EREG2 -node EREGdb02
[oracle@EREGDB01 dbs]$
[oracle@EREGDB01 dbs]$ srvctl config database -d EREGP
Database unique name: EREGP
Database name: EREG
Oracle home: /u01/app/oracle/product/19.0.0/dbhome_1
Oracle user: oracle
Spfile: +DATA/EREG/PARAMETERFILE/spfile.268.1241438749
Password file: +DATA/EREG/PASSWORD/pwdereg.256.1241437899
Domain:
Start options: open
Stop options: immediate
Database role: PRIMARY
Management policy: AUTOMATIC
Server pools:
Disk Groups: RECO,DATA
Mount point paths:
Services:
Type: RAC
Start concurrency:
Stop concurrency:
OSDBA group: oinstall
OSOPER group: oinstall
Database instances: EREG1,EREG2
Configured nodes: EREGdb01,EREGdb02
CSS critical: no
CPU count: 0
Memory target: 0
Maximum memory: 0
Default network number for database services:
Database is administrator managed
[oracle@EREGDB01 dbs]$ srvctl start database -db EREGP
SQL> show parameter name
NAME TYPE VALUE
------------------------------------ ----------- ------------------------------
cdb_cluster_name string
cell_offloadgroup_name string
db_file_name_convert string
db_name string EREG
db_unique_name string EREGP
global_names boolean FALSE
instance_name string EREG1
lock_name_space string
log_file_name_convert string
mfa_sender_email_displayname string
pdb_file_name_convert string
NAME TYPE VALUE
------------------------------------ ----------- ------------------------------
processor_group_name string
service_names string EREGP
SQL> exit
Disconnected from Oracle Database 19c Enterprise Edition Release 19.0.0.0.0 - Production
Version 19.32.0.0.0
[oracle@EREGDB01 dbs]$ cat $TNS_ADMIN/tnsnames.ora
# tnsnames.ora Network Configuration File: /u01/app/oracle/product/19.0.0/dbhome_1/network/admin/tnsnames.ora
# Generated by Oracle configuration tools.
EREG =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = TCP)(HOST = scan-ereg)(PORT = 1531))
(CONNECT_DATA =
(SERVER = DEDICATED)
(SERVICE_NAME = EREG)
)
)
[oracle@EREGDB01 dbs]$
[oracle@EREGDB01 dbs]$ lsnrctl status
LSNRCTL for Linux: Version 19.0.0.0.0 -
Production on 16-AUG-2026 13:07:30
Copyright (c) 1991, 2026, Oracle. All rights reserved.
Connecting to
(ADDRESS=(PROTOCOL=tcp)(HOST=)(PORT=1521))
STATUS of the LISTENER
------------------------
Alias LISTENER
Version TNSLSNR for Linux: Version 19.0.0.0.0 - Production
Start Date 16-AUG-2026 11:27:46
Uptime 0 days 1 hr. 39 min. 44 sec
Trace Level off
Security ON: Local OS Authentication
SNMP OFF
Listener Parameter File /u01/app/19.0.0/grid/network/admin/listener.ora
Listener Log File /u01/app/grid/diag/tnslsnr/EREGDB01/listener/alert/log.xml
Listening Endpoints Summary...
(DESCRIPTION=(ADDRESS=(PROTOCOL=ipc)(KEY=LISTENER)))
(DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=10.98.132.76)(PORT=1521)))
(DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=10.98.132.230)(PORT=1521)))
Services Summary...
Service "+ASM" has 1 instance(s).
Instance "+ASM1", status READY, has 1 handler(s) for this service...
Service "+ASM_DATA" has 1 instance(s).
Instance "+ASM1", status READY, has 1 handler(s) for this service...
Service "+ASM_OCR" has 1 instance(s).
Instance "+ASM1", status READY, has 1 handler(s) for this service...
Service "+ASM_RECO" has 1 instance(s).
Instance "+ASM1", status READY, has 1 handler(s) for this service...
Service "EREGP" has 1 instance(s).
Instance "EREG1", status READY, has 1 handler(s) for this service...
Service "EREGXDB" has 1 instance(s).
Instance "EREG1", status READY, has 1 handler(s) for this service...
The command completed successfully
[oracle@EREGDB01 dbs]$
===============================================================
#####--- update time zone
===============================================================
SQL> SELECT
VERSION FROM V$TIMEZONE_FILE;
VERSION
----------
32
SQL>
SQL> SELECT DBMS_DST.GET_LATEST_TIMEZONE_VERSION FROM DUAL;
GET_LATEST_TIMEZONE_VERSION
---------------------------
45
[oracle@EREGDB01 expdp]$ srvctl stop database -d EREGP
Instance EREG1 is not running on node EREGdb01
Instance EREG2 is not running on node EREGdb02
[oracle@EREGDB01 expdp]$ !sq
SQL> STARTUP
NOMOUNT;
ORACLE instance started.
Total System Global Area 1.5703E+10 bytes
Fixed Size 18424064 bytes
Variable Size 2181038080 bytes
Database Buffers 1.3489E+10 bytes
Redo Buffers 15126528 bytes
SQL> ALTER SYSTEM SET CLUSTER_DATABASE=FALSE SCOPE=SPFILE SID='*';
System altered.
SQL> shut
immediate
ORA-01507: database not mounted
ORACLE instance shut down.
SQL> STARTUP UPGRADE;
ORACLE instance started.
Total System Global Area 1.5703E+10 bytes
Fixed Size 18424064 bytes
Variable Size 2181038080 bytes
Database Buffers 1.3489E+10 bytes
Redo Buffers 15126528 bytes
Database mounted.
Database opened.
SQL>
SQL>
@?/rdbms/admin/utltz_upg_check.sql
Session altered.
INFO: Starting with RDBMS DST update
preparation.
INFO: NO actual RDBMS DST update will be done by this script.
INFO: If an ERROR occurs the script will EXIT sqlplus.
INFO: Doing checks for known issues ...
INFO: Database version is 19.0.0.0 .
INFO: Database RDBMS DST version is DSTv32 .
INFO: No known issues detected.
INFO: Now detecting new RDBMS DST version.
A prepare window has been successfully started.
INFO: Newest RDBMS DST version detected is DSTv45 .
INFO: Next step is checking all TSTZ data.
INFO: It might take a while before any further output is seen ...
A prepare window has been successfully ended.
INFO: A newer RDBMS DST version than the one currently used is found.
INFO: Note that NO DST update was yet done.
INFO: Now run utltz_upg_apply.sql to do the actual RDBMS DST update.
INFO: Note that the utltz_upg_apply.sql script will
INFO: restart the database 2 times WITHOUT any confirmation or prompt.
Session altered.
SQL> @?/rdbms/admin/utltz_upg_apply.sql
Session altered.
INFO: If an ERROR occurs, the script will
EXIT SQL*Plus.
INFO: The database RDBMS DST version will be updated to DSTv45 .
WARNING: This script will restart the database 2 times
WARNING: WITHOUT asking ANY confirmation.
WARNING: Hit control-c NOW if this is not intended.
SCRIPT
--------------------------------------------------------------------------------------------------------------------------------
?/rdbms/admin/utltz_upg_apply_patch.sql
INFO: Restarting the database in UPGRADE mode to start the DST upgrade.
Database closed.
Database dismounted.
ORACLE instance shut down.
ORACLE instance started.
Total System Global Area 1.5703E+10 bytes
Fixed Size 18424064 bytes
Variable Size 2181038080 bytes
Database Buffers 1.3489E+10 bytes
Redo Buffers 15126528 bytes
Database mounted.
Database opened.
INFO: Starting the RDBMS DST upgrade.
INFO: Upgrading all SYS owned TSTZ data.
INFO: It might take time before any further output is seen ...
An upgrade window has been successfully started.
INFO: Restarting the database in NORMAL mode to upgrade non-SYS TSTZ data.
Database closed.
Database dismounted.
ORACLE instance shut down.
ORACLE instance started.
Total System Global Area 1.5703E+10 bytes
Fixed Size 18424064 bytes
Variable Size 2181038080 bytes
Database Buffers 1.3489E+10 bytes
Redo Buffers 15126528 bytes
Database mounted.
Database opened.
INFO: Upgrading all non-SYS TSTZ data.
INFO: It might take time before any further output is seen ...
INFO: Do NOT start any application yet that uses TSTZ data!
INFO: Next is a list of all upgraded tables:
Table list: "GSMADMIN_INTERNAL"."AQ$_CHANGE_LOG_QUEUE_TABLE_L"
Number of failures: 0
Table list: "GSMADMIN_INTERNAL"."AQ$_CHANGE_LOG_QUEUE_TABLE_S"
Number of failures: 0
Table list: "MDSYS"."SDO_DIAG_MESSAGES_TABLE"
Number of failures: 0
Table list: "DVSYS"."AUDIT_TRAIL$"
Number of failures: 0
Table list: "DVSYS"."SIMULATION_LOG$"
Number of failures: 0
INFO: Total failures during update of TSTZ data: 0 .
An upgrade window has been successfully ended.
INFO: Your new Server RDBMS DST version is DSTv45 .
INFO: The RDBMS DST update is successfully finished.
INFO: Make sure to exit this SQL*Plus session.
INFO: Do not use it for timezone related selects.
Session altered.
SQL>
SQL>
SQL> ALTER SYSTEM SET CLUSTER_DATABASE=TRUE SCOPE=SPFILE SID='*';
System altered.
SQL> shut
immediate
[oracle@EREGDB01 expdp]$ srvctl start database -db EREGP
[oracle@EREGDB01 expdp]$ srvctl status database -db EREGP
Instance EREG1 is running on node EREGdb01
Instance EREG2 is running on node EREGdb02
[oracle@EREGDB01 expdp]$ !sq
sqlplus / as sysdba
SQL*Plus: Release 19.0.0.0.0 - Production on
Sun Aug 16 13:48:22 2026
Version 19.32.0.0.0
Copyright (c) 1982, 2026, Oracle. All rights reserved.
Connected to:
Oracle Database 19c Enterprise Edition Release 19.0.0.0.0 - Production
Version 19.32.0.0.0
SQL> SELECT
VERSION FROM V$TIMEZONE_FILE;
VERSION
----------
45
SQL> exit
===============================================================
#####--- importing backup from EXPDP
===============================================================
SQL> SELECT
VERSION FROM V$TIMEZONE_FILE;-- verify soure and target and upgrade
appropriate( eles import will fail)
VERSION
----------
32
SQL>
SQL> show parameter db_create
NAME TYPE VALUE
------------------------------------ ----------- ------------------------------
db_create_file_dest string +DATA
SQL>
SQL> set linesize 200;
select name,open_mode,LOG_MODE,FLASHBACK_ON,FORCE_LOGGING from v$database;
NAME
OPEN_MODE LOG_MODE FLASHBACK_ON FORCE_LOGGING
--------- ---------- ------------ ------------------ ---------------------------------------
EREG READ WRITE ARCHIVELOG NO NO
SQL>
SQL> alter database flashback on;
Database altered.
SQL> create
restore point before_imp guarantee flashback database;
Restore point created.
SQL> create or replace directory expdp as
'/u01/app/oracle/expdp';
Directory created.
SQL> !mkdir -p /u01/app/oracle/expdp
SQL> select name from gv$restore_point;
NAME
--------------------------------------------------------------------------------
BEFORE_IMP
BEFORE_IMP
SQL>
select a.tablespace_name,
A.Allocated, B.Freespace,round(b.freespace/a.allocated*100) "PCT % Free"
from (select tablespace_name ,sum(bytes)/1024/1024/1024 Allocated from dba_data_files group by tablespace_name) A ,
(select tablespace_name,sum(bytes)/1024/1024/1024 Freespace
from dba_free_space group by tablespace_name) B
where a.tablespace_name=b.tablespace_name(+)
--and b.tablespace_name in ('USERS','SYSTEM','SYSAUX')--to check status of individual Tablespace
ORDER BY "PCT % Free";
SELECT name, total_mb, free_mb, (total_mb - free_mb)/total_mb*100 AS USED_PCT FROM v$asm_diskgroup;
select name,time from v$restore_point;
SELECT VERSION FROM V$TIMEZONE_FILE;
SELECT DIRECTORY_PATH FROM dba_directories where DIRECTORY_NAME='EXPDP';
TABLESPACE_NAME ALLOCATED FREESPACE PCT % Free
------------------------------ ---------- ---------- ----------
SYSAUX .693359375 .003173828 0
UNDOTBS1 1.06933594 .002197266 0
SYSTEM 1.1328125 .007202148 1
USERS .004882813 .002258301 46
UNDOTBS2 .024414063 .016052246 66
SQL>
NAME TOTAL_MB FREE_MB USED_PCT
------------------------------ ---------- ---------- ----------
OCR 102396 102032 .355482636
DATA 921588 907300 1.55036741
RECO 307196 296608 3.44665946
SQL>
SQL>
NAME
--------------------------------------------------------------------------------------------------------------------------------
TIME
---------------------------------------------------------------------------
BEFORE_IMP
17-AUG-26 12.30.23.000000000 PM
SQL>
VERSION
----------
45
SQL>
DIRECTORY_PATH
--------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
/u01/app/oracle/expdp
SQL>
SQL>
===============================================================
#####--- now execute import command
===============================================================
for restore steps
SQL> startup mount
SQL> select name from gv$restore_point;
SQL> flashback database to restore point before_imp; (approx. 2 mins) works even if we delete archivelog all
Flashback complete.
SQL> alter database open resetlogs;
SQL> drop restore point before_imp;
SQL> create restore point before_imp guarantee flashback database;
SQL> shutdown immediate
$ srvctl start database –d EREGP
Database name: EREG
Oracle home: /u01/app/oracle/product/19.0.0/dbhome_1
Oracle user: oracle
Spfile: +DATA/EREG/PARAMETERFILE/spfile.268.1241438749
Password file: +DATA/EREG/PASSWORD/pwdereg.256.1241437899
Domain:
Start options: open
Stop options: immediate
Database role: PRIMARY
Management policy: AUTOMATIC
Server pools:
Disk Groups: RECO,DATA
Mount point paths:
Services:
Type: RAC
Start concurrency:
Stop concurrency:
OSDBA group: oinstall
OSOPER group: oinstall
Database instances: EREG1,EREG2
Configured nodes: EREGdb01,EREGdb02
CSS critical: no
CPU count: 0
Memory target: 0
Maximum memory: 0
Default network number for database services:
Database is administrator managed
[oracle@EREGDB01 ~]$
SQL> show parameter spfile;
------------------------------------ ----------- ------------------------------
spfile string +DATA/EREG/PARAMETERFILE/spfil
e.268.1241438749
SQL>SQL> select name from v$controlfile;
--------------------------------------------------------------------------------
+DATA/EREG/CONTROLFILE/current.261.1241438037
+RECO/EREG/CONTROLFILE/current.256.1241438037
set linesize 200 pagesize 200
col MEMBER for a50
SELECT * FROM V$LOGFILE;
select GROUP#,THREAD#,SEQUENCE#,bytes/1024/1024,MEMBERS,STATUS from v$log;
GROUP# STATUS TYPE MEMBER IS_ CON_ID
---------- ------- ------- -------------------------------------------------- --- ----------
2 ONLINE +DATA/EREG/ONLINELOG/group_2.263.1241438039 NO 0
2 ONLINE +RECO/EREG/ONLINELOG/group_2.257.1241438039 YES 0
1 ONLINE +DATA/EREG/ONLINELOG/group_1.262.1241438039 NO 0
1 ONLINE +RECO/EREG/ONLINELOG/group_1.258.1241438039 YES 0
3 ONLINE +DATA/EREG/ONLINELOG/group_3.266.1241438747 NO 0
3 ONLINE +RECO/EREG/ONLINELOG/group_3.259.1241438747 YES 0
4 ONLINE +DATA/EREG/ONLINELOG/group_4.267.1241438747 NO 0
4 ONLINE +RECO/EREG/ONLINELOG/group_4.260.1241438749 YES 0
GROUP# THREAD# SEQUENCE# BYTES/1024/1024 MEMBERS STATUS
---------- ---------- ---------- --------------- ---------- ----------------
1 1 13 200 2 INACTIVE
2 1 14 200 2 CURRENT
3 2 1 200 2 INACTIVE
4 2 2 200 2 CURRENT
col FILE_NAME for a45;
select TABLESPACE_NAME, FILE_NAME,STATUS from dba_data_files;
SQL>
-------------------- --------------------------------------------- ---------
SYSTEM +DATA/EREG/DATAFILE/system.257.1241437921 AVAILABLE
SYSAUX +DATA/EREG/DATAFILE/sysaux.258.1241437957 AVAILABLE
UNDOTBS2 +DATA/EREG/DATAFILE/undotbs2.265.1241438661 AVAILABLE
USERS +DATA/EREG/DATAFILE/users.260.1241437983 AVAILABLE
UNDOTBS1 +DATA/EREG/DATAFILE/undotbs1.259.1241437981 AVAILABLE
------------------------------------ ----------- ------------------------------
cdb_cluster_name string
cell_offloadgroup_name string
db_file_name_convert string
db_name string EREG
db_unique_name string EREG
global_names boolean FALSE
instance_name string EREG1
lock_name_space string
log_file_name_convert string
mfa_sender_email_displayname string
pdb_file_name_convert string
------------------------------------ ----------- ------------------------------
processor_group_name string
service_names string EREG
SQL>
Database log mode Archive Mode
Automatic archival Enabled
Archive destination USE_DB_RECOVERY_FILE_DEST
Oldest online log sequence 14
Next log sequence to archive 15
Current log sequence 15
SQL>
SQL> set linesize 300;
col HOST_NAME for a9;
col OPEN_MODE for a10;
select INSTANCE_NUMBER,INSTANCE_NAME,HOST_NAME,STATUS,DATABASE_STATUS,INSTANCE_ROLE,ACTIVE_STATE,INSTANCE_MODE from gv$instance;SQL> SQL> SQL>
--------------- ---------------- --------- ------------ ----------------- ------------------ --------- -----------
1 EREG1 EREG OPEN ACTIVE PRIMARY_INSTANCE NORMAL REGULAR
DB01.areef
.com
DB02.areef
.com
SQL> set linesize 200;
select name,open_mode,LOG_MODE,FLASHBACK_ON,FORCE_LOGGING from v$database;
--------- ---------- ------------ ------------------ ---------------------------------------
EREG READ WRITE ARCHIVELOG NO NO
SQL> SELECT VERSION FROM V$TIMEZONE_FILE;-- verify soure and target and upgrade appropriate( eles import will fail)
----------
32
#####--- change unique name EREG to EREGP
===============================================================
[oracle@EREGDB01 ~]$ srvctl stop database -d EREG
[oracle@EREGDB01 ~]$ srvctl remove database -d EREG
Remove the database EREG? (y/[n]) y
[oracle@EREGDB01 ~]$ sqlplus / as sysdba
Version 19.32.0.0.0
ORA-01078: failure in processing system parameters
LRM-00109: could not open parameter file '/u01/app/oracle/product/19.0.0/dbhome_1/dbs/initEREG1.ora'
SQL> exit
Disconnected
[oracle@EREGDB01 ~]$ cd $ORACLE_HOME/dbs
[oracle@EREGDB01 dbs]$ ls -ltrh
total 27M
-rw-r--r-- 1 oracle oinstall 3.1K May 14 2015 init.ora
-rw-r----- 1 oracle asmadmin 19M Aug 16 12:17 snapcf_EREG1.f
-rw-r----- 1 oracle asmadmin 8.0M Aug 16 12:56 id_EREG1.dat
-rw-rw---- 1 oracle asmadmin 1.6K Aug 16 12:56 hc_EREG1.dat
[oracle@EREGDB01 dbs]$ vi initEREG1.ora
[oracle@EREGDB01 dbs]$ cat initEREG1.ora
spfile='+DATA/EREG/PARAMETERFILE/spfile.268.1241438749'
[oracle@EREGDB01 dbs]$
[oracle@EREGDB01 dbs]$ sqlplus / as sysdba
Version 19.32.0.0.0
ORACLE instance started.
Fixed Size 18424064 bytes
Variable Size 2113929216 bytes
Database Buffers 1.3556E+10 bytes
Redo Buffers 15126528 bytes
SQL> alter system set db_unique_name='EREGP' scope=spfile sid='*';
ORA-01507: database not mounted
SQL> exit
Disconnected from Oracle Database 19c Enterprise Edition Release 19.0.0.0.0 - Production
Version 19.32.0.0.0
[oracle@EREGDB01 dbs]$ cat initEREG1.ora
spfile='+DATA/EREG/PARAMETERFILE/spfile.268.1241438749'
[oracle@EREGDB01 dbs]$
[oracle@EREGDB01 dbs]$ srvctl add database -db EREGP -dbname EREG \
-oraclehome /u01/app/oracle/product/19.0.0/dbhome_1 \
-spfile +DATA/EREG/PARAMETERFILE/spfile.268.1241438749 \
-pwfile +DATA/EREG/PASSWORD/pwdereg.256.1241437899 \
-role PRIMARY -diskgroup "RECO,DATA" \
-dbtype RAC
[oracle@EREGDB01 dbs]$
[oracle@EREGDB01 dbs]$ srvctl config database
EREGP
[oracle@EREGDB01 dbs]$ srvctl add instance -db EREGP -instance EREG1 -node EREGdb01
[oracle@EREGDB01 dbs]$ srvctl add instance -db EREGP -instance EREG2 -node EREGdb02
[oracle@EREGDB01 dbs]$
[oracle@EREGDB01 dbs]$ srvctl config database -d EREGP
Database unique name: EREGP
Database name: EREG
Oracle home: /u01/app/oracle/product/19.0.0/dbhome_1
Oracle user: oracle
Spfile: +DATA/EREG/PARAMETERFILE/spfile.268.1241438749
Password file: +DATA/EREG/PASSWORD/pwdereg.256.1241437899
Domain:
Start options: open
Stop options: immediate
Database role: PRIMARY
Management policy: AUTOMATIC
Server pools:
Disk Groups: RECO,DATA
Mount point paths:
Services:
Type: RAC
Start concurrency:
Stop concurrency:
OSDBA group: oinstall
OSOPER group: oinstall
Database instances: EREG1,EREG2
Configured nodes: EREGdb01,EREGdb02
CSS critical: no
CPU count: 0
Memory target: 0
Maximum memory: 0
Default network number for database services:
Database is administrator managed
[oracle@EREGDB01 dbs]$ srvctl start database -db EREGP
------------------------------------ ----------- ------------------------------
cdb_cluster_name string
cell_offloadgroup_name string
db_file_name_convert string
db_name string EREG
db_unique_name string EREGP
global_names boolean FALSE
instance_name string EREG1
lock_name_space string
log_file_name_convert string
mfa_sender_email_displayname string
pdb_file_name_convert string
------------------------------------ ----------- ------------------------------
processor_group_name string
service_names string EREGP
SQL> exit
Disconnected from Oracle Database 19c Enterprise Edition Release 19.0.0.0.0 - Production
Version 19.32.0.0.0
[oracle@EREGDB01 dbs]$ cat $TNS_ADMIN/tnsnames.ora
# tnsnames.ora Network Configuration File: /u01/app/oracle/product/19.0.0/dbhome_1/network/admin/tnsnames.ora
# Generated by Oracle configuration tools.
(DESCRIPTION =
(ADDRESS = (PROTOCOL = TCP)(HOST = scan-ereg)(PORT = 1531))
(CONNECT_DATA =
(SERVER = DEDICATED)
(SERVICE_NAME = EREG)
)
)
[oracle@EREGDB01 dbs]$ lsnrctl status
STATUS of the LISTENER
------------------------
Alias LISTENER
Version TNSLSNR for Linux: Version 19.0.0.0.0 - Production
Start Date 16-AUG-2026 11:27:46
Uptime 0 days 1 hr. 39 min. 44 sec
Trace Level off
Security ON: Local OS Authentication
SNMP OFF
Listener Parameter File /u01/app/19.0.0/grid/network/admin/listener.ora
Listener Log File /u01/app/grid/diag/tnslsnr/EREGDB01/listener/alert/log.xml
Listening Endpoints Summary...
(DESCRIPTION=(ADDRESS=(PROTOCOL=ipc)(KEY=LISTENER)))
(DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=10.98.132.76)(PORT=1521)))
(DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=10.98.132.230)(PORT=1521)))
Services Summary...
Service "+ASM" has 1 instance(s).
Instance "+ASM1", status READY, has 1 handler(s) for this service...
Service "+ASM_DATA" has 1 instance(s).
Instance "+ASM1", status READY, has 1 handler(s) for this service...
Service "+ASM_OCR" has 1 instance(s).
Instance "+ASM1", status READY, has 1 handler(s) for this service...
Service "+ASM_RECO" has 1 instance(s).
Instance "+ASM1", status READY, has 1 handler(s) for this service...
Service "EREGP" has 1 instance(s).
Instance "EREG1", status READY, has 1 handler(s) for this service...
Service "EREGXDB" has 1 instance(s).
Instance "EREG1", status READY, has 1 handler(s) for this service...
The command completed successfully
[oracle@EREGDB01 dbs]$
#####--- update time zone
===============================================================
----------
32
SQL> SELECT DBMS_DST.GET_LATEST_TIMEZONE_VERSION FROM DUAL;
---------------------------
45
Instance EREG1 is not running on node EREGdb01
Instance EREG2 is not running on node EREGdb02
[oracle@EREGDB01 expdp]$ !sq
ORACLE instance started.
Fixed Size 18424064 bytes
Variable Size 2181038080 bytes
Database Buffers 1.3489E+10 bytes
Redo Buffers 15126528 bytes
SQL> ALTER SYSTEM SET CLUSTER_DATABASE=FALSE SCOPE=SPFILE SID='*';
ORA-01507: database not mounted
SQL> STARTUP UPGRADE;
ORACLE instance started.
Fixed Size 18424064 bytes
Variable Size 2181038080 bytes
Database Buffers 1.3489E+10 bytes
Redo Buffers 15126528 bytes
Database mounted.
Database opened.
SQL>
INFO: NO actual RDBMS DST update will be done by this script.
INFO: If an ERROR occurs the script will EXIT sqlplus.
INFO: Doing checks for known issues ...
INFO: Database version is 19.0.0.0 .
INFO: Database RDBMS DST version is DSTv32 .
INFO: No known issues detected.
INFO: Now detecting new RDBMS DST version.
A prepare window has been successfully started.
INFO: Newest RDBMS DST version detected is DSTv45 .
INFO: Next step is checking all TSTZ data.
INFO: It might take a while before any further output is seen ...
A prepare window has been successfully ended.
INFO: A newer RDBMS DST version than the one currently used is found.
INFO: Note that NO DST update was yet done.
INFO: Now run utltz_upg_apply.sql to do the actual RDBMS DST update.
INFO: Note that the utltz_upg_apply.sql script will
INFO: restart the database 2 times WITHOUT any confirmation or prompt.
INFO: The database RDBMS DST version will be updated to DSTv45 .
WARNING: This script will restart the database 2 times
WARNING: WITHOUT asking ANY confirmation.
WARNING: Hit control-c NOW if this is not intended.
--------------------------------------------------------------------------------------------------------------------------------
?/rdbms/admin/utltz_upg_apply_patch.sql
INFO: Restarting the database in UPGRADE mode to start the DST upgrade.
Database closed.
Database dismounted.
ORACLE instance shut down.
ORACLE instance started.
Fixed Size 18424064 bytes
Variable Size 2181038080 bytes
Database Buffers 1.3489E+10 bytes
Redo Buffers 15126528 bytes
Database mounted.
Database opened.
INFO: Starting the RDBMS DST upgrade.
INFO: Upgrading all SYS owned TSTZ data.
INFO: It might take time before any further output is seen ...
An upgrade window has been successfully started.
INFO: Restarting the database in NORMAL mode to upgrade non-SYS TSTZ data.
Database closed.
Database dismounted.
ORACLE instance shut down.
ORACLE instance started.
Fixed Size 18424064 bytes
Variable Size 2181038080 bytes
Database Buffers 1.3489E+10 bytes
Redo Buffers 15126528 bytes
Database mounted.
Database opened.
INFO: Upgrading all non-SYS TSTZ data.
INFO: It might take time before any further output is seen ...
INFO: Do NOT start any application yet that uses TSTZ data!
INFO: Next is a list of all upgraded tables:
Table list: "GSMADMIN_INTERNAL"."AQ$_CHANGE_LOG_QUEUE_TABLE_L"
Number of failures: 0
Table list: "GSMADMIN_INTERNAL"."AQ$_CHANGE_LOG_QUEUE_TABLE_S"
Number of failures: 0
Table list: "MDSYS"."SDO_DIAG_MESSAGES_TABLE"
Number of failures: 0
Table list: "DVSYS"."AUDIT_TRAIL$"
Number of failures: 0
Table list: "DVSYS"."SIMULATION_LOG$"
Number of failures: 0
INFO: Total failures during update of TSTZ data: 0 .
An upgrade window has been successfully ended.
INFO: Your new Server RDBMS DST version is DSTv45 .
INFO: The RDBMS DST update is successfully finished.
INFO: Make sure to exit this SQL*Plus session.
INFO: Do not use it for timezone related selects.
SQL>
SQL> ALTER SYSTEM SET CLUSTER_DATABASE=TRUE SCOPE=SPFILE SID='*';
[oracle@EREGDB01 expdp]$ srvctl start database -db EREGP
[oracle@EREGDB01 expdp]$ srvctl status database -db EREGP
Instance EREG1 is running on node EREGdb01
Instance EREG2 is running on node EREGdb02
[oracle@EREGDB01 expdp]$ !sq
sqlplus / as sysdba
Version 19.32.0.0.0
Oracle Database 19c Enterprise Edition Release 19.0.0.0.0 - Production
Version 19.32.0.0.0
----------
45
#####--- importing backup from EXPDP
===============================================================
----------
32
------------------------------------ ----------- ------------------------------
db_create_file_dest string +DATA
SQL>
SQL> set linesize 200;
select name,open_mode,LOG_MODE,FLASHBACK_ON,FORCE_LOGGING from v$database;
--------- ---------- ------------ ------------------ ---------------------------------------
EREG READ WRITE ARCHIVELOG NO NO
SQL> alter database flashback on;
--------------------------------------------------------------------------------
BEFORE_IMP
BEFORE_IMP
A.Allocated, B.Freespace,round(b.freespace/a.allocated*100) "PCT % Free"
from (select tablespace_name ,sum(bytes)/1024/1024/1024 Allocated from dba_data_files group by tablespace_name) A ,
(select tablespace_name,sum(bytes)/1024/1024/1024 Freespace
from dba_free_space group by tablespace_name) B
where a.tablespace_name=b.tablespace_name(+)
--and b.tablespace_name in ('USERS','SYSTEM','SYSAUX')--to check status of individual Tablespace
ORDER BY "PCT % Free";
SELECT name, total_mb, free_mb, (total_mb - free_mb)/total_mb*100 AS USED_PCT FROM v$asm_diskgroup;
select name,time from v$restore_point;
SELECT VERSION FROM V$TIMEZONE_FILE;
SELECT DIRECTORY_PATH FROM dba_directories where DIRECTORY_NAME='EXPDP';
------------------------------ ---------- ---------- ----------
SYSAUX .693359375 .003173828 0
UNDOTBS1 1.06933594 .002197266 0
SYSTEM 1.1328125 .007202148 1
USERS .004882813 .002258301 46
UNDOTBS2 .024414063 .016052246 66
NAME TOTAL_MB FREE_MB USED_PCT
------------------------------ ---------- ---------- ----------
OCR 102396 102032 .355482636
DATA 921588 907300 1.55036741
RECO 307196 296608 3.44665946
SQL>
NAME
--------------------------------------------------------------------------------------------------------------------------------
TIME
---------------------------------------------------------------------------
BEFORE_IMP
17-AUG-26 12.30.23.000000000 PM
VERSION
----------
45
DIRECTORY_PATH
--------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
/u01/app/oracle/expdp
SQL>
#####--- now execute import command
===============================================================
for restore steps
SQL> startup mount
SQL> select name from gv$restore_point;
SQL> flashback database to restore point before_imp; (approx. 2 mins) works even if we delete archivelog all
SQL> drop restore point before_imp;
SQL> create restore point before_imp guarantee flashback database;
SQL> shutdown immediate
$ srvctl start database –d EREGP
------------------------------ ---------- ---------- ----------
SYSAUX .693359375 .003173828 0
SYSTEM 1.1328125 .007202148 1
USERS .004882813 .002258301 46
NAME TOTAL_MB FREE_MB USED_PCT
------------------------------ ---------- ---------- ----------
OCR 102396 102032 .355482636
DATA 921588 907300 1.55036741
RECO 307196 296608 3.44665946
NAME
--------------------------------------------------------------------------------------------------------------------------------
TIME
---------------------------------------------------------------------------
BEFORE_IMP
17-AUG-26 12.30.23.000000000 PM
VERSION
----------
45
DIRECTORY_PATH
--------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
/u01/app/oracle/expdp
Instance EREG2 is running on node EREGdb02
grant connect,resource,dba to areef1 identified by areef1;
CREATE OR REPLACE DIRECTORY EXPDP AS '/u01/app/oracle/expdp';
alter tablespace system add datafile '+DATA' size 1G autoextend on next 1G maxsize 30G;
show user
[oracle@EREGDB01 expdp]$ ls -ltrh /u01/app/oracle/expdp/*
total 42G
-rw-r----- 1 oracle oinstall 42G Aug 16 10:28 NEREG2_15-08-26.dmp
[oracle@EREGDB01 expdp]$ time impdp system/sys DIRECTORY=expdp DUMPFILE= NEREG2_15-08-26.dmp LOGFILE= NEREG2_15-08-26_imp.log FULL=Y METRICS=Y logtime=all
16-AUG-26 20:43:56.620: Job "SYSTEM"."SYS_IMPORT_FULL_01" completed with 364 error(s) at Sun Aug 16 20:43:56 2026 elapsed 0 06:54:53
17-AUG-26 15:03:32.107: Job "SYSTEM"."SYS_IMPORT_FULL_01" completed with 362 error(s) at Mon Aug 17 15:03:32 2026 elapsed 0 02:21:55
TABLESPACE_NAME ALLOCATED FREESPACE PCT % Free
------------------------------ ---------- ---------- ----------
USERS 52.1643066 2.49127197 5
SYSAUX 1.3671875 .185668945 14
SYSTEM 20.5195313 9.70910645 47
RMAN> delete noprompt archivelog all;
SQL>
NAME TOTAL_MB FREE_MB USED_PCT
------------------------------ ---------- ---------- ----------
OCR 102396 102032 .355482636
DATA 921588 470960 48.896904
RECO 307196 290612 5.39850779
SQL>
Automatic archival Enabled
Archive destination USE_DB_RECOVERY_FILE_DEST
Oldest online log sequence 2006
Next log sequence to archive 2007
Current log sequence 2007
SQL>
#####--- Post Steps for invalid and Gather stats (10 + 5 + 1) mins in total
===============================================================
----------
11649
----------
309
set sqlprompt "_user'@'_connect_identifier 'on' _date> "
alter session set nls_date_format='dd-Mon-yyyy hh24:mi:ss';
show user
dbms_stats.gather_schema_stats('SYS',options=>'GATHER STALE', estimate_percent => DBMS_STATS.AUTO_SAMPLE_SIZE,method_opt => 'FOR ALL COLUMNS SIZE AUTO',cascade => TRUE);
end;
/
PL/SQL procedure successfully completed.
15:18:56 SYS@EREG1 on 17-Aug-2026 15:18:56> exec dbms_stats.gather_fixed_objects_stats;
15:20:49 SYS@EREG1 on 17-Aug-2026 15:20:49> exec dbms_stats.gather_dictionary_stats;
set sqlprompt "_user'@'_connect_identifier 'on' _date> "
alter session set nls_date_format='dd-Mon-yyyy hh24:mi:ss';
show user
SQL> begin
dbms_stats.gather_schema_stats('SYS',options=>'GATHER STALE', estimate_percent => DBMS_STATS.AUTO_SAMPLE_SIZE,method_opt => 'FOR ALL COLUMNS SIZE AUTO',cascade => TRUE);
end;
/
SQL> exec dbms_stats.gather_fixed_objects_stats; --X$% tables last_analyzed gets updated
SQL> exec dbms_stats.gather_dictionary_stats;
SQL>
===============================================================
#####---
===============================================================
##############
dbms_stats.gather_schema_stats('SYS',options=>'GATHER STALE', estimate_percent => DBMS_STATS.AUTO_SAMPLE_SIZE,method_opt => 'FOR ALL COLUMNS SIZE AUTO',cascade => TRUE);
end;
/
SQL> exec dbms_stats.gather_fixed_objects_stats; --X$% tables last_analyzed gets updated
SQL> exec dbms_stats.gather_dictionary_stats;
SQL>
#####---
===============================================================
##############
