Oracle 12c RAC Installation

Introduction and Storage setup

Introduction:

This document is designed as a step by step explanation of the setup of an Oracle 12c RAC database on an Oracle Linux 6 system using an iSCSI interface to a NAS storage array.

Note:

This document should be used in conjunction with the following documents:

1. Oracle Real Application Clusters Installation Guide, 12c Release 1 (12.1) for Linux and UNIX. (November 2016. part no. E48917-12)

2. Oracle Database Installation Guide for 12c Release 1 (12.1) for Linux  ( August 2016 part no. E41491-16)

Software used:

1. Oracle 12c (12.1.0.2)

2. Oracle Linux 6

Chapters

1. Setup Storage using NAS and iSCSI
2. Prepare Servers for Grid and ASM Installation
3. Install Grid Software
4. Install Database software

Setup Storage using NAS and iSCSI

Step 1: Verify that the iSCSI packages are installed

 # pkginfo SUNWiscsiu SUNWiscsir

 Step 2: Install the iSCSI software

  # yum install iscsi-initiator-utils

Loaded plugins: security
Setting up Install Process
Resolving Dependencies
--> Running transaction check
---> Package iscsi-initiator-utils.x86_64 0:6.2.0.873-14.0.1.el6 will be installed
---> Package lsscsi.x86_64 0:0.23-3.el6 will be installed
--> Finished Dependency Resolution
Dependencies Resolved
================================================================================
 Package Arch Version Repository Size
================================================================================
Installing:
 iscsi-initiator-utils x86_64 6.2.0.873-14.0.1.el6 public_ol6_latest 724 k
 lsscsi x86_64 0.23-3.el6 public_ol6_latest 38 k
Transaction Summary
================================================================================
Install 2 Package(s)
. . .

Step 3: Start iSCSI services

# chkconfig iscsi on

# chkconfig iscsid on

# service iscsi start

# service iscsid start

# shutdown -r now

 Step 4: Connect to the NAS via iSCSI

Discover iSCSI targets

# iscsiadm -m discovery -t sendtargets -p nas1

10.5.1.106:3260,257 iqn.2005-10.org.nas.ctl:linuxdbisci

On node startup connect automatically to all iSCSI disks

# iscsiadm -m node –op update -n node.startup -v automatic

 Login to NAS and map iSCSI disks

# iscsiadm -m node -p primary-nas –login

 View the target disks

# ls -l /dev/disk/by-path/

total 0

lrwxrwxrwx. 1 root root 9 Mar 10 11:10 ip-10.5.1.106:3260-iscsi-iqn.2005-10.org.nas.ctl:linuxdbisci-lun-0 -> ../../sdb

lrwxrwxrwx. 1 root root 9 Mar 10 11:10 pci-0000:00:1f.1-scsi-0:0:0:0 -> ../../sr0

lrwxrwxrwx. 1 root root 9 Mar 10 11:10 pci-0000:01:00.0-scsi-0:1:0:0 -> ../../sda

lrwxrwxrwx. 1 root root 10 Mar 10 11:10 pci-0000:01:00.0-scsi-0:1:0:0-part1 -> ../../sda1

lrwxrwxrwx. 1 root root 10 Mar 10 11:10 pci-0000:01:00.0-scsi-0:1:0:0-part2 -> ../../sda2

 # lsscsi

. . .

[2:1:0:0]              disk                  Dell             VIRTUAL DISK           1028            /dev/sda

[3:0:0:0]             disk                   NAS             iSCSI Disk                    0123          /dev/sdb

Step 5: Format iSCSI disks

# fdisk /dev/sdb

Device contains neither a valid DOS partition table, nor Sun, SGI or OSF disklabel
Building a new DOS disklabel with disk identifier 0x405ec941.
Changes will remain in memory only, until you decide to write them.
After that, of course, the previous content won't be recoverable.

Warning: invalid flag 0x0000 of partition table 4 will be corrected by w(rite)
The device presents a logical sector size that is smaller than
the physical sector size. Aligning to a physical sector (or optimal
I/O) size boundary is recommended, or performance may be impacted.

WARNING: DOS-compatible mode is deprecated. It's strongly recommended to
 switch off the mode (command 'c') and change display units to
  sectors (command 'u').

Command (m for help): n
Command action
  e extended
  p primary partition (1-4)
p
Partition number (1-4): 1
First cylinder (1-28980, default 1): 1
Last cylinder, +cylinders or +size{K,M,G} (1-28980, default 28980):
Using default value 28980

Command (m for help): p

Disk /dev/sdb: 238.4 GB, 238370684928 bytes
255 heads, 63 sectors/track, 28980 cylinders
Units = cylinders of 16065 * 512 = 8225280 bytes
Sector size (logical/physical): 512 bytes / 8192 bytes
I/O size (minimum/optimal): 8192 bytes / 1048576 bytes
Disk identifier: 0x405ec941
  Device Boot      Start      End      Blocks      Id      System
/dev/sdb1              1      28980    232781818+  83      Linux
Partition 1 does not start on physical sector boundary.

Command (m for help): w

The partition table has been altered!
Calling ioctl() to re-read partition table.
Syncing disks.

Check result of disk format

# ls -l /dev/disk/by-path/

total 0

lrwxrwxrwx. 1 root root 9 Mar 10 11:51 ip-10.5.1.106:3260-iscsi-iqn.2005-10.org.nas.ctl:linuxdbisci-lun-0 -> ../../sdb

lrwxrwxrwx. 1 root root 10 Mar 10 11:51 ip-10.5.1.106:3260-iscsi-iqn.2005-10.org.nas.ctl:linuxdbisci-lun-0-part1 -> ../../sdb1

lrwxrwxrwx. 1 root root 9 Mar 10 11:10 pci-0000:00:1f.1-scsi-0:0:0:0 -> ../../sr0

lrwxrwxrwx. 1 root root 9 Mar 10 11:10 pci-0000:01:00.0-scsi-0:1:0:0 -> ../../sda

lrwxrwxrwx. 1 root root 10 Mar 10 11:10 pci-0000:01:00.0-scsi-0:1:0:0-part1 -> ../../sda1

lrwxrwxrwx. 1 root root 10 Mar 10 11:10 pci-0000:01:00.0-scsi-0:1:0:0-part2 -> ../../sda2

Update the other nodes. On the other servers use the partprobe command.

# partprobe

Clean the headers of the block devices if they already existed before the install

# dd if=/dev/zero of=/dev/sdb1 bs=1024 count=500

500+0 records in

500+0 records out

512000 bytes   (512 kB)   copied,   0.00741156 s,   69.1 MB/s

Next: Prepare Servers for Grid and ASM Installation

Advertisements