RE: Oracle hangs...Oracle 8.1.7.3 and Solaris 2.7

From: Sutton, Reed <rsutton_at_fcg.com>
Date: Thu, 21 Mar 2002 09:51:01 -0800
Message-ID: <F001.00430087.20020321095101@fatcity.com>

Well, unfortunately we haven't solved the problem yet, so I don't have any solutions to share with everyone.

We are using Sun hardware, and we have not run diagnostics on the memory. I don't want to dismiss that idea out of hand, but I don't understand how bad memory could be affecting only one of the three instances. There are two other 8.1.7.3 instances that run fine, never even a hiccup. The server has 2GB of memory.

The application that uses this database (when its up) is connecting over the network, but when it hangs, you are unable to connect from a remote client or from on the server.

I suggested to the support person handling our case that maybe we could try using some of the various oradebug options suggested by people on the list and suggested on Metalink, but he suggested looking at the following things first:

This may be caused by a system resource problem. Was this DB relinked after the upgrade?
It might help to get the init<sid>.ora's for all the instances What is the total size of each SGA?
What is the value of the PROCESSES for each instance How much physical memory on the system?
How much swap space?
Type sysdef -i |grep SHMMAX
Type sysdef -i |grep SEMMNS

Still waiting for his reply to my answers...

Thanks for all ideas you guys have shared.

-----Original Message-----
Sent: Wednesday, March 20, 2002 11:58 PM To: Multiple recipients of list ORACLE-L

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).
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Sutton, Reed
  INET: rsutton_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).

Received on Thu Mar 21 2002 - 11:51:01 CST