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

Card Puncher Data Processing

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:

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.

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





Discover More
Card Puncher Data Processing
Oracle Database - (initialization|server) parameter file (init.ora | spfile.ora)

How to manage the initialization parameters when the database start. By default, the preconfigured database uses a parameter file (spfile) named spfilesid.ora, which is stored in the $ORACLE_HOME/dbs...
Card Puncher Data Processing
Oracle Database - Data Files

Every Oracle database has one or more physical datafiles (OS File), which contain all the database data. The data of logical database structures, such as tables and indexes, is physically stored in the...
Card Puncher Data Processing
Oracle Database - Entreprise Manager

To simplify database administration, Oracle provides a Web-based management tool called Oracle Enterprise Manager. There are two ways that you can deploy Oracle Enterprise Manager: Deploy Oracle Enterprise...
Card Puncher Data Processing
Oracle Database - How to reconfigure Enterprise Manager Database Control (with Emca)

You may have to reconfigure the Enterprise Manager database control when for instance, the Database Host Name or IP Address Change. While installing Enterprise Manager or related components on Multi-homed...
Oracle Database 11gr2 Typical Installation
Oracle Database - Installation 11g Release 2 (11.2) on Linux OEL 5 (X86)

Installation of Oracle Database 11g Release 2 (11.2) on Oracle Enterprise Linux 5. Linux OEL installation login as root RAM: At least 1 GB swap space The following table describes...
Oracle Database Installationl Location 11gr2 Oel Linux X86 64
Oracle Database 11gR2 - Installation on Linux OEL 5 Update 5 (x86_64)

Installation of Oracle Database 11g Release 2 (11.2) x86_64 on Oracle Enterprise Linux 5 Update 5 on the file system (ie without ASM) or GRID. Linux OEL installation login as root ...



Share this page:
Follow us:
Task Runner