| Author |
Message
|
| slappycruzer |
 Posted: Fri Jun 11, 2010 8:49 am Post subject: MQ 5.3 AIX(5.3) EXTSHM variable causing error in ORACLE 10g |
 |
|
Newbie
Joined: 11 Jun 2010
Posts: 1
|
Dear Experts,
We are having our server on AIX5.3 32bit on ML 4
this server has MQ Version 5.3 and Oracle is recently upgraded on it to 10g
after upgrading we are getting ORA-00600 error as SKGMINVALID in alert_log in oracle and trace file was sent to Oracle .
Oracle came with suggsetion that we need to turn off/unset the EXTSHM varible in MQ environment.
on investigation we found that this variable isnt set in mqm user's profile/env
I came to know later after much investigation that MQ processes are using this variable in their environment and `ps eww pid `command confirms it.
i tried to set this variable to other values like 1SEG/MSEG but MQ throws an exception :
AMQ6218 :EXTSHM variable detected with unrecognised value '1SEG' and has been reset to 'ON'
which confirms that this variable is being used internally by strmqm only and I'm unable to get it to any other value.
Can you please help me how I can get this variable unset or set to another value so Oracle doesn't complain about it.
TIA
.. |
|
| Back to top |
|
 |
| Vitor |
| Posted: Fri Jun 11, 2010 9:57 am Post subject: |
|
|
Grand High Poobah
Joined: 11 Nov 2005
Posts: 26093
Location: Texas, USA
|
Given that WMQv5.3 is out of support and has been for a while, why did you think it would co-exist with Oracle 10g?
_________________
Honesty is the best policy.
Insanity is the best defence. |
|
| Back to top |
|
|
| fjb_saper |
| Posted: Fri Jun 11, 2010 11:51 am Post subject: |
|
|
Grand High Poobah
Joined: 18 Nov 2003
Posts: 20756
Location: LI,NY
|
| Vitor wrote: |
| Given that WMQv5.3 is out of support and has been for a while, why did you think it would co-exist with Oracle 10g? |
We've had it coexist fine on Solaris 9 but then it was never the bare 5.3.
The latest we used was CSD 6....
Finally we're on 6.0.2.9 there....
For the values for EXTSHM there is only on or off AFAIK. For any other value talk to IBM Support.
Have fun. 
_________________
MQ & Broker admin |
|
| Back to top |
|
|
| Vitor |
| Posted: Fri Jun 11, 2010 12:34 pm Post subject: |
|
|
Grand High Poobah
Joined: 11 Nov 2005
Posts: 26093
Location: Texas, USA
|
| fjb_saper wrote: |
| We've had it coexist fine on Solaris 9 but then it was never the bare 5.3. |
The OP's talking about Oracle, not Solaris.
_________________
Honesty is the best policy.
Insanity is the best defence. |
|
| Back to top |
|
|
| aditya.aggarwal |
| Posted: Fri Jun 11, 2010 1:09 pm Post subject: |
|
|
Master
Joined: 13 Jan 2009
Posts: 252
|
We also faced this kind of issue with MQ 5.3 and oracle 10g sometime back...To resolve this we upgraded MQ to V6.0.2.4 .. After that Oracle10g stopped compalining. 
Cheers,
Adi |
|
| Back to top |
|
|
|
|
