on 04-30-2009 1:54 AM
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.
It seems that if the value is longer than 255, I should edit it in pfile, and then create spfile from pfile;
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
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
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;
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Note 1178409 - ORA-32021: parameter value longer than 255 characters
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Hello Victor
use this format
alter system set <parameter> = 'string1','string2' scope=spfile;
Rohit
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
User | Count |
---|---|
96 | |
11 | |
11 | |
10 | |
9 | |
7 | |
6 | |
5 | |
4 | |
4 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.