Oracle Database Monitoring For Beginner (The Simple Way)

• Why Monitor Oracle Database

Database need to be monitored to check the performance of the monitored database, so we can change the database parameter based on result from monitoring and keep the database in it’s best performance.

Database monitoring also needed so we always know the condition of database, and know the symptom of our database and we can take action right before more problem happens to database.

• Types of Oracle Database Monitoring

Database Monitoring can be grouped into three types :

• 1. Status monitoring

This monitoring type monitors current status of an events and give reports or alert when it exceeds a defined threshold

Examples of Status Monitoring are, check tablespace where it’s about to fills up, check segment near their maximum extents.

• 2. Performance monitoring

Monitors oracle instance memory (sga, buffer, etc), sql query running in database, session which consumes a lot of memory, etc.

Examples of Performance monitoring are, query from v_$sqlarea to check what SQL has been running in our Oracle Machine, query from v$sgastat and query to get hit ratio for cache , library and buffer cache.

• 3. Trend Analysis

Collects historical data on specific event that occur in database like SGA status, segment that cannot extends, filled up tablespace and make analysis from that historical data so that we can predict the status of SGA in any given time or we can now when the tablespace will filled up.

Examples of Trend Analysis are, make a histroy table for events we monitored. We can make history table for tablespace so that from that history table we could gain information and make prediction when will the time the tablespace will be filled up. Or we can make history table from v_$session, so from that table we can know what time our database accessed by so many user.

Next is the query to monitored database … soon…

There are two ways to write error-free programs. Only the third one works.

 

 

Movie Quotes From When Harry Met Sally

Quotes From Movies When Harry Met Sally :

I love that you get cold when it’s 71 degrees out. I love that it takes you an hour and a half to order a sandwich. I love that you get a little crinkle above your nose when you’re looking at me like I’m nuts. I love that after I spend the day with you, I can still smell your perfume on my clothes. And I love that you are the last person I want to talk to before I go to sleep at night. And it’s not because I’m lonely, and it’s not because it’s New Year’s Eve. I came here tonight because when you realize you want to spend the rest of your life with somebody, you want the rest of your life to start as soon as possible.

Harry Burns: There are two kinds of women: high maintenance and low maintenance.
Sally Albright: Which one am I?
Harry Burns: You’re the worst kind. You’re high maintenance but you think you’re low maintenance.

Just love the quote……

T-Sel Bundling dengan iPhone 3G

Tanggal 26 Juni 2008 dapet email dari milis pegawai di kantor yang isinya tentang T-Sel dan iPhone. Berita selengkapnya bisa dilihat dibawah. Yang pasti dengan membeli iPhone 3G kita udah dapet fitur seperti iPod Touch n bisa bwat telpon. Sayangnya sih dari gambar2 yg iPhone 3G yg pernah gw liat dia gak ada kamera depan (yach gak bisa video call pake kamera depan donk, masih tetep menang 6120 C gw :D)

Telkomsel Siap tawarkan iPhone Murah

Written by halim
Wednesday, 28 May 2008
Jakarta - Telkomsel berniat mengikuti jejak Singtel yang akan membundling ponsel iPhone keluaran Apple. Telkomsel pun ingin menawarkannya dengan harga yang lebih murah dari pasaran. Namun sayangnya, menurut Vice President Corporate Account PT Telkomsel, Ivan Ho, program bundling tersebut baru akan ditawarkan pada pelanggan pascabayar korporat. “Detail kapannya belum bisa kami pastikan berhubung iPhone juga belum masuk ke Indonesia. Tapi kami ada niatan untuk menawarkan dengan harga yang lebih murah,” ujarnya kepada detikINET, di sela seminar dan ekshibisi layanan korporat Telkomsel di Hotel Gran Melia, Jakarta, Selasa (13/5/2008).
Mungkinkah Telkomsel iPhone di Indonesia?

Written by halim

Tuesday, 24 June 2008

