One of the common error and below is one of the reason for this error,
In the Environment where you have more than one oracle Version ,this can happen.
If the wrong oracle home is set and if you try to login to the database of different version than the ORACLE_HOME set, you will be getting the below error.
In the Environment where you have more than one oracle Version ,this can happen.
If the wrong oracle home is set and if you try to login to the database of different version than the ORACLE_HOME set, you will be getting the below error.
SQL*Plus: Release 11.2.0.1.0
Production on Thu Feb 20 07:18:44 2012
Copyright (c) 1982, 2009,
Oracle. All rights reserved.
Connected to an idle instance.
SQL> select count(1) from
v$database;
select count(1) from v$database
*
ERROR at line 1:
ORA-01034: ORACLE not available
Process ID: 0
Session ID: 0 Serial number: 0
Set the Right ORACLE_HOME and it will solve the issue
