Hi All,
I need one urgent help.
I have two node Oracle RAC database and yesterday three oracle accounts is locked which oracle account are using from application.
Please find details information :
SQL> show parameter audit
NAME TYPE VALUE
--------------------------------- ----------- ---------------------------------
audit_file_dest string /opt/oracle/admin/UTSP1/adump
audit_sys_operations boolean FALSE
audit_syslog_level string
audit_trail string DB
This is the information for one Oracle user :
select CTIME , LTIME, PTIME from sys.user$ where NAME='TAILSPROVIDER';
CTIME LTIME PTIME
------------------- ------------------- -------------------
11:53:30 05/02/2013 09:46:23 28/07/2015 17:01:53 28/07/2015
SELECT USERNAME, OS_USERNAME, USERHOST, EXTENDED_TIMESTAMP
FROM SYS.DBA_AUDIT_SESSION WHERE returncode != 0 and username = '&Account_Locked'
and EXTENDED_TIMESTAMP > (systimestamp-2) order by 4 desc
/
USERNAME OS_USERNAME USERHOST EXTENDED_TIMESTAMP
------------ ------------ ------------------------- ------------------------------------------------------------------------------------
TAILSPROVIDER gl_admin ms-glb040.vi.r 28.07.15 11:15:01,682441 +03:00
Kindly help me how to find how oracle account got locked and let me know if you need any other information.
Thanks
Sumit