RE: Veritas cluster and Oracle database startup

Lou,
This is a shortcoming in VERITAS Cluster that it does not recognize SPFILE. I had discovered this about two years ago when we were running 3.5 and till date and version 4.1, this has not been resolved. You will need to do the workaround where the PFILE would have a pointer to the SPFILE and this is the only way to resolve this.

Amir
-----Original Message-----

From: oracle-l-bounce_at_freelists.org
[mailto:oracle-l-bounce_at_freelists.org] On Behalf Of Lou Avrami Sent: Tuesday, December 26, 2006 2:14 PM To: oracle-l_at_freelists.org
Subject: Veritas cluster and Oracle database startup

Hello all,

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

We have an Oracle 9.2.0.6 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

   PKGINST:  VRTScscm
      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)

--

http://www.freelists.org/webpage/oracle-l

--

http://www.freelists.org/webpage/oracle-l Received on Wed Dec 27 2006 - 14:55:22 CST