Oracle 11g R2 installation, sqlplus only connects to idle instance??
836483Feb 15 2011 — edited Feb 17 2011Hello, I have just downloaded and installed OR11G R2 on a VM (linux Redhat 8). I tried sqlplus connection to oracle but it only connects to an idle instance. I am very new to both Linux and Oracle so I have not been able to figure it out even after reading a lot of threads online. I followed the link below for installation guide from beginning to end, and only changed the host from viper to localhost (is that the problem??).
http://www.oramoss.com/wiki/index.php/Install_OBIEE_11.1.1.3.0_on_Oracle_Enterprise_Linux_5.5_with_Oracle_11gR2_RDBMS.
I didn't what more information to post here, but please tell me how and what information you need, to may be try and fix this issue.
Thanks alot
[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'