Search This Blog

Total Pageviews

Saturday, 5 September 2026

Oracle grid installtion




curl -o oracle-database-preinstall-19c-1.0-1.el9.x86_64.rpm https://yum.oracle.com/repo/OracleLinux/OL9/appstream/x86_64/getPackage/oracle-database-preinstall-19c-1.0-1.el9.x86_64.rpm

dnf -y localinstall oracle-database-preinstall-19c-1.0-1.el9.x86_64.rpm



[root@oragrid dev]# ip a
1: lo:  mtu 65536 qdisc noqueue state UNKNOWN group default qlen 1000
    link/loopback 00:00:00:00:00:00 brd 00:00:00:00:00:00
    inet 127.0.0.1/8 scope host lo
       valid_lft forever preferred_lft forever
    inet6 ::1/128 scope host
       valid_lft forever preferred_lft forever
2: enp0s3:  mtu 1500 qdisc fq_codel state UP group default qlen 1000
    link/ether 08:00:27:8a:2c:28 brd ff:ff:ff:ff:ff:ff
    inet 192.168.1.247/24 brd 192.168.1.255 scope global dynamic noprefixroute enp0s3
       valid_lft 86023sec preferred_lft 86023sec
    inet6 2a0e:cb01:14f:3200:a00:27ff:fe8a:2c28/64 scope global dynamic noprefixroute
       valid_lft 545sec preferred_lft 544sec
    inet6 fe80::a00:27ff:fe8a:2c28/64 scope link noprefixroute
       valid_lft forever preferred_lft forever
[root@oragrid dev]#




https://anuj-singh.blogspot.com/2024/11/vm-tool-on-vm-box.html
curl -o oracle-database-preinstall-19c-1.0-1.el9.x86_64.rpm https://yum.oracle.com/repo/OracleLinux/OL9/appstream/x86_64/getPackage/oracle-database-preinstall-19c-1.0-1.el9.x86_64.rpm
   33  ls -ltr
   34  dnf -y localinstall oracle-database-preinstall-19c-1.0-1.el9.x86_64.rpm




cat /etc/sysctl.conf|egrep -i 'fs.file-max|kernel.sem|kernel.|net.|fs.|net.'



cat /etc/sysctl.conf|egrep -i 'fs.file-max|kernel.sem|kernel.|net.|fs.|net.'
# oracle-database-preinstall-19c setting for fs.file-max is 6815744
fs.file-max = 6815744
# oracle-database-preinstall-19c setting for kernel.sem is '250 32000 100 128'
kernel.sem = 250 32000 100 128
# oracle-database-preinstall-19c setting for kernel.shmmni is 4096
kernel.shmmni = 4096
# oracle-database-preinstall-19c setting for kernel.shmall is 1073741824 on x86_64
kernel.shmall = 1073741824
# oracle-database-preinstall-19c setting for kernel.shmmax is 4398046511104 on x86_64
kernel.shmmax = 4398046511104
# oracle-database-preinstall-19c setting for kernel.panic_on_oops is 1 per Orabug 19212317
kernel.panic_on_oops = 1
# oracle-database-preinstall-19c setting for net.core.rmem_default is 262144
net.core.rmem_default = 262144
# oracle-database-preinstall-19c setting for net.core.rmem_max is 4194304
net.core.rmem_max = 4194304
# oracle-database-preinstall-19c setting for net.core.wmem_default is 262144
net.core.wmem_default = 262144
# oracle-database-preinstall-19c setting for net.core.wmem_max is 1048576
net.core.wmem_max = 1048576
# oracle-database-preinstall-19c setting for net.ipv4.conf.all.rp_filter is 2
net.ipv4.conf.all.rp_filter = 2
# oracle-database-preinstall-19c setting for net.ipv4.conf.default.rp_filter is 2
net.ipv4.conf.default.rp_filter = 2
# oracle-database-preinstall-19c setting for fs.aio-max-nr is 1048576
fs.aio-max-nr = 1048576
# oracle-database-preinstall-19c setting for net.ipv4.ip_local_port_range is 9000 65500
net.ipv4.ip_local_port_range = 9000 65500
[root@oragrid ~]#





 cat /etc/group|egrep -i 'oinstall|dba|oper|backupdba|dgdba|kmdba|asmdba|asmoper|asmadmin|racdba'|uniq
oinstall:x:54321:oracle
dba:x:54322:oracle
oper:x:54323:oracle
backupdba:x:54324:oracle
dgdba:x:54325:oracle
kmdba:x:54326:oracle
racdba:x:54330:oracle
asmdba:x:54327:
asmoper:x:54328:
asmadmin:x:54329:

