| 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?
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 bytesDatabase mounted.
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,
> -----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 >
Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051 San Diego, California -- Public Internet access / Mailing Liststo: 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 Sun Jul 14 2002 - 17:58:20 CDT
--------------------------------------------------------------------
To REMOVE yourself from this mailing list, send an E-Mail message
 |
 |