Showing posts with label EM. Show all posts
Showing posts with label EM. Show all posts

9 April 2014

How to configure Enterprise Manager in 11gR2 Database

 Steps to configure Enterprise Manager in 11gR2

[oracle@dev1 bin]$ export ORACLE_HOME=/u01/app/oracle/product/11.3.0
[oracle@dev1 bin]$ export ORACLE_SID=PROD
[oracle@dev1 bin]$ cd $ORACLE_HOME/bin
[oracle@dev1 bin]$

De-register database from emconsole repository

[oracle@dev1 bin]$ ./emca -deconfig dbcontrol db -repos drop

STARTED EMCA at Apr 9, 2014 11:47:46 AM
EM Configuration Assistant, Version 11.2.0.3.0 Production
Copyright (c) 2003, 2011, Oracle.  All rights reserved.

Enter the following information:
Database SID: PROD
Listener port number: 1521
Password for SYS user:
Password for SYSMAN 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
Apr 9, 2014 11:48:00 AM oracle.sysman.emcp.EMConfig perform
INFO: This operation is being logged at /u01/app/oracle/cfgtoollogs/emca/PROD/emca_2014_04_09_11_47_46.log.
Apr 9, 2014 11:48:00 AM 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
Apr 9, 2014 11:48:00 AM oracle.sysman.emcp.EMReposConfig invoke
INFO: Dropping the EM repository (this may take a while) ...
Apr 9, 2014 11:49:57 AM oracle.sysman.emcp.EMReposConfig invoke
INFO: Repository successfully dropped
Enterprise Manager configuration completed successfully
FINISHED EMCA at Apr 9, 2014 11:49:57 AM
[oracle@dev1 bin]$

Register database from emconsole repository

[oracle@dev1 bin]$ ./emca -config dbcontrol db -repos create

STARTED EMCA at Apr 9, 2014 11:50:32 AM
EM Configuration Assistant, Version 11.2.0.3.0 Production
Copyright (c) 2003, 2011, Oracle.  All rights reserved.

Enter the following information:
Database SID: PROD
Listener port number: 1521
Listener ORACLE_HOME [ /u01/app/oracle/product/11.3.0 ]:
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.3.0

Local hostname ................ dev1.localdomain.com
Listener ORACLE_HOME ................ /u01/app/oracle/product/11.3.0
Listener port number ................ 1521
Database SID ................ PROD
Email address for notifications ...............
Outgoing Mail (SMTP) server for notifications ...............

-----------------------------------------------------------------
Do you wish to continue? [yes(Y)/no(N)]: Y
Apr 9, 2014 11:51:24 AM oracle.sysman.emcp.EMConfig perform
INFO: This operation is being logged at /u01/app/oracle/cfgtoollogs/emca/PROD/emca_2014_04_09_11_50_31.log.
Apr 9, 2014 11:51:25 AM oracle.sysman.emcp.EMReposConfig createRepository
INFO: Creating the EM repository (this may take a while) ...
Apr 9, 2014 11:59:04 AM oracle.sysman.emcp.EMReposConfig invoke
INFO: Repository successfully created
Apr 9, 2014 11:59:27 AM oracle.sysman.emcp.EMReposConfig uploadConfigDataToRepository
INFO: Uploading configuration data to EM repository (this may take a while) ...
Apr 9, 2014 12:00:49 PM oracle.sysman.emcp.EMReposConfig invoke
INFO: Uploaded configuration data successfully
Apr 9, 2014 12:00:58 PM oracle.sysman.emcp.util.DBControlUtil secureDBConsole
INFO: Securing Database Control (this may take a while) ...
Apr 9, 2014 12:01:09 PM oracle.sysman.emcp.util.DBControlUtil secureDBConsole
INFO: Database Control secured successfully.
Apr 9, 2014 12:01:09 PM oracle.sysman.emcp.util.DBControlUtil startOMS
INFO: Starting Database Control (this may take a while) ...
Apr 9, 2014 12:02:21 PM oracle.sysman.emcp.EMDBPostConfig performConfiguration
INFO: Database Control started successfully
Apr 9, 2014 12:02:21 PM oracle.sysman.emcp.EMDBPostConfig performConfiguration
INFO: >>>>>>>>>>> The Database Control URL is https://dev1.localdomain.com:5500/em <<<<<<<<<<<
Apr 9, 2014 12:02:23 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.3.0/dev1.localdomain.com_PROD/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 Apr 9, 2014 12:02:24 PM
[oracle@dev1 bin]$