Pages

Friday, 24 February 2012

Manually Configure Oracle 10g Enterprise Manager dbconsole



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





2 comments:

  1. Thanks for Information Oracle 10g/11g Database Administration In this course, you will explore how an Oracle Database applies ‘grid computing’ to multiple computers to provide fast, efficient, secure data storage and manipulation that easily scales to thousands of clients. You will learn how to install, administer, and maintain an Oracle 10g or 11g database in an effective and efficient manner. You will cover the interaction among Oracle components, Oracle’s architecture, and user management. Performance monitoring, database security, and backup and recovery techniques are covered. This course will assist those preparing to take the Oracle Certified Associate (OCA) certification examination.Oracle 10g / 11g DBA Online Training

    ReplyDelete