Questions about Oracle SFHA installation

[khemmerl]

I have a two node cluster of Sun T31B blade servers that will be eventually used to run my production Oracle databases.  I have completed the installation steps in the Veritas Cluster Server Installation Guide 5.1 Solaris and have a disk group "oraldgbl01" (Oracle local-disk disk group blade 01) and "oraldgbl02" (Oracle local-disk disk group blade 02) on server 01 and 02 respectively to hold the Oracle database software installation.  I also have a disk group "oradatadg" using LUNs from my SAN which will hold the actual Oracle database files, control files, redo logs and archive logs.  One both nodes of the cluster, I have created the mount points for the filesystems that will hold the various Oracle data files (/u02, /u03, ... /u07).  The "oradatadg" contains various volumes (u02, u03, ... u07) which I've put a filesystem on and have manually mounted on the currently active node of the cluster (node 1).

OK, so here are my questions:

1. Do I add entries for /u02, /u03, ... /u07 to /etc/vfstab on both nodes of the cluster?
2. As mentioned, I've completed the steps in the Cluster Server Installation documentation but I'm still a long way from having my database fail over from one node to the other.  Where do I find documentation on configuring and testing SFHA for an Oracle database?

Thanks

Ken

[mikebounds · Accepted solution]

Ken,

You shouldn't add entries for filesystems on the shared diskgroup (oradatadg) to vfstab as these will be controlled by the cluster.  The VCS Oracle agent guide should help you set up your Oracle service group: https://sort.symantec.com/public/documents/sf/5.1/solaris/pdf/vcs_oracle_agent.pdf

Page 120 gives a sample diagram of the service group you will need.  This diadram shows "Volume" resources, but these are optional and nobody uses these now, so you only need "Mount" resources dependent on a diskgroup resource as the diskgroup resource starts the volumes.

Page 21 shows you the example main.cf which effectively shows the attributes for each resource in the sample diagram.

You can create this by editing main.cf manually and restarting VCS, or by using Java GUI, or by using command line.  You can download java GUI by clicking on "Veritas Cluster Server Java Console, Veritas Cluster Server Simulator, Veritas Enterprise Administra..." link at:

http://www.symantec.com/business/products/utilities.jsp?pcid=pcat_business_cont&pvid=20_1

Mike