ERROR: Emon failed to start

A short note on this error which popup in alertlog. This was due to session were waiting for

select inst_id,sid, serial#, event from gv$session where upper(event) like upper('%wait for EMON to spawn%');

   INST_ID        SID    SERIAL# EVENT
---------- ---------- ---------- ----------------------------------------------------------------
         2       1428        259 wait for EMON to spawn
         1       1388         32 wait for EMON to spawn

And as per metalink note 1361166.1 there are numerous entries on system table sys.reg$. Also, that document refer to some oracle bugs also. ID 782050.1

SQL> select SUBSCRIPTION_NAME ,count(*) from reg$ group by SUBSCRIPTION_NAME;

SUBSCRIPTION_NAME
--------------------------------------------------------------------------------   COUNT(*)
----------
"SYS"."ALERT_QUE":"HAE_SUB"
         3

"SYS"."SRVQUEUE":"TAFTSM"
      8992

Removing the excessive entries from sys.reg$ will resolve the EMON start-up issue

SQL> delete from sys.reg$ where location_name like 'net8%' and
	location_name not in (select location_name from sys.loc$) and subscription_name like '%TAFTSM%';

8987 rows deleted.

SQL> commit;

Commit complete.

SQL> select SUBSCRIPTION_NAME ,count(*) from reg$ group by SUBSCRIPTION_NAME;

SUBSCRIPTION_NAME
--------------------------------------------------------------------------------
  COUNT(*)
----------
"SYS"."ALERT_QUE":"HAE_SUB"
         3

"SYS"."SRVQUEUE":"TAFTSM"
         5

About these ads