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'
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
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
Posting Komentar