• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 636
  • Last Modified:

no access

I cannot log in to the database

[oracle@mac dbs]$ export ORACLE_SID=bank
[oracle@mac dbs]$ sqlplus /nolog

SQL*Plus: Release Production on Fri Aug 31 08:00:58 2012

Copyright (c) 1982, 2009, 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/11.2.0/db_1/dbs/initbank.ora'
SQL> create pfile from spfile;
create pfile from spfile
ERROR at line 1:
ORA-01565: error in identifying file '?/dbs/spfile@.ora'
ORA-27037: unable to obtain file status
Linux Error: 2: No such file or directory
Additional information: 3

2 Solutions
slightwv (䄆 Netminder) Commented:
Oracle is unable to locate a valid parameter file for that instance.

It needs either a PFILE or SPFILE to start.  If these are not the default name or in the default location, you need to specify the pfile on startup.
Praveen Kumar ChandrashekatrDatabase Analysist Senior Commented:
As slightwv stated in is post , to startup  an oracle database you required a PFILE or SPFILE.

as it states it cann't locate the PFILE you can try manually point to the correct initSID.ora @ time of startup.

SQL> startup pfile='path of /pfile/initSID.ora'
tomvvAuthor Commented:

Featured Post

Important Lessons on Recovering from Petya

In their most recent webinar, Skyport Systems explores ways to isolate and protect critical databases to keep the core of your company safe from harm.

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