Step
1. set oracle_sid=[sid]
2. go to %ORACLE_HOME%/bin directory
3. execute EMCA executable on commandline with the following options
cmd>emca -config dbcontrol db -repos create
NOTE: before execute above statement make sure SQLNET.AUTHENTICATION_SERVICES = (NTS) set in the SQLNET.ORA file.
SQLNET.ORA file located in %ORACLE_HOME%/network/admin directory.
& You must drop the DB control repository objects.
D:\app\Administrator\11.2.0\db\BIN>set oracle_sid=fakpropr
D:\app\Administrator\11.2.0\db\BIN>emca -config dbcontrol db -repos create
STARTED EMCA at Sep 10, 2011 1:48:38 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: fakpropr
Listener port number: 1521
Listener ORACLE_HOME [ D:\app\Administrator\11.2.0\db ]:
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 ................ D:\app\Administrator\11.2.0\db
Local hostname ................ fakproora.dummy.local
Listener ORACLE_HOME ................ D:\app\Administrator\11.2.0\db
Listener port number ................ 1521
Database SID ................ fakpropr
Email address for notifications ...............
Outgoing Mail (SMTP) server for notifications ...............
-----------------------------------------------------------------
Do you wish to continue? [yes(Y)/no(N)]: Y
Sep 10, 2011 1:49:07 PM oracle.sysman.emcp.EMConfig perform
INFO: This operation is being logged at D:\app\Administrator\cfgtoollogs\emca\fa
kpropr\emca_2011_09_10_13_48_37.log.
Sep 10, 2011 1:49:09 PM oracle.sysman.emcp.EMReposConfig createRepository
INFO: Creating the EM repository (this may take a while) ...
Sep 10, 2011 2:03:43 PM oracle.sysman.emcp.EMReposConfig invoke
INFO: Repository successfully created
Sep 10, 2011 2:03:52 PM oracle.sysman.emcp.EMReposConfig uploadConfigDataToRepos
itory
INFO: Uploading configuration data to EM repository (this may take a while) ...
Sep 10, 2011 2:05:45 PM oracle.sysman.emcp.EMReposConfig invoke
INFO: Uploaded configuration data successfully
Sep 10, 2011 2:05:46 PM oracle.sysman.emcp.ParamsManager getLocalListener
WARNING: Error retrieving listener for fakproora.dummy.local
Sep 10, 2011 2:05:50 PM oracle.sysman.emcp.util.DBControlUtil secureDBConsole
INFO: Securing Database Control (this may take a while) ...
Sep 10, 2011 2:06:02 PM oracle.sysman.emcp.util.DBControlUtil secureDBConsole
INFO: Database Control secured successfully.
Sep 10, 2011 2:06:02 PM oracle.sysman.emcp.util.DBControlUtil startOMS
INFO: Starting Database Control (this may take a while) ...
Sep 10, 2011 2:07:48 PM oracle.sysman.emcp.EMDBPostConfig performConfiguration
INFO: Database Control started successfully
Sep 10, 2011 2:07:48 PM oracle.sysman.emcp.EMDBPostConfig performConfiguration
INFO: >>>>>>>>>>> The Database Control URL is https://fakproora.dummy.local
:1158/em <<<<<<<<<<<
Sep 10, 2011 2:07:52 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: D:/app/
Administrator/11.2.0/db/fakproora.dummy.local_fakpropr/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 Sep 10, 2011 2:07:52 PM
No comments:
Post a Comment