RE: prevent database down

From: Jack van Zanen <JACK_at_QUANTSYSTEMS.NL>
Date: Tue, 13 May 2003 00:01:39 -0800
Message-ID: <F001.00597635.20030513000139@fatcity.com>

what version of Oracle?

If by down you mean the oracle process takes up all CPU and new connections do not get serviced (just sit there on the login and do not get any message back) and you are on 8.1.7.3 you might want to look into applying patchset 8.1.7.4.1 (or higher). There are some memory related bugs that can cause this behaviour.

Jack

-----Original Message-----
Sent: maandag 12 mei 2003 17:42
To: Multiple recipients of list ORACLE-L

Hi listers,

I'am in oracle 8i on window 2000 server. In this month my database down almost everyday and the only thing I can do is stop dan restart the database and it makes me curious what's going on with my oracle. Pls anyone on this list, can you give me a good solution how to fix it so it will not happen again. All suggestions is welcome and very appreciated.

Rgrds,

Zettira

---

Get advanced SPAM filtering on Webmail or POP Mail ... Get Lycos Mail! http://login.mail.lycos.com/r/referral?aid=27005
--

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

Author: zions swordfish
  INET: zettira_at_lycos.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: Jack van Zanen
  INET: JACK_at_QUANTSYSTEMS.NL

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 Tue May 13 2003 - 03:01:39 CDT