Re: What is "idle instance"?

From: joel garry <>
Date: Mon, 1 Jun 2015 08:56:49 -0700 (PDT)
Message-ID: <>

On Monday, June 1, 2015 at 2:13:15 AM UTC-7, Noons wrote:
> On 31/05/2015 8:37 PM, John Doe wrote:
> > If an instance is created by allocating memory areas and starting
> > background processes then what is an "idle instance" when no oracle
> > database is up and running? No background process exists yet, no memory
> > is allocated but this thingy is called an instance (idle one). Sometimes
> > database is up and running and one still can connect to "idle instance".
> > Isn't a kind of word play here and actually "idle instance" means
> > something different than "real instance"? Can "connected to idle
> > instance" be understood as equivalent of "not connected to `real'
> > instance"?
> The instance is defined and can be started.
> But is not started, therefore, it is idle.

Not really even that, since part of the definition (including memory parameters) has not yet been accessed.

$ export ORACLE_SID=blorfo

$ sqlplus / as sysdba

SQL*Plus: Release - Production on Mon Jun 1 08:56:49 2015

Copyright (c) 1982, 2007, Oracle. All Rights Reserved.

Connected to an idle instance.

SYS_at_blorfo> startup
ORA-01078: failure in processing system parameters LRM-00109: could not open parameter file '/oracle/app/oracle/product/10.2.0/db_1/dbs/initblorfo.ora' SYS_at_blorfo>

It's just the initial bootstrap for sqlplus to be able to startup, which was once handled by separate utilities.


-- is bogus.
Received on Mon Jun 01 2015 - 17:56:49 CEST

Original text of this message