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

Thread: pfile-

  1. #1
    Join Date
    Jan 2002
    Posts
    45

    Question

    Hi friends & Gurus:

    I am running into a very annoying problem and am hoping that one of you may be able to help me. I created a query against the v$parameter view to get the exact path of the pfile. The query is:

    Select value from v$parameter where name ='ifile';

    The interesting thing is that when I ran this against some of the databases that are on the same server, some of them return a value (exact path) but some don't. Since all the databases run on Oracle 8.16/Win2K, I am not sure why. Please help. I will need to get this done ASAP since we'll be 'cleaning up' the server this weekend and want to make sure we have all the info.

    Thanks in advance for all the help.

    John

  2. #2
    Join Date
    Dec 2000
    Location
    Ljubljana, Slovenia
    Posts
    4,439
    IFILE does not contain the path to pfile! In fact you won't be able to find the path and the name of the pfile that was used when starting the instance nowhere in the dictionary! It is simply not there, it can't be. That's why they invented spfile concept in 9i.

    IFILE is only another parameter which can be specified inside the actual init parameter file. It instructs Oracle to read that file for additional parameters that might be listed in that file.

    So for instances that return something for your query this parameter was specified in their init file, with others this parameter was not used. But in any case the path reported might be totaly different than the path of the actual pfile.
    Jurij Modic
    ASCII a stupid question, get a stupid ANSI
    24 hours in a day .... 24 beer in a case .... coincidence?

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