OraFAQ Forum: Security » v$session logs

Home » RDBMS Server » Security » v$session logs (Oracle 10g 10.2.0.4.0/ Solaris 10)

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

v$session logs [message #575391]

Tue, 22 January 2013 18:52

reym21
Messages: 241
Registered: February 2010
Location: Philippines

Senior Member

Gurus,

Good day.

Is there a way where I can check users/IPs who connect to the database
in a specific time 2 days ago?

Thanks in advance.

Report message to a moderator

Re: v$session logs [message #575392 is a reply to message #575391]

Tue, 22 January 2013 18:54

BlackSwan
Messages: 26766
Registered: January 2009
Location: SoCal

Senior Member

>Is there a way where I can check users/IPs who connect to the database

listener.log file contains a record of every connection request that it received; which includes originating client (but not user)

[Updated on: Tue, 22 January 2013 18:55]

Report message to a moderator

Re: v$session logs [message #575393 is a reply to message #575392]

Tue, 22 January 2013 19:23

reym21
Messages: 241
Registered: February 2010
Location: Philippines

Senior Member

Blackswan,

Are the following columns (v$session) could also help: USERNAME, TERMINAL, MACHINE, LOGON_TIME?

Thanks again, Sir.

Report message to a moderator

Re: v$session logs [message #575394 is a reply to message #575393]

Tue, 22 January 2013 19:29

BlackSwan
Messages: 26766
Registered: January 2009
Location: SoCal

Senior Member

>Are the following columns (v$session) could also help: USERNAME, TERMINAL, MACHINE, LOGON_TIME?

V$SESSION is simply real time memory based data structure that is not logged.

Report message to a moderator

Re: v$session logs [message #575395 is a reply to message #575394]

Tue, 22 January 2013 20:25

reym21
Messages: 241
Registered: February 2010
Location: Philippines

Senior Member

Blackswan,

Thanks for this.

I'm currently browsing the listener.log. I'd see the client ip address but I'm curious the port number it uses.
Every time it established a connection the port number increments by 1 ... what's the use of incrementing the port number?

"22-JAN-2013 08:00:00 * (CONNECT_DATA=(SID=hr)(CID=(PROGRAM=)(HOST=__jdbc__)(USER=))) * (ADDRESS=(PROTOCOL=tcp)(HOST=123.45.67.89)(PORT=57344)) * establish * hr * 0
22-JAN-2013 08:00:00 * (CONNECT_DATA=(SID=hr)(CID=(PROGRAM=)(HOST=__jdbc__)(USER=))) * (ADDRESS=(PROTOCOL=tcp)(HOST=123.45.67.89)(PORT=57345)) * establish * hr * 0
22-JAN-2013 08:00:00 * (CONNECT_DATA=(SID=hr)(CID=(PROGRAM=)(HOST=__jdbc__)(USER=))) * (ADDRESS=(PROTOCOL=tcp)(HOST=123.45.67.89)(PORT=57346)) * establish * hr * 0
22-JAN-2013 08:00:00 * (CONNECT_DATA=(SID=hr)(CID=(PROGRAM=)(HOST=__jdbc__)(USER=))) * (ADDRESS=(PROTOCOL=tcp)(HOST=123.45.67.89)(PORT=57347)) * establish * hr * 0
22-JAN-2013 08:00:01 * (CONNECT_DATA=(SID=hr)(CID=(PROGRAM=)(HOST=__jdbc__)(USER=))) * (ADDRESS=(PROTOCOL=tcp)(HOST=123.45.67.89)(PORT=57350)) * establish * hr * 0
22-JAN-2013 08:00:01 * (CONNECT_DATA=(SID=hr)(CID=(PROGRAM=)(HOST=__jdbc__)(USER=))) * (ADDRESS=(PROTOCOL=tcp)(HOST=123.45.67.89)(PORT=57351)) * establish * hr * 0
22-JAN-2013 08:00:01 * service_update * hr * 0
22-JAN-2013 08:00:01 * (CONNECT_DATA=(SID=hr)(CID=(PROGRAM=)(HOST=__jdbc__)(USER=))) * (ADDRESS=(PROTOCOL=tcp)(HOST=123.45.67.89)(PORT=57352)) * establish * hr * 0
22-JAN-2013 08:00:01 * (CONNECT_DATA=(SID=hr)(CID=(PROGRAM=)(HOST=__jdbc__)(USER=))) * (ADDRESS=(PROTOCOL=tcp)(HOST=123.45.67.89)(PORT=57353)) * establish * hr * 0
22-JAN-2013 08:00:01 * service_update * sales * 0
22-JAN-2013 08:00:02 * (CONNECT_DATA=(SID=hr)(CID=(PROGRAM=)(HOST=__jdbc__)(USER=))) * (ADDRESS=(PROTOCOL=tcp)(HOST=123.45.67.89)(PORT=57354)) * establish * hr * 0
22-JAN-2013 08:00:02 * (CONNECT_DATA=(SID=hr)(CID=(PROGRAM=)(HOST=__jdbc__)(USER=))) * (ADDRESS=(PROTOCOL=tcp)(HOST=123.45.67.89)(PORT=57355)) * establish * hr * 0
22-JAN-2013 08:00:02 * (CONNECT_DATA=(SID=hr)(CID=(PROGRAM=)(HOST=__jdbc__)(USER=))) * (ADDRESS=(PROTOCOL=tcp)(HOST=123.45.67.89)(PORT=57356)) * establish * hr * 0"
...

Thanks again.

Report message to a moderator

Re: v$session logs [message #575396 is a reply to message #575395]

Tue, 22 January 2013 20:44

BlackSwan
Messages: 26766
Registered: January 2009
Location: SoCal

Senior Member

>what's the use of incrementing the port number?
no two client can utilize the same port, so each client connection gets their own dedicated port.

Report message to a moderator

Previous Topic:	Remote connection using SYS
Next Topic:	Integrating LDAP for User Authentication

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Sat Mar 08 01:49:14 CST 2025