Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Mailing Lists -> Oracle-L -> RE: Caffeine good.

RE: Caffeine good.

From: Hemant K Chitale <hkchital_at_singnet.com.sg>
Date: Tue, 01 Jul 2003 08:54:53 -0700
Message-ID: <F001.005BCD3D.20030701073437@fatcity.com>


I haven't like SPFILEs either -- haven't got used to them. When I do use an SPFILE, I have a backup init<sid>.ora pfile available. Hemant
At 01:29 PM 30-06-03 -0800, you wrote:
And another thing. If in pre 9i days you tried to allocate more than 2gb to the Oracle.exe process, just cause you have 9i and dynamic memory allocation does not mean that os limits have disappeared. Your text file (init.ora) with the incorrect value in it to edit on the other hand, has.
Actually, I have learned a number of lessons from this experience which may have general applicability.
1. Your co-worker having a bad experience (db crashing with bad init.ora parameters for memory) does not mean that you won't hit the same barrier.
2. Spfiles have extra pain and little convenience over pfiles - read you can screw up badly.

3. don't change the same thing on 3 databases at 16:30 Friday.
4. Actually don't make *any* changes at 16:30 Friday.
5. Windows sucks (ok this isn't exactly a lesson really).
The Niall practicum (no fee-no certification).

On a windows 9i server (not a valuable one OK).

Connect / as sysdba
Alter system set SGA_MAX_SIZE=2047MB scope=spfile; Alter system checkpoint;
Shutdown immediate/abort;
Startup
What happens next? How do you fix it?

Niall

--

Please see the official ORACLE-L FAQ: http://www.orafaq.net
--

Author: Niall Litchfield
  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). Hemant K Chitale
Oracle 9i Database Administrator Certified Professional My personal web site is : http://hkchital.tripod.com
--

Please see the official ORACLE-L FAQ: http://www.orafaq.net
--

Author: Hemant K Chitale
 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). Received on Tue Jul 01 2003 - 10:54:53 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US