Enable Enterprise Manager Database Control for Oracle E-Business Suite R12

Introduction

Managing the Oracle Database installed with Oracle Applications was a headache task for me specially when there is no EM console installed with the Applications Installation. And searching in this criteria always will take you to the direction of installing EM Grid or Cloud Management and trying to enable the Management Pack for E-Business which is a task you may not prefer to do if you have only one system which is the Oracle E-business Suite in our case.



After all of that time when you find a document that describe how to enable the EM database control with oracle APPS, this will be the big good news for this day. So here are the steps and references...


Enable EM Database Control for E-Business Suite R12


1. Source the environment for the 10g ORACLE_HOME

$ cd $ORACLE_HOME
$ . ./test_oratest2.env

2. Start the database and the listener

$ cd $ORACLE_HOME/appsutil/scripts/test_oratest2
$ ./addbctl.sh start
$ ./addlnctl.sh start test

3. Implement the password file and to overcome any ORA-01031 errors on the database using Note 358201.1, we only need the following commands to be run (You may have to be under HOME/bin to run this command)

$ orapwd file=/oratest/db/tech_st/10.2.0/dbs/orapwtest password=sys entries=5

And to Confirm that the SYS user has been granted the SYSDBA role, use v$pwfile_users view

$ sqlplus / as sysdba
SQL> select * from v$pwfile_users;

USERNAME   SYSDB     SYSOP
----------------    ---------      ---------
SYS                  TRUE        TRUE


4. After that we convert our Applications database to work with an SPFile instead of an init.ora.

For Instructions you may read "Converting Oracle APPS R12 to start and work with spfile instead of pfil" or refere to the Note 166601.1 for details on how to convert to using an SPFile.

5. As the owner of the 10gR2 ORACLE_HOME, run the following command to create the Enterprise Manager repository:-

$ emca -config dbcontrol db -repos create

Note: You will be asked to Enter values for SID, port number for Listener Please be sure to Enter the values appropriate to your environment, In our test fresh install we use the following values

Database SID: test
Listener port number: 1521
Password for SYS user: sys
Password for DBSNMP user: dbsnmp
Password for SYSMAN user: sysman
Email address for notifications (optional):
Outgoing Mail (SMTP) server for notifications (optional):

Confirm the creation by Entering Y to continue and a after completing a screen will be displayed like

When the repository is created a message should appear like the following

INFO: >>>>>>>>>>> The Database Control URL is http://xxxxxxxxxx.xx.oracle.com:1158/em <<<<<<<<<<<
Enterprise Manager configuration completed successfully
FINISHED EMCA at Sep 13, 2007 2:13:48 PM
Use the above Database Control URL to access the Enterprise Manager console through a browser interface.

Note the URL for EM, and use your browser to go to it. Log in as sys with sysdba privilege.

And here it is, EM database control for Oracle E-Business R12 Displayed,

Notes: 

1. Make sure to Enter the correct values when asked by EMCA or other wise ....
2. at the first time we entered a wrong values for port number and the configuration completed with no errors but cannot log to the database control, It displayed all status to be down. We correct that by dropping and recreating the DB Control using Note 278100.1. We only execute the two commands and enter the correct value for listener port.

$ cd  $ORACLE_HOME/bin/
$ emca -deconfig dbcontrol db

$ emca -config dbcontrol db

References

How to Enable Enterprise Manager on the Oracle E-Business Suite Release 12 [ID 458533.1]
How To Drop, Create And Recreate the Database Control (DB Control) Release 10g and 11g [ID 278100.1]
How to Migrate from a Pfile to an Spfile [ID 166601.1]
Troubleshooting the 'ORA-01031: insufficient privileges' error when using EMCA to Create or Drop
DBconsole [ID 358201.1]



Hope this Informative for You

Best Regards
Mostafa Mahmoud
February 2013

Related Articles:

Converting Oracle APPS R12 to start and work with spfile instead of pfile