Results 1 to 9 of 9
  1. #1
    Join Date
    Jan 2011
    Posts
    32

    Cool Unanswered: spfile is visible, in Vi ? why ?

    Hi All,

    According to ORACLE , spfile is a binary file,

    in my oracle instance, i could read the content

    of the spfile with , Vi

    how is this possible ?

  2. #2
    Join Date
    Aug 2003
    Location
    Where the Surf Meets the Turf @Del Mar, CA
    Posts
    7,776
    Provided Answers: 1
    >how is this possible ?
    vi does not or care about whether a file is binary or not.
    You can use vi to open/edit a PDF file, but will likely corrupt it in the process.
    so accept this reality & worry about those things you can control.
    You can lead some folks to knowledge, but you can not make them think.
    The average person thinks he's above average!
    For most folks, they don't know, what they don't know.
    Good judgement comes from experience. Experience comes from bad judgement.

  3. #3
    Join Date
    Jan 2011
    Posts
    32

    Cool

    Hi anacedent,

    here I mean to say, in text format , i e same as pfile

    I could read all the parameters , in Spfile.

    So how this is possible , coz spfile is a binary file, we cannot read the

    content

    it's content can ,only be altered with

    SQL>alter system set <parameter=value> scope=memory or spfile;

    Regards

  4. #4
    Join Date
    Aug 2003
    Location
    Where the Surf Meets the Turf @Del Mar, CA
    Posts
    7,776
    Provided Answers: 1
    >here I mean to say, in text format , i e same as pfile
    No, spfile NOT the same as pfile.
    compare results of 2 commands below
    od -c pfile
    od -c spfile
    >I could read all the parameters , in Spfile.
    OK
    >So how this is possible ,
    bits are bits
    >coz spfile is a binary file, we cannot read the content
    but you just said you could read it. Do NOT contradict yourself.

    so accept this reality & worry about those things you can control.
    You can lead some folks to knowledge, but you can not make them think.
    The average person thinks he's above average!
    For most folks, they don't know, what they don't know.
    Good judgement comes from experience. Experience comes from bad judgement.

  5. #5
    Join Date
    Jan 2011
    Posts
    32

    Cool

    Thanks for the reply

    I humbly , want to say, that again,

    i could read the contents of

    spfile(SID).ora , which is located in

    /oracle/SID/102_64/dbs

    tommorow, i shall check other of my systems

    and revert you with my findings



    Regards

  6. #6
    Join Date
    Aug 2003
    Location
    Where the Surf Meets the Turf @Del Mar, CA
    Posts
    7,776
    Provided Answers: 1
    >i could read the contents of spfile(SID).ora , which is located in /oracle/SID/102_64/dbs
    Not even an interesting observation.
    How does this fact change your behavior, Oracle's behavior, or anything else in the universe?
    You can lead some folks to knowledge, but you can not make them think.
    The average person thinks he's above average!
    For most folks, they don't know, what they don't know.
    Good judgement comes from experience. Experience comes from bad judgement.

  7. #7
    Join Date
    Jun 2004
    Location
    Liverpool, NY USA
    Posts
    2,509
    spfile has a binary header and command separator but the rest is in text. however it is not modifiable, change it using vi and your database will not start up.
    Bill
    You do not need a parachute to skydive. You only need a parachute to skydive twice.

  8. #8
    Join Date
    Jan 2011
    Posts
    32

    Cool

    Hi beilstwh

    Thanks for the Reply, and for clarifying the query


    Regards

  9. #9
    Join Date
    Jul 2003
    Posts
    2,296
    yeah, if you modify the file through vi then you corrupt the file and cannot start your database with it.
    - The_Duck
    you can lead someone to something but they will never learn anything ...

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •