Confiiguring E-Business Suite to work on Spfile

1.   By default Oracle E-Business Suite is configured to run on Pfile. In this respective work around to configure    E-Business suite to work on spfile is an indirect way of using spfile through pfile and please note that this is not an officially oracle guided way. Even though this work around was before update in metalink, they have later on removed this. I will not be explaining the advantages the SPFILE has over the PFILE, please do a google on this subject.

       1.) Ensure the database is up and running

          2.) Create spfile from pfile 

   SQL> CREATE SPFILE='/oradata/spfileORCL.ora' from PFILE='/oradata/initORCL.ora'

 3.) Shutdown the database and then modify the pfile:

           SQL> Shutdown immediate

a.       Remove all the entries in the pfile (init<sid>.ora)

b.       Only have the following entry in PFILE, i.e. Location to the SPFILE

                       spfile=/oradata/spfileORCL.ora 




4.   4.) Start the database using the adstrtl.sh in order to start the E-Business Suite (Listener, DB & Apps).

Th    That's it!!! And you are ready to run you Database with the SPFILE... Taking favour of the respective  parameter files advantages.