Manually Configure Oracle 11gR2 Enterprise Manager Database Control

Prerequisite

·         Create password file

                     $orapwd file=orapwTEST password=Oraclesoft1234 ignorecase=y

·         Change password for below users

SQL>alter user DBSNMP identified by Oraclesoft1234;

SQL>alter user SYSMAN identified by Oraclesoft1234;

$emca -deconfig dbcontrol db -repos drop

STARTED EMCA at Dec 10, 2011 11:45:23 PM
EM Configuration Assistant, Version 11.2.0.0.2 Production
Copyright (c) 2003, 2005, Oracle.  All rights reserved.
Enter the following information:
Database SID: TESTDB
Listener port number: 1521
Password for SYS user:*******
Password for SYSMAN user:********
Password for SYSMAN user:********
Do you wish to continue? [yes(Y)/no(N)]: y
Dec 10, 2011 11:45:58 PM oracle.sysman.emcp.EMConfig perform
INFO: This operation is being logged at C:\app\RAJKUMAR\cfgtoollogs\emca\TESTDB\emca_2011_12_10_23_45_22.log.
Dec 10, 2011 11:45:59 PM oracle.sysman.emcp.util.DBControlUtil stopOMS
INFO: Stopping Database Control (this may take a while) ...
Dec 10, 2011 11:46:08 PM oracle.sysman.emcp.ParamsManager checkListenerStatusForDBControl
WARNING: Error initializing SQL connection. SQL operations cannot be performed
Dec 10, 2011 11:46:08 PM oracle.sysman.emcp.EMReposConfig invoke
INFO: Dropping the EM repository (this may take a while) ...
Dec 10, 2011 11:49:29 PM oracle.sysman.emcp.EMReposConfig invoke
INFO: Repository successfully dropped
Enterprise Manager configuration completed successfully
FINISHED EMCA at Dec 10, 2011 11:49:39 PM

$ emca -repos create
STARTED EMCA at Dec 10, 2011 11:50:48 PM
EM Configuration Assistant, Version 11.2.0.0.2 Production
Copyright (c) 2003, 2005, Oracle.  All rights reserved.
Enter the following information:
Database SID: TESTDB
Listener port number: 1521
Password for SYS user:
Password for SYSMAN user: *******
Password for SYSMAN user:********
Do you wish to continue? [yes(Y)/no(N)]: y
Dec 10, 2011 11:51:08 PM oracle.sysman.emcp.EMConfig perform
INFO: This operation is being logged at C:\app\RAJKUMAR\cfgtoollogs\emca\TESTDB\emca_2011_12_10_23_50_48.log.
Dec 10, 2011 11:51:08 PM oracle.sysman.emcp.EMReposConfig createRepository
INFO: Creating the EM repository (this may take a while) ...
Dec 11, 2011 12:00:57 AM oracle.sysman.emcp.EMReposConfig invoke
INFO: Repository successfully created
Enterprise Manager configuration completed successfully
FINISHED EMCA at Dec 11, 2011 12:00:57 AM


$emca -config dbcontrol db
STARTED EMCA at Dec 11, 2011 12:06:01 AM
EM Configuration Assistant, Version 11.2.0.0.2 Production
Copyright (c) 2003, 2005, Oracle.  All rights reserved.
Enter the following information:
Database SID: TESTDB
Listener port number: 1521
Listener ORACLE_HOME [ C:\app\RAJKUMAR\product\11.2.0\dbhome_1 ]:
Password for SYS user:******
Password for DBSNMP user:******
Password for SYSMAN 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 ................ C:\app\RAJKUMAR\product\11.2.0\dbhome_1
Local hostname ................ RAJKUMAR
Listener ORACLE_HOME ................ C:\app\RAJKUMAR\product\11.2.0\dbhome_1
Listener port number ................ 1521
Database SID ................ TESTDB
Email address for notifications ...............
Outgoing Mail (SMTP) server for notifications ...............
-----------------------------------------------------------------
Do you wish to continue? [yes(Y)/no(N)]: y
Dec 11, 2011 12:06:43 AM oracle.sysman.emcp.EMConfig perform
INFO: This operation is being logged at C:\app\RAJKUMAR\cfgtoollogs\emca\TESTDB\emca_2011_12_11_00_06_01.log.
Dec 11, 2011 12:07:01 AM oracle.sysman.emcp.EMReposConfig uploadConfigDataToRepository
INFO: Uploading configuration data to EM repository (this may take a while) ...
Dec 11, 2011 12:08:44 AM oracle.sysman.emcp.EMReposConfig invoke
INFO: Uploaded configuration data successfully
Dec 11, 2011 12:09:08 AM oracle.sysman.emcp.util.DBControlUtil configureSoftwareLib
INFO: Software library configured successfully.
Dec 11, 2011 12:09:08 AM oracle.sysman.emcp.EMDBPostConfig configureSoftwareLibrary
INFO: Deploying Provisioning archives ...
Dec 11, 2011 12:10:23 AM oracle.sysman.emcp.EMDBPostConfig configureSoftwareLibrary
INFO: Provisioning archives deployed successfully.
Dec 11, 2011 12:10:23 AM oracle.sysman.emcp.util.DBControlUtil secureDBConsole
INFO: Securing Database Control (this may take a while) ...
Dec 11, 2011 12:10:52 AM oracle.sysman.emcp.util.DBControlUtil secureDBConsole
INFO: Database Control secured successfully.
Dec 11, 2011 12:10:52 AM oracle.sysman.emcp.util.DBControlUtil startOMS
INFO: Starting Database Control (this may take a while) ...
Dec 11, 2011 12:12:38 AM oracle.sysman.emcp.EMDBPostConfig performConfiguration
INFO: Database Control started successfully
Dec 11, 2011 12:12:39 AM oracle.sysman.emcp.EMDBPostConfig performConfiguration
INFO: >>>>>>>>>>> The Database Control URL is https://loracledb.localhost:1158/em <<<<<<<<<<<
Dec 11, 2011 12:12:43 AM 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: C:/app/
RAJKUMAR/product/11.2.0/dbhome_1/RAJKUMAR_TESTDB/sysman/config/emkey.ora.   Please ensure this file is backed up as the encrypted data will become unusabl
e if this file is lost.
***********************************************************
Enterprise Manager configuration completed successfully
FINISHED EMCA at Dec 11, 2011 12:12:44 AM

dbconsole administration command

 

  $emctl start dbconsole

  $emctl stop dbconsole

  $emctl status dbconsole