| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
 |
 | |||
| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
|
| |||
Home -> Community -> Mailing Lists -> Oracle-L -> 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 bytesDatabase mounted.
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 bytesDatabase mounted.
NAME TYPE VALUE ------------------------------------ ----------- --------------------------- --- job_queue_processes integer 30 <-- initSQL>
Ramon
> 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
>
> > -----Original Message-----
> > From: Larry Elkins [SMTP:elkinsl_at_flash.net]
> > Sent: Friday, July 12, 2002 9:03 PM
> > To: Multiple recipients of list ORACLE-L
> > Subject: RE: Where is Oracle 9.2 init.ora?
> >
> > Man, it scares the heck out of me too that Jared and Kirti are actually
> > "doing Oracle" -- I can't believe companies actually pay them ;-)
> >
> > And you two guys, and I'm talking to you Kirti and Jared, probably dig
in
> > and do things you shouldn't on test boxes just to see how things work
and
> > to
> > learn. FWIW, I've heard rumors about other people doing similar things.
> > You've probably even intentionally crashed a DB or pulled the plug just
to
> > see if you could recover. Shame on you two. You should both be banished
> > from
> > the list for doing such unconventional things ;-)
> >
> > And neither of you will ever be allowed close to a DB I deal with --
I'll
> > call ltiu from now on ;-)
> >
> > Larry
> > > -----Original Message-----
> > > From: root_at_fatcity.com [mailto:root_at_fatcity.com]On Behalf Of
> > > Jared.Still_at_radisys.com
> > > Sent: Friday, July 12, 2002 8:08 PM
> > > To: Multiple recipients of list ORACLE-L
> > > Subject: RE: Where is Oracle 9.2 init.ora?
> > >
> > >
> > > Some of us have been around the block a few times. :)
> > >
> > > Editing binary files is no big deal.
> > >
> > > You neophytes are all the same.
> > >
> > > Jared
> > >
> > > ltiu <ltiu_at_alumni.sfu.ca>
> > > Sent by: root_at_fatcity.com
> > > 07/12/2002 04:28 PM
> > > Please respond to ORACLE-L
> > >
> > >
> > > To: Multiple recipients of list ORACLE-L
> > > <ORACLE-L_at_fatcity.com>
> > > cc:
> > > Subject: RE: Where is Oracle 9.2 init.ora?
> > >
> > >
> > > You DBA's must be drunk.
> > >
> > > Spfiles are in binary format and if you open it in a text editor, all
> > you
> > > see
> > > are weird characters.
> > >
> > > Man. You guys are actually doing Oracle? Scares me.
> > >
> > > ltiu
> >
> --
> 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).Received on Mon Jul 15 2002 - 14:58:27 CDT
 |
 |