Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

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

RE: Veritas cluster and Oracle database startup

From: Jeremiah Wilton <jeremiah_at_ora-600.net>
Date: Tue, 26 Dec 2006 11:28:41 -0800
Message-ID: <002201c72924$0dd9fda0$0301a8c0@flbp7000a>


Lou,

I think most VCS users just create in init<SID>.ora with one line:

spfile=<path to spfile>

Then point VCS at the init<SID>.ora:

$ hares -modify ora_ga4 Pfile "<path to init<SID>.ora"

That way you can have your VCS and your spfile too.

Jeremiah Wilton
ORA-600 Consulting
http://www.ora-600.net

-----Original Message-----
On Behalf Of Lou Avrami

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...

...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....

--
http://www.freelists.org/webpage/oracle-l
Received on Tue Dec 26 2006 - 13:28:41 CST

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US