Moneycontrol Brokerage Recos

Sunday, December 11, 2011

Manually Configure Oracle 11gR2 Enterprise Manager Database Control

Here I have outlined the steps to configure Oracle 11g R2 OEM manually:

C:\>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
C:\>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:  s
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


C:\>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:
Invalid username/password.
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://RAJKUMAR: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

Hope it would help someone....

2 comments:

  1. Very good steps : I had changed hostname and oem was not workin. Followed the above step and created
    new configuration. It is now working fine.
    Thanks.

    ReplyDelete