SQL> startup error

SQL> startup error

[oracle@localhost ~]$ sqlplus sys as sysdba

SQL*Plus: Release 11.2.0.1.0 Production on Tue Feb 15 16:09:03 2011

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

Enter password:
Connected to an idle instance.

SQL> selct * from v$version
SP2-0734: unknown command beginning "selct * fr..." - rest of line ignored.
SQL> select * from v$version;
select * from v$version
*
ERROR at line 1:
ORA-01034: ORACLE not available
Process ID: 0
Session ID: 0 Serial number: 0

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/initDB11G.ora'

FIX
execute following commands
env|grep ORA|sort
cat /etc/oratab
ps -ef|grep pmon

check if ORACLE_SID set to proper value. set the environment to proper values,

$ export ORACLE_SID=orcl

source

Posting Komentar