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

From: Richard Ji <Richard.Ji_at_ztango.com>
Date: Thu, 17 Jul 2003 12:11:42 -0400
Message-Id: <25946.338274@fatcity.com>

This is a multi-part message in MIME format.

------_=_NextPart_001_01C34C7E.1C91872C
Content-Type: text/plain;

charset="iso-8859-1"
Content-Transfer-Encoding: quoted-printable

Of course you are right that no one should use it as the right way to = change parameters.
I will admit playing with binary file some times is my idea of fun. = Hey, you never know,
you might learn something from it. To see the data structure gives me = idea of how things work.
And it might come in handy some day in a recovery situation. =20
Best regards
=20
Richard Ji

-----Original Message-----
From: Jamadagni, Rajendra [mailto:Rajendra.Jamadagni_at_espn.com] Sent: Thursday, July 17, 2003 12:19 PM
To: Multiple recipients of list ORACLE-L Subject: RE: Why are SPFILEs binary anyway? (was RE: How to make SPFILE = in

Questin is why do you want to mess with it? That's not exactly my idea = of fun ...=20

I'd still use alter system, alter database commands to change whatever.=20 Raj=20

-------------------------------------------------------------------------=

-------=20
Rajendra dot Jamadagni at nospamespn dot com=20 All Views expressed in this email are strictly personal.=20 QOTD: Any clod can have facts, having an opinion is an art !=20

-----Original Message-----=20
From: Richard Ji [ mailto:Richard.Ji_at_ztango.com]=20 Sent: Thursday, July 17, 2003 12:10 PM=20 To: Multiple recipients of list ORACLE-L=20 Subject: RE: Why are SPFILEs binary anyway? (was RE: How to make SPFILE=20 in=20

That's a good point. Someone should try a binary editor instead,=20 like bvi and see what happens.=20

-----Original Message-----=20
Sent: Thursday, July 17, 2003 10:45 AM=20 To: Multiple recipients of list ORACLE-L=20 in=20

I wonder if it is something built into the file or something that vi (or =

whatever editor you are using) does to the file when you save it. I say =

that because, if you edit the text part of an export file with vi, you = get=20
an unusable file. But the text part of an export file can be edited by=20 other means and it will work -- for example, by running it through a C = or=20
Perl program and editing the stream as it flows through the program; and = I=20
think, if the export file is not too big (< 2 gig I think ) emacs (with=20 certain options??) can be used.=20

The official word in the 9i new features class at the ivory tower in=20 Colorado Springs is that all the new features are wonderful, and you = should=20
be using them.=20

> -----Original Message-----=20

>=20

> it's a fake sort of binary -- try editing it with vi and then try=20
> opening your database with the spfile... but first make an init.ora=20
> copy of it.=20

>=20

> There is some sort of checksum going on, even though it looks like=20
> ASCII=20

>=20
--=20
Please see the official ORACLE-L FAQ: http://www.orafaq.net=20 --=20
Author: Stephen Lee=20
INET: Stephen.Lee_at_DTAG.Com=20

Fat City Network Services    -- 858-538-5051 http://www.fatcity.com=20
San Diego, California        -- Mailing list and web hosting services=20
---------------------------------------------------------------------=20

To REMOVE yourself from this mailing list, send an E-Mail message=20 to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in=20 the message BODY, include a line containing: UNSUB ORACLE-L=20 (or the name of mailing list you want to be removed from). You may=20 also send the HELP command for other information (like subscribing).=20 --=20
Please see the official ORACLE-L FAQ: http://www.orafaq.net=20 --=20
Author: Richard Ji=20
INET: Richard.Ji_at_ztango.com=20

Fat City Network Services    -- 858-538-5051 http://www.fatcity.com=20
San Diego, California        -- Mailing list and web hosting services=20
---------------------------------------------------------------------=20

------_=_NextPart_001_01C34C7E.1C91872C
Content-Type: text/html;

charset="iso-8859-1"
Content-Transfer-Encoding: quoted-printable

<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN">
<HTML><HEAD>
<META HTTP-EQUIV=3D"Content-Type" CONTENT=3D"text/html; =

charset=3Diso-8859-1">
<TITLE>RE: Why are SPFILEs binary anyway? (was RE: How to make SPFILE = in</TITLE>

<META content=3D"MSHTML 6.00.2800.1106" name=3DGENERATOR></HEAD>
<BODY>
<DIV><SPAN class=3D429110416-17072003><FONT face=3DArial color=3D#0000ff =

size=3D2>Of=20
course you are right that no one should use it as the right way to = change=20
parameters.</DIV>
<DIV>I will=20
admit playing with binary file some times is my idea of fun.  Hey, = you=20
never know,</DIV>
<DIV>you=20
might learn something from it.  To see the data structure gives me = idea=20
of how things work.</DIV> <DIV>And it=20
might come in handy some day in a recovery = situation.</DIV>
<DIV><FONT face=3DArial color=3D#0000ff =

size=3D2> </DIV>
<DIV>Best=20
regards</DIV>
<DIV><FONT face=3DArial color=3D#0000ff =

size=3D2> </DIV>
<DIV><FONT face=3DArial color=3D#0000ff =

size=3D2>Richard Ji</DIV>
<BLOCKQUOTE dir=3Dltr style=3D"MARGIN-RIGHT: 0px"> <DIV class=3DOutlookMessageHeader dir=3Dltr align=3Dleft>-----Original Message----- From: Jamadagni, = Rajendra=20
 [mailto:Rajendra.Jamadagni_at_espn.com] Sent: Thursday, July = 17, 2003=20
 12:19 PM To: Multiple recipients of list = ORACLE-L Subject:=20
 RE: Why are SPFILEs binary anyway? (was RE: How to make SPFILE=20 in </DIV>
 Questin is why do you want to mess with it? That's = not exactly=20
 my idea of fun ... 
 I'd still use alter system, alter database commands = to change=20
 whatever. Raj <FONT=20 =

size=3D2>----------------------------------------------------------------=
----------------</FONT>=20

Rajendra dot Jamadagni at nospamespn dot com = <FONT=20
 size=3D2>All Views expressed in this email are strictly = personal.=20
 QOTD: Any clod can have facts, having an opinion is = an art=20
 ! 
 -----Original Message----- From:=20
 Richard Ji [<A=20
 =
href=3D"mailto:Richard.Ji_at_ztango.com">mailto:Richard.Ji_at_ztango.com</A>]</= FONT>=20
 Sent: Thursday, July 17, 2003 12:10 PM = <FONT=20
 size=3D2>To: Multiple recipients of list ORACLE-L <FONT=20 size=3D2>Subject: RE: Why are SPFILEs binary anyway? (was RE: How to = make=20
 SPFILE in That's a good point.  Someone should try a = binary editor=20
 instead, like bvi and see what = happens. 
 -----Original Message----- Sent:=20
 Thursday, July 17, 2003 10:45 AM To: = Multiple=20
 recipients of list ORACLE-L in = 
 I wonder if it is something built into the file or = something=20
 that vi (or whatever editor you are using) = does to the=20
 file when you save it.  I say that = because, if=20
 you edit the text part of an export file with vi, you get = <FONT=20
 size=3D2>an unusable file.  But the text part of an export file = can be=20
 edited by other means and it will work -- = for example,=20
 by running it through a C or Perl program = and editing=20
 the stream as it flows through the program; and I <FONT=20 size=3D2>think, if the export file is not too big (< 2 gig I think = ) emacs=20
 (with certain options??) can be used. = 
 The official word in the 9i new features class at = the ivory=20
 tower in Colorado Springs is that all the = new features=20
 are wonderful, and you should be using = them.=20
 
 > -----Original Message----- >=20
 > it's a fake sort of binary -- try = editing it with=20
 vi and then try > opening your database = with the=20
 spfile... but first make an init.ora > = copy of=20
 it. > > = There is some=20
 sort of checksum going on, even though it looks like <FONT=20 size=3D2>> ASCII > --=20
 Please see the official ORACLE-L FAQ: <A=20 href=3D"http://www.orafaq.net" =
target=3D_blank>http://www.orafaq.net</A>=20 -- Author: Stephen = Lee=20
   INET: Stephen.Lee_at_DTAG.Com Fat City Network Services    -- = 858-538-5051 <A=20
 href=3D"http://www.fatcity.com" =
target=3D_blank>http://www.fatcity.com</A>=20 San Diego,=20
 California        -- Mailing list = and web=20
 hosting services <FONT=20
 =

size=3D2>----------------------------------------------------------------=

-----=20
 To REMOVE yourself from this mailing list, send an = E-Mail=20
 message to: ListGuru_at_fatcity.com (note EXACT = spelling=20
 of 'ListGuru') and in the message BODY, = include a line=20
 containing: UNSUB ORACLE-L (or the name of = mailing=20
 list you want to be removed from).  You may also=20
 send the HELP command for other information (like subscribing). =

-- Please see the = official ORACLE-L=20
FAQ: <A href=3D"http://www.orafaq.net"=20 target=3D_blank>http://www.orafaq.net</A> -- =

Author: Richard Ji  =20
 INET: Richard.Ji_at_ztango.com Fat City Network Services    -- = 858-538-5051 <A=20
 href=3D"http://www.fatcity.com" =
target=3D_blank>http://www.fatcity.com</A>=20 San Diego,=20
 California        -- Mailing list = and web=20
 hosting services <FONT=20
 =

size=3D2>----------------------------------------------------------------=