Oracle supports response to my answers was to increase SHMMAX from 128M to 4G and SEMMNS to 2000. Upping the semaphores seems like a good idea, but when I questioned why we should increase SHMMAX to more than 2x the real memory on the machine, the answer was "I had my Unix Guru look at these and he recommended the parameters." A little less than what I was hoping for...
At this point I am going to start launching my own investigation, from tips from you guys and research on Metalink, to try to find out what these processes are doing when the server is hung. Thanks again for all the help. Reed -----Original Message----- Sent: Thursday, March 21, 2002 12:51 PM To: Multiple recipients of list ORACLE-L 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" <[EMAIL PROTECTED]> 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: [EMAIL PROTECTED] > > 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: [EMAIL PROTECTED] (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: [EMAIL PROTECTED] 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: [EMAIL PROTECTED] (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: [EMAIL PROTECTED] 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: [EMAIL PROTECTED] (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: [EMAIL PROTECTED] 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: [EMAIL PROTECTED] (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).
