| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
 |
 | |||
| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
|
| |||
Home -> Community -> Mailing Lists -> Oracle-L -> RE: Oracle hangs...Oracle 8.1.7.3 and Solaris 2.7
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?
-- 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). -- 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 - 15:33:23 CST
 |
 |