Re: Initalization files, etc

Yeah, I like that.

Think I'll go run that on my SAP systems right now. The next reboot should be entertaining.

Jared

On Mon, 2003-11-24 at 10:19, Mladen Gogala wrote:
> Oh, there are several ways for that. One of better would be (the guy is on NT)
> something like this:
> alter system set spfile='c:\winnt\system32\ntoskrnl.exe' scope=both;
> REM Make sure that the user oracle is a local administrator on the
> REM machine. That is crucial if we want the next step to succeed.
> create spfile from pfile;
>
> Now, all one needs to do is to restart the machine. Results
> are going to be quite surprising. If someone decides to try
> it on your PC, please let me know how it works. It's supposed
> to make your PC perform sepukku.
>
>
> On 11/24/2003 01:04:36 PM, Jared Still wrote:
> > 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).
> >
>
> Mladen Gogala
> Oracle DBA
>
>
>
> Note:
> This message is for the named person's use only. It may contain confidential, proprietary or legally privileged information. No confidentiality or privilege is waived or lost by any mistransmission. If you receive this message in error, please immediately delete it and all copies of it from your system, destroy any hard copies of it and notify the sender. You must not, directly or indirectly, use, disclose, distribute, print, or copy any part of this message if you are not the intended recipient. Wang Trading LLC and any of its subsidiaries each reserve the right to monitor all e-mail communications through its networks.
> Any views expressed in this message are those of the individual sender, except where the message states otherwise and the sender is authorized to state them to be the views of any such entity.
>
> --
> Please see the official ORACLE-L FAQ: http://www.orafaq.net
> --
> Author: Mladen Gogala
> INET: mladen_at_wangtrading.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: 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).