Monitoring essential tasks for multiple Oracle on a single server
Shell scripts are commonly used for automating repetitive tasks, managing system configurations, and executing sequences of commands. learning shell scripts is particularly advantageous in this situation.
Here’s a straightforward method I used to monitor multiple databases simultaneously as part of my daily routine before commencing morning work. It involves utilizing shell scripts that I created!
All results are transmitted via email and can also be forwarded to WhatsApp and the Line messaging program.
Alertlog result
The alert log results are provided below. My team and I can promptly identify the issues and address them before the system becomes available for services.
Tablespace routine checking
the free space of tablespace; the email result is provided below. If there are multiple databases on the server, the script will present them together in the email. My team and I can discern what is occurring and address it before the system is ready for services
Recovery dest size
It’s crucial to verify the size of the recovery destination daily.
Backup Result
Incomplete backups will also be displayed in the email, aiding in your awareness and facilitating a decision to re-backup if necessary.
