Oracle Database 19c RAC Kurulumu Grid Infrastructure Part 2

Oracle Database 19c RAC Kurulumu

Part 2

Oracle Database 19c Grid Infrastructure

Openfiler iscsi 200gb diskin linux’e tanıtılması

[root@orarac1 ~]# iscsiadm -m discovery -t sendtargets -p 192.168.10.200

192.168.10.200:3260,1 iqn.2006-01.com.openfiler:tsn.7293befd6f01

[root@orarac1 ~]# iscsiadm -m node -T iqn.2006-01.com.openfiler:tsn.7293befd6f01 –op update -n node.startup -v automatic

[root@orarac2 ~]# iscsiadm -m discovery -t sendtargets -p 192.168.10.200

192.168.10.200:3260,1 iqn.2006-01.com.openfiler:tsn.7293befd6f01

[root@orarac2 ~]# iscsiadm -m node -T iqn.2006-01.com.openfiler:tsn.7293befd6f01 –op update -n node.startup -v automatic

systemctl start iscsi

[root@orarac1 ~]# fdisk -l

Disk /dev/sda: 128.8 GB, 128849018880 bytes, 251658240 sectors

Units = sectors of 1 * 512 = 512 bytes

Sector size (logical/physical): 512 bytes / 512 bytes

I/O size (minimum/optimal): 512 bytes / 512 bytes

Disk label type: dos

Disk identifier: 0x000bbbdb

Device Boot Start End Blocks Id System

/dev/sda1 * 2048 2099199 1048576 83 Linux

/dev/sda2 2099200 251658239 124779520 8e Linux LVM

Disk /dev/mapper/ol_orarac1-root: 119.2 GB, 119181148160 bytes, 232775680 sectors

Units = sectors of 1 * 512 = 512 bytes

Sector size (logical/physical): 512 bytes / 512 bytes

I/O size (minimum/optimal): 512 bytes / 512 bytes

Disk /dev/mapper/ol_orarac1-swap: 8589 MB, 8589934592 bytes, 16777216 sectors

Units = sectors of 1 * 512 = 512 bytes

Sector size (logical/physical): 512 bytes / 512 bytes

I/O size (minimum/optimal): 512 bytes / 512 bytes

Disk /dev/sdb: 204.8 GB, 204782698496 bytes, 399966208 sectors

Units = sectors of 1 * 512 = 512 bytes

Sector size (logical/physical): 512 bytes / 512 bytes

I/O size (minimum/optimal): 512 bytes / 512 bytes

[root@orarac2 ~]# fdisk -l

Disk /dev/sda: 128.8 GB, 128849018880 bytes, 251658240 sectors

Units = sectors of 1 * 512 = 512 bytes

Sector size (logical/physical): 512 bytes / 512 bytes

I/O size (minimum/optimal): 512 bytes / 512 bytes

Disk label type: dos

Disk identifier: 0x000b807e

Device Boot Start End Blocks Id System

/dev/sda1 * 2048 2099199 1048576 83 Linux

/dev/sda2 2099200 251658239 124779520 8e Linux LVM

Disk /dev/mapper/ol-root: 119.2 GB, 119181148160 bytes, 232775680 sectors

Units = sectors of 1 * 512 = 512 bytes

Sector size (logical/physical): 512 bytes / 512 bytes

I/O size (minimum/optimal): 512 bytes / 512 bytes

Disk /dev/mapper/ol-swap: 8589 MB, 8589934592 bytes, 16777216 sectors

Units = sectors of 1 * 512 = 512 bytes

Sector size (logical/physical): 512 bytes / 512 bytes

I/O size (minimum/optimal): 512 bytes / 512 bytes

Disk /dev/sdb: 204.8 GB, 204782698496 bytes, 399966208 sectors

Units = sectors of 1 * 512 = 512 bytes

Sector size (logical/physical): 512 bytes / 512 bytes

I/O size (minimum/optimal): 512 bytes / 512 bytes

Disk Yapılandırma Sadece orarac1 üzerinde yapılacak

[root@orarac1 ~]# fdisk /dev/sdb

Welcome to fdisk (util-linux 2.23.2).

Changes will remain in memory only, until you decide to write them.

Be careful before using the write command.

Device does not contain a recognized partition table

Building a new DOS disklabel with disk identifier 0x1047b99a.

Command (m for help): n

Partition type:

p primary (0 primary, 0 extended, 4 free)

e extended

Select (default p): p

Partition number (1-4, default 1):

First sector (2048-399966207, default 2048):

Using default value 2048

Last sector, +sectors or +size{K,M,G} (2048-399966207, default 399966207):

Using default value 399966207

Partition 1 of type Linux and of size 190.7 GiB is set

