ORA-01078 & LRM-00109 Errors

Check the location of your parameter file then enter :
startup pfile=<full/path/to/parameter/file>

Which OS do you use ?

I checked the directory that it is searching for the initsid.ora file in and it does not exist. There is a spfileGabriele.ora file.

should I enter startup pfile='/u01/oracle/product/app/9.2.0.1/dbs/spfileGabriele.ora'

Please check that environment variable $ORACLE_HOME is set to u01/oracle/product/app/9.2.0.1/

I believe it is. see below:

echo $ORACLE_HOME
/u01/oracle/product/app/9.2.0.1

oh sorry I am using Solaris 10

How did you create the DB ? Using DBCA or manually ?

DBCA

You should recreate the SPFILE. You might have a temporary PFILE in $ORACLE_HOME/admin/Gabriele/pfile

startup pfile=$ORACLE_HOME/admin/Gabriele/pfile/<pfile_name>
create spfile from pfile;

in the /u01/app/oracle/admin/Gabriele/pfile directory there is one file:
init.ora.227200617535

option 1:

so are you saying type the following:

startup pfile='/u01/app/oracle/admin/Gabriele/pfile/spfileGabriele.ora'
create spfile from pfile;
 
or

option 2:

startup pfile='/u01/app/oracle/admin/Gabriele/pfile/init.ora.227200617535
create spfile from pfile;

or

option 3:

could I do the following (There is a spfile spfileGabriele.ora in the directory referenced below) :

startup pfile=$ORACLE_HOME/dbs/spfileGabriele.ora
create spfile from pfile;


The directory in option 3 has the following files:

-rw-r--r--   1 oracle   dba         8385 Mar  9  2002  init.ora
-rw-r--r--   1 oracle   dba        12920 Mar  9  2002 initdw.ora
-rw-rw----   1 oracle   dba           24 Mar 27 17:53 lkGABRIELE
-rwSr-----   1 oracle   dba         1536 Mar 28 08:21 orapwGabriele
-rw-r-----   1 oracle   dba         2560 Mar 27 17:53 spfileGabriele.ora

Thanks!

Go for the second option.

I tried option 2 and got the following output:

ORACLE instance started.

Total System Global Area  320308312 bytes
Fixed Size                   730200 bytes
Variable Size             285212672 bytes
Database Buffers           33554432 bytes
Redo Buffers                 811008 bytes
Database mounted.
Database opened.
SQL> create spfile from pfile
*
ERROR at line 1:
ORA-01078: failure in processing system parameters
LRM-00109: could not open parameter file
'/u01/oracle/product/app/9.2.0.1/dbs/initGabriele.ora'

Sorry, this one will work better :

create spfile from pfile='/u01/oracle/product/app/9.2.0.1/dbs/spfileGabriele.ora';

I got the following output:

create spfile from pfile='/u01/oracle/product/app/9.2.0.1/dbs/spfileGabriele.ora';
*
ERROR at line 1:
ORA-01078: failure in processing system parameters
LRM-00123: invalid character 0 found in the input file

output:

File created.


Thanks so much!