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.

3.3 - access

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.

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.