Please let us know how you fixed the problem.
Are you using Sun Hardware? can you run diagnostics for the memory?
Are you connecting using IPC(meaning direct) or through TCP(network)?
Is it the network that is causing problem?
- "Grabowy, Chris" <cgrabowy_at_fcg.com> wrote:
> We have a particular database that hangs on a regular basis. Here
> are the
> stats and symptoms.
>
> Oracle stats
> ------------------------------------------
> 8.1.7.3 (highest patch level applied)
> Solaris 2.7
> UTF8 character set
>
> Symptoms
> ------------------------------------------
> Random hanging.
> Hanging meaning SQL processing stops.
> New connections "hang".
> No traces files.
> No messages in the alert log.
> Killing the Oracle processes is the only way to recover from the
> problem.
>
> This problem has been reported to Oracle Support, they are now
> escalating it
> up.
>
> I just wanted to PING the list to see if anyone else has encountered
> this.
>
> TIA!!!
>
> Chris
> --
> Please see the official ORACLE-L FAQ: http://www.orafaq.com
> --
> Author: Grabowy, Chris
> INET: cgrabowy_at_fcg.com
>
> Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051
> San Diego, California -- Public Internet access / Mailing
> Lists
> --------------------------------------------------------------------
> 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).
Mohammed Shakir
CompuSoft, Inc.
11 Heather Way
East Brunswick, NJ 08816-2825
(732) 672-0464 (Cell)
(732) 257-6001 (Home)
Do You Yahoo!?
Yahoo! Movies - coverage of the 74th Academy Awards®
http://movies.yahoo.com/
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: Mohammed Shakir
INET: mshakir08816_at_yahoo.com
Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051
San Diego, California -- Public Internet access / Mailing Lists
--------------------------------------------------------------------
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 Wed Mar 20 2002 - 22:58:25 CST
