OraFAQ Forum: Unix » ORA-01078: failure in processing system parameters

Home » Infrastructure » Unix » ORA-01078: failure in processing system parameters (Linux Centos 5)

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

ORA-01078: failure in processing system parameters [message #390587]

Sat, 07 March 2009 23:26

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'

Report message to a moderator

Re: ORA-01078: failure in processing system parameters [message #390588 is a reply to message #390587]

Sat, 07 March 2009 23:35

Mahesh Rajendran
Messages: 10708
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.

Report message to a moderator

Re: ORA-01078: failure in processing system parameters [message #390590 is a reply to message #390587]

Sat, 07 March 2009 23:38

BlackSwan
Messages: 26766
Registered: January 2009
Location: SoCal

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:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Tue Dec 03 13:31:22 CST 2024