Jared,
You can do this with PFILE as well. And to resolve a problem there is (not complicated) solution.
Alex.
-----Original Message-----
From: Jared Still [mailto:[EMAIL PROTECTED]]
Sent: Monday, November 24, 2003 10:05 AM
To: Multiple recipients of list ORACLE-L
Subject: Re: Initalization files, etc
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: [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).
> >
>
> --
> Mladen Gogala
> Oracle DBA
> --
> Please see the official ORACLE-L FAQ: http://www.orafaq.net
> --
> Author: Mladen Gogala
> 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).
>
--
Please see the official ORACLE-L FAQ: http://www.orafaq.net
--
Author: Jared Still
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).
