Monday, August 15, 2011

Oracle Enterprise Manager Console Rebuild

The Oracle Enterprise Manager Console (emconsole) that came out in Oracle 10g was a great tool to use to perform DBA tasks... when it works.  Too many times I have run into problems after the system administrator applied security patches or performed hardening on the database server.  These changes would result in the emconsole service not being able to startup.  If I was lucky, rebuilding the console would get the service to startup again.  Here are the steps I performed in order to rebuild the management console:

Please Note:  The following drops and recreates your repository which will cause you to lose any existing data that resides there such as jobs you may have created!

1. Open a Command prompt and set your ORACLE_HOME and ORACLE_SID

2.  Drop the emconsole and repository:
    cmd> emca -deconfig dbcontrol db -repos drop
3. Bounce the Oracle database service

4.  Recreate the emconsole and repository
     cmd> emca -config dbcontrol db -repos recreate

5.  Restart the server

Hopefully this gets you back up and running on the Enterprise Manager Console.  Like I said, its a valuable tool, its just not very reliable in some environments.

Are you sick of trying to manage your Oracle database?  Have you lost your emconsole and cannot reliably administer your database without it?  I can save you a lot of frustration by providing reliable and experienced Oracle DBA support at an inexpensive monthly rate.  Feel free to Contact Me to learn more about what I can provide.

1 comment: