Go Premium for a chance to win a PS4. Enter to Win

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

startup problems

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
walkerdba
Asked:
walkerdba
  • 2
1 Solution
 
DavidSenior Oracle Database AdministratorCommented:
1.   Does the referenced parameter file exist?
2.   What is your value for ORACLE_HOME?
3.   Show us your INIT.ORA.
0
 
Mark GeerlingsDatabase AdministratorCommented:
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
 
Mark GeerlingsDatabase AdministratorCommented:
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
 
walkerdbaAuthor Commented:
yes
0

Featured Post

Free Tool: SSL Checker

Scans your site and returns information about your SSL implementation and certificate. Helpful for debugging and validating your SSL configuration.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

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