How to Create an SPFILE from a PFILE in Oracle Database

To create an SPFILE (server parameter file) from a PFILE (text-based initialization parameter file), you can use the following steps:

1. Connect to your Oracle database as a user with SYSDBA privileges.

sqlplus / as sysdba

2. If you don't have an existing SPFILE, create a new one using the PFILE.

CREATE SPFILE='<path_to_spfile>' FROM PFILE='<path_to_pfile>';

Replace '<path_to_spfile>' with the desired path and filename for the SPFILE, and '<path_to_pfile>' with the path and filename of your PFILE.

Example:

CREATE SPFILE='/u01/app/oracle/product/12.2.0/dbhome_1/dbs/spfileORCL.ora' FROM PFILE='/u01/app/oracle/product/12.2.0/dbhome_1/dbs/initORCL.ora';

3. Verify that the SPFILE was created successfully.

SHOW PARAMETER spfile;

This command will display the current value of the `spfile` parameter, which should now point to the newly created SPFILE.

That's it! You have successfully created an SPFILE from a PFILE. The SPFILE is a binary file that is automatically read by Oracle during database startup, while the PFILE is a text-based file that can be edited manually.