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 |