Disabling tracing using DBMS_MONITOR fails with ORA-13852: Tracing For Service(module/action) %s Is Not Enabled (Doc ID 1625214.1)

Last updated on DECEMBER 06, 2016

Applies to:

Oracle Database - Enterprise Edition - Version 11.2.0.3 and later
Information in this document applies to any platform.

Symptoms

Disabling trace using dbms_monitor fails with:

exec DBMS_MONITOR.SERV_MOD_ACT_TRACE_DISABLE('TEST.ORACLE.COM','SQL Developer');
BEGIN DBMS_MONITOR.SERV_MOD_ACT_TRACE_DISABLE('TEST.ORACLE.COM','SQL Developer'); END;

*
ERROR at line 1:
ORA-13852: Tracing for service(module/action) TEST.ORACLE.COM/SQL Developer is not enabled
ORA-06512: at "SYS.DBMS_MONITOR", line 105
ORA-06512: at line 1

Attempting to enable the trace using dbms_monitor to verify fails with:

exec DBMS_MONITOR.SERV_MOD_ACT_TRACE_ENABLE('TEST.ORACLE.COM','SQL Developer',null,waits => true, binds => false);
BEGIN DBMS_MONITOR.SERV_MOD_ACT_TRACE_ENABLE('TEST.ORACLE.COM','SQL Developer',null,waits => true, binds => false); END;

*
ERROR at line 1:
ORA-13853: Tracing for service (module/action) TEST.ORACLE.COM/SQL Developer is already enabled
ORA-06512: at "SYS.DBMS_MONITOR", line 78
ORA-06512: at line 1

Cause

Sign In with your My Oracle Support account

Don't have a My Oracle Support account? Click to get started

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms