Connected to an idle instance – while database is running
Posted by Kamran Agayev A. on 11th July 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 …
Posted in Administration | 10 Comments »