RE: Where is Oracle 9.2 init.ora?

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
elkinsl_at_flash.net
214.954.1781

> -----Original Message-----
> From: root_at_fatcity.com [mailto:root_at_fatcity.com]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: elkinsl_at_flash.net

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