This article explains how to configure Enterprise Manager database control using database configuration assistant (DBCA) and manual methods.
Enterprise Manager, first introduced in 9i is Oracle’s single, integrated solution for managing databases. With Enterprise manager grid control introduced in 11g, all aspects of the Oracle Grid and the applications running on it can be managed using graphical interface. Enterprise Manager also allows you to manage single instances of Oracle Databases. Combining a graphical console, Oracle Management Servers, Oracle Intelligent Agents, common services, and administrative tools, Oracle Enterprise Manager provides a comprehensive systems management platform for managing Oracle products. The Oracle Enterprise manager can be configured in two ways, while creating a database using database configuration (DBCA) or after database creation using Enterprise manager Configuration Assistant (EMCA).
Let us see each method in detail.
(i) Configuring using DBCA:
Start the database configuration assistant and at the “Enterprise manager” screen, make sure the check box is ticked as shown below, and click next.
If you encounter an error like shown in the picture above, configure a listener using the net configuration assistant (NETCA) as it is mandatory to have a listener set up before configuring the Enterprise manager and click next.
In the following screen you will be asked to enter password for the user accounts SYS, SYSTEM, DBSNMP, SYSMAN. You can give different passwords to each administrative account or give same password to all the accounts as shown in the picture below and click next to continue.
- Proceed with the options of your choice for database creation and when the summary page shows up, make sure “Enterprise Manager Repository” value is set to true under “Database Components” section and click finish.
- After the database creation is complete, an URL to access the EM is shown as below.
- Open the web browser and enter the URL in the above picture and login using the credentials you set during the setup process. After logging in, the Enterprise manager screen should look like below.
This completes creation of Enterprise Manager database control using DBCA.
(ii) Configuring Manually:
- Firstly we have to remove the above configuration to reconfigure manually using enterprise manager configuration assistant (EMCA). This can be done using the command.
When prompted, enter SID (name of your instance), PORT you used when creating a listene using NETCA and password of SYS and SYSMAN user accounts and press Y to complete the de configuration of Enterprise manager.
After completely removing the enterprise manager configuration, connect to SQL*PLUS client and ensure the database is started. Then unlock and set a new password of the administrative account “DBSNMP” as shown in the below picture, which will be used for configuring Enterprise Manager.
Now create a listener by adding the following lines to “listener.ora” file in “$ORACLE_HOME/network/admin” directory. And start the listener using,
$ lsnrctl start dev
- Create a password file for the instance in “$ORACLE_HOME/dbs” location using the command shown in the picture.
- Create the OEM GRID repository as shown in the picture below and when prompted, enter SID, PORT number you used while creating, and passwords for “SYS” and “SYSMAN” user accounts.
- Configure EM Grid control using following command. Enter SID, PORT number, ORACLE_HOME path, passwords for SYS, DBSNMP, SYSMAN user accounts when prompted.
- Once the configuration completes you will see the following message which displays the URL using which you can access Enterprise Manager and login using the credentials you created.