Oracle Database - Oracle Enterprise Manager Database Control (Database Control)
Table of Contents
1 - 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.
2 - Articles Related
3 - How to
3.1 - status
To get the status:
emctl status dbconsole
3.2 - 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 184.108.40.206.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
3.3 - access
Use a Web browser to access the Database Control URL:
- https://host:5500/em: 12c
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
3.4 - 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.
4 - User
4.1 - 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.
4.2 - 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.
5 - Support
5.1 - Diagnostic Log
The log are in the directory