ORA-01078 & LRM-00109 Errors

I created a new database and I am trying to log in to the database. However when I enter connect /as sysdba
it reads that I am connect to an idle instance. When I type startup I get the following errors:

ORA-01078: failure in processing system parameters

LRM-00109: could not open parameter '/u01/oracle/product/app/9.2.0.1/dbs/initgabriele.ora

Could someone help me fix this problem?
sikyalaSenior Database AdministratorAsked:
Who is Participating?
I wear a lot of hats...

"The solutions and answers provided on Experts Exchange have been extremely helpful to me over the last few years. I wear a lot of hats - Developer, Database Administrator, Help Desk, etc., so I know a lot of things but not a lot about one thing. Experts Exchange gives me answers from people who do know a lot about one thing, in a easy to use platform." -Todd S.

Pierrick LOUBIERIS Operational Excellence ManagerCommented:
Check the location of your parameter file then enter :
startup pfile=<full/path/to/parameter/file>

Which OS do you use ?
0
sikyalaSenior Database AdministratorAuthor Commented:
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'
0
Pierrick LOUBIERIS Operational Excellence ManagerCommented:
Please check that environment variable $ORACLE_HOME is set to u01/oracle/product/app/9.2.0.1/
0
Ultimate Tool Kit for Technology Solution Provider

Broken down into practical pointers and step-by-step instructions, the IT Service Excellence Tool Kit delivers expert advice for technology solution providers. Get your free copy now.

sikyalaSenior Database AdministratorAuthor Commented:
I believe it is. see below:

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

0
sikyalaSenior Database AdministratorAuthor Commented:
oh sorry I am using Solaris 10
0
Pierrick LOUBIERIS Operational Excellence ManagerCommented:
How did you create the DB ? Using DBCA or manually ?
0
sikyalaSenior Database AdministratorAuthor Commented:
DBCA
0
Pierrick LOUBIERIS Operational Excellence ManagerCommented:
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;
0
sikyalaSenior Database AdministratorAuthor Commented:
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!
0
Pierrick LOUBIERIS Operational Excellence ManagerCommented:
Go for the second option.
0
sikyalaSenior Database AdministratorAuthor Commented:
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'

0
Pierrick LOUBIERIS Operational Excellence ManagerCommented:
Sorry, this one will work better :

create spfile from pfile='/u01/oracle/product/app/9.2.0.1/dbs/spfileGabriele.ora';
0
sikyalaSenior Database AdministratorAuthor Commented:
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
0
Pierrick LOUBIERIS Operational Excellence ManagerCommented:
Wow I think I should have a sleep ASAP
My apologizes, here is finally the correct one (damed copy / paste ;-)

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

Experts Exchange Solution brought to you by

Your issues matter to us.

Facing a tech roadblock? Get the help and guidance you need from experienced professionals who care. Ask your question anytime, anywhere, with no hassle.

Start your 7-day free trial
sikyalaSenior Database AdministratorAuthor Commented:
output:

File created.


Thanks so much!
0
It's more than this solution.Get answers and train to solve all your tech problems - anytime, anywhere.Try it for free Edge Out The Competitionfor your dream job with proven skills and certifications.Get started today Stand Outas the employee with proven skills.Start learning today for free Move Your Career Forwardwith certification training in the latest technologies.Start your trial today
Oracle Database

From novice to tech pro — start learning today.

Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.