Oracle Database Discussions

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

How to find the listener i.e. port number used by a session to connect to databse

user633056May 30 2015 — edited Jul 10 2015

Hi,

Say i have configured two listeners for a database named ORCL, one on 1521 and the other on 1522.

There are more than 1000 sessions currently connected, is it possible to find the port number used by a session to connect to the database.

It is not possible to go to all the 1000 client machine and see which TNS entry is saved on their local machine.

Locked Post

New comments cannot be posted to this locked post.

Locked on Aug 7 2015

Added on May 30 2015

#general-database-discussions

14 comments

5,900 views