Home » RDBMS Server » Security » v$session logs (Oracle 10g 10.2.0.4.0/ Solaris 10)
v$session logs [message #575391] Tue, 22 January 2013 18:52 Go to next message
reym21
Messages: 178
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.

Re: v$session logs [message #575392 is a reply to message #575391] Tue, 22 January 2013 18:54 Go to previous messageGo to next message
BlackSwan
Messages: 22786
Registered: January 2009
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 Go to previous messageGo to next message
reym21
Messages: 178
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.
Re: v$session logs [message #575394 is a reply to message #575393] Tue, 22 January 2013 19:29 Go to previous messageGo to next message
BlackSwan
Messages: 22786
Registered: January 2009
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.
Re: v$session logs [message #575395 is a reply to message #575394] Tue, 22 January 2013 20:25 Go to previous messageGo to next message
reym21
Messages: 178
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.
Re: v$session logs [message #575396 is a reply to message #575395] Tue, 22 January 2013 20:44 Go to previous message
BlackSwan
Messages: 22786
Registered: January 2009
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.
Previous Topic: Remote connection using SYS
Next Topic: Integrating LDAP for User Authentication
Goto Forum:
  


Current Time: Wed Sep 17 17:37:25 CDT 2014

Total time taken to generate the page: 0.25362 seconds