startup problems

walkerdba
walkerdba used Ask the Experts™
on
Failure in processing parameters..

[oracle@new ~]$ export ORACLE_SID=orcl
[oracle@new ~]$ sqlplus /nolog

SQL*Plus: Release 11.2.0.1.0 Production on Sat Dec 29 14:25:41 2012

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

SQL> conn / as sysdba
Connected to an idle instance.
SQL> startup mount
ORA-01078: failure in processing system parameters
LRM-00109: could not open parameter file '/u01/app/oracle/product/11.2.0/db_1/dbs/initorcl.ora'
Comment
Watch Question

Do more with

Expert Office
EXPERT OFFICE® is a registered trademark of EXPERTS EXCHANGE®
David VanZandtOracle Database Administrator III

Commented:
1.   Does the referenced parameter file exist?
2.   What is your value for ORACLE_HOME?
3.   Show us your INIT.ORA.
Mark GeerlingsDatabase Administrator

Commented:
Did this database open successfully in the past?  Or, is this a new database?

Do you want to use the older-style pfile rather than an spfile?
Database Administrator
Commented:
Can you navigate manually to this directory: /u01/app/oracle/product/11.2.0/db_1/dbs?
Does it contain a file named: initorcl.ora?

Author

Commented:
yes

Do more with

Expert Office
Submit tech questions to Ask the Experts™ at any time to receive solutions, advice, and new ideas from leading industry professionals.

Start 7-Day Free Trial