Table of Contents

OEM DBconsole Manually

This tutorial is from oracle 11g, and we are going to learn how to configure OEM dbconsole manually on the Linux platform. If you have previously configured the OEM console but it is not working then we need to drop the existing configuration and recreate the OEM repository, start configuration using the below steps. The sysman is the owner of the OEM repository.

How to drop oracle database manually

Drop existing dbcontrol configuration

Step 1. Check and drop the existing OEM dbconsole repository if exist.

SQL> Select username from dba_users where username='SYSMAN';

USERNAME
------------------------------
SYSMAN

The sysman user exists now drop the repository.

$ emca -deconfig dbcontrol db -repos drop

STARTED EMCA at May 27, 2021 7:25:03 PM
EM Configuration Assistant, Version 11.2.0.3.0 Production
Copyright (c) 2003, 2011, Oracle.  All rights reserved.

Enter the following information:
Database SID: gaming
Listener port number: 1521
Password for SYS user:  
Password for SYSMAN user:  

----------------------------------------------------------------------
WARNING : While repository is dropped the database will be put in quiesce mode.
----------------------------------------------------------------------
Do you wish to continue? [yes(Y)/no(N)]: Y
May 27, 2021 7:25:19 PM oracle.sysman.emcp.EMConfig perform
INFO: This operation is being logged at /u01/app/oracle/cfgtoollogs/emca/frtgame/emca_2021_05_27_19_25_03.log.
May 27, 2021 7:25:19 PM oracle.sysman.emcp.EMDBPreConfig performDeconfiguration
WARNING: EM is not configured for this database. No EM-specific actions can be performed. Some of the possible reasons may be: 
 1) EM is configured with different hostname then physical host. Set environment variable ORACLE_HOSTNAME=<hostname> and re-run EMCA script 
 2) ORACLE_HOSTNAME is set. Unset it and re-run EMCA script
May 27, 2021 7:25:19 PM oracle.sysman.emcp.EMReposConfig invoke
INFO: Dropping the EM repository (this may take a while) ...
May 27, 2021 7:26:40 PM oracle.sysman.emcp.EMReposConfig invoke
INFO: Repository successfully dropped
Enterprise Manager configuration completed successfully
FINISHED EMCA at May 27, 2021 7:26:40 PM

How to create the new OEM repository

Step 2. Create OEM dbconsole manually.

$ emca -repos create

STARTED EMCA at May 27, 2021 7:28:58 PM
EM Configuration Assistant, Version 11.2.0.3.0 Production
Copyright (c) 2003, 2011, Oracle.  All rights reserved.

Enter the following information:
Database SID: gaming
Listener port number: 1521
Password for SYS user:  
Password for SYSMAN user:  

Do you wish to continue? [yes(Y)/no(N)]: Y
May 27, 2021 7:29:13 PM oracle.sysman.emcp.EMConfig perform
INFO: This operation is being logged at /u01/app/oracle/cfgtoollogs/emca/frtgame/emca_2021_05_27_19_28_57.log.
May 27, 2021 7:29:13 PM oracle.sysman.emcp.EMReposConfig createRepository
INFO: Creating the EM repository (this may take a while) ...
May 27, 2021 7:32:27 PM oracle.sysman.emcp.EMReposConfig invoke
INFO: Repository successfully created
Enterprise Manager configuration completed successfully
FINISHED EMCA at May 27, 2021 7:32:27 PM

Now our dbconsole repository has been created successfully. Now we need to configure DB Control for the repository.

Configure Oracle EM db control

Step 3. Configure DB control for the EM repository.

$ emca -config dbcontrol db

STARTED EMCA at May 27, 2021 7:35:08 PM
EM Configuration Assistant, Version 11.2.0.3.0 Production
Copyright (c) 2003, 2011, Oracle.  All rights reserved.

Enter the following information:
Database SID: gaming
Listener port number: 1521
Listener ORACLE_HOME [ /u01/app/oracle/product/11.2.0.4/db_1 ]: 
Password for SYS user:  
Password for DBSNMP user:  
Password for SYSMAN user:  
Email address for notifications (optional): 
Outgoing Mail (SMTP) server for notifications (optional): 
-----------------------------------------------------------------

You have specified the following settings

Database ORACLE_HOME ................ /u01/app/oracle/product/11.2.0.4/db_1

Local hostname ................ rhel6.localdomain
Listener ORACLE_HOME ................ /u01/app/oracle/product/11.2.0.4/db_1
Listener port number ................ 1521
Database SID ................ gaming
Email address for notifications ............... 
Outgoing Mail (SMTP) server for notifications ............... 

-----------------------------------------------------------------
Do you wish to continue? [yes(Y)/no(N)]: Y
May 27, 2021 7:35:34 PM oracle.sysman.emcp.EMConfig perform
INFO: This operation is being logged at /u01/app/oracle/cfgtoollogs/emca/frtgame/emca_2021_05_27_19_35_08.log.
May 27, 2021 7:35:37 PM oracle.sysman.emcp.EMReposConfig uploadConfigDataToRepository
INFO: Uploading configuration data to EM repository (this may take a while) ...
May 27, 2021 7:36:21 PM oracle.sysman.emcp.EMReposConfig invoke
INFO: Uploaded configuration data successfully
May 27, 2021 7:36:26 PM oracle.sysman.emcp.util.DBControlUtil secureDBConsole
INFO: Securing Database Control (this may take a while) ...
May 27, 2021 7:37:15 PM oracle.sysman.emcp.util.DBControlUtil secureDBConsole
INFO: Database Control secured successfully.
May 27, 2021 7:37:15 PM oracle.sysman.emcp.util.DBControlUtil startOMS
INFO: Starting Database Control (this may take a while) ...
May 27, 2021 7:38:06 PM oracle.sysman.emcp.EMDBPostConfig performConfiguration
INFO: Database Control started successfully
May 27, 2021 7:38:06 PM oracle.sysman.emcp.EMDBPostConfig performConfiguration
INFO: >>>>>>>>>>> The Database Control URL is https://rhel6.localdomain:1158/em <<<<<<<<<<<
May 27, 2021 7:38:14 PM oracle.sysman.emcp.EMDBPostConfig invoke
WARNING: 
************************  WARNING  ************************

Management Repository has been placed in secure mode wherein Enterprise Manager data will be encrypted.  The encryption key has been placed in the file: /u01/app/oracle/product/11.2.0.4/db_1/rhel6.localdomain_frtgame/sysman/config/emkey.ora. Ensure this file is backed up as the encrypted data will become unusable if this file is lost. 

***********************************************************
Enterprise Manager configuration completed successfully
FINISHED EMCA at May 27, 2021 7:38:14 PM

The OEM DBconsole repository configuration has been completed successfully.

Check the status of EMConsole

Check the status of the EM repository.

$ emctl status dbconsole

Oracle Enterprise Manager 11g Database Control Release 11.2.0.3.0 
Copyright (c) 1996, 2011 Oracle Corporation.  All rights reserved.
https://rhel6.localdomain:1158/em/console/aboutApplication
Oracle Enterprise Manager 11g is running. 
------------------------------------------------------------------
Logs are generated in directory /u01/app/oracle/product/11.2.0.4/db_1/rhel6.localdomain_frtgame/sysman/log

After login into the EM Console, you will see the first screen, click on the database to see EM console features.

On the next screen you will see all the features of EM Console:

How to stop EM Console

$emctl stop dbconsole

How to start EM Console

$emctl start dbconsole

I hope you found this article very helpful, write your fillings in the comment box.

Chat with me on:

How to Configure OEM DBconsole Manually