Solved

Pfile - Spfile errors

Posted on 2007-11-14
1
951 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
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
1 Comment
 
LVL 1

Accepted Solution

by:
amolghadge earned 250 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

MS Dynamics Made Instantly Simpler

Make Your Microsoft Dynamics Investment Count  & Drastically Decrease Training Time by Providing Intuitive Step-By-Step WalkThru Tutorials.

Question has a verified solution.

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

Introduction A previously published article on Experts Exchange ("Joins in Oracle", http://www.experts-exchange.com/Database/Oracle/A_8249-Joins-in-Oracle.html) makes a statement about "Oracle proprietary" joins and mixes the join syntax with gen…
Cursors in Oracle: A cursor is used to process individual rows returned by database system for a query. In oracle every SQL statement executed by the oracle server has a private area. This area contains information about the SQL statement and the…
This video shows information on the Oracle Data Dictionary, starting with the Oracle documentation, explaining the different types of Data Dictionary views available by group and permissions as well as giving examples on how to retrieve data from th…
Via a live example, show how to restore a database from backup after a simulated disk failure using RMAN.
Suggested Courses

615 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