Oracle Enterprise Manager (referred to as Enterprise Manager or EM) is the Oracle integrated management solution for managing the complete Oracle environment. All services within your enterprise, including hosts, databases, listeners, application servers, HTTP Servers, and Web applications, are easily managed as one cohesive unit.

When you install an Oracle database, the Oracle Universal Installer also installs the Oracle Enterprise Manager. The Web-based Database Control serves as a tool for managing your Oracle database. From the Oracle Enterprise Manager, you can perform administrative tasks such as creating schema objects (tablespaces, tables, and indexes), managing user security, backing up and recovering your database, and importing and exporting data. You can also view performance and status information about your database instance.

From the Oracle Enterprise Manager, you can perform administrative tasks such as creating schema objects (tablespaces, tables, and indexes), managing user security, backing up and recovering your database, and importing and exporting data. You can also view performance and status information about your database instance.

Starting EM Service (dbconsole) in Windows

After successful installation of Oracle10g, Windows will start EM service automatically when the computer is started. If it does not start automatically, you can start the EM service (dbconsole process) as follows.

To start EM service (dbconsole) as a service:

1. Click Start->Control Panel->Administrative Tools->Services. The Services page appears.

2. Oracle services begin with Oracle . The dbconsole service is listed as Oracle<oracle_home><SID>DBConsole . The status of this process is listed in the Status column, either Started or Stopped. Double click the service. The property page appears.

3. In the properties page, ensure that the Startup Type is either Manual or Automatic and not Disabled. Click Start , if the process is not already started. Click OK .

You can also use the Services page to stop the EM process. The following illustrates how it looks like for Oracle 11g. (8/2/2011)

Accessing the Oracle Enterprise Manager

At the end of a successful database creation, Oracle Enterprise Manager is automatically launched and the database is started. At other times, provided the dbconsole process is running on the server, you can navigate to your Database Control from your client browser as follows:

1. Point your Web browser (such as Internet Explorer or Netscape) to the following URL:

   http://hostname:portnumber/em

   For example, if you installed the database on a host computer named comp42 , and the installer indicated that your Enterprise Manager Console HTTP port number is 5500 (also recorded in the $ORACLE_HOME/install/portlist.ini file), enter the following URL:

   http://comp42:5500/em
   
   If you do not know the name of your computer, you may go to Command Prompt in your system, and type "hostname" and enter.
   
   The following link may also work:
   
   http://localhost:5500/em/
   
   If you download Oracle10g after Dec. 2005, the default port number may be different. For example, in my computer, file: C:\oracle\product\10.2.0\db_1\install\portlist.ini lists the following ports:

   iSQL*Plus HTTP port number =5560
   Enterprise Manager Console HTTP Port (oracle) = 1158
   Enterprise Manager Agent Port (oracle) = 3938
   
   
   If this is the case, your URL should be:
   
   http://localhost:1158/em/
   
   Note (8/2/2011): Oracle changed the above access to HTTPS on Oracle 11g. Thus, if you installed Oracle 11g, your access URL will be:
   https://localhost:1158/em/
   
   I kept above details just in case students use different versions of the database.
   
   

   If the database is up, Enterprise Manager displays the Database Control Login page.

   If the database is down and needs to be re-started, Enterprise Manager displays the Startup/Shutdown and Perform Recovery page. If this is the case, click Startup/Shutdown. You are then prompted for the host and target database login usernames and passwords, which you must enter. For the database user and password, use SYS and the password you specified during installation.

   Click OK to start the database. In the Confirmation screen, click YES to start the database in open mode.

2. Log in to the database using a username that is authorized to access the Database Control. This initially could be SYS or SYSTEM . Use the password you specified for the account during the database installation.

   Enterprise Manager displays the Database Home page:

   
   

The property pages across the top of the page enable you to access performance, administration, and maintenance pages for managing your database. The functionality provided by these pages is discussed in other chapters of this book.

The various sections of the Database Home page, and related links, provide a wealth of information about the database's environment and health. For example, the Alerts , Related Alerts , and Performance Analysis sections warn you of errors and performance problems that are impacting the operation of your database. You can click the provided links to see more detail about the problem area, and even to obtain recommendations for resolving the problem.

Please click here to go to Oracle's web site to learn more details on Oracle Enterprise Manager.