top of page
Search

Trace down the IPs connected to the Oracle Database 19c on the Linux server

I am running an Oracle Database 19c on oracle linux 7.9.

Now I need to check the IPs connected to my database on the listener port.

We can check this at the OS level.


Of course, many of us think we can use v$session, but using this view, we can only get the machine's name, not the IP.

I have an SQL Developer (on windows) session connected to my oracle database, let's see the details of this session in v$session.

select sid, username,status,osuser, machine, port, program from v$session where type='USER';

You can run below command to check what are the IP addresses are connected to listener port, in my case it is 1522.

The first process is LREG (Listener registration).

The second process is our actual listener process.

The third process is our SQL Developer connection.


You can check below.


47 views0 comments

Recent Posts

See All

Comments


Contact Me

Tel: 7989359581

Lakshminarayana0071@gmail.com

  • Facebook Social Icon
  • LinkedIn Social Icon
  • Twitter Social Icon

Thanks for submitting!

© 2023 by Phil Steer . Proudly created with Wix.com

bottom of page