RE: Veritas cluster and Oracle database startup

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