How to Configure Oracle Enterprise manager (OEM) in Oracle 10g
Oracle Enterprise manager is important GUI tool to monitor , administrate the Oracle database
How to Configure Oracle Enterprise manager (OEM) in Oracle 10g
you will following options in oracle 10 g:
Step 1 )
go to your DB server
XXXX:oracle 7> emca -config dbcontrol db -repos create
this command will create and configure repository for dbconstrol
in background it will craete synonyms, roles for sysman users
You need to know the SID of database , port on which LISTNER for database in running. for that go to LSNRCTL and look for serrvices and status
STARTED EMCA at Jul 6, 2010 12:33:45 PM
EM Configuration Assistant, Version 10.2.0.1.0 Production
Copyright (c) 2003, 2005, Oracle. All rights reserved.
Enter the following information:
Database SID:
Listener port number: 1527
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 ................ /oracle/BIP/102_64
Database hostname ................ krbep21.kr.com
Listener port number ................ 1527
Database SID ................ BIP
Email address for notifications ...............
Outgoing Mail (SMTP) server for notifications ...............
-----------------------------------------------------------------
Do you wish to continue? [yes(Y)/no(N)]: y
Jul 6, 2010 12:34:52 PM oracle.sysman.emcp.EMConfig perform
INFO: This operation is being logged at /oracle/BIP/102_64/cfgtoollogs/emca/BIP/emca_2010-07-06_12-33-45-PM.log.
All logs are wtitten here
Jul 6, 2010 12:34:53 PM oracle.sysman.emcp.EMReposConfig createRepository
INFO: Creating the EM repository (this may take a while) ...
from here it will actually start creating repository
Jul 6, 2010 12:37:05 PM oracle.sysman.emcp.EMReposConfig invoke
INFO: Repository successfully created
here repository creation cimplted..
Jul 6, 2010 12:37:09 PM oracle.sysman.emcp.util.DBControlUtil secureDBConsole
INFO: Securing Database Control (this may take a while) ...
Jul 6, 2010 12:38:20 PM oracle.sysman.emcp.util.DBControlUtil secureDBConsole
INFO: Database Control secured successfully.
Jul 6, 2010 12:38:20 PM oracle.sysman.emcp.util.DBControlUtil startOMS
INFO: Starting Database Control (this may take a while) ...
Jul 6, 2010 12:39:58 PM oracle.sysman.emcp.EMDBPostConfig performConfiguration
INFO: Database Control started successfully
db control started
Jul 6, 2010 12:39:58 PM oracle.sysman.emcp.EMDBPostConfig performConfiguration
INFO: >>>>>>>>>>> The Database Control URL is https://krbep21.kr.com:1158/em <<<<<<<<<<<
Enterprise Manager configuration completed successfully
FINISHED EMCA at Jul 6, 2010 12:39:58 PM
XXXXX:oracle >
courtesy : http://linux-oracle-dba.blogspot.com/2010/07/how-to-configure-oracle-enterprise.html
Reference: http://linux-oracle-dba.blogspot.com/2010/07/how-to-configure-oracle-enterprise.html