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:
- Ensure your listener properly configured and started.
- Ensure environment variable properly set.
- Ensure password file is created. (Optional)
- 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/
Select Configure Database Option and continue.
Select Database Instance and continue, In my case I have only ORCL database installed.
Select Configure Enterprise Manager check box and continue.
Provide SYS user credential and continue.
Configuration has completed successfully. Ensure your Database Control URL mentioned in snap shot, In my case its: https://prod.localdomain:5500/em.
To access your Enterprise Manager, Browse URL: https://localhost.localdomain:5500/em, like below and Confirm security Exception.
Provide Login credentials of SYS users to access EM for ORCL instance.
Enterprise Manager Instance Dashbord for ORCL.
Cheers!! Enterprise Manager configured Successfully.
Stay Tune. 🙂