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