Command (m for help): w

The partition table has been altered!

Calling ioctl() to re-read partition table.

Syncing disks.

orarac1 – orarac2 asm disk yapılandırması ve mühürlenmesi

[root@orarac1 ~]# oracleasm configure -I

Configuring the Oracle ASM library driver.

This will configure the on-boot properties of the Oracle ASM library

driver. The following questions will determine whether the driver is

loaded on boot and what permissions it will have. The current values

will be shown in brackets (‘[]’). Hitting <ENTER> without typing an

answer will keep that current value. Ctrl-C will abort.

Default user to own the driver interface []: grid

Default group to own the driver interface []: asmadmin

Start Oracle ASM library driver on boot (y/n) [n]: y

Scan for Oracle ASM disks on boot (y/n) [y]: y

The next two configuration options take substrings to match device names.

The substring “sd” (without the quotes), for example, matches “sda”, “sdb”,

etc. You may enter more than one substring pattern, separated by spaces.

The special string “none” (again, without the quotes) will clear the value.

Device order to scan for ASM disks []:

Devices to exclude from scanning []:

Directories to scan []:

Use device logical block size for ASM (y/n) [n]: y

Writing Oracle ASM library driver configuration: done

[root@orarac2 ~]# oracleasm configure -I

Configuring the Oracle ASM library driver.

This will configure the on-boot properties of the Oracle ASM library

driver. The following questions will determine whether the driver is

loaded on boot and what permissions it will have. The current values

will be shown in brackets (‘[]’). Hitting <ENTER> without typing an

answer will keep that current value. Ctrl-C will abort.

Default user to own the driver interface []: grid

Default group to own the driver interface []: asmadmin

Start Oracle ASM library driver on boot (y/n) [n]: y

Scan for Oracle ASM disks on boot (y/n) [y]: y

The next two configuration options take substrings to match device names.

The substring “sd” (without the quotes), for example, matches “sda”, “sdb”,

etc. You may enter more than one substring pattern, separated by spaces.

The special string “none” (again, without the quotes) will clear the value.

Device order to scan for ASM disks []:

Devices to exclude from scanning []:

Directories to scan []:

Use device logical block size for ASM (y/n) [n]: y

Writing Oracle ASM library driver configuration: done

[root@orarac1 ~]# oracleasm init

Creating /dev/oracleasm mount point: /dev/oracleasm

Loading module “oracleasm”: oracleasm

Configuring “oracleasm” to use device logical block size

Mounting ASMlib driver filesystem: /dev/oracleasm

[root@orarac2 ~]# oracleasm init

Creating /dev/oracleasm mount point: /dev/oracleasm

Loading module “oracleasm”: oracleasm

Configuring “oracleasm” to use device logical block size

Mounting ASMlib driver filesystem: /dev/oracleasm

orarac1 üzerinde iscsi olarak eklenen 200gb /dev/sdb1 diskin asm olarak kullanılması. Diskin ismi DATA olarak oluşturuldu.

[root@orarac1 ~]# oracleasm createdisk data /dev/sdb1

Writing disk header: done

Instantiating disk: done

orarac2 üzerinde diskin check edilmesi. Görüldüğü gibi orarac1 üzerinde oluşturulan DATA isimli disk burada görülüyor.

[root@orarac2 ~]# oracleasm scandisks

Reloading disk partitions: done

Cleaning any stale ASM disks…

Scanning system for ASM disks…

Instantiating disk “DATA”

Oracle Database 19c Grid Infrastructure Kurulumu

/u01/app/grid/19.3.0/grid_1

[grid@orarac1 grid_1]$ unzip LINUX.X64_193000_grid_home.zip

Graphical user interface, text, application, email

Description automatically generated

Graphical user interface, text, application, email

Description automatically generated

Graphical user interface, text, application, email

Description automatically generated

Graphical user interface, email

Description automatically generated

Graphical user interface, text, application, Word

Description automatically generated

Graphical user interface, text, application

Description automatically generated

Graphical user interface

Description automatically generated

Graphical user interface, text, application, email

Description automatically generated

Graphical user interface, text, application, email

Description automatically generated

Graphical user interface, text, application, email

Description automatically generated

Graphical user interface, text, email

Description automatically generated

Graphical user interface, text, application, email

Description automatically generated

Graphical user interface, application, email

Description automatically generated

Graphical user interface, text, application, email

Description automatically generated

Graphical user interface, text, application, email

Description automatically generated

Graphical user interface, text, application, email

Description automatically generated

Graphical user interface, text, email

Description automatically generated

Graphical user interface, text, application

Description automatically generated

Graphical user interface, text, application

Description automatically generated

Graphical user interface, application

Description automatically generated