JAKARTA - Rumor mengenai Telkomsel yang mendapatkan mandat memasok iPhone bisa jadi benar adanya. Pasalnya, Telkomsel merupakan operator yang disinyalir memiliki kriteria yang cukup kuat untuk bisa membujuk Apple menyerahkan sebagian iPhone 3G-nya untuk dibundle dengan operator dominan di negeri ini. Saat ini Telkomsel dan SingTel sama-sama termasuk operator terbesar di negaranya masing-masing, Indonesia dan Singapura. Bahkan beberapa operator lainnya pun memiliki posisi yang sama, setidaknya berada di posisi pertama dan kedua terbesar di negara masing-masing. Belum lagi, hubungan yang cukup erat antara SingTel dengan Telkomsel melalui suntikan saham. Seperti diketahui, SingTel saat ini memiliki kontribusi saham sebesar 35 persen di tubuh Telkomsel sedangkan sisanya sebesar 65 persen masih dikuasai Telkom. Bahkan beberapa operator yang mendapatkan jatah pasokan iPhone ditengarai juga memiliki hubungan sangat dekat dengan Sing Tel. Sebut saja Bharti Airtel, Globe Telecom dan Optus. Masing-masing operator tersebut ditugaskan untuk menggelontorkan gadget multimedia milik Apple itu ke negara masing-masing. Bharti akan memasok iPhone ke India, Globe Telecom mendapat jatah pasar di Filipina sedangkan Optus mendapat kewajiban untuk memasarkan iPhone ke Australia. Dikutip melalui situs resmi SingTel, Senin (23/6/2008), pada tahun 2001, perusahaan telekomunikasi terbesar di Asia itu telah berhasil mengakuisisi Optus, yang kala itu menduduki posisi operator nomor dua terbesar di Australia. Bahkan beberapa perusahaan besar lainnya di Asia juga disusupi oleh SingTel. Di Bharti, SingTel punya sekira 30,5 persen saham dengan jumlah pelanggan di India saat ini mencapai 64 juta. Sedangkan di Globe, SingTel menyusup dengan 44,5 persen saham dan telah meraih 21,3 juta pelanggan di Filipina. Di Singapura dan Australia sendiri, SingTel dan Optus masing-masing memiliki 2,3 juta dan 7 juta pelanggan. Dengan hubungan yang erat tersebut, dan tentunya jumlah pelanggan paling besar yang dimiliki Telkomsel hingga mencapai lebih dari 50 juta pelanggan, bukan tidak mungkin jika Telkomsel pun akan kebagian jatah untuk memberikan pengalaman multimedia yang mengesankan dengan menggunakan gadget multimedia iPhone dari pemilik merek gadget terpercaya, Apple. Apalagi pada hasil RUPS Telkomsel yang berlangsung pertengahan Juni lalu, Telkomsel mengubah haluan AD/ART perusahaan untuk memperluas bisnis mereka ke arah multimedia. Hal ini dilakukan seiring dengan perubahan dan tantangan yang dialami Telkomsel dalam lingkungan bisnis. Hanya saja, yang menjadi pertanyaan adalah kapan Telkomsel benar-benar akan mewujudkan hal tersebut.

Remote desktop your Linux using Xmanager

It’s really helpful to remote your Linux. For example if your Linux is in Data Center where the place is so  cold  and there is  no ‘cozy’ place  for  you  to  install  and  configure  something  in your  Linux  that  need X11(Like install Oracle using Oracle Universal Installer).

To remote your Linux into your workstation you need software to remote your Linux, for now i choose Xmanager (Quite simple but “LICENSED” huh). There is other tool like VNC or XMing(I think i choose XManager because i’ve use it in my Solaris Box long time ago and always got good connection using it)

So to enable your Linux for remote desktop just follow this simple  instruction :

1. Open gdm.conf configuration file, usually located in /etc/X11/gdm/gdm.conf or /etc/gdm/custom.conf

2. Edit gdm.conf file, in section [gdcmp] change enable =  false  to  enable  =  true

