Enterprise Manager Configuration on R12

STEP - 1
Ensure REMOTE_LOGIN_PASSWORDFILE=EXCLUSIVE is set in the init.ora for the database using this command:

SQL> show parameter REMOTE_LOGIN_PASSWORDFILE;

STEP - 2

orapwd file=$ORACLE_HOME/dbs/orapw$ORACLE_SID password=change_on_install
entries=5

STEP - 3

Make sure connect with oracle user.

[oracle@testoracle]$ cd $ORACLE_HOME/bin/

[oracle@testoracle bin]$ emca -config dbcontrol db -repos create

STARTED EMCA at Nov 14, 2008 2:31:46 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: PROD
Listener port number: 1521
Password for SYS user:
Password for DBSNMP user:
Invalid username/password.
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/db/tech_st/10.2.0

Database hostname ................ xxxx.xxxxxxxxxxxx.com
Listener port number ................ 1521
Database SID ................ PROD
Email address for notifications ...............
Outgoing Mail (SMTP) server for notifications ...............
-----------------------------------------------------------------


  
Do you wish to continue? [yes(Y)/no(N)]: Y

The repostitory should then start to be created. Typically this can take anywhere between 10 and 60 minutes depending on

hardware and database configuration and size.

Info: Creading the EM repository (this may take a while) ...

When the repositry is created the wollowing message should appear....

INFO:     >>>>>>> The Database control URL is http://xxxxxxxxx.xxxxxxxx.com:1158/em

Enterprise Manager configureation completed successfully
FINISHED EMCA at Nov 18, 2008 12:12:48 PM

Note :
The 10g database listener should be up and running inorder to configure and
access the dbconsole

TO DROP REPOSITORY
$ emca -deconfig dbcontrol db -repos drop

TO START DB CONSOLE
$ emctl start dbconsole
TO STOP DB CONSOLE
$ emctl stop dbconsole

METALINK NOTE 278100.1
How To Drop, Create And Recreate DB Control In A 10g Database

Please Subscribe my blog Qamar Zahoor, YouTube Channel YouTube, Join the Facebook group

Facebook Group and do follow on Twitter Twitter to get knowledge of Oracle EBS, Database, Ecommerce, Amazon, Ebay and Digital Marketing. Keep learning.