Using the SPFILE in a VCS Cluster
When using the Oracle enterprise agent, you can start a database instance by specifying a PFILE. If you do not specify the PFILE, the database instance starts up using the default SPFILE.
- The agent attribute Pfile must specify the location of the PFILE. If your configuration uses the SPFILE, the contents of the PFILE must specify the location of the SPFILE, which must be created from the PFILE.
Note
VERITAS recommends that the SPFILE be located on shared storage, preferably at the same location as that of the database control files.
Specifying the SPFILE Location in the PFILE
To specify the location of the SPFILE in a PFILE, create the following entry in the PFILE:
SPFILE = spfile_location
The variable spfile_location represents the complete path of the SPFILE. For example:
SPFILE = /database/startup/spfileora1.ora
In this case, to start the database use the following command:
startup pfile=location_of_pfile
Creating the SPFILE from a PFILE
The SPFILE must be created from the PFILE. You must have the sysdba or the sysoper system privileges to create an SPFILE.
You can run the following command to create the SPFILE:
CREATE SPFILE [= spfile_name] FROM PFILE [= pfile_name ];
If you do not specify the complete path for the SPFILE, this commands creates an SPFILE at the default location ($ORACLE_HOME/dbs on UNIX).
|
