Home » RDBMS Server » Server Administration » ORA-01078: failure in processing system parameters (Oracle,10.2.0.3.0, Windows xp)
ORA-01078: failure in processing system parameters [message #333768] Mon, 14 July 2008 07:13 Go to next message
saikumar_mudigonda
Messages: 23
Registered: June 2008
Location: hyderabad
Junior Member
Dear All,

I am having an issue while creating another SID on my existing database. When i am trying to exectue the following statment via a batch file i am getting the following error.


SQL> CREATE SPFILE = '%ORACLE_HOME%\database\spfileNOV61.ora' [CODE]FROM
  2  	    PFILE =  '%ORACLE_BASE%\admin\NOV61\pfile\initNOV61.ora'
  3  ;
CREATE SPFILE = '%ORACLE_HOME%\database\spfileNOV61.ora' FROM
*
ERROR at line 1:
ORA-01078: failure in processing system parameters 
LRM-00109: could not open parameter file 
'D:\ORACLE\PRODUCT\10.2.0\ADMIN\NOV61\PFILE\INITNOV61.ORA' [/CODE]

can any one pls help me what went wrong exactly, when i am trying to bringup the same database from command promt, it is coming up without any issues.

thanks
Sai Kumar
Re: ORA-01078: failure in processing system parameters [message #333772 is a reply to message #333768] Mon, 14 July 2008 07:23 Go to previous message
Mahesh Rajendran
Messages: 10708
Registered: March 2002
Location: oracleDocoVille
Senior Member
Account Moderator
>> when i am trying to bringup the same database from command promt, it is coming up without any issues.
I fail to understand the relevance here.
It seems you are trying to create an spfile from nonexistent pfile.
Check the directory for pfile.
Previous Topic: How Can I calculate the DBIO_EXPECTED?
Next Topic: ORA-02049: timeout: distributed transaction waiting for lock
Goto Forum:
  


Current Time: Fri Nov 29 19:30:33 CST 2024