My Oracle Support Banner

EM 13c :Connection Growing In Target Database After Querying Rman Backup List (Doc ID 2727601.1)

Last updated on NOVEMBER 30, 2020

Applies to:

Enterprise Manager for Cloud - Version 12.1.0.1.0 and later
Information in this document applies to any platform.

Symptoms

After running the below rest api for multiple times, database connections are not closing:

https://<hostname>:<port>/em/cloud/dbaas/pluggabledbplatforminstance/byrequest/789?RMAN_backup_list

the connection grow in database and it is not closing.

select count(*) from v$session where PROGRAM = 'OMS' AND MACHINE like '%<target_db_name>%';

COUNT(*)
----------
18

SQL> /

COUNT(*)
----------
19

SQL> /

COUNT(*)
----------
20

SQL> /

COUNT(*)
----------
21

 

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
Cause
Solution
References


My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.