Category Archives: Oracle

scsi_id on CentOS 6 on VMware returns null

Posted on by • Posted in ASM, Linux, Oracle, VMware • Tagged , , , , , • 3 Comments

You may find the scsi_id command returns a null result in CentOS 6 or RHEL 6 on VMware.

[root@localhost ~]# scsi_id -g -u -d /dev/sdb
[root@localhost ~]#

 
The problem here is that VMware Workstation does not provide unique SCSI identifiers to the virtual SCSI devices. We need to modify the VMX file to make this happen by adding the following directive:

disk.EnableUUID = "TRUE"

 
Restart the VM and now the scsi_id command should work:

[root@localhost ~]# scsi_id -g -u -d /dev/sdb
36000c2980c56d98cc5150a0ac103058d

11gR2 Grid install – clscfg.bin: error while loading shared libraries: libcap.so.1: cannot open shared object file

Posted on by • Posted in ASM, Linux, Oracle • Tagged , , , , , • 3 Comments

You are installing 11gR2 11.2.0.1 Grid Infrastructure on Red Hat 6, CentOS 6 or similar Linux operating system, and right at the very end of the process, the root.sh script blows up with a really odd error:

[root@localhost oraInventory]# cd /u01/app/oracle/product/11.2.0/db_1
[root@localhost db_1]# ./root.sh
Running Oracle 11g root.sh script...

Continue reading →

Oracle 11gR2 2-node RAC on VMware Workstation 9

Posted on by • Posted in Linux, Oracle, RAC, VMware • Tagged , , , , • 1 Comment

Last week I was in Dallas, Texas meeting with some customers and reminding myself what sunny weather looks like.

I took the opportunity to hook up with my friend and colleague Lester Wells, an awesome EMC guy based out of Dallas, and who is also an expert in all things Oracle.

Sitting in the Champps bar near to DFW, we decided, as geeks are often want to do, to see if the 11gR2 RAC on VMware Workstation 8, the process for which is shown in this blog, would also work under Lester’s VMware Workstation 9.

Two guys, two laptops, a table close to wall sockets and more than just a few beers later, happily it turns out that everything worked exactly the same under Workstation 9, as it did under Workstation 8.

If you’re running under Workstation 8 you can go ahead and upgrade, it won’t break anything.

If you are wishing to create a RAC under your Workstation 9, the ten part process will work just the same.

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

Posted on by • Posted in Linux, Oracle, RAC, VMware • Tagged , , , , • 21 Comments

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

Posted on by • Posted in ASM, Linux, Oracle, RAC, VMware • Tagged , , , , , , , , • 27 Comments

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 RAC – sshUserSetup.sh script to swap ssh keys between hosts

Posted on by • Posted in Linux, Oracle, RAC • Tagged , , , , • 1 Comment

Oracle 11gR2 RAC Grid install includes a useful script to establish and exchange ssh keys between hosts of the cluster.

The process to set up and exchange ssh keys between hosts to facilitate unchallenged logins between trusted users has been well documented already. Oracle simply provides a handy wrapper script over the whole process.

Although the main Grid install process will set up ssh keys, this is a useful verification step to ensure all nodes are reachable, as well as a prerequisite to having the cluvfy script succeed.

Continue reading →

Oracle 11gR2 – clean up after failed database install

Posted on by • Posted in Linux, Oracle • Tagged , , , • Leave a comment

So your Oracle database install crashes and burns and you are left with a mess to clean up.

Oracle now provides some canned de-install scripts to try to do this for you, but in my experience they are about as useful as a chocolate teapot.

First, let’s verify where Oracle did the install.  Check the oraInst.loc file in the /etc directory:

Continue reading →

Oracle 11gR2 RAC install – installer hangs at 65%

Posted on by • Posted in Linux, Oracle, RAC • Tagged , , , , , • Leave a comment

During the install of Oracle 11gR2 RAC Grid, the installer hangs at 65%, with no errors on screen or in the log file.

The problem is the Linux firewall interfering with the install.

Before running the runInstaller script, make sure the firewall is disabled on ALL nodes. Connect as root and disable it as follows:

[root@tbird1 ~]# service iptables stop
Flushing firewall rules: [  OK  ]
Setting chains to policy ACCEPT: filter [  OK  ]
Unloading iptables modules: [  OK  ]

 

To make sure it stays permanently disabled use the following:

[root@tbird1 init.d]# chkconfig iptables off