[Q] ORACLE 9.2 SGA_MAX_size cause SUN server crash ????
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 10 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: 0800 ff61a998 2100 0001 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 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 e006 ffba0ac0 ff577c10 e166bb 80 Dec 3 13:35:03 ISS unix: [ID 10 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: [EMAIL PROTECTED] 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: [EMAIL PROTECTED] (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).
RE: [Q] ORACLE 9.2 SGA_MAX_size cause SUN server crash ????
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. [EMAIL PROTECTED] -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 10 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: 0800 ff61a998 2100 0001 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 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 e006 ffba0ac0 ff577c10 e166bb 80 Dec 3 13:35:03 ISS unix: [ID 10 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: [EMAIL PROTECTED] 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: [EMAIL PROTECTED] (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: [EMAIL PROTECTED] 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: [EMAIL PROTECTED] (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).
RE: [Q] ORACLE 9.2 SGA_MAX_size cause SUN server crash ????
Not sure if this would help, but a paper presented at the recent Oracle World (Titled : Oracle9i Memory Mgmt: Easier Than Ever by Shushil Kumar of Oracle Corp) mentioned following: On Solaris, the _USE_ISM parameter is set to TRUE by default for performance reasons. On versions of Solaris with no DISM support, this causes locking of physical memory equal to the SGA_MAX_SIZE specification. In a foot note the paper states: DISM (dynamic intimate shared memory) is supported on Solaris 8 release date 01/01 or later. Sun also recommends installing the patch 108528-16 while using the dynamic SGA feature. We do not have Oracle9i R2 on Sun Solaris 8, so I have not tested this. I just had the paper handy :) HTH, - Kirti -Original Message- Sent: Tuesday, December 03, 2002 4:09 PM To: Multiple recipients of list ORACLE-L 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. [EMAIL PROTECTED] -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 10 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: 0800 ff61a998 2100 0001 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 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 e006 ffba0ac0 ff577c10 e166bb 80 Dec 3 13:35:03 ISS unix: [ID 10 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: [EMAIL PROTECTED] 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: [EMAIL PROTECTED] (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: [EMAIL PROTECTED] 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: [EMAIL PROTECTED] (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
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... [EMAIL PROTECTED] 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. [EMAIL PROTECTED] -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 10 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: 0800 ff61a998 2100 0001 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 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 e006 ffba0ac0 ff577c10 e166bb 80 Dec 3 13:35:03 ISS unix: [ID 10 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: [EMAIL PROTECTED] 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: [EMAIL PROTECTED] (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: [EMAIL PROTECTED] 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: [EMAIL PROTECTED] (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: [EMAIL PROTECTED] 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: [EMAIL PROTECTED] (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
Re: [Q] ORACLE 9.2 SGA_MAX_size cause SUN server crash ????
I have not used this feature but there is a note on metalink that you may find useful regarding dynamic SGA issues on Solaris 8. It is note 151222.1 Scott --- dist cash [EMAIL PROTECTED] wrote: 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 10 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: 0800 ff61a998 2100 0001 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 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 e006 ffba0ac0 ff577c10 e166bb 80 Dec 3 13:35:03 ISS unix: [ID 10 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: [EMAIL PROTECTED] 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: [EMAIL PROTECTED] (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). __ Do you Yahoo!? Yahoo! Mail Plus - Powerful. Affordable. Sign up now. http://mailplus.yahoo.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Scott INET: [EMAIL PROTECTED] 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: [EMAIL PROTECTED] (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).
RE: [Q] ORACLE 9.2 SGA_MAX_size cause SUN server crash ????
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 10 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: 0800 ff61a998 2100 0001 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 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 e006 ffba0ac0 ff577c10 e166bb 80 Dec 3 13:35:03 ISS unix: [ID 10 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: [EMAIL PROTECTED] 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: [EMAIL PROTECTED] (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: [EMAIL PROTECTED] 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: [EMAIL PROTECTED] (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).
RE: [Q] ORACLE 9.2 SGA_MAX_size cause SUN server crash ????
I imagine this has been done already? There is a file called oradism at $ORACLE_HOME/bin. The file needs to be moved to another location such as /var/opt/oracle/sbin (where we put ours). A soft link ln -s /var/opt/oracle/sbin/oradism $ORACLE_HOME/bin/oradism is then created. You also need to update a couple of files. Add the following to /etc/user_attr oracletype=normal;profiles=Oracle DISM mgmt Add the following to /etc/security/exec_attr Oracle DISM mgmt:suser:cmd:::/var/opt/oracle/sbin/oradism:euid=0 = I couldn't even create a database with a dynamic SGA without doing the above. I have no 9.2 experience the above was necessary for 9.0.1 Ian MacGregor Stanford Linear Accelerator Center [EMAIL PROTECTED] -Original Message- Sent: Tuesday, December 03, 2002 2:46 PM To: Multiple recipients of list ORACLE-L Not sure if this would help, but a paper presented at the recent Oracle World (Titled : Oracle9i Memory Mgmt: Easier Than Ever by Shushil Kumar of Oracle Corp) mentioned following: On Solaris, the _USE_ISM parameter is set to TRUE by default for performance reasons. On versions of Solaris with no DISM support, this causes locking of physical memory equal to the SGA_MAX_SIZE specification. In a foot note the paper states: DISM (dynamic intimate shared memory) is supported on Solaris 8 release date 01/01 or later. Sun also recommends installing the patch 108528-16 while using the dynamic SGA feature. We do not have Oracle9i R2 on Sun Solaris 8, so I have not tested this. I just had the paper handy :) HTH, - Kirti -Original Message- Sent: Tuesday, December 03, 2002 4:09 PM To: Multiple recipients of list ORACLE-L 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. [EMAIL PROTECTED] -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 10 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: 0800 ff61a998 2100 0001 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 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 e006 ffba0ac0 ff577c10 e166bb 80 Dec 3 13:35:03 ISS unix: [ID 10 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: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services
