Kirti, That's interesting. I guess anyone would have *expected* scope=both to report a problem regarding spfile just as it did when specifying just scope=spfile. I wonder if they are going to say in your TAR that this is the expected behavior ;-)
Regards, Larry G. Elkins [EMAIL PROTECTED] 214.954.1781 > -----Original Message----- > From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]On Behalf Of Deshpande, > Kirti > Sent: Saturday, July 13, 2002 6:23 PM > To: Multiple recipients of list ORACLE-L > Subject: 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 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: Larry Elkins INET: [EMAIL PROTECTED] 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: [EMAIL PROTECTED] (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).