no access

I cannot log in to the database



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

SQL*Plus: Release 11.2.0.1.0 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


SQL>
tomvvAsked:
Who is Participating?
 
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'
0
 
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.
0
 
tomvvAuthor Commented:
helpful...
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.