Posted by Mir Sayeed Hassan on 18th June 2018
Find the user failed login attempts in Oracle database 11gR2 The user is created with the default profile set in database & the FAILED_LOGIN_ATTEMPTS set to 10, In this case if you exceed the more than 10 failed login attempts, then your account will be locked Now verify the user with number of failed login Read More
Posted in DBA Administration | Comments Off on Find the user failed login attempts in Oracle database 11gR2
Posted by Mir Sayeed Hassan on 17th June 2018
Script to verify the database for Primary & standby [oracle@Prim-DB ~]$ cd /home/oracle/scripts/ [oracle@Prim-DB scripts]$ vi dblogsummary.sql !df -h !free !uptime !last reboot set linesize 500 col host_name format a40; select INST_ID,instance_name,STARTUP_TIME,status,archiver from gv$instance; select name,log_mode,protection_mode,… Read more..
Posted in DBA Scripts | Comments Off on Script to verify the database for Primary & standby
Posted by Mir Sayeed Hassan on 13th June 2018
Deleting the SYS.AUD$ Table in Oracle Database Find the below procedure: Before deleting the SYS.AUD$ table, take the backup by using the exp utility Note: In Oracle 11g we cannot run expdp to export the SYS.AUD$ table, Use the exp utility Create the directory in OS & DB Level:
Posted in DBA Administration | Comments Off on Deleting the SYS.AUD$ Table in Oracle Database
