Oracle Database - Oracle Enterprise Manager Database Control (Database Control)

About

Oracle Enterprise Manager Database Control is one of the two way that Oracle Enterprise Manager can be installed.

You can deploy Oracle Enterprise Manager:

locally on the database system called database controle
or in the environment called Oracle Enterprise Manager Grid Control (or simply grid).

If you configured Oracle Enterprise Manager Database Control (Database Control) during the installation, you can use it to manage the database. Alternatively, you can use Oracle Enterprise Manager Grid Control to manage the database.

Oracle Enterprise Manager Database Control software is installed by default with every Oracle Database installation.

This local installation provides a Web-based interface called Oracle Enterprise Manager Database Control. The Database Control is similar in function to the Grid Control, but it can manage only a single database.

If you want to administer more than one database on this system, then you must either configure a separate Database Control for each database, or install Oracle Enterprise Manager Grid Control.

Articles Related

Oracle Database - How to reconfigure Enterprise Manager Database Control (with Emca)

How to

status

To get the status:

emctl status dbconsole

start

If you receive this message “Oracle Enterprise Manager 11g is not running”, then start it with this command:

emctl start dbconsole

Oracle Enterprise Manager 11g Database Control Release 11.2.0.3.0
Copyright (c) 1996, 2011 Oracle Corporation.  All rights reserved.
https://Exalytics-01.hotitem.local:1158/em/console/aboutApplication
Starting Oracle Enterprise Manager 11g Database Control ...... started.
------------------------------------------------------------------
Logs are generated in directory /u01/app/oracle/product/11.2.0/dbhome_1/Exalytics-01.hotitem.local_EXAREPO/sysman/log

access

Use a Web browser to access the Database Control URL:

In this example, host is the name of the computer on which you installed the Oracle Database, port is the port number reserved for the Database Control during installation. If you do not know the correct port number to use, look for the following line in the ORACLE_HOME/install/portlist.ini file:

Enterprise Manager Console HTTP Port (db_name) = 1158

The installation reserves the first available port from the range 5500 to 5519.

Example of portlist.ini file

[oracle@Exalytics-01 ~]$ cat $ORACLE_HOME/install/portlist.ini
Enterprise Manager Console HTTP Port (EXAREPO) = 1158
Enterprise Manager Agent Port (EXAREPO) = 3938

Log in

Log in to the database using the user name SYSTEM and connect as SYSDBA. Enterprise Manager displays the Database Home page. Use the password that you specified for the SYSTEM account during the installation.

You can also log in to the Database Control using the SYS, SYSTEM or SYSMAN accounts or you can grant login privileges to other database users. If you log in as SYS, then you must connect as SYSDBA.

User

SYSMAN - the Oracle Enterprise Manager super user

When you log in to the Oracle Enterprise Manager Database Control using the SYSMAN user account, you are logging in as the Oracle Enterprise Manager super user. The SYSMAN account is automatically granted the roles and privileges required to access all the management features provided by the Database Control.

You can also use the SYS and SYSTEM accounts to log in to the Database Control.

Grant login privileges to other database users

In addition, you can grant login privileges to other database users, as follows:

Log in to the Database Control.
Click Setup at the top of the Database Control home page.
Click Administrators in the left navigation bar.
Click Create to create an Enterprise Manager user.
In the Name field, enter the user name of an existing database user or click the flashlight icon and select a user from the pop-up window.
In the E-mail Address field, specify one or more e-mail addresses.
In the Administrator Privilege list, select either View on all targets, Full on all targets, or Super Administrator.
You can also select the Grant SELECT_CATALOG_ROLE option.
Enter the password for this user, and then click Review.
On the properties page, click Finish.

Enterprise Manager assigns login privileges to the specified user and includes this user in the list of Enterprise Manager users on the Setup Administrators page.

Support

Diagnostic Log

The log are in the directory

ORACLE_BASE/product/11.2.0/db_1/oel11g.localdomain_orcl/sysman/log