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: [Q] ORACLE 9.2 "SGA_MAX_size" cause SUN server crash ????

RE: [Q] ORACLE 9.2 "SGA_MAX_size" cause SUN server crash ????

From: DENNIS WILLIAMS <DWILLIAMS_at_LIFETOUCH.COM>
Date: Tue, 03 Dec 2002 14:09:17 -0800
Message-ID: <F001.005116D5.20021203140917@fatcity.com>


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 memory
l1 ptp
Dec 3 13:35:03 ISS unix: [ID 100000 kern.notice] Dec 3 13:35:03 ISS genunix: [ID 872817 kern.notice] e166ba40 unix:srmmu_share+130 (0, 0, ff61af38, 0, 8, ff619c20) Dec 3 13:35:03 ISS genunix: [ID 645206 kern.notice] %l0-7: 08000000 ff61a998 21000000 00000001 ffc77004 ff0982c0 ffc77484 01629b 31
Dec 3 13:35:03 ISS genunix: [ID 872817 kern.notice] e166bab0 genunix:as_dup+dc (0, ffba14a0, ff61a9b4, ffbe2c28, ffbe2c44, ff61a99 8)
Dec 3 13:35:03 ISS genunix: [ID 645206 kern.notice] %l0-7: e00e94f0 ffc8f760 f0a2981c ff385908 e166bb7c ff385908 00000000 df13a0 00
Dec 3 13:35:03 ISS genunix: [ID 872817 kern.notice] e166bb10 genunix:cfork+10c (0, 0, ff876768, 1e, 0, 0) Dec 3 13:35:03 ISS genunix: [ID 645206 kern.notice] %l0-7: 40401085 df119740 df119744 e0060000 00000000 ffba0ac0 ff577c10 e166bb 80
Dec 3 13:35:03 ISS unix: [ID 100000 kern.notice] Dec 3 13:35:03 ISS genunix: [ID 672855 kern.notice] syncing file systems...
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
Dec 3 13:35:03 ISS genunix: [ID 353387 kern.notice] dumping to /dev/dsk/c0t0d0s1, offset 83886080
Dec 3 13:35:03 ISS genunix: [ID 409368 kern.notice] ^M100% done: 10698 pages dumped, compression ratio 2.95,
Dec 3 13:35:03 ISS genunix: [ID 851671 kern.notice] dump succeeded

If I take out "SGA_MAX_size" entry from init.ora, the database run correctly. Does anyone knoe why SUN server crash?

Thanks.



Add photos to your e-mail with MSN 8. Get 2 months FREE*. http://join.msn.com/?page=features/featuredemail

--

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).
--

Please see the official ORACLE-L FAQ: http://www.orafaq.com
--

Author: DENNIS WILLIAMS
  INET: DWILLIAMS_at_LIFETOUCH.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). Received on Tue Dec 03 2002 - 16:09:17 CST

Original text of this message

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