1.The question is when the database open which parameter file search the database?

 

SPFILE (Binary File) P File (Text File)

1.The question is when the database open which parameter file search the database?

Ans: By default, Oracle Search the SPFILE to open the database because it is the binary file.

SQl>
Show parameter SPFILE (if you get output from this command then you could understand that

database is open by SPFILE otherwise it is open by PFILE.)

Then you will get the path of the location.

From PFile you can create SPFILE .

Command : Create SPFILE FROM PFILE;