Solved

Pfile - Spfile errors

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

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.  …
From implementing a password expiration date, to datatype conversions and file export options, these are some useful settings I've found in Jasper Server.
This video explains at a high level about the four available data types in Oracle and how dates can be manipulated by the user to get data into and out of the database.
This video shows how to recover a database from a user managed backup

770 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