Skip to Content
avatar image
Former Member

Set event 100183 & 10027 in Oracle 11g

Hi

I have upgraded the Oracle 10.2.0.4.0 to Oracle 11.2.0.2.0 . while running the script provided by SAP vide note no. 1171650 (Automated Oracle DB Parameter Check) , following recommendation comes after running the scripts

means change the event to values like 1or 2 or 1024 etc.

event (38087) change value to "38087" 1

event (10183) change value to "10183" 1

event (10027) change value to "10027" 2

event (10028) change value to "10028" 2

event (10142) change value to "10142" 2

event (38068) change value to "38068 level 100" 2

event (38085) change value to "38085" 2

event (44951) change value to "44951 level 1024" 2

event (10191) change value to "10191"

event (10995) change value to "10995 level 2"

when i executed the command on sqlplus / as sysdba level

ALTER SYSTEM SET EVENT=

'10027 trace name context forever, level 2',

'10028 trace name context forever, level 2',

'10191 trace name context forever, level 1',

'38087 trace name context forever, level 1',

'10183 trace name context forever, level 1',

'10142 trace name context forever, level 1',

'38068 trace name context forever, level 100',

'38085 trace name context forever, level 2',

'44951 trace name context forever, level 1024',

'10995 trace name context forever, level 2'

COMMENT='SAP RECOMMENDED SETTINGS - 201108' SCOPE=SPFILE;

thereafter i shutdown the oracle & restart it , it either comes instead of "change" to "add". It also don't give any error.

Can anybody be help in sort out that why these are happening. why it is not changing the values.

Thanks

Regards

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

3 Answers

  • Best Answer
    Sep 02, 2011 at 10:41 AM

    Hello Ravi,

    in addition to Gerd's reply - make sure that you have not set the event parameter for your specific <sid> in the past. If you don't specify the SID parameter - you will set the value of the global parameter (sid='*').

    By the way - the check script of sapnote #1171650 is rubbish in my opinion - even the SAP support uses it, but does not look at the kind of system (OLTP / OLAP) and suggests parameter that are just wrong. I've known it to happen.

    Regards

    Stefan

    Add comment
    10|10000 characters needed characters exceeded

    • Hi Fidel,

      I think this will be the first time I do not agree with you.

      No problem at all - otherwise it would be boring 😊)

      Well that's just my experience with this script - as you are from SAP you can check the service request "667733 / 2011" and go to the replies from "15.08.2011" - there you can see what i mean. Personally i never used this script, because of i think that i am able to set the correct parameters regarding the installed SBP.

      Regards

      Stefan

  • avatar image
    Former Member
    Sep 02, 2011 at 09:36 AM

    Hi,

    When you set the event parameters then you have to include Previously set parameters as well in the command because this command simply overwrites previously set parameters as a result when you will restart the system it will show you previous set event parameter as missing. So, add new and old event parameter in one command and then check.

    Thanks

    Sunny

    Add comment
    10|10000 characters needed characters exceeded

    • Former Member

      Hi Sunny

      You are right that while adding new parameters , we have to keep in mind for old parameters recommenations also.

      I am highly obligued that the support you have given to me.

      Thanks

      Regards

      Ravi Arya

  • avatar image
    Former Member
    Sep 02, 2011 at 10:09 AM

    With 11.2.0.2 there is no 'trace name context forever' anymore.

    Look at the readme file from the bundle patch:

    ALTER SYSTEM SET EVENT=

    '10027',

    '10028',

    '10142',

    '10183',

    '10191',

    '10995 level 2',

    '38068 level 100',

    '38085',

    '38087',

    '44951 level 1024'

    COMMENT='SAP_112021_201103 RECOMMENDED SETTINGS'

    SCOPE=SPFILE;

    Add comment
    10|10000 characters needed characters exceeded

    • Former Member

      Hi Gerd Kirchner

      Thanks for your valuable support, but running this command . my Problem solved

      Thanks a lot.

      Regards

      Ravi