Home » RDBMS Server » Security » find user failed to connect to datadbse
find user failed to connect to datadbse [message #285971] Thu, 06 December 2007 04:07 Go to next message
Rafeek
Messages: 159
Registered: April 2007
Location: egypt
Senior Member
hi all
i have oracle DataBase 10g.
i want to find which computer(or ip) try to connect to database (failed ) .
how can i get it ?
Thax
Rafeek
Re: find user failed to connect to datadbse [message #285992 is a reply to message #285971] Thu, 06 December 2007 04:33 Go to previous messageGo to next message
Michel Cadot
Messages: 68624
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
Use AUDIT and query dba_audit_session view.

Regards
Michel
Re: find user failed to connect to datadbse [message #286002 is a reply to message #285992] Thu, 06 December 2007 04:59 Go to previous messageGo to next message
Rafeek
Messages: 159
Registered: April 2007
Location: egypt
Senior Member
no data found in the view
Quote:

SELECT os_username, username, userhost, terminal, TIMESTAMP, action_name,
logoff_time, logoff_lread, logoff_pread, logoff_lwrite, logoff_dlock,
sessionid, returncode, client_id, session_cpu, proxy_sessionid,
global_uid, instance_number, os_process
FROM dba_audit_session


some one try to connect to user this user is lock.
i want to get computer name try to connect ?
thax
Rafeek
Re: find user failed to connect to datadbse [message #286012 is a reply to message #286002] Thu, 06 December 2007 05:19 Go to previous messageGo to next message
ebrian
Messages: 2794
Registered: April 2006
Senior Member
Have you enabled auditing?

If not, the listener.log file may provide some info.
Re: find user failed to connect to datadbse [message #286081 is a reply to message #286002] Thu, 06 December 2007 07:22 Go to previous message
Michel Cadot
Messages: 68624
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
You have to PREVIOUSLY activate the audit to use this view.

Regards
Michel
Previous Topic: getover the lock on the table
Next Topic: Problem with SYSDBA login credentials
Goto Forum:
  


Current Time: Thu Mar 28 08:00:28 CDT 2024