Connected to an idle instance

Posted: January 6, 2010 in Administration, Troubleshooting
Tags: , , , , ,

While trying to connect to a Oracle database with SYSDBA privileges, I get this message in the SQLPLUS prompt :

sqlplus “/ as sysdba”
SQL*Plus: Release – 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”.

Leave a Reply

Fill in your details below or click an icon to log in: Logo

You are commenting using your account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s