Solving INS-06006: Passwordless SSH connectivity during Oracle 19c RAC install

I was recently installing Oracle 19c RAC on a pair of servers running OEL8 UEK.

During the install of Grid Infrastructure the installer repeatedly failed the verification check stating that:

“[INS-06006] Passwordless SSH connectivity not set up between the following nodes(s)”

It is worth remembering that Oracle offers a relatively simple method to set up passwordless ssh connections between machines, which I had used prior to trying to install RAC:

In the Grid Infrastructure directory there is a script called sshUserSetup.sh

Continue reading

UDEV rules for ASM disks on RHEL7

On this blog and elsewhere you will find UDEV rules examples for setting device ownership and naming consistency on older versions of Linux.

With RHEL7 some of the syntax has changed slightly.

This example was created using OEL7 with the Red Hat kernel, but should also work on Red Hat and CentOS.

Continue reading

Oracle 11gR2 2-node RAC on VMware Workstation 8 – Part X

Time Required: 60 minutes

Class Materials:

  • Oracle 11gR2 Database software

Next we are going to install the Oracle Database 11gR2 software.

This is the last part of our ten-part process of installing a two node RAC on VMware Workstation 8.

To begin, download the zip file from the Oracle software download website and unzip on Orpheus. Make sure you are logged into Orpheus as the oracle user so that oracle owns the unzipped files.

Continue reading

Oracle 11gR2 2-node RAC on VMware Workstation 8 – Part IX

Time Required: 60 minutes

Class Materials:

  • Oracle 11gR2 Grid Infrastructure software

Next we are going to install the Oracle Grid Infrastructure software.

The Grid Infrastructure will provide the Cluster software that allows the RAC nodes to communicate, as well as the ASM software to manage the shared disks.

To begin, download the zip file from the Oracle software download website and unzip on Orpheus. Make sure you are logged into Orpheus as the oracle user so that oracle owns the unzipped files.

Continue reading

Oracle 11gR2 2-node RAC on VMware Workstation 8 – Part VIII

Time Required: 60 minutes

Class Materials:

  • 5GB of disk space
  • an ASCII text editor

Next we are going to add some shared disk to our new freshly minted VMs

VMware Workstation makes the allocation of shared disk to VMs very simple. Shared disk has been the biggest obstacle to create Oracle RAC clusters at home, but now VMware gives us a reliable and portable solution that does not require fire-wire hacks, your own NFS server or a SCSI disk array.

Best of all this whole solution can exist on a single laptop, so you can take your RAC on the road.

Continue reading

Oracle 11gR2 2-node RAC on VMware Workstation 8 – Part VII

Time Required: 60 minutes

Class Materials:

  • none

Next we are going to give our two new VMs identities.

As discussed in the previous section, I have decided to name my VMs Orpheus and Eurydice. In this section we will give each machine a hostname plus static IP address on the VMnet2 and VMnet3 networks we created earlier.

This will allow our two operatic lovers to communicate both publicly and privately.

Continue reading

Oracle 11gR2 2-node RAC on VMware Workstation 8 – Part VI

Time Required: 60 minutes

Class Materials:

  • none

Next we are going to create two networks for our RAC system to talk on.

The Oracle RAC system requires at least two network connections between cluster nodes. One network will be the public IP and the second will be a private IP reserved for inter-cluster traffic.

Continue reading

Oracle 11gR2 2-node RAC on VMware Workstation 8 – Part V

Time Required: 20 minutes

Class Materials:

  • oracleasm-support-2.1.7-1.el5.x86_64.rpm
  • oracleasm-2.6.18-194.el5-2.0.5-1.el5.x86_64.rpm
  • oracleasmlib-2.0.4-1.el5.x86_64.rpm

Next we will install the ASMLib drivers that simplify management of ASM on Linux.

ASMLib is an interface between block devices presented to Linux, and the Oracle ASM software that executes as the Oracle user.

Continue reading

Oracle 11gR2 2-node RAC on VMware Workstation 8 – Part IV

Time Required: 20 minutes

Class Materials:

  • none

Next we need to create the Oracle user account, OS groups and mount point.

The Oracle software will be installed and owned by the oracle user account. In additional several OS groups are created that allow other non oracle OS users privileged access to the database and grid resources.

Continue reading