create spfile from pfile

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.