Pfile - Spfile errors
Posted on 2007-11-14
Getting the following error when trying to restart my Oracle Database. I have been getting errors from the database complaining that it was running out of processes. I shutdown the database and opened the spfile specific to the database having the problem. I increased the processes from 100 to 200 and saved file. I then attempted to restart the database. I get the following error.
ORA-01078: failure in processing system parameters
LRM-00109: could not open parameter file '/opt/oracle/OraHome1/dbs/initMXTEST.ora'
Researching the error on the web I found a possible solution.
"ORA-01078: failure in processing system parameters
There was an incorrect parameter specified in the startup file for Oracle (init<SID>.ora).
Remove the incorrect parameter or value from the init file and restart the database.
Usually the init file can be found in your %ORACLE_HOME%\database (Windows) or $ORACLE_HOME/dbs (Unix) directory.
It might be that this pfile links to antoher pfile (ifile=) or spfile (spfile=). Just follow the location to find the correct startup file.
Should you be using an spfile instead of a pfile, you can create a pfile using following command:
create pfile from spfile;
This pfile will be created in the default destination, as specified above."
I have tried to run this create command with no luck. It does not exist in the bin directory for oracle. Can someone give me direction on how I can restart my database successfully?