How to configure Enterprise Manager with Database Configuration Assistant

This article is about step by step approach to configure EM database control with DBCA.

Where as in earlier article we Configure Enterprise Manager Database Control Manually with Enterprise Manager Configuration Assistant.

Before start configuration:

  1. Ensure your listener properly configured and started.
  2. Ensure environment variable properly set.
  3. Ensure password file is created. (Optional)
  4. Ensure your /etc/hosts file mentioned below two lines.
[oracle@prod ~]$ cat /etc/hosts
127.0.0.1 localhost.localdomain localhost
192.168.17.146 prod.localdomain prod

Set Environment Variable and instantiate DBCA utility as below:

[oracle@prod ~]$ export ORACLE_SID=orcl
[oracle@prod ~]$ export ORACLE_UNQNAME=orcl
[oracle@prod ~]$ export ORACLE_HOME=/home/oracle/app/oracle/product/11.2.0/dbhome_1/
[oracle@prod ~]$ export PATH=$PATH:/home/oracle/app/oracle/product/11.2.0/dbhome_1/bin/
Instantiate Database Configuration Assistant

Instantiate Database Configuration Assistant

Database Configuration Assistant - Welcome

Select Configure Database Option and continue.

DBCA - Configure Database Option

DBCA – Configure Database Option

Select Database Instance and continue, In my case I have only ORCL database installed.

DBCA - Select Database Instance

DBCA – Select Database Instance

Select Configure Enterprise Manager check box and continue.

DBCA - Configure Enterprise Manager

DBCA – Configure Enterprise Manager

DBCA - Database content

DBCA – Database content

Provide SYS user credential and continue.

DBCA - Database Credentials

DBCA – Database Credentials

DBCA - Connection Mode

DBCA – Connection Mode

DBCA - Confirmation

DBCA – Confirmation

DBCA - Progress

DBCA – Progress

Configuration has completed successfully. Ensure your Database Control URL mentioned in snap shot, In my case its: https://prod.localdomain:5500/em.

Database Configuration Assistant - Enterprise Manager

Database Configuration Assistant – Enterprise Manager

To access your Enterprise Manager, Browse URL: https://localhost.localdomain:5500/em, like below and Confirm security Exception.

Enterprise Manager URL - Add Exception to browser

Enterprise Manager URL – Add Exception to browser

Enterprise Manager URL - Confirm Security Exception

Enterprise Manager URL – Confirm Security Exception

Provide Login credentials of SYS users to access EM for ORCL instance.

Enterprise Manager Login

Enterprise Manager Login

Enterprise Manager Instance Dashbord for ORCL.

Enterprise Manager Instance Dashbord

Enterprise Manager Instance Dashbord

Cheers!! Enterprise Manager configured Successfully.

Stay Tune. 🙂

Leave a Reply