My Oracle Support Banner

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 AUGUST 14, 2018

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

To view full details, 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 a vibrant support community of peers and Oracle experts.