Re: Initalization files, etc

> > 1) What difference between SPFILE and PFILE?
>
> Big one. It's best described in the concepts manual as well as in the DBA
guide.
> To make long story short, you can modify SPFILE from sqlplus which is not
> possible with PFILe. SPFILE is "binary" (quotes are here because it's not
very binary, just a little),
> while PFILE is a standard text file.
>
> > 2) Where by default Oracle search these files when instance starts?
>
> In %ORACLE_HOME%\DBS directory.

Well. But, I have Oracle installed by default to d:\oracle It's structure is:
d:\oracle\
admin
oradata
ora92 (it's my home dir)

in admin I have pfile\init.ora.<long number> with pfile structe (plain text) and in ora92\databases\spfilevirvitdb.ora (seems SPFILE as it in binary format).

In Windows Service Params I've found no specification of path to PFILE or SPFILE. So, where Oracle finds these files?

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.net
-- 
Author: VirVit
  INET: virvit_at_prodtorg.udm.net

Fat City Network Services    -- 858-538-5051 http://www.fatcity.com
San Diego, California        -- Mailing list and web hosting services
---------------------------------------------------------------------
To REMOVE yourself from this mailing list, send an E-Mail message
to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).