[Q] SUN server crash due to ORACLE 9.2 DB start????

From: bbb bb (mccux1@hotmail.com)
Date: Tue Dec 03 2002 - 16:13:50 EST


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
_______________________________________________
sunmanagers mailing list
sunmanagers@sunmanagers.org
http://www.sunmanagers.org/mailman/listinfo/sunmanagers



This archive was generated by hypermail 2.1.7 : Wed Apr 09 2008 - 23:25:24 EDT