DBAsupport.com Forums - Powered by vBulletin
Results 1 to 8 of 8

Thread: Have a question

  1. #1
    Join Date
    Feb 2002
    Posts
    41

    Question

    I would appreciate if someone can clue me in.

    How does the database know where to find it's initialization file when not started up with the pfile= parameter?

    The reason for this question is that, while performing some tests, I deleted both the link and the database init.ora file. Despite this, the database is still starting up !!!

    Link was in /opt/oracle/product/9.0.1/dbs, and pfile was in
    /opt/oracle/admin/test1/pfile.

    I just deleted them and was expecting some kind of error, but database started up as if nothing had happened.

    TIA







  2. #2
    Join Date
    Mar 2002
    Location
    Mesa, Arizona
    Posts
    1,204
    It looks at your environment first for the value of $ORACLE_HOME and it looks under $ORACLE_HOME/dbs

    Look at your $ORACLE_HOME environment var. It's probably pointing to a different directory than you think.
    "I do not fear computers. I fear the lack of them." Isaac Asimov
    Oracle Scirpts DBA's need

  3. #3
    Join Date
    Feb 2002
    Posts
    41
    Ken,

    Oracle Home is /opt/oracle/product/9.0.1

    I also deleted the link located in /opt/oracle/product/9.0.1/dbs which was pointing to the actual pfile.

    Both link and pfile were deleted and database still starts up!

    Any clue?

  4. #4
    Join Date
    Mar 2002
    Location
    Mesa, Arizona
    Posts
    1,204
    Do you have an spINSTANCENAME.ora -substitute your instance name- file in $ORACLE_HOME/dbs?
    "I do not fear computers. I fear the lack of them." Isaac Asimov
    Oracle Scirpts DBA's need

  5. #5
    Join Date
    Oct 2000
    Location
    Charlotte, USA
    Posts
    330
    In 9i database .....What about spfile?.
    it will startup using spfile....(might have created ...)
    it uses the init.ora file only at the time of first time startup..
    next time onwards it uses the spfile.
    Try to startup after deleting/renaming the spfile...you will get error.
    It is a spl feature in 9i.
    Thanks.
    Thanigaivasan.

  6. #6
    Join Date
    Feb 2002
    Posts
    41

    Talking

    You both got it !!!

    Thanks, this spfilexxxx is new to me! I did not know it existed.

    a) I renamed it and it resulted in an error.
    b) I generated a link in the $ORACLE_HOME/dba pointing to the init.ora (which I had moved to another folder) and it started normally, but spfile was not recreated.

    Questions (If you please)

    spfile replaces init.ora?
    Which one of them should I backup?
    Which one of them is better to use?

    Thanks a lot.

  7. #7
    Join Date
    Mar 2002
    Location
    Mesa, Arizona
    Posts
    1,204
    spfile is a binary file, so you can't modify it, but you can make dynamic parameter changes and they'll be stored in the spfile.

    You can export an initSID.ora file from the spfile, then back that up if you want something you can read/modify.

    bottom line, if I wanted dynamic parameter changes, I'd use an spfile and add an export of it to my backup. Otherwise, I'd stick to my initSID.ora file.
    "I do not fear computers. I fear the lack of them." Isaac Asimov
    Oracle Scirpts DBA's need

  8. #8
    Join Date
    Feb 2002
    Posts
    41

    Thumbs up

    Thanks pal.

Posting Permissions

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


Click Here to Expand Forum to Full Width