Re: Where is Oracle 9.2 init.ora?

Kirti,

    I am using Red Hat 7.1, I will test it in W2K

• Original Message ----- To: "Multiple recipients of list ORACLE-L" <ORACLE-L_at_fatcity.com> Sent: Monday, July 15, 2002 3:53 PM

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

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Ramon E. Estevez
  INET: com.banilejas_at_codetel.net.do

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