RE: Veritas cluster and Oracle database startup
- From: "Hameed, Amir" <Amir.Hameed@xxxxxxxxx>
- To: <avramil@xxxxxxxxxxxxxx>, <oracle-l@xxxxxxxxxxxxx>
- Date: Wed, 27 Dec 2006 15:55:22 -0500
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@xxxxxxxxxxxxx
[mailto:oracle-l-bounce@xxxxxxxxxxxxx] On Behalf Of Lou Avrami
Sent: Tuesday, December 26, 2006 2:14 PM
To: oracle-l@xxxxxxxxxxxxx
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)
--
//www.freelists.org/webpage/oracle-l
--
//www.freelists.org/webpage/oracle-l
Other related posts:
