GoldenGate, Streams and Distributed Database (MOSC)

MOSC Banner

The database connection not getting released over dblink

edited Jun 26, 2018 9:38AM in GoldenGate, Streams and Distributed Database (MOSC) 2 commentsAnswered

Hi All,


The connections are getting established for a process from database A to database B over dblink.

However when the process gets completed and the sessions from database A are exited we are still observing the sessions running on database B in active state.

These sessions have a wait event of 'TCP Socket (KGAS)' and do not execute any queries.

The last executed sql statement on these sessions is as follows:

=============================================================================

SELECT HOST,

LOWER_PORT,

UPPER_PORT,

STATUS

  FROM (SELECT *

FROM (  SELECT P.*,

DBMS_NETWORK_ACL_UTILITY.CONTAINS_HOST (:1, HOST)

PRECEDENCE

FROM SYS.USER_NETWORK_ACL_PRIVILEGES P

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center