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

Thread: Init.ora file

  1. #1
    Join Date
    Sep 2001
    Posts
    34

    Init.ora file

    Hi,
    Just a little question.

    I would like to know with which init.ora file is my database started (because I've 3 init file on my server). Does it exist a system view to know it ? Or a tips ?

  2. #2
    Join Date
    Nov 2002
    Location
    Dublin, Ireland
    Posts
    132
    If you are on Unix U will find it in $ORACLE_HOME/dbs and follow the symbolic link if any.
    Giani

  3. #3
    Join Date
    Sep 2001
    Posts
    34
    little precision : oracle 8.1.7

    Thanks

  4. #4
    Join Date
    Apr 2002
    Location
    France
    Posts
    118
    Hi,

    There is unfortunately no view and I don't think no tip neither.
    Only thing : compare the current parameters with your init files, with a bit of luck ( and if they have not been changed by alter system) you will find which one was used.
    If there is no solution, it is because there is no problem - Shadok -

  5. #5
    Join Date
    Nov 2002
    Location
    Geneva Switzerland
    Posts
    3,142
    alrt.log shows the non-default values at startup - there ought to be something there that is different for each init.ora.
    "The power of instruction is seldom of much efficacy except in those happy dispositions where it is almost superfluous" - Gibbon, quoted by R.P.Feynman

  6. #6
    Join Date
    Sep 2001
    Posts
    34
    I'm on windows 2000 Server.

    In [oracle_home]\database, i've a file called init[sid].ora which redirect to another init[sid].ora file..... but when i verify parameters in this file, they doesn't correspond with parameters in my database.... very strange...

  7. #7
    Join Date
    Nov 2002
    Location
    Geneva Switzerland
    Posts
    3,142
    If you start with
    startup pfile=X:\directory\initSID.ora
    then the file used won't be the one in the default location.
    "The power of instruction is seldom of much efficacy except in those happy dispositions where it is almost superfluous" - Gibbon, quoted by R.P.Feynman

  8. #8
    Join Date
    Feb 2001
    Posts
    295
    In other words, there is no way to find out what pfile was used to start the instance. It is possible even that the file was altered or doesn't exist anymore.

    In [oracle_home]\database, i've a file called init[sid].ora which redirect to another init[sid].ora file..... but when i verify parameters in this file, they doesn't correspond with parameters in my database.... very strange...
    Not so strange... maybe someone changed the pfile without bouncing the database, so none of the changes took effect on the instance.
    An ounce of action is worth a ton of theory.
    —Friedrich Engels

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