Oracle Clusterware: Third Voting disk on NFS
A voting disk is a critical file for Oracle Clusterware. You must have at least 3 voting disks. If you have „only“ two SAN then you can configure the third on a NFS share.
Oracle supports now a third voting disk on NFS for HPUX. But only for HPUX 11.31 and Oracle Clusterware 10.2.0.2 onwards.
This white paper describse how to configure it:
Using standard NFS to support a third voting disk on an Extended Distance cluster configuration on Linux,AIX,HP, or Solaris (PDF)
Oracle Grid Agent Deployment
To deploy the Agents from the Grid it uses ssh/scp. On HPUX it searchs the scp binary in /usr/local/bin but the binary is in /usr/bin. So you have to create a link:
ln -s /usr/bin/scp /usr/local/bin/scp
In general if the SSH connection check part fails have a look at this logs and search for PROV errors or „not found“:$ORACLE_HOME/sysman/prov/agentpush/logs
Here an example for the bash binary which oracle search in another directory:
oracle:$ORACLE_HOME/oms10g/sysman/prov/agentpush/logs# grep found \
remoteInterfaces2007-10-18_02-46-32-PM.log
INFO: Remote id was found in REMOTE platforminfo.properties
INFO: Errstream [rnode node1]: ksh: /usr/local/bin/bash: not found
The command ksh: /usr/local/bin/bash: not found
The command ksh: /usr/local/bin/bash: not found
INFO: Errstream [rnode node2]: ksh: /usr/local/bin/bash: not found
The command ksh: /usr/local/bin/bash: not found
The command ksh: /usr/local/bin/bash: not found
so I have to create a link on the two target nodes:
ln -s /usr/bin/sh /usr/local/bin/bash
Or simply adapt this file with the correct path:
$ORACLE_HOME/oms10g/sysman/prov/resources/ssPaths_hpi.properties
Oracle Instance Menu depend on oratab
This ksh script creates a menu with the content of the oratab. Hence you can select an Oracle instance, and the script login as sysdba.
Written and tested for:
- HPUX
- Oracle 10gR2 Instances
- ASM non RAC
Enjoy and have fun!
