Monitoring Oracle 10g Server

I've posted some articles about Oracle. How to connect Oracle to PHP, connect Oracle to ASP.NET, or splitting Oracle server. In this blog you can find how to handle host credentials of your Oracle server or optimizing Oracle server.

This article will talk about how to monitor Oracle server. It's very sensitive for database administrator. Admin should make sure the server works well. To do it, he has to monitor time by time. There are some ways to do this job. We'll try to use Oracle Entrepise Manager 10g. Let's check it out:

#1. Open your browser like Mozilla Firefox or Internet Explorer
#2. Go to Oracle Entrepise Manager 10g by entering url address: http://localhost:5500/. 5500 is default port for the first database. If you have some database, port will be incremented automatically like 5501, 5502, ...
#2. Enter your username and password correctly.
#3. On the first page, there are some menus: Home, Performance, Administration, and maintenance.
#4. Home page is loaded directly. Information we can get are: - General (Server information in common points like: Status, Up Since, Availability etc)
- Host CPU and Active Session displayed on graphics mode. So, we can analyze it quickly and easily.
- High Availability and Space Usage
- Diagnostic Summary and the last part is Alert. Alert shows Critical and Warning for system administrator.
#5. Second menu is Performance. We can monitor:
- Host
- Session: Waiting and Working
- Instance Throughput
- Additional Monitoring links.

Pay attention on Warning displayed on the screen. Analyze and diagnose it to prevent serious trouble on oracle server.

Make Blog Stay Update

It's very important to make blog staying up to date. Search engine like Google like to visit blog with update content. But there is one problem: we don't have enough time to blogging or sometimes we lazy to write a post. There are some solutions but I want to discuss about Newsreel page element. I try to use Page Element provided by blogger because I use blogger. Here are the tips:

#1. Sign to your blog on blogger.
#2. Pick Template menu, choose Page Element and Click Add Page Element.
#3. Scroll down the window and choose Newsreel widget, click "Add to Blog".
#4. Configure Newsreel and customize based on your style.
#5. Click Save Changes button to save this changes.

Preview your blog and make it stay update!

Free Search Engine Submissions

One of offpage optimization type in seo is search engine submissions. There are many online tools that provide it. One of them is http://addme.com. addme.com is one of online search engine optimization tool. You can submit your site on many search engine for free. For example, I open addme.com and then choose Free Search Engine Submission menu. We'll get two options: Basic Search Engine Submission (14 search engine) and Professional Search Engine Submission (Hundreds of search engines). Now, try to click the first option. This is step by step process. Just follow the instructions written on the web page.

#Step one

1. Add link to addme.com by copying and paste it on your web page
2. Enter information about your website and contact information
Give check for options you want and ready to the next step.

Add me to google
Add me to scrub the web
And then click next

#Step two

Add me to burf.com, if you see an apporval from burf.com click Back button on your web browser.
Add me to alexa. This is confirmation shown on the screen:

"Thank You
Your request was successful. The Alexa bot will visit your site within the next few days.
You may also wish to update your contact information, or suggest related links.
Note: it may take several weeks for information about your site to appear in the Alexa service."

#Step 3

Addme to BigFinder
Confirmation: Thank you for submitting your web site to BigFinder.com
Addme to FyberSearch
Confirmation: You have successfully suggested your website to FyberSearch.

#Step 4

Addme to life tips
Addme to Exactseek, email required

#Step 5

Addme to nerdworld
Confirmation: Site Submission Completed
Addme to infotiger, email address required.
Confirmation: Successfully added http://studiawan.blogspot.com

#Step 6

Addme to FocusLook
Addme to Walhello
Confirmation: Thank You!! Walhello will index your URL!!

#Step 7

Addme to jayde
Confirmation: Thank you for submitting to jayde.com
Addme to entireweb
Confirmation (if you don't give email address):
An error has occured!
The email noemail\\@add-me.com is invalid.

#Step 8

Add me to my friends

Process Done.

However, there is still one bonuses from addme.com. It is a bookmark button. Just simply copy the code on the textarea shown and paste it on your web page. It's done!