init.ora
DBAsupport.com Forums - Powered by vBulletin
Results 1 to 10 of 10

Thread: init.ora

  1. #1
    Join Date
    Sep 2002
    Posts
    376

    init.ora

    Hi,
    I have 3 init.ora files my oracle home directory.

    How can i find out which is the one my oracle has used to
    start ?

    Is there any easy way apart from cross checking with file name
    and env variable.
    Any dictionary view gives me the path and name of the init.ora file ????

  2. #2
    Join Date
    Feb 2004
    Posts
    50
    show parameter pfile

  3. #3
    Join Date
    Feb 2000
    Location
    Singapore
    Posts
    1,758
    If you do not explicitly mention pfile then the file from $ORACLE_HOME/dbs is used.
    Sanjay G.
    Oracle Certified Professional 8i, 9i.

    "The degree of normality in a database is inversely proportional to that of its DBA"

  4. #4
    Join Date
    Feb 2000
    Location
    Singapore
    Posts
    1,758
    Originally posted by Rickenbacker
    show parameter pfile
    I don't think it works.
    Sanjay G.
    Oracle Certified Professional 8i, 9i.

    "The degree of normality in a database is inversely proportional to that of its DBA"

  5. #5
    Join Date
    Dec 2000
    Location
    Ljubljana, Slovenia
    Posts
    4,439
    If you don't use spfile then there is no way in this world to identify which pfile was used at startup with absolute accuracy.
    Last edited by jmodic; 02-16-2004 at 08:47 AM.
    Jurij Modic
    ASCII a stupid question, get a stupid ANSI
    24 hours in a day .... 24 beer in a case .... coincidence?

  6. #6
    Join Date
    Feb 2004
    Posts
    50
    Originally posted by SANJAY_G
    I don't think it works.
    Works for me

    Windows 2000 9.2.0.1

  7. #7
    Join Date
    Feb 2000
    Location
    Singapore
    Posts
    1,758
    Originally posted by Rickenbacker
    Works for me

    Windows 2000 9.2.0.1
    HP UX 9.2.0.3
    Code:
    SQL*Plus: Release 9.2.0.3.0 - Production on Mon Feb 16 06:33:08 2004
    
    Copyright (c) 1982, 2002, Oracle Corporation.  All rights reserved.
    
    
    Connected to:
    Oracle9i Enterprise Edition Release 9.2.0.3.0 - 64bit Production
    With the Partitioning option
    JServer Release 9.2.0.3.0 - Production
    
    SQL> show parameter pfile
    
    NAME                                 TYPE        VALUE
    ------------------------------------ ----------- ------------------------------
    spfile                               string
    SQL
    It shows spfile not pfile.. See what jmodic has said above.
    Sanjay G.
    Oracle Certified Professional 8i, 9i.

    "The degree of normality in a database is inversely proportional to that of its DBA"

  8. #8
    Join Date
    Mar 2002
    Location
    Manchester, England
    Posts
    202
    just try
    >show parameter file

  9. #9
    Join Date
    Feb 2000
    Location
    Singapore
    Posts
    1,758
    Originally posted by mrchrispy
    just try
    >show parameter file
    Nope.
    Sanjay G.
    Oracle Certified Professional 8i, 9i.

    "The degree of normality in a database is inversely proportional to that of its DBA"

  10. #10
    Join Date
    Feb 2004
    Posts
    50
    Originally posted by SANJAY_G

    It shows spfile not pfile.. See what jmodic has said above.
    Yea, right enough.

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