RE: Initalization files, etc

Jared,

You can do this with PFILE as well. And to resolve a problem there is (not complicated) solution.

Alex.

-----Original Message-----
Sent: Monday, November 24, 2003 10:05 AM To: Multiple recipients of list ORACLE-L

Mladen,

I'm surprised at you. You didn't mention that using SPFILE makes it possible to put your database in a state that will prevent it from being started.

ie. alter system set shared_pool=1024m scope spfile;

I doubt many systems could handle that.

Kirti and others convinced me to abandon spfile for now.

Jared

On Sun, 2003-11-23 at 23:44, Mladen Gogala wrote:
>
> On 2003.11.24 01:34, VirVit wrote:
> > Hello.
> >
> > I'am a newbie in Oracle, so I have some questions to experts :)
> >
> > 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.
>
> > 3) Where oracle searches datafiles by default?
>
> Nowhere. It doesn't search them. Locations of the control files are a
> mandatory parameter in the parameter file (PFILE and SPFILE) and
> control files contain, among other things, locations of all data,
> temporary and redo log files.
>
> > 4) Sorry for lame questions :(
>
> No problem. There is plenty of literature available on OTN
> (technet.oracle.com) as well as in the bookshops just across the wire,
> like http://www.bn.com (Barnes & Noble). Oracle has a site, maintained
> by the book writer of the year (no, it's not Cary Millsap, it's like
> NFL, the best team never wins. I have quite a few funny stories about
> NFL and being dead certain that I know which team will win, but this
> is not an NFL mailing list). The site is http://asktom.oracle.com.
> It's maintained by Tom Kyte who answers as many questions as humanly
possible. Not all answers are useful, but all are factually correct. The good books to read are probably
> 1) Oracle9i DBA Handbook by Kevin Loney and Marlene Theriault (don't
shoot, Rachel, it's French!)
> 2) Expert 1-on-1 , Tom Kyte
> 3) Practical Oracle 8i (one of the best DBA books ever written, even for a
beginner, pertinent for version 9i
> as well), written by J. Lewis
> 4) Oracle Administratiion and Management by M. Ault (don't buy Oracle8i
Admin. and Mgmt. as it is obsolete.
>

the second edition is much better)
> There are other good books, which are not, in my opinion, suitable for a
beginner.
> 1) Cary Millsap: Optimizing Oracle Performance (excellent book)
> 2) Gaja V., Kirti Deshpande, John Kostelac 101 Oracle Performance Tuning
(really great book)
> 3) Guy Harrison Oracle SQL High Performance Tuning
>
> The mandatory parts of the DBA arsenal are also Robert Freeman's RMAN
> book, Don Burleson's Statspack book and last but least, Andy Duncan,
> Jared Still: Perl for Oracle DBAs (just for the lovers of the
> pathologically eclectic rubish lister)
>
> >
> > Oracle 9.2.0.4, win2k.
>
> It's not your fault. You may want to try with Linux, though.
>
> >
> > --
> > Поцелуев Виталий Игоревич (VirVit)
> > Oracle 9i DBA beginner
> >
> >
> > --
> > 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).
> >
>
> --
> Mladen Gogala
> Oracle DBA
> --
> Please see the official ORACLE-L FAQ: http://www.orafaq.net
> --
> Author: Mladen Gogala
> INET: mgogala_at_adelphia.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).
>

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.net
-- 
Author: Jared Still
  INET: jkstill_at_cybcon.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).



-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.net
-- 
Author: 
  INET: Alexander.Feinstein_at_mitchell1.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).