Re: What is "idle instance"?

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 10.2.0.4.0 - 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.

jg

-- 
_at_home.com is bogus.
http://phys.org/news/2015-06-oracle-google-case-threatens-foundations.html