event parameter problem

[Former Member]

in early watch report, it tells me to set event(10027) event(10028)

event(10091) event(10162) event(10183) event(10629) event(10891)

event(38068),

my command is: alter system set event='10027 trace name context forever,level 1:10028 trace name context forever, level 1:10091 trace name

context forever, level 1:10162 trace name context forever, level 1:10183trace name context forever, level 1:10629 trace name context forever,

level 32:10891 trace name context forever, level 1:38068 trace name

context forever, level 100:' scope=spfile;

then I get an error message:ORA-32021: parameter value longer than 255

characters.

how to set these eight events together.

thanks a lot.

[Former Member · Accepted solution]

It seems that if the value is longer than 255, I should edit it in pfile, and then create spfile from pfile;

[Former Member · Accepted solution]

Dear victor,

1) create pfile from spfile - from sqlplus type create pfile from spfile

2) you will see initSID.ora under "dbs" directory

3) edit the initSID.orafile and add all the required events

4) shutdown db

5) startup mount the DB using the pfile sqlplus: startup mount pfile ='give the path of the pfile'

6) create spfile from pfile

7) startup the db normally

Gerard

[former_member204746]

alter system set event='10027 trace name context forever, level 1','10028 trace name context forever, level 1','10091 trace name context forever, level 1','10162 trace name context forever, level 1','10183 trace name context forever, level 1','10629 trace name context forever, level 32','10891 trace name context forever, level 1','38068 trace name context forever, level 100' scope=spfile;

[Former Member]

Note 1178409 - ORA-32021: parameter value longer than 255 characters

[Former Member]

Hello Victor

use this format

alter system set <parameter> = 'string1','string2' scope=spfile;

Rohit