DB Time Viewer
Install
Install
Download from: http://dominicgiles.com/downloads.html
Copy zip file to /u01/dba/dbtimemonitor and unzip
Set these parameter in your environment. (Recommended: add them to the .bash_profile for the 'oracle' user)...
export CLASSPATH=$ORACLE_HOME/jdk/lib
export PATH=$ORACLE_HOME/jdk/bin:$PATH:/u01/dba/dbtimemonitor/bin
NOTE: This was tested with Database Time Viewer 0.2 (16-Aug-2018) against an Oracle 12.2.0.1.0 database using Java version 1.8.0_91
Configure
Configure
cd /u01/dba/dbtimemonitor/bin
vi databases.xml
<?xml version="1.0" encoding="UTF-8" standalone="yes"?><WaitMonitor Title="Monitored Databases" xmlns="http://www.dominicgiles.com/waitmonitor"> <MonitoredDatabase> <ConnectString>localhost:1521:ORCL1</ConnectString> <Username>system</Username> <Password>enc(aNCQDHbJUYCcfEtl9p/Cpw==)</Password> <Comment>ORCL1</Comment> </MonitoredDatabase> <MonitoredDatabase> <ConnectString>localhost:1522:ORCL2</ConnectString> <Username>system</Username> <Password>enc(aNCQDHbJUYCcfEtl9p/Cpw==)</Password> <Comment>ORCL2</Comment> </MonitoredDatabase></WaitMonitor>
Run
Run
dbtimemonitor
