Please find database queries to check failed connections to Oracle Database:


select OS_USERNAME,USERNAME,USERHOST,to_char(timestamp,'DD-MM-YYYY HH24:MI:SS'), returncode from dba_audit_trail

  where returncode > 0

  and timestamp>sysdate-1

  and username='<USER>'

  order by 4 desc;


select DBUSERNAME, OS_USERNAME, USERHOST, ACTION_NAME, RETURN_CODE, EVENT_TIMESTAMP

from UNIFIED_AUDIT_TRAIL 

where DBUSERNAME='<USER>' 

-- and RETURN_CODE not in (0, 28000)

and EVENT_TIMESTAMP > sysdate - 1 

order by EVENT_TIMESTAMP desc;



Note:

RETURNCODE=0 indicates success

RETURNCODE=1017 indicates bad password

RETURNCODE=28000 indicates account is locked out


About Me

I have 20 years of thorough experience in the Information Technology industry, specializing in Oracle Database, Fusion Middleware, OBIEE, Oracle E-Business Applications, Hyperion, UPK, Oracle Cloud & Virtualization Administration using Oracle Development / Administration / Management / Training tools on different platforms across industry, including C&IP (Manufacturing, Supply Chain Planning), HCM, Financials, and TMT, with knowledge in Project Management, Application Strategy, Software Development Lifecycle (SDLC), and Application Testing (Unit, System, Integration, UAT, and Performance). I worked on number of projects, implementing custom and ERP/CRM Oracle applications and used AIM/ Macro-scope methodology Project Documentation and version control. I used IT Service Management (ITSM) guidelines and ITIL framework on projects to manage Oracle Infrastructure.


Feedback, Comments, Questions?

Please provide your valuable feedback/comments and let me know if any questions? Feel free to contact me for any ORACLE technology assistance.

Contact: +91-9930920689 | Amit.Garg@redcircle.in | Linkedin