Setup Enterprise Manager on Oracle Database
- Prepare user SYSMAN password (or reset password)
alter user SYSMAN IDENTIFIED BY xxxxx - Prepare user DBSNMP password (or reset password)
alter user DBSNMP IDENTIFIED BY xxxxxxx - Prepare user SYSMAN password (or create a user if not exist)
- set environment ORACLE_UNQNAME
- run emca recreate configuration
oracle@db01 ~]$ emca -config dbcontrol db -repos recreate
STARTED EMCA at Apr 17, 2013 3:25:19 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: mydb1
Listener port number: 1521
Listener ORACLE_HOME [ /u01/app/oracle/product/11.2.0/dbhome_1 ]:
Password for SYS user:
Password for DBSNMP user:
Password for SYSMAN user:
Email address for notifications (optional): myemail@domain.com
Outgoing Mail (SMTP) server for notifications (optional): mysmtp.domain.com
ASM ORACLE_HOME [ /u01/app/oracle/product/11.2.0/dbhome_1 ]: /u01/app/11.2.0/grid
ASM SID [ +ASM ]:
ASM port [ 1521 ]:
ASM username [ ASMSNMP ]:
ASM user password:
ASM user password:
-----------------------------------------------------------------
You have specified the following settings
Database ORACLE_HOME ................ /u01/app/oracle/product/11.2.0/dbhome_1
Local hostname ................ db01.mydomain.com
Listener ORACLE_HOME ................ /u01/app/oracle/product/11.2.0/dbhome_1
Listener port number ................ 1521
Database SID ................ mydb1
Email address for notifications ............... myemail@domain.com
Outgoing Mail (SMTP) server for notifications ............... mysmtp.domain.com
ASM ORACLE_HOME ................ /u01/app/11.2.0/grid
ASM SID ................ +ASM
ASM port ................ 1521
ASM user role ................ SYSDBA
ASM username ................ ASMSNMP
-----------------------------------------------------------------
----------------------------------------------------------------------
WARNING : While repository is dropped the database will be put in quiesce mode.
----------------------------------------------------------------------
Do you wish to continue? [yes(Y)/no(N)]: y
Apr 17, 2013 3:29:47 PM oracle.sysman.emcp.EMConfig perform
INFO: This operation is being logged at /u01/app/oracle/cfgtoollogs/emca/cctxt/emca_2013_04_17_15_25_19.log.
Apr 17, 2013 3:29:49 PM oracle.sysman.emcp.EMReposConfig invoke
INFO: Dropping the EM repository (this may take a while) ...
Apr 17, 2013 3:29:50 PM oracle.sysman.emcp.EMReposConfig invoke
INFO: Repository successfully dropped
Apr 17, 2013 3:29:50 PM oracle.sysman.emcp.EMReposConfig createRepository
INFO: Creating the EM repository (this may take a while) ...
Apr 17, 2013 3:34:30 PM oracle.sysman.emcp.EMReposConfig invoke
INFO: Repository successfully created
Apr 17, 2013 3:34:33 PM oracle.sysman.emcp.EMReposConfig uploadConfigDataToRepository
INFO: Uploading configuration data to EM repository (this may take a while) ...
Apr 17, 2013 3:35:06 PM oracle.sysman.emcp.EMReposConfig invoke
INFO: Uploaded configuration data successfully
Apr 17, 2013 3:35:06 PM oracle.sysman.emcp.ParamsManager getLocalListener
WARNING: Error retrieving listener for db01.mydomain.com
Apr 17, 2013 3:35:08 PM oracle.sysman.emcp.util.DBControlUtil secureDBConsole
INFO: Securing Database Control (this may take a while) ...
Apr 17, 2013 3:36:59 PM oracle.sysman.emcp.util.DBControlUtil secureDBConsole
INFO: Database Control secured successfully.
Apr 17, 2013 3:36:59 PM oracle.sysman.emcp.util.DBControlUtil startOMS
INFO: Starting Database Control (this may take a while) ...
Apr 17, 2013 3:37:17 PM oracle.sysman.emcp.EMDBPostConfig performConfiguration
INFO: Database Control started successfully
Apr 17, 2013 3:37:17 PM oracle.sysman.emcp.EMDBPostConfig performConfiguration
INFO: >>>>>>>>>>> The Database Control URL is https://db01.domain.com:5509/em <<<<<<<<<<<
Apr 17, 2013 3:37:19 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/dbhome_1/db01_mydb/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 17, 2013 3:37:19 PM
Comments