Lesson 1

As an Oracle Database Administrator (DBA) using Oracle 12c, accessing the Enterprise Manager (EM) Console via a browser involves a straightforward process. The Oracle Enterprise Manager is a web-based tool providing a comprehensive management solution for Oracle databases, middleware, and hardware. To access the EM Console from a browser, follow these steps:

1. Ensure the EM Console is Configured and Running:
   • Before attempting to access the Enterprise Manager, confirm that it is properly configured and running on your Oracle server.
   • Use the command-line interface on the server to check the status of the Oracle Enterprise Manager service. You can typically do this using the `emctl status dbconsole` command (for the Database Control) or `emctl status oms` command (for Cloud Control).
2. Obtain the Access URL:
   • Upon successful configuration and startup, the Enterprise Manager Console provides a URL for web access.
   • This URL typically looks like `https://hostname:port/em`, where `hostname` is the name of your Oracle server, and `port` is the specific port number on which the Enterprise Manager is listening (default is usually 5500 for newer versions).
3. Access from a Web Browser:
   • Open your preferred web browser on a machine that has network access to the Oracle server.
   • Enter the URL provided by the Enterprise Manager in the address bar of your browser.
   • Note that the Enterprise Manager Console uses HTTPS for secure communication, so ensure that your browser can accept the Oracle server's security certificate. If it's a self-signed certificate, you may have to add an exception in your browser.
4. Log In:
   • Once the Enterprise Manager page loads, you will be prompted to log in.
   • Use your Oracle database credentials to log in. This would typically be the credentials of a user with DBA privileges or a specifically designated Enterprise Manager administrative account.
5. Navigate the EM Console:
   • After logging in, you will be presented with the Enterprise Manager dashboard.
   • From here, you can avigate to various sections of the console to monitor the database, check performance, manage users, and perform other administrative tasks.
6. Troubleshoot Connection Issues:
   • If you are unable to access the EM Console, check for common issues like network connectivity, firewall configurations, and ensure that the Enterprise Manager service is running on the server.
   • Additionally, confirm that the port number is correct and the server is reachable from your browser's location.

It’s crucial to maintain proper security practices when using the Enterprise Manager Console, especially since it provides comprehensive control over your Oracle environment. Always ensure secure connections and restrict access to authorized personnel only. Regularly updating and patching the Oracle software also helps in maintaining a secure and efficient management environment.

The Enterprise Manager console has been improved and enhanced so that you can run it from the Web and so that you can easily create and monitor remote databases. You can set up the console to send you an email or call your pager when something happens to the database. In this module, you will learn how to set up the console to run from the Web, monitor the database, and notify you of database changes via email.

By the end of the module you will be able to:

1. Set up a Web-based Enterprise Manager console
2. Create a user for running batch jobs for the Enterprise Manager
3. Configure Management Server to use a specified user for its batch jobs and email
4. Create an event to monitor the database

Once you become familiar with the console, you will think of lots of important tasks that it can handle for you in your role as Database Administrator (DBA).
The next lesson teaches you how to configure and run the console on the Web.