Connected to an idle instance – while database is running
Posted by Kamran Agayev A. on July 11th, 2012
I strongly believe you already know it, but would like to share if you’ve forgot and can’t understand why you’re not able to connect to the instance which is already running
[php]-bash-3.2$ sqlplus / as sysdba
SQL*Plus: Release 10.2.0.4.0 – Production on Wed Jul 11 09:24:18 2012
Copyright (c) 1982, 2007, Oracle. All Rights Reserved.
Connected to an idle instance.
SQL> exit
-bash-3.2$ ps -ef | grep smon
oracle 21202 1 0 Nov 8 ? 118:15 ora_smon_MYDB
[/php]
The database is running, but I can’t login to the instance. Let’s check ORACLE_HOME environment variable:
[php]
/home/oracle/product/10g/
[/php]
Do you see the slash in the end of the line? That’s the reason! Let’s set it again without the slash at the end and try again
[php]
-bash-3.2$ export ORACLE_HOME=/home/oracle/product/10g
-bash-3.2$ sqlplus / as sysdba
SQL*Plus: Release 10.2.0.4.0 – Production on Wed Jul 11 09:33:39 2012
Copyright (c) 1982, 2007, Oracle. All Rights Reserved.
Connected to:
Oracle Database 10g Enterprise Edition Release 10.2.0.4.0 – 64bit Production
With the Partitioning, OLAP, Data Mining and Real Application Testing options
SQL>
[/php]
Here it is …
July 11th, 2012 at 7:33 am
Interesting! Thanks for share
July 11th, 2012 at 7:56 am
Hi Kamran!
You are right, this is reason of connection idle instance.
Thanks for share !
Mistake ORACLE_SID is reason of connection idle instance, too.
[oracle@oel62-x64 /]$ echo $ORACLE_SID
admdb
[oracle@oel62-x64 /]$
[oracle@oel62-x64 /]$ sqlplus / as sysdba
SQL*Plus: Release 11.2.0.3.0 Production on Wed Jul 11 12:55:47 2012
Copyright (c) 1982, 2011, Oracle. All rights reserved.
Connected to:
Oracle Database 11g Enterprise Edition Release 11.2.0.3.0 – 64bit Production
With the Partitioning, Oracle Label Security, OLAP, Data Mining,
Oracle Database Vault and Real Application Testing options
SQL>
SQL> exit
[oracle@oel62-x64 /]$ export ORACLE_SID=ADMDB
[oracle@oel62-x64 /]$ sqlplus / as sysdba
SQL*Plus: Release 11.2.0.3.0 Production on Wed Jul 11 12:56:01 2012
Copyright (c) 1982, 2011, Oracle. All rights reserved.
Connected to an idle instance.
SQL>
Regards
Mahir M. Quluzade
July 11th, 2012 at 8:39 am
That’s right Mahir. Actually in this case the first thing you check is ORACLE_SID. When you see it’s correctly set and the instance is running on the OS level, you need to check ORACLE_HOME variable and remove the last character which is slash “/”
July 11th, 2012 at 7:26 pm
Hi Kamran,
I felt your blog is very interesting. it will be very helpful if we work on ORACLE Performance Tuning. We want to master it.do you have any idea how we can create a dummy application to learn oracle performance tuning. Thank you.With Regards..liveinoracle
December 13th, 2012 at 11:33 pm
[...] este ejemplo, escrito por Kamran Agayev, aquí y decidí traducirlo en español. Tenía una base de datos en un servidor [...]