| find user failed to connect to datadbse [message #285971] |
Thu, 06 December 2007 04:07  |
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 #286002 is a reply to message #285992] |
Thu, 06 December 2007 04:59  |
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
|
|
|
|
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
