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 <mccdba_at_hotmail.com> 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 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).
>
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: oraracdba_at_yahoo.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 - 17:56:24 CST
