So I have an Oracle instance, and I know it’s running on this system, I’ve su’d to the oracle user, and I’m trying to connect using «/ as sysdba». However, when I do connect, it says the instance is idle. I know the database is up and opened, because my application’s talking to it. My paths (ORACLE_HOME, etc.) might be incorrect: any idea which incorrect setting might result in this?
13 Answers 13
make sure you have your ORACLE_HOME setup exactly the same as when the server was started, I’ve seen this problem with oracle 9.2.0.5.0 on solaris,
is two different things, and will result in issues connecting locally.
that means that the database instance is not mounted nor open. Execute the startup command and see if any errors appear.
The database cannot be idle and in use by your application at the same time. It seems like the sqlplus session must be connected to a different instance than the application. Try specifying the connect identifier in the connect statement as follows:
try from the machine console
I know on windows there is a command to create a service to start up an instance for you, oradmin -new -sid %ORACLE_SID% -intpwd %oracle_pwd% -startmode A
thanks. it indeed was that extra front slash at the end in ORACLE_HOME variable.
I have strange issue. I have 11.2.0.1 db on AIX6. ORACLE_HOME and ORACLE_SID already set.
When i try to run below command:
sqlplus «/as sysdba»
SQL*Plus: Release 11.2.0.1.0 Production on 2011
Copyright (c) 1982, 2009, Oracle. All rights reserved.
Connected to an idle instance.
But Oracle process is running
sqlplus sys/xx@SID as sysdba У меня такой же вопрос Показать отметки «Мне нравится» (0) (0)
- 51787 Просмотров
- Метки: нет (добавить)
1. Re: Connected to an >
make sure ORACLE_SID is exported correctly and your run sqlplus from the right directory (binaries) in case you have more oracle installations in the box.
to check , try
echo $ORACLE_SID
- Мне нравится Показать отметки «Мне нравится» (0) (0)
- Действия
2. Re: Connected to an > 
Hi,
You must know that when Oracle connects to a local instance under Unix it is using ORACLE_SID and ORACLE_HOME env.var to compute shared memory key used by instance (and displayed by ipcs -mob):
So if SQL*Plus says «idle instance», it means the computed key is wrong because something has changed between
— the time instance has been started
— the time you try to connect
You should really try to find what has changed for ORACLE_SID and ORACLE_HOME.
Are you also sure that «testuser» is connected on the same host as «oracle» ? If not local connections cannot work and you should use Oracle Net connection strings.
Best regards
Phil
Edited by: Philippe Florent on Feb 3, 2011 11:30 AM
I tried to connect to my database and got Connected to an idle instance :
Further, the Getting Started page cannot be found with Error code: ERR_CONNECTION_REFUSED :
What I did to try and resolve this issue
While digging in various forums, I found that maybe I needed to specify the initXE.ora file on startup:
No such spfileXE.ora file. OK, so create it?
Well, I guess I have no ADR Base directory..
I list as much supporting information as I know how to below.
Environment
- Windows 7 Enterprise, SP1, 64-bit.
- Oracle Database Express Edition 11g Release 2 for Windows x32
I have these environment variables set:
Installation settings
These are the installation settings used by the installer:
Output from lsnrctl stat
Some debugging information that may be useful:
Various config files
Here are contents of other important files.