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: Urgent: Can connect internal but hangs when connecting as

RE: Urgent: Can connect internal but hangs when connecting as

From: Linda Wang <lwang_at_messagemedia.com>
Date: Thu, 3 Aug 2000 14:40:44 -0600
Message-Id: <10578.113795@fatcity.com>


$ ipcs -m
IPC status from <running system> as of Thu Aug 3 14:34:28 MDT 2000 T ID KEY MODE OWNER GROUP Shared Memory:
m 100 0x4d4e5251 --rw-r--r-- root other $ ipcs -s
IPC status from <running system> as of Thu Aug 3 14:34:39 MDT 2000 T ID KEY MODE OWNER GROUP Semaphores:

s      65537   0x55535253 --ra-ra-ra-     root    other
s     458754   0          --ra-r-----   oracle      dba


Oracle installation guide has formulas.
strange processes may create core dumps and eat up memories.

-----Original Message-----
From: root_at_fatcity.com [mailto:root_at_fatcity.com]On Behalf Of Ron Rogers Sent: Thursday, August 03, 2000 1:55 PM
To: Multiple recipients of list ORACLE-L Subject: RE: Urgent: Can connect internal but hangs when connecting as

It's been a while since I did any sysadmin work but I remember a unix command that would check the semiphores in a system and also remove the semiphores that were phantom to the system and just eating up resources. May be some of the DBA/sysadmin members can help you out with the commands. We use to do it on a weekly basis just to prevent troubles (learned the hard way).
It was something like IPCRM - option. with the input from a IPCS -option command.
Hope this helps in the future.
Ron Rogers
DBA OCP
Atl.ga
>>> Cherie_Machler_at_gelco.com 08/03/00 12:56PM >>>
Thanks for your reply. I found the problem. After hanging for 20 minutes, eventually an
Oracle error was produced that said we are out of operating system memory.

As an aside, does anyone have any formulas for calculating what the shared memory semaphores
should be in /etc/system. I've found a formula for one or two of them but it's
hard to know
what to set the others to other then just trial and error increasing them.

Thanks,

Cherie

--
Author:
  INET: Cherie_Machler_at_gelco.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).

--
Author: Ron Rogers
  INET: RROGERS_at_galottery.org

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
Received on Thu Aug 03 2000 - 15:40:44 CDT

Original text of this message

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