Add parameter_file Property Section to Setting HA for Oracle Database Extension Properties in Oracle Solaris Cluster Data Service for Oracle Database Guide (33131714)

The parameter_file property specifies the location of an ASCII parameter file (pfile). The file you specify can also include the location of a binary version of the pfile called an spfile.

When you specify a parameter_file property value, the startup command run by the SUNW.oracle_server resource includes pfile=location-specified-by-$PARAMETER_FILE.

If you want to use an spfile instead of a pfile, use one of the following options:

• Specify an empty value for the parameter_file property so that the database uses its default search path to find the startup command.

• Create a pfile that contains the full path to a binary spfile. Then, specify the full path to the pfile as the value of the parameter_file property. The pfile references the full path to the spfile as a value of the SPFILE variable. For example, the $ORACLE_HOME/dbs/init$ORACLE_SID.ora pfile includes a line similar to SPFILE=$ORACLE_HOME/dbs/spfile$ORACLE_SID.ora. Then, update the Oracle Solaris Cluster HA Oracle resource's parameter_file property to specify this pfile.

• Use the spfile to create a pfile and then reference the new pfile as the parameter_file property value. At the SQL> prompt, specify the CREATE PFILE = 'init$ORACLE_SID.ora' FROM SPFILE = 'spfile$ORACLE_SID.ora'; command. Then, update the Oracle Solaris Cluster HA Oracle resource's parameter_file property to specify this pfile.