Requirement:

Configure a shell script in crontab, that will send alert to DB support Team, in the case of any invalid login attempts in the database.

 

1. First, enable audit for create session

2. Final shell script

Below script for any invalid login attempts in last 15 minutes.

cat /export/home/oracle/invalid_log.sh

3. provide proper permission:

4. Configure in crontab:

5. SAMPLE OUTPUT: