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

2002-12-03 Thread MacGregor, Ian A.
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 nee

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

2002-12-03 Thread Richard Ji
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 En

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

2002-12-03 Thread Scott
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). C

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

2002-12-03 Thread Binley Lim
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 lik

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

2002-12-03 Thread Deshpande, Kirti
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

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

2002-12-03 Thread DENNIS WILLIAMS
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] -Orig