RE: Initalization files, etc

Hi VirVit

> -----Original Message-----
> From: ml-errors_at_fatcity.com [mailto:ml-errors_at_fatcity.com] 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: niall.litchfield_at_dial.pipex.com

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).