[Last Call] Learn how to a build a cloud-first strategyRegister Now

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 4137
  • Last Modified:

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?
0
sikyala
Asked:
sikyala
  • 8
  • 7
1 Solution
 
Pierrick LOUBIERCommented:
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 LOUBIERCommented:
Please check that environment variable $ORACLE_HOME is set to u01/oracle/product/app/9.2.0.1/
0
Visualize your virtual and backup environments

Create well-organized and polished visualizations of your virtual and backup environments when planning VMware vSphere, Microsoft Hyper-V or Veeam deployments. It helps you to gain better visibility and valuable business insights.

 
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 LOUBIERCommented:
How did you create the DB ? Using DBCA or manually ?
0
 
sikyalaSenior Database AdministratorAuthor Commented:
DBCA
0
 
Pierrick LOUBIERCommented:
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 LOUBIERCommented:
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 LOUBIERCommented:
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 LOUBIERCommented:
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
 
sikyalaSenior Database AdministratorAuthor Commented:
output:

File created.


Thanks so much!
0

Featured Post

Concerto's Cloud Advisory Services

Want to avoid the missteps to gaining all the benefits of the cloud? Learn more about the different assessment options from our Cloud Advisory team.

  • 8
  • 7
Tackle projects and never again get stuck behind a technical roadblock.
Join Now