Re: What is "idle instance"?
Date: Tue, 02 Jun 2015 20:34:16 +1000
Message-ID: <mkk0p0$hos$1_at_dont-email.me>
On 2/06/2015 1:56 AM, joel garry wrote:
>>
>> 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.
>
Yeah, good point. Received on Tue Jun 02 2015 - 12:34:16 CEST