Re: What is Idle Instance

From: sybrandb <sybrandb_at_gmail.com>
Date: 10 Jan 2007 01:43:24 -0800
Message-ID: <1168422204.041510.186680@i56g2000hsf.googlegroups.com>

On Jan 10, 9:59 am, "Gaurav Upadhyay" <upadhy..._at_gmail.com> wrote:
> Hi Everybody,
>
> I am basically a SQL Server DBA and just starting out with Oracle and
> soon hope to be an Oracle DBA as well.
> I have a basic question that what is an Idle Instance.Is it that
> Instance has been started but database has not been mounted or Is it
> that instance has not been started.
> Any help would be greatly appreciated.
>
> Regards

It is an instance which has not been started. Note: you will get this message also if you have an incorrect ORACLE_SID environment variable. Connecting to an instance doesn't check anything
Please note the order of events is

- startup
- mount
- open

If you issue just 'startup nomount' you won't get this error.

Reading the documentation, especially the Concepts Manual, or any book on Oracle architecture by Thomas Kyte cannot be recommended too highly.

-- 
Sybrand Bakker
Senior Oracle DBA

Received on Wed Jan 10 2007 - 03:43:24 CST