Execute the following query to see if your database was started with a PFILE or SPFILE:
SELECT DECODE(value, NULL, 'PFILE', 'SPFILE') "Init File Type" FROM sys.v_$parameter WHERE name = 'spfile';
I am writing at my blog for future reference. I am writing Oracle related experiences and stuffs. I have over 7 years of Oracle DBA experience, I am also Oracle 11g DBA & 10g DBA Certified Professional. If you want to hire me on Permanent / Contract / Project basis then do contact me at email@example.com or firstname.lastname@example.org.