[root@oragrid ~]#





groupadd -g 54321 oinstall
groupadd -g 54322 dba
groupadd -g 54323 oper
groupadd -g 54324 backupdba
groupadd -g 54325 dgdba
groupadd -g 54326 kmdba
groupadd -g 54327 asmdba
groupadd -g 54328 asmoper
groupadd -g 54329 asmadmin
groupadd -g 54330 racdba




mkdir -p /u01/app/19.3.0/grid
chown -R grid:oinstall  /u01/app/19.3.0/grid
chmod -R 775 /u01/app/19.3.0/grid 




systemctl status  avahi-daemon
systemctl stop avahi-daemon
systemctl disable avahi-daemon




C:\VM-Box\Ora-grid>"C:\Program Files\Oracle\VirtualBox\VBoxManage.exe" createhd --filename "C:\VM-Box\Ora-grid\data_01.vdi" --size 20480 --format VDI --variant Fixed
0%...10%...20%...30%...40%...50%...60%...70%...80%...90%...100%
Medium created. UUID: 1b5f2ff3-be5e-44a9-bf6d-7dd0e8d5a0fb

C:\VM-Box\Ora-grid>



c:\Program Files\Oracle\VirtualBox\VBoxManage" createhd --filename "C:\VM-Box\Ora-grid\data_01.vdi" --size 20480 --format VDI --variant Fixed


C:\VM-Box\Ora-grid



cd /dev
ls sd*|grep -v [12]|grep -v a


[root@oragrid ~]# ls /dev/sd*|grep -v [12]|grep -v a
/dev/sdb
[root@oragrid ~]#


C:\Users\anuj2804\Downloads\



$ sudo rpm -ivh oracleasm-support-3.1.0-10.el9.x86_64.rpm
$ sudo rpm -ivh oracleasmlib-3.1.0-6.el9.x86_64.rpm



https://edelivery.oracle.com/
Oracle ASMLib for Oracle Linux 9 3.1



https://yum.oracle.com/repo/OracleLinux/OL9/addons/x86_64/index.html
oracleasm-support-3.1.1-5.el9.x86_64.rpm




[root@oragrid ~]# rpm -ivh oracleasm-support-3.1.1-5.el9.x86_64.rpm
warning: oracleasm-support-3.1.1-5.el9.x86_64.rpm: Header V4 RSA/SHA256 Signature, key ID 8d8b756f: NOKEY
Verifying...                          ################################# [100%]
Preparing...                          ################################# [100%]
Updating / installing...
   1:oracleasm-support-3.1.1-5.el9    ################################# [100%]
Created symlink /etc/systemd/system/multi-user.target.wants/oracleasm.service → /usr/lib/systemd/system/oracleasm.service.

[root@oragrid ~]# rpm -ivh oracleasmlib-3.1.1-1.el9.x86_64.rpm
warning: oracleasmlib-3.1.1-1.el9.x86_64.rpm: Header V4 RSA/SHA256 Signature, key ID 8d8b756f: NOKEY
Verifying...                          ################################# [100%]
Preparing...                          ################################# [100%]
Updating / installing...
   1:oracleasmlib-3.1.1-1.el9         ################################# [100%]
[root@oragrid ~]#




[root@oragrid ~]# /usr/sbin/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  without
typing an answer will keep that current value.  Ctrl-C will abort.

Default user to own the ASM disk devices []: oracle
Default group to own the ASM disk devices []: dba
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]: y

WARNING: I/O filtering not supported with Linux 5.14.0-708.el9.x86_64 on x86_64

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@oragrid ~]#






[root@oragrid ~]# /usr/sbin/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  without
typing an answer will keep that current value.  Ctrl-C will abort.

Default user to own the ASM disk devices []: oracle
Default group to own the ASM disk devices []: dba
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]: y

WARNING: I/O filtering not supported with Linux 5.14.0-708.el9.x86_64 on x86_64

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@oragrid ~]# /usr/sbin/oracleasm configure
ORACLEASM_UID=oracle
ORACLEASM_GID=dba
ORACLEASM_SCANBOOT=true
ORACLEASM_SCANORDER=""
ORACLEASM_SCANEXCLUDE=""
ORACLEASM_SCAN_DIRECTORIES=""
ORACLEASM_USE_LOGICAL_BLOCK_SIZE="false"
ORACLEASM_CONFIG_MAX_DISKS="2048"
ORACLEASM_ENABLE_IOFILTER="true"
[root@oragrid ~]#



