We help IT Professionals succeed at work.

Find Oracle log files for database connection

luchuanc
luchuanc asked
on
Hi,
In Oracle 11gR2, how to find the log files that shows all the connections to the databas
I will appreciate for a quick reslonse.
Thanks,
Luchuan
Comment
Watch Question

CERTIFIED EXPERT
Most Valuable Expert 2012
Distinguished Expert 2019
Commented:
The listener log file will log connections.

To see where this is located, from a command prompt: lsnrctl status

If this isn't the information you are looking for please explain what you are wanting.


Author

Commented:
Hi slightwv:
Cool, I got this file.
we have a possible security breach, and want to see all the oracle logs for unusual connections
and activities. What are other log/alert/trace files that can be useful?
Thanks,

Luchuan
Top Expert 2011

Commented:
- you can query to v$session view for user connection activity.
CERTIFIED EXPERT
Most Valuable Expert 2012
Distinguished Expert 2019

Commented:
>>you can query to v$session view for user connection activity.

v$session will only show 'current' connections not 'past activity'.

>>What are other log/alert/trace files that can be useful?

Nothing really out of the box from an Oracle standpoint.  In the future you could turn on auditing.

You might check with your network/system folk to see what logging they might be doing.

Author

Commented:
Hi slightwv:
This listener log file seems good enough for our investigation right now.
Thanks a lot for your help.

Luchuan

Explore More ContentExplore courses, solutions, and other research materials related to this topic.