Solved

Pfile - Spfile errors

Posted on 2007-11-14
1
949 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 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

PRTG Network Monitor: Intuitive Network Monitoring

Network Monitoring is essential to ensure that computer systems and network devices are running. Use PRTG to monitor LANs, servers, websites, applications and devices, bandwidth, virtual environments, remote systems, IoT, and many more. PRTG is easy to set up & use.

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…
How to Unravel a Tricky Query Introduction If you browse through the Oracle zones or any of the other database-related zones you'll come across some complicated solutions and sometimes you'll just have to wonder how anyone came up with them.  …
This video explains at a high level with the mandatory Oracle Memory processes are as well as touching on some of the more common optional ones.
This video shows how to copy an entire tablespace from one database to another database using Transportable Tablespace functionality.

821 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