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'
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
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.