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

From: Richard Ji <richard.ji_at_mobilespring.com>
Date: Tue, 03 Dec 2002 16:33:47 -0800
Message-ID: <F001.0051197A.20021203163347@fatcity.com>

You are most likely running into an OS bug, because its a CPU panic. Have your SA run adb on the core file. Look at what thread ffba0ac0 is.

Richard Ji

-----Original Message-----
Sent: Tuesday, December 03, 2002 4: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: Richard Ji
INET: richard.ji_at_mobilespring.com

Fat City Network Services    -- 858-538-5051 http://www.fatcity.com
San Diego, California        -- Mailing list and web hosting services
---------------------------------------------------------------------