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

Thread: Init.ora file

  1. 03-20-2003, 10:03 AM #1
    PWC
    PWC is offline Junior Member
    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 ?
    Reply With Quote Reply With Quote
  2. 03-20-2003, 10:12 AM #2
    Giani's Avatar
    Giani
    Giani is offline Oracle DBA
    Join Date
    Nov 2002
    Location
    Dublin, Ireland
    Posts
    133
    If you are on Unix U will find it in $ORACLE_HOME/dbs and follow the symbolic link if any.
    Giani
    Reply With Quote Reply With Quote
  3. 03-20-2003, 10:13 AM #3
    PWC
    PWC is offline Junior Member
    Join Date
    Sep 2001
    Posts
    34
    little precision : oracle 8.1.7

    Thanks
    Reply With Quote Reply With Quote
  4. 03-20-2003, 10:13 AM #4
    yanban
    yanban is offline Member
    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 -
    Reply With Quote Reply With Quote
  5. 03-20-2003, 10:17 AM #5
    DaPi's Avatar
    DaPi
    DaPi is offline Old Cranky Philosopher
    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
    Reply With Quote Reply With Quote
  6. 03-20-2003, 10:18 AM #6
    PWC
    PWC is offline Junior Member
    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...
    Reply With Quote Reply With Quote
  7. 03-20-2003, 10:20 AM #7
    DaPi's Avatar
    DaPi
    DaPi is offline Old Cranky Philosopher
    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
    Reply With Quote Reply With Quote
  8. 03-20-2003, 10:45 AM #8
    adrianomp's Avatar
    adrianomp
    adrianomp is offline Senior Member
    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
    Reply With Quote Reply With Quote
« Previous Thread | Next Thread »

Posting Permissions

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

Forum Rules

Click Here to Expand Forum to Full Width