[Oracle] How to set event (eg:ora-00235) for a database

[Oracle] How to set event (eg:ora-00235) for a database

When you use SPFILE,

Setting procedure:

1. Check The current event setting status:

Sql> show parameter event;

2. Add an event and set it up:

If there is the no existing event, it is set as follows:
Sql> alter system set event = ' 235 errorstack (3) systemstate (Ten) ' scope = SPFile;

If There is an existing event, add it and set it as follows:
For example, if there was already an event of "902 Errorstack (3) systemstate" As a result of the above "1"
Sql> alter system set event = ' 902 Errorstack (3) SystemState: 235 errorstack (3) systemstate (Ten) ' scope = SPFile ;

3. Just to be sure, I'll get a backup of SPFILE:

Example of execution:
sql> Create pfile = '/Home/oracle/pfile.ora ' from SPFile;

4. Restart the database.

To disable it:

1. Delete Event 235:

If there is the no existing event, it is set as follows:
Sql> alter system set event = ' scope = SPFile;

If There is an existing event, restore the original value:
For example, if there was already an event "902 Errorstack (3) systemstate ()" Before this event setting,
Sql> alter system set event = ' 902 Errorstack (3) systemstate (Ten) ' scope = SPFile;

2. Restart the database. In case

When you use PFILE,

Setting procedure:

1. Check the line related to "*. Event "with the cat command in the contents of PFILE.

2. Add and configure Event 235:

If there is the no existing event, please modify it as follows:
*. Event = ' 235 errorstack (3) systemstate (10) '

The existing event would be appended and set as follows:
For example, if the event of *. Event = ' 902 errorstack (3) systemstate (Ten) ' already exists as a result of the above "1"
In some cases,
*. Event = ' 902 errorstack (3) systemstate (Ten): 235 errorstack (3) systemstate (10) '

3. Restart the database.

To disable it:

1. Correct the line related to "*. Event "to the contents of PFILE.

If there is the no existing event, it is set as follows:
*. Event = ' '

If There is an existing event, restore the original value:
For example, if there was already an event of *. event = ' 902 Errorstack (3) systemstate (Ten) ' Before this event setting,
*. Event = ' 902 errorstack (3) systemstate (10) '

2. Restart the database.

[Oracle] How to set event (eg:ora-00235) for a database