Solved

startup problems

Posted on 2012-12-29
4
302 Views
Last Modified: 2013-01-10
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'
0
Comment
Question by:walkerdba
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 2
4 Comments
 
LVL 23

Expert Comment

by:David
ID: 38730080
1.   Does the referenced parameter file exist?
2.   What is your value for ORACLE_HOME?
3.   Show us your INIT.ORA.
0
 
LVL 35

Expert Comment

by:Mark Geerlings
ID: 38730202
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?
0
 
LVL 35

Accepted Solution

by:
Mark Geerlings earned 500 total points
ID: 38733138
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?
0
 

Author Closing Comment

by:walkerdba
ID: 38765215
yes
0

Featured Post

Free Tool: ZipGrep

ZipGrep is a utility that can list and search zip (.war, .ear, .jar, etc) archives for text patterns, without the need to extract the archive's contents.

One of a set of tools we're offering as a way to say thank you for being a part of the community.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Suggested Solutions

Title # Comments Views Activity
Oracle DB Slows After Datapump Until Next Reboot 27 173
rsyslog raw message 4 61
replicate in oracle 13 45
how to solve "recursive" database tables 2 61
I remember the day when someone asked me to create a user for an application developement. The user should be able to create views and materialized views and, so, I used the following syntax: (CODE) This way, I guessed, I would ensure that useā€¦
Checking the Alert Log in AWS RDS Oracle can be a pain through their user interface.  I made a script to download the Alert Log, look for errors, and email me the trace files.  In this article I'll describe what I did and share my script.
This video shows setup options and the basic steps and syntax for duplicating (cloning) a database from one instance to another. Examples are given for duplicating to the same machine and to different machines
This video shows how to recover a database from a user managed backup

710 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question