[root@oragrid ~]# rpm -qa | grep bpf
libbpf-1.5.0-3.el9.x86_64
bpftool-7.5.0-804.el9.x86_64
[root@oragrid ~]#



 cat /sf_working/scripts/asm_mapping.sh
#!/bin/sh -e
for disk in `/etc/init.d/oracleasm listdisks`
do
oracleasm querydisk -d $disk
#ls -l /dev/*|grep -E `oracleasm querydisk -d $disk|awk '{print $NF}'|sed s'/.$//'|sed '1s/^.//'|awk -F, '{print $1 ",.*" $2}'`
# Alternate option to remove []
ls -l /dev/*|grep -E `oracleasm querydisk -d $disk|awk '{print $NF}'|sed 's/[][]//g'|awk -F, '{print $1 ",.*" $2}'`
echo
done





 blkid|grep asm


[root@oel9 ~]# systemctl restart oracleasm
[root@oel9 ~]# systemctl status oracleasm


[root@oragrid ~]# systemctl status oracleasm
● oracleasm.service - Oracle ASM Service
     Loaded: loaded (/usr/lib/systemd/system/oracleasm.service; enabled; preset>
     Active: active (exited) since Sun 2026-05-31 18:32:01 BST; 13s ago
    Process: 4119 ExecStartPre=/usr/bin/udevadm settle -t 120 (code=exited, sta>
    Process: 4120 ExecStart=/usr/sbin/oracleasm.init start (code=exited, status>
   Main PID: 4120 (code=exited, status=0/SUCCESS)
        CPU: 336ms

May 31 18:32:01 oragrid systemd[1]: Starting Oracle ASM Service...
May 31 18:32:01 oragrid oracleasm.init[4136]: Mounting oracleasm driver filesys>
May 31 18:32:01 oragrid oracleasm.init[4147]: Reloading disk partitions: done
May 31 18:32:01 oragrid oracleasm.init[4147]: Cleaning any stale ASM disks...
May 31 18:32:01 oragrid oracleasm.init[4158]: WARNING: I/O filtering not suppor>
May 31 18:32:01 oragrid oracleasm.init[4163]: Scanning system for ASM disks...
May 31 18:32:01 oragrid oracleasm.init[4183]: Disk scan successful
May 31 18:32:01 oragrid systemd[1]: Finished Oracle ASM Service.
lines 1


C:\Users\anuj2804\OneDrive - Rackspace Inc\Temp---



https://ronekins.com/2025/07/11/installation-and-configuration-of-the-new-oracle-asmlib-v3-1-on-oracle-linux-9/#asmlib-download

You will need to fix this before continuing. To do this add a new entry of kernel.io_uring_disabled = 0 to the end of /etc/sysctl.conf.

Once updated, update the kernel with sysctl -p and check setting with sysctl kernel.io_uring_disabled.

$ sudo sudo sysctl -p 
$ sysctl kernel.io_uring_disabled




 mkdir -p /u01/app/grid/19.3.0/gridhome_1
 mkdir -p /u01/app/grid/gridbase/
mkdir -p /u01/app/oracle/database/19.3.0/dbhome_1
chown -R oracle.oinstall /u01/
chown -R grid.oinstall /u01/app/grid
chmod -R 775 /u01/


mkdir -p /u01/app/19.3.0/grid
mkdir -p /u01/19.3.0/grid

[root@oragrid ~]# mkdir -p /u01/app/19.3.0/grid
[root@oragrid ~]# mkdir -p /u01/19.3.0/grid
[root@oragrid ~]# mkdir -p /u01/app/oraInventory
[root@oragrid ~]#




groupadd -g oinstall
groupadd -g dba
groupadd -g  asmadmin
groupadd -g  asmdba
groupadd -g  asmoper



[root@oragrid ~]# /usr/sbin/useradd -u 3001 -g oinstall -G asmdba,dba,asmadmin oracle
useradd: user 'oracle' already exists
[root@oragrid ~]# /usr/sbin/usermod  -g oinstall -G asmdba,dba,asmadmin oracle
[root@oragrid ~]# id oracle
uid=54321(oracle) gid=54321(oinstall) groups=54321(oinstall),54322(dba),3003(asmadmin),3004(asmdba)
[root@oragrid ~]# id grid
uid=3000(grid) gid=54321(oinstall) groups=54321(oinstall),54322(dba),3003(asmadmin),3004(asmdba),3005(asmoper)
[root@oragrid ~]# passwd oracle
Changing password for user oracle.
New password:
BAD PASSWORD: The password is shorter than 8 characters
Retype new password:
passwd: all authentication tokens updated successfully.
[root@oragrid ~]#



mkdir -p /u01/app/grid ( ORACLE_BASE for GRID HOME )
# mkdir -p /u01/app/19.0.0/grid         ( GRID_HOME )
# chown -R grid:oinstall /u01

# mkdir -p /u01/app/oracle              ( ORACLE_BASE for ORACLE HOME ) 
# mkdir -p /u01/app/oracle/product/19.0.0/dbhome_1 ( ORACLE HOME )
# chown -R oracle:oinstall /u01/app/oracle

# chmod -R 775 /u01/

[root@testbox ~]# mkdir -p /u01/app/19.0.0/grid
[root@testbox ~]# mkdir -p /u01/app/grid
[root@testbox ~]# chown -R grid:oinstall /u01
[root@testbox ~]#
[root@testbox ~]# mkdir -p /u01/app/oracle
[root@testbox ~]# mkdir -p /u01/app/oracle/product/19.0.0/dbhome_1
[root@testbox ~]# chown -R oracle:oinstall /u01/app/oracle
[root@testbox ~]# chmod -R 775 /u01/
[root@testbox ~]#



/usr/sbin/useradd -u 3000 -g oinstall -G asmdba,dba,asmadmin,asmoper grid
passwd grid
/usr/sbin/useradd -u 3001 -g oinstall -G asmdba,dba,asmadmin oracle
/usr/sbin/usermod  -g oinstall -G asmdba,dba,asmadmin oracle
id oracle
id grid
passwd oracle
ls -ltr /u01/19.3.0/grid
history
rm -rf /u01
mkdir -p /u01/app/grid
mkdir -p /u01/app/19.0.0/grid
 chown -R grid:oinstall /u01
mkdir -p /u01/app/oracle
mkdir -p /u01/app/oracle/product/19.0.0/dbhome_1
chown -R grid:oinstall /u01
chown -R oracle:oinstall /u01/app/oracle
chmod -R 775 /u01/
ls -ld /u01/app/19.0.0/grid
ls -ld /u01/app/grid
ls -ld /u01/app/oracle
ls -ld /u01/app/oracle/product/19.0.0/dbhome_1



[root@oragrid ~]# ls -ltr /dev/sdb*
brw-rw----. 1 root disk 8, 16 Jun  1 19:59 /dev/sdb
brw-rw----. 1 root disk 8, 17 Jun  1 19:59 /dev/sdb1
[root@oragrid ~]#



https://edelivery.oracle.com/

https://yum.oracle.com/repo/OracleLinux/OL8/addons/x86_64/index.html   oracleasm-support-3.1.1-4.el8.x86_64.rpm



 dnf install -y https://yum.oracle.com/repo/OracleLinux/OL8/developer/UEKR7/x86_64/getPackage/libbpf-0.6.0-6.el8.x86_64.rpm
Last metadata expiration check: 0:59:20 ago on Mon 01 Jun 2026 19:15:46 BST.
libbpf-0.6.0-6.el8.x86_64.rpm                                                                                71 kB/s | 162 kB     00:02
Dependencies resolved.
============================================================================================================================================
 Package                       Architecture                  Version                              Repository                           Size
============================================================================================================================================
Upgrading:
 libbpf                        x86_64                        2:0.6.0-6.el8                        @commandline                        162 k

Transaction Summary
============================================================================================================================================
Upgrade  1 Package

Total size: 162 k
Downloading Packages:
Running transaction check
Transaction check succeeded.
Running transaction test
Transaction test succeeded.
Running transaction
  Preparing        :                                                                                                                    1/1
  Upgrading        : libbpf-2:0.6.0-6.el8.x86_64                                                                                        1/2
  Cleanup          : libbpf-0.4.0-1.el8.x86_64                                                                                          2/2
  Running scriptlet: libbpf-0.4.0-1.el8.x86_64                                                                                          2/2
  Verifying        : libbpf-2:0.6.0-6.el8.x86_64                                                                                        1/2
  Verifying        : libbpf-0.4.0-1.el8.x86_64                                                                                          2/2

Upgraded:
  libbpf-2:0.6.0-6.el8.x86_64

Complete!
[root@oragrid ~]#





[root@oragrid ~]# dnf -y localinstall oracleasmlib-3.1.1-1.el8.x86_64.rpm oracleasm-support-3.1.1-4.el8.x86_64.rpm
Last metadata expiration check: 0:59:43 ago on Mon 01 Jun 2026 19:15:46 BST.
Dependencies resolved.
============================================================================================================================================
 Package                               Architecture               Version                            Repository                        Size
============================================================================================================================================
Installing:
 oracleasm-support                     x86_64                     3.1.1-4.el8                        @commandline                      87 k
 oracleasmlib                          x86_64                     3.1.1-1.el8                        @commandline                      52 k

Transaction Summary
============================================================================================================================================
Install  2 Packages

Total size: 138 k
Installed size: 415 k
Downloading Packages:
Running transaction check
Transaction check succeeded.
Running transaction test
Transaction test succeeded.
Running transaction
  Preparing        :                                                                                                                    1/1
  Installing       : oracleasm-support-3.1.1-4.el8.x86_64                                                                               1/2
  Running scriptlet: oracleasm-support-3.1.1-4.el8.x86_64                                                                               1/2
Created symlink /etc/systemd/system/multi-user.target.wants/oracleasm.service → /usr/lib/systemd/system/oracleasm.service.

  Installing       : oracleasmlib-3.1.1-1.el8.x86_64                                                                                    2/2
  Running scriptlet: oracleasmlib-3.1.1-1.el8.x86_64                                                                                    2/2
  Verifying        : oracleasmlib-3.1.1-1.el8.x86_64                                                                                    1/2
  Verifying        : oracleasm-support-3.1.1-4.el8.x86_64                                                                               2/2

Installed:
  oracleasm-support-3.1.1-4.el8.x86_64                                    oracleasmlib-3.1.1-1.el8.x86_64

Complete!
[root@oragrid ~]#



[root@oragrid ~]# systemctl start oracleasm
[root@oragrid ~]# systemctl status oracleasm
● oracleasm.service - Oracle ASM Service
   Loaded: loaded (/usr/lib/systemd/system/oracleasm.service; enabled; vendor preset: disabled)
   Active: active (exited) since Mon 2026-06-01 20:25:01 BST; 8s ago
  Process: 11147 ExecStart=/usr/sbin/oracleasm.init start (code=exited, status=0/SUCCESS)
  Process: 11145 ExecStartPre=/usr/bin/udevadm settle -t 120 (code=exited, status=0/SUCCESS)
 Main PID: 11147 (code=exited, status=0/SUCCESS)

Jun 01 20:25:01 oragrid systemd[1]: Starting Oracle ASM Service...
Jun 01 20:25:01 oragrid oracleasm.init[11147]: Mounting oracleasm driver filesystem: Not applicable with Linux 4.18.0-348.7.1.el8_5.x86_64
Jun 01 20:25:01 oragrid oracleasm.init[11147]: Reloading disk partitions: done
Jun 01 20:25:01 oragrid oracleasm.init[11147]: Cleaning any stale ASM disks...
Jun 01 20:25:01 oragrid oracleasm.init[11147]: Scanning system for ASM disks...
Jun 01 20:25:01 oragrid oracleasm.init[11147]: Disk scan successful
Jun 01 20:25:01 oragrid systemd[1]: Started Oracle ASM Service.
[root@oragrid ~]#


https://yum.oracle.com/repo/OracleLinux/OL8/5/baseos/base/x86_64/index.html

[root@oragrid ~]# yum localinstall ./kmod-redhat-oracleasm-2.0.8-12.0.1.el8.x86_64.rpm
Last metadata expiration check: 0:08:11 ago on Mon 01 Jun 2026 20:28:43 BST.
Dependencies resolved.
============================================================================================================================================
 Package                                 Architecture             Version                              Repository                      Size
============================================================================================================================================
Installing:
 kmod-redhat-oracleasm                   x86_64                   8:2.0.8-12.0.1.el8                   @commandline                    44 k

Transaction Summary
============================================================================================================================================
Install  1 Package

Total size: 44 k
Installed size: 138 k
Is this ok [y/N]: y
Downloading Packages:
Running transaction check
Transaction check succeeded.
Running transaction test
Transaction test succeeded.
Running transaction
  Preparing        :                                                                                                                    1/1
  Installing       : kmod-redhat-oracleasm-8:2.0.8-12.0.1.el8.x86_64                                                                    1/1
  Running scriptlet: kmod-redhat-oracleasm-8:2.0.8-12.0.1.el8.x86_64                                                                    1/1


rpm -qa | grep oracleasm
oracleasm-support-3.1.1-4.el8.x86_64
kmod-redhat-oracleasm-2.0.8-12.0.1.el8.x86_64
oracleasmlib-3.1.1-1.el8.x86_64
[root@oragrid ~]#



Oracle DBA

anuj blog Archive