FAQ
I have an Oracle 8.1.7.0 database running on an MS2000 server. A few
times a day the database just stops running for no reason.
There are no messages in the alert or trace logs. Nothing in the Event
logs. It just stops.


When I restart the database it goes through crash recovery but comes up
fine.


Anyone have any ideas?


Thanks!
Ron Smith

--
Please see the official ORACLE-L FAQ: http://www.orafaq.net
--
Author: Smith, Ron L.
INET: rlsmith_at_kmg.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).

Search Discussions

  • Gudmundur Bjarni Josepsson at Oct 14, 2003 at 8:34 pm
    This probably sounds like Oracle Support but I'd start by patching to
    8.1.7.4.1.


    Regards,
    Gudmundur

    -----Original Message-----
    Smith, Ron L.
    Sent: 14. október 2003 20:14
    To: Multiple recipients of list ORACLE-L

    I have an Oracle 8.1.7.0 database running on an MS2000 server. A few
    times a day the database just stops running for no reason.
    There are no messages in the alert or trace logs. Nothing in the Event
    logs. It just stops.


    When I restart the database it goes through crash recovery but comes up
    fine.


    Anyone have any ideas?


    Thanks!
    Ron Smith

    --
    Please see the official ORACLE-L FAQ: http://www.orafaq.net
    --
    Author: Gudmundur Bjarni Josepsson
    INET: gbj_at_index.is

    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).
  • Johnston, Tim at Oct 14, 2003 at 8:39 pm
    Hi Ron...


    You need to poke it and find out what's it's doing... I'd start with the
    following Metalink notes...


    Note 175006.1
    Note 215858.1
    Note 61552.1

    They cover diagnosing database hanging issues...


    SYSTEMSTATE AND HANGANALYZE DUMPS OH MY!


    Good luck...


    Tim


    -----Original Message-----
    Sent: Tuesday, October 14, 2003 4:14 PM
    To: Multiple recipients of list ORACLE-L

    I have an Oracle 8.1.7.0 database running on an MS2000 server. A few times
    a day the database just stops running for no reason.
    There are no messages in the alert or trace logs. Nothing in the Event
    logs. It just stops.


    When I restart the database it goes through crash recovery but comes up
    fine.


    Anyone have any ideas?


    Thanks!
    Ron Smith

    --
    Please see the official ORACLE-L FAQ: http://www.orafaq.net
    --
    Author: Johnston, Tim
    INET: TJohnston_at_quallaby.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).
  • Ryan at Oct 14, 2003 at 8:39 pm
    Messagedefine 'just stops'. A specific user cant do anything. CAn any users log in?

    are you in archive log mode? If so this is possibly a sign that your archiver cant keep up with the amount of redo to archive.

    Original Message -----
    From: Smith, Ron L.
    To: Multiple recipients of list ORACLE-L
    Sent: Tuesday, October 14, 2003 4:14 PM
    Subject: Database just stops

    I have an Oracle 8.1.7.0 database running on an MS2000 server. A few times a day the database just stops running for no reason.
    There are no messages in the alert or trace logs. Nothing in the Event logs. It just stops.

    When I restart the database it goes through crash recovery but comes up fine.

    Anyone have any ideas?

    Thanks!
    Ron Smith

    --
    Please see the official ORACLE-L FAQ: http://www.orafaq.net
    --
    Author: Ryan
    INET: rgaffuri_at_cox.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).
  • Oracle-L at Oct 14, 2003 at 8:39 pm
    MessageWhen you mean by "stops" - do u mean you are not able to connect any more from sql*net ? or even the current sessions hang ?

    Are you running this in archivelog mode ? Is it possible that the database is in archivelog more and the archiver is not running ?

    Babu

    Original Message -----
    From: Smith, Ron L.
    To: Multiple recipients of list ORACLE-L
    Sent: Tuesday, October 14, 2003 3:14 PM
    Subject: Database just stops

    I have an Oracle 8.1.7.0 database running on an MS2000 server. A few times a day the database just stops running for no reason.
    There are no messages in the alert or trace logs. Nothing in the Event logs. It just stops.

    When I restart the database it goes through crash recovery but comes up fine.

    Anyone have any ideas?

    Thanks!
    Ron Smith
    --
    Please see the official ORACLE-L FAQ: http://www.orafaq.net
    --
    Author: Oracle-L
    INET: orclbabu_at_hotmail.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 at Oct 14, 2003 at 8:39 pm
    So, what happens when you try to connect internal?
    I haven't worked with 8.1.7 database for eternity (since 8/4/03)
    but I believe that syntax is something like:
    svrmgrl
    connect internal

    Furthermore, did you notice existence of beautiful files
    named something like *SMON*.TRC or *PMON*.TRC (same
    for LGWR, DBWR and CKPT)?
    What is the last entry in alert.log and are looking into
    the right one?
    On 10/14/2003 04:14:25 PM, "Smith, Ron L." wrote:
    I have an Oracle 8.1.7.0 database running on an MS2000 server. A few
    times a day the database just stops running for no reason.
    There are no messages in the alert or trace logs. Nothing in the
    Event
    logs. It just stops.

    When I restart the database it goes through crash recovery but comes
    up
    fine.

    Anyone have any ideas?

    Thanks!
    Ron Smith
    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).
  • Paul Drake at Oct 14, 2003 at 8:59 pm
    Ron,


    Its highly likely that if you were to open a TAR on this, that the analyst would recite the following:


    "please apply the currently supported patchset" - which would be 8.1.7.4.1.


    Unfortunately, there are numerous security fixes that have been made available that are not in a full patchset release (one that can be applied with OUI) - e.g. patchset 8.1.7.4.12. I'd recommend having the security fixes in place, but Oracle is less than wonderful about how they word the use of one-off patchsets. So, if you're risk-averse in terms of applying patchsets instead of being risk-averse in terms of some user running load with a long username/password and crashing the instance (security), at least apply the 8.1.7.4.1 patchset.


    There is exploit code in the wild (shipped by oracle) that can crash an instance.
    You should be able to find an entry in the listener.log file for this.
    It is highly unlikely that this is causing the crash, however.
    (email me backchannel, as I don't want to


    IMHO: Oracle should release an 8.1.7.5.x patchset so that the security fixes are in a full patchset release. Now that they've extended support for a year of 8.1.7, there really isn't an excuse not to.


    Unless you get lucky, you're going to have to apply a patchset.
    So why not just apply the patchset (properly, after reading the release notes, full backups, exports, etc) and see if that takes care of the problem?


    More often then not, the issue has been encountered by some other user, they filed a tar >> bug report >> bug fix >> patch (a lengthy process).


    hth.


    Paul

    "Smith, Ron L." wrote:
    I have an Oracle 8.1.7.0 database running on an MS2000 server. A few times a day the database just stops running for no reason.
    There are no messages in the alert or trace logs. Nothing in the Event logs. It just stops.


    When I restart the database it goes through crash recovery but comes up fine.


    Anyone have any ideas?


    Thanks!
    Ron Smith

    Do you Yahoo!?
    The New Yahoo! Shopping - with improved product search

    --
    Please see the official ORACLE-L FAQ: http://www.orafaq.net
    --
    Author: Paul Drake
    INET: discgolfdba_at_yahoo.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).
  • Ryan at Oct 14, 2003 at 9:09 pm
    Messagei ran into this problem with DOM objects.we were loading them in memory and taking up so much memory the only way to even access the database was through connect internal. couldnt connect any other way. had to shutdown abort. I cant find any notes on it though.

    Original Message -----
    From: Ryan
    To: Multiple recipients of list ORACLE-L
    Sent: Tuesday, October 14, 2003 4:39 PM
    Subject: Re: Database just stops

    define 'just stops'. A specific user cant do anything. CAn any users log in?

    are you in archive log mode? If so this is possibly a sign that your archiver cant keep up with the amount of redo to archive.

    Original Message -----
    From: Smith, Ron L.
    To: Multiple recipients of list ORACLE-L
    Sent: Tuesday, October 14, 2003 4:14 PM
    Subject: Database just stops

    I have an Oracle 8.1.7.0 database running on an MS2000 server. A few times a day the database just stops running for no reason.
    There are no messages in the alert or trace logs. Nothing in the Event logs. It just stops.

    When I restart the database it goes through crash recovery but comes up fine.

    Anyone have any ideas?

    Thanks!
    Ron Smith

    --
    Please see the official ORACLE-L FAQ: http://www.orafaq.net
    --
    Author: Ryan
    INET: rgaffuri_at_cox.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).
  • Stephane Paquette at Oct 14, 2003 at 9:09 pm
    MessageIf the archive destination is full then for sure the database will
    stop but it will not crash.
    It's probably a bug, you should probably go to 8.1.7.4.

    Talking about database stop, I just did an audit at a client site, during my
    spare time.
    The top 3 SQL:
    The first one was run 20 times per second and has 1280 gets
    The second one was run 14 times per minute and each execution has 78091 gets
    The third one was run 1 per minute and each execution has 965637 gets.

    The database was really stopped !!!
    Of course the application vendor was talking about adding more hardware ...

    Stephane
    -----Original Message-----
    From: ml-errors_at_fatcity.com On Behalf Of
    Oracle-L
    Sent: 14 octobre, 2003 16:40
    To: Multiple recipients of list ORACLE-L
    Subject: Re: Database just stops

    When you mean by "stops" - do u mean you are not able to connect any more
    from sql*net ? or even the current sessions hang ?

    Are you running this in archivelog mode ? Is it possible that the database
    is in archivelog more and the archiver is not running ?

    Babu

    Original Message -----
    From: Smith, Ron L.
    To: Multiple recipients of list ORACLE-L
    Sent: Tuesday, October 14, 2003 3:14 PM
    Subject: Database just stops

    I have an Oracle 8.1.7.0 database running on an MS2000 server. A few
    times a day the database just stops running for no reason.

    There are no messages in the alert or trace logs. Nothing in the Event
    logs. It just stops.

    When I restart the database it goes through crash recovery but comes up
    fine.

    Anyone have any ideas?

    Thanks!
    Ron Smith

    --
    Please see the official ORACLE-L FAQ: http://www.orafaq.net
    --
    Author: Stephane Paquette
    INET: stephane.paquette_at_standardlife.ca

    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).
  • Smith, Ron L. at Oct 14, 2003 at 9:24 pm
    Thanks for the replies. The server admin fessed up and said he had
    bounced the server a few times to do some software installs.


    Thanks!
    Ron

    -----Original Message-----
    From: Stephane Paquette

    Sent: Tuesday, October 14, 2003 4:10 PM
    To: Multiple recipients of list ORACLE-L
    Subject: RE: Database just stops

    If the archive destination is full then for sure the database
    will stop but it will not crash.
    It's probably a bug, you should probably go to 8.1.7.4.

    Talking about database stop, I just did an audit at a client
    site, during my spare time.
    The top 3 SQL:
    The first one was run 20 times per second and has 1280 gets
    The second one was run 14 times per minute and each execution
    has 78091 gets
    The third one was run 1 per minute and each execution has 965637

    gets.


    The database was really stopped !!!
    Of course the application vendor was talking about adding more

    hardware ...


    Stephane

    -----Original Message-----
    From: ml-errors_at_fatcity.com
    On Behalf Of Oracle-L
    Sent: 14 octobre, 2003 16:40
    To: Multiple recipients of list ORACLE-L
    Subject: Re: Database just stops

    When you mean by "stops" - do u mean you are not able to

    connect any more from sql*net ? or even the current sessions hang ?


    Are you running this in archivelog mode ? Is it possible
    that the database is in archivelog more and the archiver is not running
    ?


    Babu



    Original Message -----
    From: Smith, Ron L.
    To: Multiple recipients of list ORACLE-L

    Sent: Tuesday, October 14, 2003 3:14 PM
    Subject: Database just stops

    I have an Oracle 8.1.7.0 database running on an
    MS2000 server. A few times a day the database just stops running for no
    reason.

    There are no messages in the alert or trace
    logs. Nothing in the Event logs. It just stops.


    When I restart the database it goes through
    crash recovery but comes up fine.


    Anyone have any ideas?


    Thanks!
    Ron Smith

    --
    Please see the official ORACLE-L FAQ: http://www.orafaq.net
    --
    Author: Smith, Ron L.
    INET: rlsmith_at_kmg.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).
  • Caffrey, Melanie at Oct 15, 2003 at 12:39 pm
    Paul,


    My question is a little off-topic here, but since Ron has already discovered the source of his problem ...


    You state below that Oracle has "extended support for a year of 8.1.7".


    What do you mean exactly? For instance, when does support actually end, then?


    The reason I ask is that the word from Ken Jacobs in September was that 8i would only be supported through the end of this calendar year.


    This is incredibly relevant information, for I will have to guide my clients accordingly.


    Regards,
    Melanie

    -----Original Message-----
    From: Paul Drake
    Sent: Tue 10/14/2003 4:59 PM
    To: Multiple recipients of list ORACLE-L
    Cc:
    Subject: Re: Database just stops

    Ron,

    Its highly likely that if you were to open a TAR on this, that the analyst would recite the following:

    "please apply the currently supported patchset" - which would be 8.1.7.4.1.

    Unfortunately, there are numerous security fixes that have been made available that are not in a full patchset release (one that can be applied with OUI) - e.g. patchset 8.1.7.4.12. I'd recommend having the security fixes in place, but Oracle is less than wonderful about how they word the use of one-off patchsets. So, if you're risk-averse in terms of applying patchsets instead of being risk-averse in terms of some user running load with a long username/password and crashing the instance (security), at least apply the 8.1.7.4.1 patchset.

    There is exploit code in the wild (shipped by oracle) that can crash an instance.
    You should be able to find an entry in the listener.log file for this.
    It is highly unlikely that this is causing the crash, however.
    (email me backchannel, as I don't want to

    IMHO: Oracle should release an 8.1.7.5.x patchset so that the security fixes are in a full patchset release. Now that they've extended support for a year of 8.1.7, there really isn't an excuse not to.

    Unless you get lucky, you're going to have to apply a patchset.
    So why not just apply the patchset (properly, after reading the release notes, full backups, exports, etc) and see if that takes care of the problem?

    More often then not, the issue has been encountered by some other user, they filed a tar >> bug report >> bug fix >> patch (a lengthy process).

    hth.

    Paul

    "Smith, Ron L." wrote:

    I have an Oracle 8.1.7.0 database running on an MS2000 server. A few times a day the database just stops running for no reason.
    There are no messages in the alert or trace logs. Nothing in the Event logs. It just stops.

    When I restart the database it goes through crash recovery but comes up fine.

    Anyone have any ideas?

    Thanks!
    Ron Smith

    Do you Yahoo!?
    The New Yahoo! Shopping <http://shopping.yahoo.com/?__yltc=s%3A150000443%2Cd%3A22708228%2Cslk%3Atext%2Csec%3Amail> - with improved product search

    --
    Please see the official ORACLE-L FAQ: http://www.orafaq.net
    --
    Author: Caffrey, Melanie
    INET: mcaffrey_at_proximo.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).
  • Rachel Carmichael at Oct 15, 2003 at 1:14 pm
    support for 8i has been extended to 12/31/2004

    "Caffrey, Melanie" wrote:
    Paul,

    My question is a little off-topic here, but since Ron has already
    discovered the source of his problem ...

    You state below that Oracle has "extended support for a year of
    8.1.7".

    What do you mean exactly? For instance, when does support actually
    end, then?

    The reason I ask is that the word from Ken Jacobs in September was
    that 8i would only be supported through the end of this calendar
    year.

    This is incredibly relevant information, for I will have to guide my
    clients accordingly.

    Regards,
    Melanie

    -----Original Message-----
    From: Paul Drake
    Sent: Tue 10/14/2003 4:59 PM
    To: Multiple recipients of list ORACLE-L
    Cc:
    Subject: Re: Database just stops


    Ron,

    Its highly likely that if you were to open a TAR on this, that the
    analyst would recite the following:

    "please apply the currently supported patchset" - which would be
    8.1.7.4.1.

    Unfortunately, there are numerous security fixes that have been made
    available that are not in a full patchset release (one that can be
    applied with OUI) - e.g. patchset 8.1.7.4.12. I'd recommend having
    the security fixes in place, but Oracle is less than wonderful about
    how they word the use of one-off patchsets. So, if you're risk-averse
    in terms of applying patchsets instead of being risk-averse in terms
    of some user running load with a long username/password
    and crashing the instance (security), at least apply the 8.1.7.4.1
    patchset.

    There is exploit code in the wild (shipped by oracle) that can crash
    an instance.
    You should be able to find an entry in the listener.log file for
    this.
    It is highly unlikely that this is causing the crash, however.
    (email me backchannel, as I don't want to

    IMHO: Oracle should release an 8.1.7.5.x patchset so that the
    security fixes are in a full patchset release. Now that they've
    extended support for a year of 8.1.7, there really isn't an excuse
    not to.

    Unless you get lucky, you're going to have to apply a patchset.
    So why not just apply the patchset (properly, after reading the
    release notes, full backups, exports, etc) and see if that takes care
    of the problem?

    More often then not, the issue has been encountered by some other
    user, they filed a tar >> bug report >> bug fix >> patch (a lengthy
    process).

    hth.

    Paul

    "Smith, Ron L." wrote:

    I have an Oracle 8.1.7.0 database running on an MS2000 server. A
    few times a day the database just stops running for no reason.
    There are no messages in the alert or trace logs. Nothing in the
    Event logs. It just stops.

    When I restart the database it goes through crash recovery but
    comes up fine.

    Anyone have any ideas?

    Thanks!
    Ron Smith


    _____

    Do you Yahoo!?
    The New Yahoo! Shopping
    <http://shopping.yahoo.com/?__yltc=s%3A150000443%2Cd%3A22708228%2Cslk%3Atext%2Csec%3Amail>
    - with improved product search

    --
    Please see the official ORACLE-L FAQ: http://www.orafaq.net
    --
    Author: Caffrey, Melanie
    INET: mcaffrey_at_proximo.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).
    Do you Yahoo!?
    The New Yahoo! Shopping - with improved product search
    http://shopping.yahoo.com

    --
    Please see the official ORACLE-L FAQ: http://www.orafaq.net
    --
    Author: Rachel Carmichael
    INET: wisernet100_at_yahoo.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).
  • Whittle Jerome Contr NCI at Oct 15, 2003 at 1:44 pm
    Where do we send the flowers? I'm assuming that you killed or at least severely wounded him.

    Jerry Whittle
    ASIFICS DBA

    NCI Information Systems Inc.
    jerome.whittle_at_scott.af.mil
    618-622-4145
    -----Original Message-----
    From: Smith, Ron L. [SMTP:rlsmith_at_kmg.com]

    Thanks for the replies. The server admin fessed up and said he had bounced the server a few times to do some software installs.

    Thanks!
    Ron
    --
    Please see the official ORACLE-L FAQ: http://www.orafaq.net
    --
    Author: Whittle Jerome Contr NCI
    INET: Jerome.Whittle_at_scott.af.mil

    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).
  • Caffrey, Melanie at Oct 15, 2003 at 2:04 pm
    Oh, OK. I just looked at Metalink and saw that this announcement took place less than a week ago.


    I guess the original announcement of desupport panicked quite a few people. Hence the extension.


    Anyway, since I've already recommended upgrades to 9i, I'm going to stick with it.


    No reason to encourage anybody to stick with old technology unless they are in dire financial straits ...

    -----Original Message-----
    From: Rachel Carmichael
    Sent: Wed 10/15/2003 9:14 AM
    To: Multiple recipients of list ORACLE-L
    Cc:
    Subject: RE: Database just stops

    support for 8i has been extended to 12/31/2004

    --- "Caffrey, Melanie" wrote:
    Paul, >
    My question is a little off-topic here, but since Ron has already
    discovered the source of his problem ... >
    You state below that Oracle has "extended support for a year of
    8.1.7". >
    What do you mean exactly? For instance, when does support actually
    end, then? >
    The reason I ask is that the word from Ken Jacobs in September was
    that 8i would only be supported through the end of this calendar
    year. >
    This is incredibly relevant information, for I will have to guide my
    clients accordingly. >
    Regards,
    Melanie >
    -----Original Message-----
    From: Paul Drake
    Sent: Tue 10/14/2003 4:59 PM
    To: Multiple recipients of list ORACLE-L
    Cc:
    Subject: Re: Database just stops
    >
    >
    Ron, >
    Its highly likely that if you were to open a TAR on this, that the
    analyst would recite the following: >
    "please apply the currently supported patchset" - which would be
    8.1.7.4.1. >
    Unfortunately, there are numerous security fixes that have been made
    available that are not in a full patchset release (one that can be
    applied with OUI) - e.g. patchset 8.1.7.4.12. I'd recommend having
    the security fixes in place, but Oracle is less than wonderful about
    how they word the use of one-off patchsets. So, if you're risk-averse
    in terms of applying patchsets instead of being risk-averse in terms
    of some user running load with a long username/password
    and crashing the instance (security), at least apply the 8.1.7.4.1
    patchset. >
    There is exploit code in the wild (shipped by oracle) that can crash
    an instance.
    You should be able to find an entry in the listener.log file for
    this.
    It is highly unlikely that this is causing the crash, however.
    (email me backchannel, as I don't want to >
    IMHO: Oracle should release an 8.1.7.5.x patchset so that the
    security fixes are in a full patchset release. Now that they've
    extended support for a year of 8.1.7, there really isn't an excuse
    not to. >
    Unless you get lucky, you're going to have to apply a patchset.
    So why not just apply the patchset (properly, after reading the
    release notes, full backups, exports, etc) and see if that takes care
    of the problem? >
    More often then not, the issue has been encountered by some other
    user, they filed a tar >> bug report >> bug fix >> patch (a lengthy
    process). >
    hth. >
    Paul >
    "Smith, Ron L." wrote: >
    I have an Oracle 8.1.7.0 database running on an MS2000 server. A
    few times a day the database just stops running for no reason.
    There are no messages in the alert or trace logs. Nothing in the
    Event logs. It just stops. >
    When I restart the database it goes through crash recovery but
    comes up fine. >
    Anyone have any ideas? >
    Thanks!
    Ron Smith
    >
    >
    _____ >
    Do you Yahoo!?
    The New Yahoo! Shopping
    >
    <http://shopping.yahoo.com/?__yltc=s%3A150000443%2Cd%3A22708228%2Cslk%3Atext%2Csec%3Amail>
    - with improved product search >
    --
    Please see the official ORACLE-L FAQ: http://www.orafaq.net
    --
    Author: Caffrey, Melanie
    INET: mcaffrey_at_proximo.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).
    __________________________________
    Do you Yahoo!?
    The New Yahoo! Shopping - with improved product search
    http://shopping.yahoo.com
    --
    Please see the official ORACLE-L FAQ: http://www.orafaq.net
    --
    Author: Rachel Carmichael
    INET: wisernet100_at_yahoo.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: Caffrey, Melanie
    INET: mcaffrey_at_proximo.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).

Related Discussions

Discussion Navigation
viewthread | post
Discussion Overview
grouporacle-l @
categoriesoracle
postedOct 14, '03 at 8:14p
activeOct 15, '03 at 2:04p
posts14
users11
websiteoracle.com

People

Translate

site design / logo © 2022 Grokbase