> > 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: [EMAIL PROTECTED] 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: [EMAIL PROTECTED] (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).
