Home » Infrastructure » Unix » ORA-01078: failure in processing system parameters (Linux Centos 5)
ORA-01078: failure in processing system parameters [message #390587] Sat, 07 March 2009 23:26 Go to next message
Detroit5
Messages: 1
Registered: March 2009
Junior Member

I dont have a clue where to begin repairing this error. I have not done Linux in about 10yrs, so please HELP!!!
javascript:%20insertTag(document.post_form.msg_body,%20'',%20'%20:(%20');
[oracle@localhost ~]$ sqlplus /nolog

SQL*Plus: Release 10.2.0.1.0 - Production on Sun Mar 8 00:16:36 2009

Copyright (c) 1982, 2005, Oracle. All rights reserved.

SQL> conn / as sysdba
Connected to an idle instance.
SQL> startup
ORA-01078: failure in processing system parameters
LRM-00109: could not open parameter file '/u01/app/oracle/product/10.2.0/db_1/dbs/initorcl.ora'
Re: ORA-01078: failure in processing system parameters [message #390588 is a reply to message #390587] Sat, 07 March 2009 23:35 Go to previous messageGo to next message
Mahesh Rajendran
Messages: 10626
Registered: March 2002
Location: oracleDocoVille
Senior Member
Account Moderator
oracle will read an init file to start the instance.
The init file will be named as init<yourSid>.ora by default and will be identified by ORACLE_SID environment variable.
Seems it is not finding the said initfile in the default location of $ORACLE_HOME/dbs.
Set proper ORACLE_SID.
Check whether init<ORACLE_SID>.ora exists.

try again.
Re: ORA-01078: failure in processing system parameters [message #390590 is a reply to message #390587] Sat, 07 March 2009 23:38 Go to previous message
BlackSwan
Messages: 22804
Registered: January 2009
Senior Member
env | sort -o /tmp/my.env

Post contents of /tmp/my.env back here.

You need to help us by following the Posting Guidelines as stated below.
http://www.orafaq.com/forum/t/88153/0/

[Updated on: Sat, 07 March 2009 23:38]

Report message to a moderator

Previous Topic: Resurrect a backup corrupted by FTP (ASCII)
Next Topic: Oracle 9.2.0 connection to Oracle 10.2.0 database
Goto Forum:
  


Current Time: Tue Sep 23 13:38:16 CDT 2014

Total time taken to generate the page: 0.05179 seconds