| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
 |
 | |||
| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
|
| |||
Home -> Community -> Mailing Lists -> Oracle-L -> RE: Initalization files, etc
But, in this case you can always start it specifying explicitly
PFILE=... (instead of using SPFILE).
Igor Neyman, OCP DBA
ineyman_at_perceptron.com
-----Original Message-----
Jared Still
Sent: Monday, November 24, 2003 1:05 PM
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
> >
-- 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: Igor Neyman INET: ineyman_at_perceptron.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).Received on Mon Nov 24 2003 - 12:24:26 CST
 |
 |