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 JANUARY 07, 2025

Applies to:

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

Changes

Cause

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.