Unable to set EVENT parameter in SPFILE

[Former Member]

Hi all,

I am trying to set few Event parameters in SPFILE using the command below.

ALTER SYSTEM SET EVENT='10027 trace name context forever, level 1' SCOPE=SPFILE;

But each time i set a new event parameter, the old one is getting replaced by the new one in the SPFILE instead of the new one getting Appended below the first.

Any help is appreciated.

Regards,

Sandeep.

[Former Member · Accepted solution]

That's the way it works;

SAP note 596423 says:

Events that have already been set are deleted if they are not specified again.

[Former Member · Accepted solution]

Thanks

from the note.

The best way to set events in the SPFILE is to use SQL statements:

SQL> ALTER SYSTEM SET

EVENT='10181 trace name context forever, level 10',

'10183 trace name context forever, level 1'

COMMENT='my comment, user, date'

SCOPE=SPFILE;

System altered.

[former_member204746 · Accepted solution]

or... do like me and stop using SPFILE and revert to the good old initSID.ora pfile.

[Former Member · Accepted solution]

Or you can use a sentence like this one at oracle level...

alter system set EVENT = '10027 trace name context forever, level 1',

'10028 trace name context forever, level 1',

'10162 trace name context forever, level 1',

'10183 trace name context forever, level 1',

'10191 trace name context forever, level 1',

'10629 trace name context forever, level 32',

'10891 trace name context forever, level 1',

'14532 trace name context forever, level 1',

'38087 trace name context forever, level 1',

'38068 trace name context forever, level 100' scope = SPFILE;

FF

[Former Member · Accepted solution]

Fernando you are super !!!

Many thanks

Simos