Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
![]() |
![]() |
Home -> Community -> Mailing Lists -> Oracle-L -> RE: [Q] ORACLE 9.2 "SGA_MAX_size" cause SUN server crash ????
If you set something too big for the Solaris kernel, it should spit it out, and carry on to do other things. It should not take a plate of food and smack it onto its own face.
This sounds like a case for more Solaris patches...
>>> DWILLIAMS_at_LIFETOUCH.COM 12/04/02 11:09a.m. >>>
Dist - It sounds like you are setting SGA_MAX_SIZE too large for the server
kernel. Try setting it smaller and see if the server is okay with that. If
this is true, then you may need to adjust some Solaris kernel parameters.
Dennis Williams
DBA, 40%OCP
Lifetouch, Inc.
dwilliams_at_lifetouch.com
-----Original Message-----
Sent: Tuesday, December 03, 2002 3:20 PM
To: Multiple recipients of list ORACLE-L
We are doing ORACLE 9.2.0.2 Enterprise Edition testing on SUN server (Solaris 8). Currently one problem happen. If I put "SGA_MAX_size" entry on init.ora file and restart database, the SUN server will crash and following messages on /var/adm/message file:
Dec 3 13:34:59 ISS unix: [ID 253085 kern.notice] NOTICE: hat_memload: unsupported flags 256 Dec 3 13:35:00 ISS unix: [ID 253085 kern.notice] NOTICE: hat_memload: unsupported flags 256
Dec 3 13:35:02 ISS last message repeated 9618 times Dec 3 13:35:03 ISS unix: [ID 836849 kern.notice] Dec 3 13:35:03 ISS ^Mpanic[cpu3]/thread=ffba0ac0: Dec 3 13:35:03 ISS unix: [ID 977504 kern.notice] invalid shared memoryl1 ptp
Dec 3 13:35:03 ISS genunix: [ID 733762 kern.notice] 2 Dec 3 13:35:03 ISS genunix: [ID 733762 kern.notice] 1 Dec 3 13:35:03 ISS last message repeated 19 times Dec 3 13:35:03 ISS genunix: [ID 616637 kern.notice] cannot sync --giving up
If I take out "SGA_MAX_size" entry from init.ora, the database run correctly. Does anyone knoe why SUN server crash?
Thanks.
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: dist cash
INET: mccdba_at_hotmail.com
Fat City Network Services -- 858-538-5051 http://www.fatcity.com San Diego, California -- Mailing list and web hosting services ---------------------------------------------------------------------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).
Fat City Network Services -- 858-538-5051 http://www.fatcity.com San Diego, California -- Mailing list and web hosting services ---------------------------------------------------------------------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: Binley Lim
INET: Binley.Lim_at_ird.govt.nz
Fat City Network Services -- 858-538-5051 http://www.fatcity.com San Diego, California -- Mailing list and web hosting services ---------------------------------------------------------------------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 Tue Dec 03 2002 - 16:52:41 CST
![]() |
![]() |