Below is the procedure to configure Oracle 10g Enterprise Manager Database Control manually without Database Configuration Assistant.
Using EM database control,you can monitor and administer single database.
The Database Control Framework consists of the Database Control and its underlying technologies:
* A local Oracle Management Repository installed in the local database and designed to store management data for the Database Control.
* A local version of the Oracle Management Service designed to work with the local database or clustered database.
Steps to configure Oracle 10g Enterprise Manager Database Control
1.Ensure that you can connect to the Repository Database. Test it with SQL*Plus or TNSPING Utility.
#> tnsping TESTDB
TNS Ping Utility for Linux: Version 10.2.0.3.0 - Production on 23-FEB-2012 22:13:41
Copyright (c) 1997, 2006, Oracle. All rights reserved.
Used parameter files:
/spl/intbase/DB/oracletns/sqlnet.ora
Used TNSNAMES adapter to resolve the alias
Attempting to contact (DESCRIPTION = (ADDRESS = (PROTOCOL = TCP)(HOST = sf-lindb-10)(PORT = 1521)) (CONNECT_DATA = (SID = TESTDB)))
OK (50 msec)
= TESTDB Shared DB server = oracle@testdb.sangam.com /orasw/app/oracle/product/10.2.0.3/bin
#> . oraenv
ORACLE_SID = [TESTDB] ?
The /orasw/app/oracle/product/10.2.0.3/bin/orabase binary does not exist
You can set ORACLE_BASE manually if it is required.
= TESTDB Shared DB server = oracle@testdb.sangam.com /orasw/app/oracle/product/10.2.0.3/bin
#> sqlplus '/as sysdba'
SQL*Plus: Release 10.2.0.3.0 - Production on Thu Feb 23 22:13:32 2012
Copyright (c) 1982, 2006, Oracle. All Rights Reserved.
Connected to:
Oracle Database 10g Enterprise Edition Release 10.2.0.3.0 - 64bit Production
With the Partitioning, OLAP and Data Mining options
SQL> exit
2.Start the Oracle enterprise manager dbconsole Build Script ($ORACLE_HOME/bin/emca for Linux and and $ORACLE_HOME\Bin\emca.bat for Windows).
a.Create EM repository as below.
#> ./emca -repos create
STARTED EMCA at Feb 23, 2012 10:32:43 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: TESTDB
Listener port number: 1521
Password for SYS user:
Password for SYSMAN user:
Do you wish to continue? [yes(Y)/no(N)]: y
Feb 23, 2012 10:33:04 PM oracle.sysman.emcp.EMConfig perform
INFO: This operation is being logged at /orasw/app/oracle/product/10.2.0.3/cfgtoollogs/emca/TESTDB/emca_2012-02-23_10-32-43-PM.log.
Feb 23, 2012 10:33:07 PM oracle.sysman.emcp.EMReposConfig createRepository
INFO: Creating the EM repository (this may take a while) ...
Feb 23, 2012 10:35:20 PM oracle.sysman.emcp.EMReposConfig invoke
INFO: Repository successfully created
Enterprise Manager configuration completed successfully
FINISHED EMCA at Feb 23, 2012 10:35:20 PM
= TESTDB Shared DB server = oracle@testdb.sangam.com /orasw/app/oracle/product/10.2.0.3/bin
b.Configure the db control as below.
#> ./emca -config dbcontrol db
STARTED EMCA at Feb 23, 2012 11:06:17 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: TESTDB
Listener port number: 1521
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 ................ /orasw/app/oracle/product/10.2.0.3
Database hostname ................ testdb.sangam.com
Listener port number ................ 1521
Database SID ................ TESTDB
Email address for notifications ...............
Outgoing Mail (SMTP) server for notifications ...............
-----------------------------------------------------------------
Do you wish to continue? [yes(Y)/no(N)]: y
Feb 23, 2012 11:08:17 PM oracle.sysman.emcp.EMConfig perform
INFO: This operation is being logged at /orasw/app/oracle/product/10.2.0.3/cfgtoollogs/emca/TESTDB/emca_2012-02-23_11-06-16-PM.log.
Feb 23, 2012 11:08:55 PM oracle.sysman.emcp.ParamsManager getLocalListener
WARNING: Error retrieving listener for testdb.sangam.com
Feb 23, 2012 11:11:40 PM oracle.sysman.emcp.util.DBControlUtil startOMS
INFO: Starting Database Control (this may take a while) ...
Feb 23, 2012 11:16:42 PM oracle.sysman.emcp.EMDBPostConfig performConfiguration
INFO: Database Control started successfully
Feb 23, 2012 11:16:43 PM oracle.sysman.emcp.EMDBPostConfig performConfiguration
INFO: >>>>>>>>>>> The Database Control URL is
http://testdb.sangam.com:5510/em <<<<<<<<<<<
Enterprise Manager configuration completed successfully
FINISHED EMCA at Feb 23, 2012 11:16:43 PM
= TESTDB Shared DB server = oracle@testdb.sangam.com /orasw/app/oracle/product/10.2.0.3/bin
3.Try to connect to the database Control using an URL http://testdb.sangam.com:5510/em
Note: If you get any error while creating repository, you may refer my another article at
http://oracledba-sharinganexperience.blogspot.in/2012/02/oracle-10g-em-dbconsole-configuration.html
