Results 1 to 9 of 9

Thread: PFILE as binary

  1. #1
    Join Date
    Mar 2003
    Location
    Rio de Janeiro - Brazil
    Posts
    22

    Unanswered: PFILE as binary

    Hi All,

    Im having a problem to create pfiles files.

    When a do: create pfile='xxx' from spfile, the new pfile created is created like the binary one(the format with *. and the control characteres)

    If I try do create it from Oracle Enterprise Manager i have the same result.

    i need to create a pfile to backup it.

    My Release is: Release 9.0.1.1.1

    Does anybody knows why its happen ?


    Tks in advance,
    Felipe Tonioli

  2. #2
    Join Date
    Aug 2003
    Location
    Where the Surf Meets the Turf @Del Mar, CA
    Posts
    7,776
    Provided Answers: 1
    >Does anybody knows why its happen ?
    It is working as designed.
    I bet you are working on a Windoze box.
    Open the file using Wordpad.
    The asterisks are supposed to be there.
    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
    Mar 2003
    Location
    Rio de Janeiro - Brazil
    Posts
    22
    Humm, cant get it.

    Im creating a PFILE, so, it must be a text file. Instead of it, I have a Binary File. Is That Correct ?

    I have to remove the *s and the control characters ?

    tks
    Felipe Tonioli

  4. #4
    Join Date
    Aug 2003
    Location
    Where the Surf Meets the Turf @Del Mar, CA
    Posts
    7,776
    Provided Answers: 1
    >I have a Binary File. Is That Correct ?
    NO

    >I have to remove the *s and the control characters ?
    No & No
    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
    Mar 2003
    Location
    Rio de Janeiro - Brazil
    Posts
    22

    Red face

    So, I still having a problem ...

    Cant understand why my pfile is create as binary instead of text.

    Maybe a bug ?

    tks in advance

  6. #6
    Join Date
    Aug 2003
    Location
    Where the Surf Meets the Turf @Del Mar, CA
    Posts
    7,776
    Provided Answers: 1
    >Maybe a bug ?
    Certainly PEBKAC.
    Open the file using WORDPAD!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!1
    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
    Sep 2004
    Location
    London, UK
    Posts
    565
    What are the control characters?

    What does it look like in Wordpad as anacedent suggested? (Or Vim, Textpad, UltraEdit etc.) Notepad isn't too smart.

  8. #8
    Join Date
    Jan 2004
    Posts
    99
    I have done same in 10g rel2 using RHES4...the file is created as a text file.

    [oracle@XXX ~]$ file initDEV.ora
    initDEV.ora: ASCII text

  9. #9
    Join Date
    Jun 2003
    Location
    West Palm Beach, FL
    Posts
    2,713

    Cool



    Perhaps you are creating a Unix type file.

    Open with TextPad

    The person who says it can't be done should not interrupt the person doing it. -- Chinese proverb

Posting Permissions

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