Sometime back I had released a useful Unix menu driven database monitoring tool and had made it available for the Linux, Solaris and AIX operating systems.
Here is a link to the original post.
I have got numerous requests to do something similar for the HP UX platform, so here is the new database monitoring menu for HP UX which can be downloaded and installed.
Please follow the instructions carefully and they are basically very simple to adopt.
1) Untar the dbamenu.tar file in a directory where you have the appropriate read/write permissions.
oracle@inpsit1:/home/oracle/ tar -xvf dbamenu.tar x dbamenu/dba_assist.sh, 2392 bytes, 5 tape blocks x dbamenu/dba_main.sh, 2568 bytes, 6 tape blocks x dbamenu/dbinfo.sh, 1443 bytes, 3 tape blocks x dbamenu/dbinfo.sql, 2989 bytes, 6 tape blocks x dbamenu/dbinfo9.sql, 2757 bytes, 6 tape blocks x dbamenu/dbmon_menu.sh, 49253 bytes, 97 tape blocks x dbamenu/machine.sh, 1720 bytes, 4 tape blocks x dbamenu/menu.log, 467 bytes, 1 tape blocks x dbamenu/monitor_passwd, 8 bytes, 1 tape blocks x dbamenu/object_menu.sh, 27622 bytes, 54 tape blocks x dbamenu/ops_dba.sh, 2335 bytes, 5 tape blocks x dbamenu/opsdba.sh, 2335 bytes, 5 tape blocks x dbamenu/orahome90.sh, 769 bytes, 2 tape blocks x dbamenu/security_menu.sh, 25550 bytes, 50 tape blocks x dbamenu/sga.sh, 1072 bytes, 3 tape blocks x dbamenu/storage_menu.sh, 18695 bytes, 37 tape blocks x dbamenu/test_menu.sh, 2691 bytes, 6 tape blocks x dbamenu/tune_menu.sh, 26707 bytes, 53 tape blocks x dbamenu/unix_menu.sh, 8783 bytes, 18 tape blocks x dbamenu/version.log, 318 bytes, 1 tape blocks
2) Note that 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.
3) Ensure that the PATH includes the directory where scripts are unzipped.
For example:
$ export PATH=.:$PATH
4) 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.
5) 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
6) Ensure that the environment variable ORACLE_HOME is set before launching the menu
7) Launch the menu by running :
./dba_main.sh
Kindly provide feedback if the menu is found to be useful and if there are any issues or problems encountered as well as any suggestions for improvements and enhancements.
Download the DBA Menu
Some screenshots of the DBA Menu ….
[DBA Menu - INPSIDT1]
#######################################################
(1) Unix Node Information
(2) Connect to Database
########################################################
UNIX Node Information Menu - INPSIT1
===================================================
(1) General Machine Information
(2) Mount Points > 90% Full
(3) Mount Points Free Space
(4) Monitor Machine Activity
(5) ORACLE_HOME's On This Machine
Enter your choice (q to quit):
******************************************************************
Information for UNIX node : inpsit1
*****************************************************************
CPU info:
6 Intel(R) Itanium 2 9100 series processors (1.59 GHz, 9 MB)
266 MHz bus, CPU version A1
Memory: 6138 MB (5.99 GB)
Firmware info:
Firmware revision: 04.10.00
FP SWA driver revision: 1.18
IPMI is supported on this system.
BMC firmware revision: 4.0a
Platform info:
Model: "ia64 hp server Integrity Virtual Machine"
Machine ID number: 85a2576a-c6aa-11df-b904-abcdefghijk
Machine serial number: VM01038002345678
OS info:
Nodename: inpsit1
Release: HP-UX B.11.31
Version: U (unlimited-user license)
Machine: ia64
ID Number: 22420038
vmunix _release_version:
@(#) $Revision: vmunix: B.11.31_LR FLAVOR=perf
Last Reboot Time and Date: May 9 13:30
Hit return to continue
Connected to Database- shieldt1
#######################################################
(1) Database Overview
(2) Database Storage
(3) Database Objects
(4) Database Security
(5) Database Monitor
(6) Database Performance
Enter your choice (q to quit):
########################################################
#######################################################
Database Monitoring Menu - shieldt1
#######################################################
(1) User Sessions
(2) Redo Log File Switches
(3) Current SQL (by Unix PID)
(4) Current SQL (by SID)
(5) Current SQL (by Oracle Username)
(6) Rollback Segment Usage
(7) Locked Sessions
(8) Locked Objects
(9) Datafile I/O
(10) DBMS Jobs Status
(11) View Long Operations
(12) Active Transactions
(13) Idle Sessions
(14) Flashback Logging
(15) Sessions With High I/O
(16) Data Guard Log Shipping
(17) Redo Generation By Day
(18) RMAN Backup Status
(19) Streams Replication Status: CAPTURE
(20) Streams Replication Status: APPLY
Enter your choice (q to quit):
#######################################################
#######################################################
Database Performance Menu - shieldt1
#######################################################
(1) Waits - Instance Level (by time waited)
(2) Waits - By Class
(3) Waits - Waiting Session's SQL
(4) Waits - What are users currently waiting on?
(5) Waits - Datafile Level
(6) Buffer Busy Waits
(7) Locked Sessions
(8) Large Objects In Shared Pool
(9) Hit Ratios - Quick Check
(10) Top 5 Problem Queries (Disk Reads)
(11) Top 5 Problem Queries (Buffer Gets)
(12) Top 5 Problem Queries (Disk Reads/Executions)
(13) Top 5 Queries (Executions)
(14) Top 5 Latch Waits (by sleeps)
(15) Top 5 Latch Waits (by misses)
(16) Current Waits On Latches
(17) Enqueue Waits - By Session
(18) Enqueue Waits - By Database
(19) Enqueue Waits - By Object
(20) Key CBO init.ora Parameters
(21) Tables ANALYZE Status
(22) Indexes ANALYZE Status
(23) Top Segments with most I/O
Enter your choice (q to quit):
#######################################################
