RUEI: Post New Installation of RUEI there are frequent Connection Drops to Reported Database (Database connection lost)
(Doc ID 2174384.1)
Last updated on NOVEMBER 16, 2022
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.
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
Changes
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! |
In this Document
| Symptoms |
| Changes |
| Cause |
| Solution |
| References |