Connected to an idle instance

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

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.
SQL>

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”.

About these ads

Leave a Reply

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

WordPress.com Logo

You are commenting using your WordPress.com 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