iSelfSchooling.com  Since 1999     References  |  Search more  | Oracle Syntax  | Free Online Oracle Problem Solver

    .Home      .Subscribe     .Login      .Start Learning      .Certification      .Cancel      .Password Reminder      .Password Change     .Sign out

 

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

Gandhi

 

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.

            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 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

 

 

Google
 
Web web site