1. Home
  2. Knowledge Base
  3. Database Administration
  4. DBA Monitoring Menu
Searching...

DBA Monitoring Menu

I have written a simple Unix shell script driven menu which contains SQL scripts which covers most common day to day DBA activity tasks related to monitoring and performance tuning. Once installed in a central location, we canconnect to any database in our enterprise and monitor it from one interface.

We can also connect to and monitor any databases on Windows platform. The scripts will support all databases in versions 10g as well as 11g – a few menu options may not work for Oracle 9i databases.

Have a look at the screen shots below. The download links as well as installation instructions are provide below as well.

Please let me know if this menu can be enhanced in any way and your feedback will be taken on board.


Installation Instructions:

  • Unzip the contents in a directory with read/write privileges. Note this needs to be installed on only one machine where SQL*Net is installed where an appropriate tnsnames.ora file is available in $ORACLE_HOME/network/admin

  • Execute the command chmod +x *.sh

  • Ensure that the PATH includes the directory where scripts are unzipped.

    • For eg – export PATH=.:$PATH

  • Create a database user MONITOR in each database which needs to be monitored. Grant this user appropriate privileges like CONNECT and SELECT ANY DICTIONARY roles.

  • The password for the user MONITOR is contained in the monitor_passwd file. Edit this file to include the correct password. For security, change permissions to 700.

  • Ensure that the environment variable ORACLE_HOME is set before launching the menu.

  • Launch the menu by running : ./dba_main.sh
      • Note – please download for the appropriate Operating System

    a) For AIX and Solaris :

    b) For Linux:

    Updated on June 2, 2021

    Was this article helpful?

    Yes No

    About The Author

    Gavin Soorma

    Oracle ACE Director (only 3 in Australia), Oracle Cloud Infrastructure Architect, Oracle Certified Master Database and Cloud (10g,11g and 12c), Oracle Certified Specialist (GoldenGate, Exadata 11g, Exadata Database Machine and Cloud Service 2017) and Oracle OCP (8i to 12c).

    Related Articles

    Comments

    3. Nice! As a command line DBA old school style, its a nice alternative to GRID control OEM!

      Just need to build on your foundation to add scripts for monitoring EBS things like concurrent managers, and such.

      Cheers.
      Ben

    4. Superb tool. Very good improvement to the existing menu. Saves a lot of time having to go around searching for scripts.

    7. Very few people like to share their work,ideas..You are one of that..really appreciated.

    8. I can say that you really know the concept of sharing and growing in the deepest part of your HEART. Thanks for sharing such wonderful work.

    9. Excellent… I really like this site.. Lots of hard and great work.. Hats off …

    12. Gavin: Nice idea(Kaizen), I like it, will install this for Linux. Thanks for sharing. Uday

    13. please can u please explain more how to install this great tool
      thank you man

    14. What is the problem you are facing – I have supplied the install directions in the same post – let me know what is the issue you are having

    15. This is fantastic….useful for all the DBAs…Great work.

    16. Hello Gavin,

      Wonderfull tool….Thank you very much for sharing.

    17. Hi Gavin,

      u done a good job.. i have one doubt if we dont have oratab then how to install .In my enivornment only one DB is there if i install this one it will give the one error msg oratab quiting .. then how to proceed plz let me know asap…

      Regards
      Ramesh

    18. This is really super. its working fine for us. Thanks so much!

    19. Excellent Work…can be easily deployed to make it work in our environment.

    20. Hi Gavin,

      One single script..will reduce much work of DBA’s. Thanks for the script. really appreciated.

    Leave a Comment