Salam Alikom
Ihave installed Oracle 10g on SUSE Linux During the installation, there were no errors. After installation
I used dbstart utility to startup instance When I used Sqlplus as sysdba to startup instance
Oracle told me Connected to an idle instance
when i do startup give this error

ORA-01078: failure in processing system parameters
LRM-00109: could not open parameter file '/opt/oracle/product/oracle_home/dbs/in itorcl.ora'

the instance name is QNET NOT orcl

when i writ comment ENV give the ORACLE_SID=orcl

Your support shall be highly appreciated

There is no way the spfile can be repaired or modified manually.

The solution is to restore a spfile from backup, or recreate a new spfile.


If a SPFILE backup exists, restore it to the original location.
SPFILE backup could be a copy of the spfile or from a RMAN backup.


If the spfile backup does not exist, one can use
an existing pfile or the list of non-default parameters listed in the alert log
at startup time, or one can also get the parameters from the corrupted spfile
using utilities like strings available on unix, similar utilities can be found
for Windows as well.

Extract the parameters either from the alert log or the corrupted spfile
and create a pfile from that and using the SQL command CREATE SPFILE FROM PFILE
create a spfile from the pfile.

$ strings spfile<SID>.ora > init<SID>.ora

SQL> create spfile from pfile ;


Now startup the database

try this and it will work ISA

1-connect to the database using sys as sysdba user
SQL>conn SYS as sysdba
2-startup the database with the pfile found in this path '/opt/oracle/product/oracle_home/dbs/in itorcl.ora'
SQL>startup pfile='/opt/oracle/product/oracle_home/dbs/initorcl.ora'
3- the database will startup
4-create another spfile from the pfile '/opt/oracle/product/oracle_home/dbs/initorcl.ora'
SQL>create spfile from pfile='/opt/oracle/product/oracle_home/dbs/in itorcl.ora';
5-shutdown the database
6-startup the database