RUEI: Post New installation of RUEI we are seeing frequent connection drops to Reported Database (Database connection lost) (Doc ID 2174384.1)

Last updated on SEPTEMBER 06, 2016

Applies to:

APM - Application Performance Management - Version 13.1.2.1.0 to 13.1.2.1.0 [Release 13.1]
Information in this document applies to any platform.

Symptoms

RUEI :- 13.1.2.1.0

Oracle Database 12c Enterprise Edition Release 12.1.0.2.0

Post recent installation of RUEI we see lot of connection drops to the reporter DB.

Event logs

2016-06-17 08:12:04 error 29998 14189 cop alarm=@cop_alarm_1m monito r -alert 201606171009 127.0.0.1 Internal error (%1$s). command cop exited with status 255
2016-06-17 08:12:04 error 20001 14353 logmsgd 127.0.0.1 Job exited with exit code %1$s -1 cop alarm=@cop_alarm_1m monitor -alert 201606171009 (%2$s).
2016-06-17 08:17:07 info 20056 20885 cop alarm=@cop_alarm_5m batch_ 127.0.0.1 Cannot connect to database will retry. dump rt_slow_url
2016-06-17 08:17:08 error 20001 20902 logmsgd 127.0.0.1 Job exited with exit code %1$s -1 cop alarm=@cop_alarm_1m monitor -alert 201606171014 (%2$s).
2016-06-17 08:17:08 error 29998 20723 cop alarm=@cop_alarm_1m monito r -alert 201606171014 127.0.0.1 Internal error (%1$s). command cop exited with status 255
2016-06-17 08:17:13 info 20064 20885 cop alarm=@cop_alarm_5m batch_ id=201606170810 dim=dump-id.id dump rt_slow_url 127.0.0.1 Connected to database %1$s aft uxinsight er some attempts.
2016-06-17 08:19:02 error 20001 23519 logmsgd 127.0.0.1 Job exited with exit code %1$s -1 cop alarm=@cop_alarm_1m monitor -alert 201606171016(%2$s).
2016-06-17 08:19:03 error 20001 23523 logmsgd 127.0.0.1 Job exited with exit code %1$s -2 (%2$s). modr all
2016-06-17 08:19:03 error 29998 23255 modr all 127.0.0.1 Internal error (%1$s). command modr exited with status -2
2016-06-17 08:19:03 error 29998 23255 modr all 127.0.0.1 Internal error (%1$s). Message 1(12519): ORA-12519: TNS:no appropriate service handler found
2016-06-17 08:19:03 error 20004 23255 modr all 127.0.0.1 Cannot connect to database %1$ uxinsights.
2016-06-17 08:19:03 error 29998 23255 modr all 127.0.0.1 Internal error (%1$s). propagate: cannot open database connection

Listner Logs

27-JUN-2016 04:28:01 * (CONNECT_DATA=(SID=RUEIDB13c)(CID=(PROGRAM=logmsgd)(HOST=test.oracle.com)(USER=moniforce))) * (ADDRESS=(PROTOCOL=tcp)(HOST=test.oracle.com)(PORT=56770)) * establish * RUEIDB13c * 12519
TNS-12519: TNS:no appropriate service handler found
27-JUN-2016 04:28:01 * (CONNECT_DATA=(SID=RUEIDB13c)(CID=(PROGRAM=logmsgd)(HOST=test.oracle.com)(USER=moniforce))) * (ADDRESS=(PROTOCOL=tcp)(HOST=test.oracle.com)(PORT=56772)) * establish * RUEIDB13c * 12519
TNS-12519: TNS:no appropriate service handler found
27-JUN-2016 04:28:01 * (CONNECT_DATA=(SID=RUEIDB13c)(CID=(PROGRAM=logmsgd)(HOST=test.oracle.com)(USER=moniforce))) * (ADDRESS=(PROTOCOL=tcp)(HOST=test.oracle.com)(PORT=56774)) * establish * RUEIDB13c * 12519
TNS-12519: TNS:no appropriate service handler found
27-JUN-2016 04:28:01 * (CONNECT_DATA=(SID=RUEIDB13c)(CID=(PROGRAM=logmsgd)(HOST=test.oracle.com)(USER=moniforce))) * (ADDRESS=(PROTOCOL=tcp)(HOST=test.oracle.com)(PORT=56776)) * establish * RUEIDB13c * 12519
TNS-12519: TNS:no appropriate service handler found
27-JUN-2016 04:28:01 * (CONNECT_DATA=(SID=RUEIDB13c)(CID=(PROGRAM=logmsgd)(HOST=test.oracle.com)(USER=moniforce))) * (ADDRESS=(PROTOCOL=tcp)(HOST=test.oracle.com)(PORT=56778)) * establish * RUEIDB13c * 12519

 

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