Since 1999     References  |  Search more  | Oracle Syntax  | Free Online Oracle Training

    Home      .Services     Login       Start Learning     Certification      .                 .Share your BELIEF(s)...


. Online Accounting        .Copyright & User Agreement   |
    .Vision      .Biography     .Acknowledgement

.Contact Us      .Comments/Suggestions       Email2aFriend    |


Oracle 10g New Features


Navigate the Oracle Enterprise Manager Grid Control in the Oracle 10g database


"Whenever I see an erring man, I say to myself I have also erred; when I see a lustful man I say to myself, so was I once; and in this way I feel kinship with everyone in the world and feel that I cannot be happy without the humblest of us being happy."



Oracle Grid


What is the Oracle 10g Database Grid?

Yesterday was Internet and today is Grid. It looks like the technology finds its way to hang on something to grow. Now, there is a committee called the Global Grid Forum (GGF) that is developing standards for Grid computing.


The following are some of the most important features that enable Grid computing at the Oracle 10g Database level:

  • Automatic Storage Management

  • Portable Clusterware

  • High-Speed InfiniBand Network Support

  • Real Application Clusters and automatic workload management

  • Resource Manager

  • Oracle Streams

  • Centralized Management with Enterprise Manager Grid Control

  • Oracle Database 10g New self-management feature

  • "

What is OEM 10g?

It is Oracle Enterprise Manager with more new features. It can automatically alert you to new critical patches.  You can use the patch wizard to select an interim patch and see if any of your system requires it. It is integrated with a build-in MetaLink connection.


Navigate the Oracle Enterprise Manager Grid Control in the Oracle 10g database


Step #1:  Find your hostname or IP address of your server. Ex: hostname is: myserver


Step #2:  Make sure that the /etc/hosts file contains the localhost name and server name.

For example you should have the following two lines in your /etc/hosts.

              localhost.localdomain            localhost

              myserver.mydomain            myserver

Notice that the 'myserver' name should be the same as your server name.


Step #3:  Open your browser and enter the following URL http://myserver:7777/em and press enter key. This will initiate Enterprise Manager Database Grid Control.


Step#4:   Enter your username and Password. Username can be SYSTEM with its password.


Now, you should see the Oracle EM 10g Grid Control page. By clicking on the Home, Targets, Deployments, Alerts, Jobs, and Management System tabs, you can navigate and monitor your databases information.


On the Oracle 10g, one more tablespace (SYSAUX) was added. It provides a centralized location for all auxiliary database metadata that does not reside in the SYSTEM tablespace.


To stop the Oracle Management Server, do the following command:

# emctl stop oms


To start the Oracle Management Server, do the following command:

# emctl start oms


To get the status of the Oracle Management Server, do the following command:

# emctl status oms


Using Enterprise Manager Database Control

You must have the dbconsole process running.

To start EM Database Contorl:

# emctl start dbconsole


To stop it:

# emctl stop dbconsole


To get its status:

# emctl status dbconsole


The default port is 5500 and you can access it by opening your Web browser and enter the following URL: http://myserver:5500/em



Web web site