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
Advertisements

About Taral
I am Rookie to Oracle Technology so let's see where it goes

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s

%d bloggers like this: