Starting database using PFILE
811119Nov 8 2010 — edited Nov 9 2010Hello, Gurus.
I am a newbie to Oracle. Need to modify the paramters for database, so the use of Pfile is required. But even the Pfile created by oracle is not working correctly.
Below shows the error messages:
SQL> create pfile='C:\responsefiles\oraclesetup\win\pfileoXXbg.ORA' from spfile;
File created.
Now when I am trying to use this file to start the instance, I am getting the error:
C:\Windows\system32>oradim -STARTUP -SID OXXBG -STARTTYPE inst -PFILE 'C:\responsefiles\oraclesetup\win\pfileoXXbg.ORA'
ORA-01078: failure in processing system parameters
I have not modifed or put any comments in the above file, so could not understand the reason for error mesaages. I can start the instance without using PFILE option.
Any ideas are welcome.
Edited by: 808116 on Nov 7, 2010 9:50 PM