Go Premium for a chance to win a PS4. Enter to Win

x
?
Solved

Pfile - Spfile errors

Posted on 2007-11-14
1
Medium Priority
?
954 Views
Last Modified: 2012-05-05
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.

SQL> startup
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?

Thank you,
0
Comment
Question by:Jaziar
1 Comment
 
LVL 1

Accepted Solution

by:
amolghadge earned 1000 total points
ID: 20280962
Hi ,
Try this :
1)  edit the /opt/oracle/OraHome1/dbs/initMXTEST.ora ( for processes parameter ) and save it.
2) startup mount pfile=/opt/oracle/OraHome1/dbs/initMXTEST.ora
3) now create a spfile from pfile . ( create spfile from pfile ) .
4) alter database open .

I think this should work .
Let me know if u still  have a proble ,
0

Featured Post

Learn Veeam advantages over legacy backup

Every day, more and more legacy backup customers switch to Veeam. Technologies designed for the client-server era cannot restore any IT service running in the hybrid cloud within seconds. Learn top Veeam advantages over legacy backup and get Veeam for the price of your renewal

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

This article started out as an Experts-Exchange question, which then grew into a quick tip to go along with an IOUG presentation for the Collaborate confernce and then later grew again into a full blown article with expanded functionality and legacy…
I remember the day when someone asked me to create a user for an application developement. The user should be able to create views and materialized views and, so, I used the following syntax: (CODE) This way, I guessed, I would ensure that use…
This video shows how to Export data from an Oracle database using the Original Export Utility.  The corresponding Import utility, which works the same way is referenced, but not demonstrated.
This video shows how to copy an entire tablespace from one database to another database using Transportable Tablespace functionality.
Suggested Courses

927 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question