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

Thread: which pfile is being used

  1. #1
    Join Date
    Mar 2001
    Location
    New York , New York
    Posts
    577
    Hi,

    How do you determine the location of the pfile used to bring up the database.

    We have multiple copies of pfile on the machine and want a easy way to find out whuch pfile was used. I know about the entry in the windows registry. Thats not what i am looking for.

    I am on windows 2000 .


    Thanks
    Ronnie
    ronnie_yours@yahoo.com

    You can if you think you can.

  2. #2
    Join Date
    Dec 2000
    Location
    Ljubljana, Slovenia
    Posts
    4,439
    Absolutely no way to determine that. That's one of the reasons why Oracle9i introduced "spfiles".
    Jurij Modic
    ASCII a stupid question, get a stupid ANSI
    24 hours in a day .... 24 beer in a case .... coincidence?

  3. #3
    Join Date
    Oct 2000
    Location
    Halifax, Nova Scotia
    Posts
    197
    What kind of statement is being used to start up the database.

    Are you just issuing STARTUP or STARTUP PFILE= or is this a 9i database and a SPFILE has been created for it

    The first place I would look is the ORACLE_HOME/dbs directory for an init.ora file.

    Don't be afraid to try something new. Amateurs built the Ark, professionals built the Titanic

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