Creating Oracle DB Enterprise Manager repository

Note ID: 278100.1

- As the DB files owner run:

[ortest@erpapp02 ~]$ emca -config dbcontrol db -repos create

STARTED EMCA at Apr 3, 2011 9:51:31 AM
EM Configuration Assistant, Version 11.1.0.7.0 Production
Copyright (c) 2003, 2005, Oracle.  All rights reserved.

Enter the following information:
Database SID: TEST
Listener port number: 1521
Password for SYS 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 ................ /Oracle/Test/db/tech_st/11.1.0

Local hostname ................ erpapp02.rsteel.com
Listener port number ................ 1521
Database SID ................ TEST
Email address for notifications ...............
Outgoing Mail (SMTP) server for notifications ...............

-----------------------------------------------------------------
Do you wish to continue? [yes(Y)/no(N)]: y
Apr 3, 2011 9:53:35 AM oracle.sysman.emcp.EMConfig perform
INFO: This operation is being logged at /Oracle/Test/db/tech_st/11.1.0/cfgtoollogs/emca/TEST/emca_2011_04_03_09_51_31.log.
Apr 3, 2011 9:53:37 AM oracle.sysman.emcp.EMReposConfig createRepository
INFO: Creating the EM repository (this may take a while) ...
Apr 3, 2011 10:03:03 AM oracle.sysman.emcp.EMReposConfig invoke
INFO: Repository successfully created
Apr 3, 2011 10:03:07 AM oracle.sysman.emcp.EMReposConfig uploadConfigDataToRepository
INFO: Uploading configuration data to EM repository (this may take a while) ...
Apr 3, 2011 10:04:01 AM oracle.sysman.emcp.EMReposConfig invoke
INFO: Uploaded configuration data successfully
Apr 3, 2011 10:04:05 AM oracle.sysman.emcp.util.DBControlUtil configureSoftwareLib
INFO: Software library configured successfully.
Apr 3, 2011 10:04:05 AM oracle.sysman.emcp.EMDBPostConfig configureSoftwareLibrary
INFO: Deploying Provisioning archives ...
Apr 3, 2011 10:04:16 AM oracle.sysman.emcp.EMDBPostConfig configureSoftwareLibrary
INFO: Provisioning archives deployed successfully.
Apr 3, 2011 10:04:16 AM oracle.sysman.emcp.util.DBControlUtil secureDBConsole
INFO: Securing Database Control (this may take a while) ...
Apr 3, 2011 10:04:39 AM oracle.sysman.emcp.util.DBControlUtil secureDBConsole
INFO: Database Control secured successfully.
Apr 3, 2011 10:04:39 AM oracle.sysman.emcp.util.DBControlUtil startOMS
INFO: Starting Database Control (this may take a while) ...
Apr 3, 2011 10:05:09 AM oracle.sysman.emcp.EMDBPostConfig performConfiguration
INFO: Database Control started successfully
Apr 3, 2011 10:05:09 AM oracle.sysman.emcp.EMDBPostConfig performConfiguration
INFO: >>>>>>>>>>> The Database Control URL is https://erpapp02.rsteel.com:5500/em <<<<<<<<<<<
Apr 3, 2011 10:05:13 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: /Oracle/Test/db/tech_st/11.1.0/erpapp02.alrajhisteel.com_TEST/sysman/config/emkey.ora.   Please 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 3, 2011 10:05:13 AM
[ortest@erpapp02 ~]$

Recreate DB Enterprise Manager Repository :

- This will first drop the existing repository first, ensure you deleted the old EM folder under the $ORACLE_HOME

emca -config dbcontrol db -repos recreate

Drop DB Enterprise Manager Repository :

emca -deconfig dbcontrol db -repos drop

IMPORTANT: Dropping or recreating the EM repository will put the DB in the quiesce mode.

Regards,

Mohamed