3. Change run level to 5 in file /etc/inittab (example : x:5:once:/etc/X11/prefdm -nodaemon

4. Restart gdm service by simply run command : gdm-restart

5. Find your Xmanager source, installed it but not crack it.

PS : To enable X graphic open your terminal using root and type xhost +

Now let see my Linux Box in my workstation

Apache on Solaris 10

Solaris 10 already have Apache in it, in order to use it you just need to start the service. The step to start the Apache server are :
1. Go to /usr/apache/bin : #cd /usr/apache/bin
2. To start the service : #./apachectl start
You will get error message if you don’t have httpd.conf located in /etc/apache/
To create htttpd.conf just copy httpd.conf-example located in /etc/apache/ :
#cp /etc/apache/httpd.conf-example /etc/apache/httpd.conf
After that try again run command #./apachectl start
If it success than in your solaris will show message ./apachectl start: httpd started
3.After that you can try your Apache server using your browser and type : http://yourIPserver/

That’s all

Web for monitoring Server and DB in DataCenter

The idea(actually is developing existing web) for creating Web for monitoring Server and DB in DataCenter is came to me when one of my comrades introduce to me and my other work partners about web for monitoring resource in Data Center like server and database.
We need to have this web beacause we have a lot of server to monitored. And we can do it manually checking it one by one. And also inside those servers we have databases to managed.
Actually we already have application for monitoring performance of the server, but that application only show us response time not the detail of the server.
So in our Web for monitoring Server and DB in DataCenter will be given detail information to us about server and database performance like CPU usage, Memory usage, diskspace check , tablespace check and etc. And we hope our Web for monitoring Server and DB in DataCenter can give us notification wheter it via email or via sms (eg. server send sms when the diskspace is 80% used).
And i have an idea for further development this web will be act like an intelligence web who can not only give us information but also can fix the problem by itself.
So it’s not just only give us information about the condition of the server and database but also can take an action based on that information. It’s just like we plug our standard operation procedure(SOP) into that server and tell the server to do just like in SOP.

So the point for our Web for monitoring Server and DB in DataCenter will be like this :
1. Give real time usefull information about our server and database condition.
2. Server can take immediate action based on information processsed by server and the standard operating procedure we plug in to that server

The point look like simple (only 2 points), but i thought that i have to work on it more seriously so my data center will be full automate……(hopefully)

When dream drives you…….

Always down in unexpected time

Why our servers in D6 always down in unexpected time. It’s always down in late night , in holiday time, when there is no people around. Hate that. Why it always down when there is only a small usage on it or even it’s not used by someone. I still don’t have the clue……….

IT , BLOG & PEMBLOKIRAN

Look.
The people you are after
are the people you depend on.

We develop your applications. We install your servers.
We connect your computers. We deliver your e-mails.
We guard your network while you sleep

Do not fuck with us.

Kalimat diatas gw ambil dari sebuah blog .
Pas gw baca jadi merasa penting banget jadi bagian dari IT dan pentingnya IT menunjang kebutuhan untuk membantu manusia dalam menyelesaikan setiap tugas-tugas, pekerjaan, ataupun sekedar menggunakan internet untuk browsing dan chatting saja.

Sebenarnya sih kalimat diatas terkait dengan pemblokiran situs - situs seperti youtube,metacafe, multiply dan lain - lain. Tapi kalimat diatas scukup membuat gw sadar juga sih, betapa kecilnya gw sekarang di dunia IT(belum semua hal yang ditulis diatas gw mengerti). Masih banyak yang harus di explore, walaupun semuanya gak mungkin bisa gw kuasai dengan baik(biar gak ASBUN aja,mengutip dari sebuah blog: Di negri ini orang dikatakan pakar karena komentar - komentarnya sering dikutip, bukan karena pencapaiannya dan hasil penelitiannya di bidang yg dikuasainya). Tetap gw harus memilih untuk expert IT di bidang apa dan menjadi bagian tak terpisahkan dari perkembangan dunia IT di Indonesia.

The points on installing Oracle in non windows environment

The points on installing Oracle in non windows environment is (from my point of view) are :

1. Of course you must have the Installer source and check if the installer is compatible with your UNIX or LINUX version
2. Check the packages needed by the oracle Installer to successfully installed in your UNIX (check the pkginfo) and Linux (check it use rpm command)
3. Check your memory ( mostly oracle required 512 MB)
4. Check your diskspace, including your tmp diskspace and another partition for the oracle.
5. Create your Optimal Flexible Architecture (OFA), it’s the oracle file folder structure
6. Create DBA and OINSTALL group for installation
7. Set environment variable for oracle, including oracle_home,oracle_base, etc.
8. Create user oracle for installation.

This some useful link for Oracle installation in non windows environment :
oracle documentation
ORACLE-BASE

The Blade09 is up

it so weird, i have known that blade09 is having trouble like that the day before. And the solution is quite simple just push the power button to restart (i’m making an assumption that blade09 is HANG) or ssh to blade an reboot it(this can’t be done because i can’t ping the server).

So at 16.30 when i was in the DC room and i saw Mr E (The ‘incumbent’ SysAdmin).I just ask him and he ask me “so, what should i do with this server ??” I told him all the reason. Then he said, “ok then i think we have to restart the server” and he push the power button in blade09(just like me and my partner do). After he push that button, the monitor is indicating that the blade09 is in process of rebooting.

How he did that, actually me and my friend are doing just like him. But it didn’t work (it’s so weird). I thought he got the experiences (i didn’t have that).

After blade09 is up and ready for installation, i’m installed it with Oracle 9.0.2(struggling with the RPM). I’ve success installed the software but the Database Configuration Assistant (DBCA) didn’t work. Sadly the day after when I am trying to troubleshoot the DBCA, the server  will be  installed with Fedora.

The point are, i’ve got new knowledge about Linux, Oracle Installation on it and the RPM package that is not support by RHEL AS4

Another point is, knowledge is not enough, we still need experience. And if we combine our knowledge with experience hopefully we can have the WISDOM (it’s the art of knowledge)