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:

    Please follow and like us:

    Last Update: April 20, 2010  

    April 20, 2010 200 Gavin Soorma
    Total 0 Votes:

    Tell us how can we improve this post?

    + = Verify Human or Spambot ?

    Add A Knowledge Base Question !

    You will receive an email when your question will be answered.

    + = Verify Human or Spambot ?


    20 thoughts on “DBA Monitoring Menu

    1. Ben Prusinski

      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.


    2. Shahid Nasir

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

    3. Yusuf

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

    4. Balwan

      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.

    5. Ramesh

      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…


    6. shravan

      Hi Gavin,

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

    Leave a Comment

    Your email address will not be published. Required fields are marked *


    Social media & sharing icons powered by UltimatelySocial
    Back To Top

    Add A Knowledge Base Question !

    You will receive an email when your question will be answered.

    + = Verify Human or Spambot ?