Hi VirVit > -----Original Message----- > From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On > Behalf Of VirVit > Sent: 24 November 2003 07:54 > To: Multiple recipients of list ORACLE-L > Subject: 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.
This is a great description of the difference. > > > > > 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). On windows by default Oracle will look in %oracle_home% (prob d:\oracle\ora92 from your description)\database for these files. Thus I expect you to be starting your database with spfilevirvitdb.ora. You can tell be typing show parameter spfile when in sqlplus as system/sys. > In Windows Service Params I've found no specification of path > to PFILE or SPFILE. So, where Oracle finds these files? Specified by oradim at db creation and can be read from HKEY\local machine\software\oracle in the registry. HTH Niall -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Niall Litchfield 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).
