RE: Where is Oracle 9.2 init.ora?

Ramon,
 I can not explain that. What platform are you on?  May be this is another bug with SPFILE.

• Kirti

> -----Original Message-----
> From: Ramon E. Estevez [SMTP:com.banilejas_at_codetel.net.do]
> Sent: Monday, July 15, 2002 2:58 PM
> To: Multiple recipients of list ORACLE-L
> Subject: Re: Where is Oracle 9.2 init.ora?
>
> Hi Kirti
>
> I have something to add to the topic.
>
> I "could" edit the spfile with VI and add a parameter with a value of 20,
> later add the same parameter to the init file with a value of 30, bounce
> the
> DB and it worked very fine.
>
> SQL> shutdown immediate;
> Database closed.
> Database dismounted.
> ORACLE instance shut down.
> SQL> startup
>
> ORACLE instance started.
>
> Total System Global Area 235693104 bytes
> Fixed Size 279600 bytes
> Variable Size 167772160 bytes
> Database Buffers 67108864 bytes
> Redo Buffers 532480 bytes
> Database mounted.
> Database opened.
> SQL> SHOW PARAMETER JOB
>
> NAME TYPE VALUE
> ------------------------------------ -----------
> ---------------------------
> ---
> job_queue_processes integer 20 <------ spfile
>
>
> SQL> shutdown immediate;
> Database closed.
> Database dismounted.
> ORACLE instance shut down.
> SQL> startup
> ORACLE instance started.
>
> Total System Global Area 235693104 bytes
> Fixed Size 279600 bytes
> Variable Size 167772160 bytes
> Database Buffers 67108864 bytes
> Redo Buffers 532480 bytes
> Database mounted.
> Database opened.
> SQL> show parameter job
>
> NAME TYPE VALUE
> ------------------------------------ -----------
> ---------------------------
> ---
> job_queue_processes integer 30 <-- init
> SQL>
> SQL>
>
> Could you explain me that ???
>
> Ramon
>
>
> ----- Original Message -----
> To: "Multiple recipients of list ORACLE-L" <ORACLE-L_at_fatcity.com>
> Sent: Sunday, July 14, 2002 5:58 PM
>
>
> > All Right, Larry. Since we have the test servers and databases; and my
> > Company still pays for 'doing Oracle' the 'scary' way, here is another
> > 'scary thing' I did with SPFILE :)
> > (9iR1 on HP)
> >
> > SQL> conn / as sysdba
> > Connected to an idle instance.
> > SQL> startup <---- using spfile
> >
> > ORACLE instance started.
> > Total System Global Area 72273416 bytes
> > Fixed Size 437768 bytes
> > Variable Size 37748736 bytes
> > Database Buffers 33554432 bytes
> > Redo Buffers 532480 bytes
> > Database mounted.
> > Database opened.
> > SQL> show parameter db_cache_size
> > NAME TYPE VALUE
> > ------------------------------------ -----------
> > ------------------------------
> > db_cache_size big integer 33554432
> >
> > SQL> !mv spfileKED9.ora spfileKED9.ora.bak <-- hide the spfile
> >
> > SQL> !ls -l *.ora
> > -rw-r--r-- 1 oracle dba 12920 May 10 2001 initdw.ora
> >
> > SQL> alter system set db_cache_size=10M scope=both; <-- try to set a
> new
> > value
> >
> > System altered. <--- No problem?
> >
> > SQL> show parameter db_cache_size
> >
> > NAME TYPE VALUE
> > ------------------------------------ -----------
> > ------------------------------
> > db_cache_size big integer 12582912
> >
> > --> New value in effect.
> >
> > SQL> !ls -l *.ora
> > -rw-r--r-- 1 oracle dba 12920 May 10 2001 initdw.ora
> >
> > --> Still no SFILE....
> > --> Now, why would not Oracle tell us that there was no spfile to
> process
> > SCOPE=BOTH ?
> >
> > SQL> c/both/spfile
> > 1* alter system set db_cache_size=10M scope=spfile
> > SQL> /
> > alter system set db_cache_size=10M scope=spfile
> > *
> > ERROR at line 1:
> > ORA-27037: unable to obtain file status
> > HP-UX Error: 2: No such file or directory
> > Additional information: 3
> >
> > -->This is what should have happened with SCOPE=BOTH as well, or at
> least
> a
> > warning that SCOPE=BOTH was processed as SCOPE=MEMORY since there was no
> > SPFILE available. I would not have objected if Oracle re-recreated
> SPFILE
> in
> > the default location and told me so!
> >
> > If anyone has seen any mention of this particular behaviour of
> SCOPE=BOTH,
> I
> > would like to know the source of that information. I have searched
> Metalink,
> > Google but have not come across any. I have created an iTar with OWS.
> > Thanks.
> >
> > As I said before, SPFILE has some things that need to be made fool
> proof.
> >
> > This time I did not drink prior to doing this 'scary' stuff !! ;-)
> >
> > Regards,
> >
> > - Kirti
>

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Deshpande, Kirti
  INET: kirti.deshpande_at_verizon.com

Fat City Network Services    -- (858) 538-5051  FAX: (858) 538-5051
San Diego, California        -- Public Internet access / Mailing Lists
--------------------------------------------------------------------
To REMOVE yourself from this mailing list, send an E-Mail message
to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).