Database Time Monitor

22 Dec

Untuk mengetahui performance database server oracle memang sudah menyediakan tool dari oracle yaitu Oracle Enterprise Manager (OEM), tetapi OEM yang web base, harus dijalankan service-nya agar dapat diakses lewat browser.
Ada alternatif lain untuk mengetahui performance database server oracle yaitu Database Time Monitor, berikut ulasannya :
Sedangkan untuk Untuk mengetahui performance server sendiri dapat menggunakan ini

1. Database Time Monitor adalah aplikasi yang dibangun dengan Java oleh Dominic Giles. Teknologinya secara langsung mengambil data di server dimana server yang digunakan sebagai target tidak perlu dipasangi agent.

Database Time Monitor suport Oracle 11g dan 10g.
2. File dapat di download di http://www.dominicgiles.com/downloads.html
3. Dapatkan yang terakhir, misalnya : dbtimemonitor01.zip
4. Extract
[oracle@test ~]$ pwd
/home/oracle
[oracle@test ~]$ unzip dbtimemonitor01.zip
5. download juga java, saya menggunakan jre-6u5-linux-i586-rpm.bin
[oracle@test ~]$ su – root
[root@test ~]# chmod a+x jre-6u5-linux-i586-rpm.bin
[root@test ~]# ./jre-6u5-linux-i586-rpm.bin
[root@test ~]# rpm -ivh jre-6u5-linux-i586.rpm
6. edit cpumonitor dan tambahkan /usr/java/jre1.6.0_05/bin/
[oracle@test ~]$ cd /home/oracle/dbtimemonitor/bin
[oracle@test bin]$ vi dbtimemonitor

7. Menyiapkan test, pada kasus ini saya ingin melakukan monitor terhadap server database oracle, dengan
ConnectString : //10.0.0.4/orcl1
Comment : orcl1
Username : system
Password : 123456 (setelah dirunning password akan di-encrypt)

[oracle@test bin]$ vi databases.xml

<?xml version = ‘1.0’ encoding = ‘UTF-8’?>
<WaitMonitor Title=”Monitored Databases” xmlns=”http://www.dominicgiles.com/waitmonitor”&gt;
<!– You can add as many Monitored Databases as you like. –>
<!– They will connect to the server over the thin jdbc connection stack.–>
<!– Passwords will be encrypted from clear text after the file is read.–>
<!– To change/update a password simply change all the text between the <Password> tags</Password>–>
<!– –>
<MonitoredDatabase>
<ConnectString>//10.0.0.4/orcl1</ConnectString>
<Comment>orcl1 </Comment>
<Username>system</Username>
<Password>123456</Password>
</MonitoredDatabase>
</WaitMonitor>

8. jalankan test
[oracle@test bin]$ ./dbtimemonitor

9. jika diinginkan memonitor lebih dari 1 server dan dengan nama file konfigurasi yang berbeda
[oracle@test bin]$ cp databases.xml databases_a.xml
[oracle@test bin]$ vi databases_a.xml

<?xml version = ‘1.0’ encoding = ‘UTF-8’?>
<WaitMonitor Title=”Monitored Databases” xmlns=”http://www.dominicgiles.com/waitmonitor”&gt;
<!– You can add as many Monitored Databases as you like. –>
<!– They will connect to the server over the thin jdbc connection stack.–>
<!– Passwords will be encrypted from clear text after the file is read.–>
<!– To change/update a password simply change all the text between the <Password> tags</Password>–>
<!– –>
<MonitoredDatabase>
<ConnectString>//10.0.0.4/orcl1</ConnectString>
<Comment>orcl1 </Comment>
<Username>system</Username>
<Password>123456</Password>
</MonitoredDatabase>
<MonitoredDatabase>
<ConnectString>//10.0.1.4/orcl2</ConnectString>
<Comment>orcl2 </Comment>
<Username>system</Username>
<Password>123456</Password>
</MonitoredDatabase>
</WaitMonitor>

10. running
[oracle@test bin]$ ./dbtimemonitor -c databases_a.xml

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s

%d bloggers like this: