While trying to connect to a 10.2.0.4.0 Oracle database with SYSDBA privileges, I get this message in the SQLPLUS prompt :
sqlplus “/ as sysdba”
SQL*Plus: Release 10.2.0.4.0 – Production on Wed Jan 6 17:51:02 2010
Copyright (c) 1982, 2007, Oracle. All Rights Reserved.
Connected to an idle instance.
The database is open and running well :
oracle@fool:~$ ps -ef |grep smon
oracle 19952 1 0 2009 ? 00:03:42 ora_smon_ORACLE_SID
It appears that the instance was not started up with the same value of ORACLE_HOME than the one in the oracle user session.
To display the value of the variable ORACLE_HOME when the database was started :
oracle@fool:~$ cat /proc/19952/environ
In this “special” file, ORACLE_HOME’s value has a trailing slash at the end whereas ORACLE_HOME’s value in the oracle user bashrc do not have this trailing slash.
You need to restart your database to be able to connect again as “/ as sysdba”.