Oracle FAQ Your Portal to the Oracle Knowledge Grid

Home -> Community -> Mailing Lists -> Oracle-L -> Veritas cluster and Oracle database startup

Veritas cluster and Oracle database startup

From: Lou Avrami <>
Date: Tue, 26 Dec 2006 14:14:02 -0500 (EST)
Message-ID: <>

Hello all,

We are experiencing an interesting problem that hopefully someone has encountered previously.

We have an Oracle database that is running on a Solaris 9 server. The server is part of a Veritas cluster, so that if either the server itself or the database go down, the cluster detaches the filesystems associated with the database to another server, mounts them up and starts the listener and the database.

A test of the system works fine, with one caveat: after failing over, apparently the database is being started with the pfile=init.ora option, instead of using the spfile:

SQL> alter system set undo_suppress_errors=true scope=both; alter system set undo_suppress_errors=true scope=both *
ERROR at line 1:
ORA-32001: write to SPFILE requested but no SPFILE specified at startup

It seems that a PFILE specification is required by the Veritas cluster software. Is this absolutely necessary? Our preference would be to have an pfile and spfile defined separately, and to start up the database with the spfile. Our preference would be to NOT specify a pfile on startup, so that the database uses the spfile.

I know that we can just have the pfile point to the spfile, but our preference would be to have a pfile with the database values in it, so that we can drop it into SCCS and track what changes are made and when they are made.

If any one can pass along andy info about the requirments for Veritas clustering, it would be greatly appreciated. I will also post this question to a Veritas group.

The Veritas cluster software version info is below.

Lou Avrami

      NAME:  VERITAS Cluster Server Cluster Manager
  CATEGORY:  optional
      ARCH:  sparc
   VERSION:  4.3
   BASEDIR:  /
    VENDOR:  VERITAS Software Corp.
      DESC:  VERITAS Cluster Server Cluster Manager
    PSTAMP:  4.3P1 11/08/05-20:55:48
  INSTDATE:  Dec 08 2006 14:49
    STATUS:  completely installed
     FILES:      216 installed pathnames
                   3 shared pathnames
                  21 directories
                   2 executables
               14930 blocks used (approx)

Received on Tue Dec 26 2006 - 13:14:02 CST

Original text of this message