iSelfSchooling.com  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    |

 

Online Oracle Training for beginners and advanced - The most comprehensive Oracle tutorial

The authors do not guarantee or take any responsibility for the accuracy, or completeness of the information.

 

 

 

 

 

 

 

Lesson 17

‘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.’ Gandhi

 

Oracle Grid

Introduction

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 Oracle 10g Grid important features

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

·

The EM Oracle 10g Database Control

It is like Oracle Enterprise Manager with more features that are new. 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.

 

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

Setting configuration

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.

127.0.0.1 localhost.localdomain localhost

111.222.33.4 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 the dbconsole process

You must have the dbconsole process running.

To start the EM Database Control:

# 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

 

 

 

“Nonviolence is the answer to the crucial political and moral questions of our time; the need for mankind to overcome oppression and violence without resorting to oppression and violence. Mankind must evolve for all human conflict a method which rejects revenge, aggression, and retaliation. The foundation of such a method is love.” Martin Luther King Jr., December 11, 1964

Questions:

Questions on

Oracle Grid

Q: What is the Oracle 10g Database Grid?

Q: List some of the most important features of the Oracle 10g Grid.

Q: What is OEM 10g?

Q: How do you stop the Oracle Management Server?

Q: How do you start the Oracle Management Server?

Q: How do you get the status of the Oracle Management Server?

Q: How do you start EM Database Control?

Q: How do you stop the EM Database Control?

Q: How do you get the status of the EM Database Control?

Q: What is the default port for your Web Browser?