RE: Why are SPFILEs binary anyway? (was RE: How to make SPFILE in

From: Thomas Day <tday6_at_csc.com>
Date: Thu, 17 Jul 2003 09:37:21 -0400
Message-Id: <25946.338251@fatcity.com>

My experience also on Win2K. 9.2.0.1.0 the file is editable. On 9.2.0.3.0 results are unpredictable if you edit the file. I guess that they really don't want us editing it.

                                                                                                                                       
                      Kirtikumar                                                                                                       
                      Deshpande                To:      Multiple recipients of list ORACLE-L <ORACLE-L_at_fatcity.com>                    
                      <kirtikumar_desh         cc:                                                                                     
                      pande                    Subject: RE: Why are SPFILEs binary anyway? (was RE: How to make SPFILE in              
                      @yahoo.com>                                                                                                      
                      Sent by:                                                                                                         
                      ml-errors                                                                                                        
                                                                                                                                       
                                                                                                                                       
                      07/16/2003 11:24                                                                                                 
                      PM                                                                                                               
                      Please respond                                                                                                   
                      to ORACLE-L

Keeping them binary gives them "power" I guses... On most platforms there is just a hashed value on the first line.

In 9i R1 (9.0.1), I was able to replace some param value without changing number of chars on the
line, and the changes were taken without any problem (HP-UX 11, it was I think). Could not believe
that it worked. No such luck in 9i R2...

Binary, text, whatever, I will just stay away from him till pfile really goes away :)

Kirti
- "Jamadagni, Rajendra" <Rajendra.Jamadagni_at_espn.com> wrote:
  > it isn't binary on solaris ... pure text ...
  >
  > Raj
  >
  > -----Original Message-----
  > Sent: Wednesday, July 16, 2003 6:40 PM
  > To: Multiple recipients of list ORACLE-L
  > sync with INIT.ORA ?)
  >
  >
  > I can definitely appreciate the benefits of dynamic parameters, and of
  being
  > able to persist the values of those parameters accross shutdown/startup
  > cycles. But I would have guessed that oracle could have gotten both of
  > those features together without going to a binary parameter
  file--couldn't
  > whatever process writes to the spfile just write to a plain text file
  > instead? Does anybody know what the advantage of having a binary store
  of
  > params is?
  >
  > Cheers,
  > -Roy
  > >
  ********************************************************************This e-mail message is
  > confidential, intended only for the named recipient(s) above and may
  contain information that is
  > privileged, attorney work product or exempt from disclosure under
  applicable law. If you have
  > received this message in error, or are not the named recipient(s), please
  immediately notify
  > corporate MIS at (860) 766-2000 and delete this e-mail message from your
  computer, Thank
  > you.
  *********************************************************************2
  >

Do you Yahoo!?
SBC Yahoo! DSL - Now only $29.95 per month! http://sbc.yahoo.com

--
Please see the official ORACLE-L FAQ: http://www.orafaq.net
--
Author: Kirtikumar Deshpande
  INET: kirtikumar_deshpande_at_yahoo.com

Fat City Network Services    -- 858-538-5051 http://www.fatcity.com
San Diego, California        -- Mailing list and web hosting services
---------------------------------------------------------------------
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

Received on Thu Jul 17 2003 - 08:37:21 CDT