Installing Enterprise manager on Home PC

Hi All,

This post covers my efforts to install enterprise manager on my home machine. This is part of sql tuning exercise. In professional life you will not get licence for this Enterprise manager as only DBA will have access and its licence is expensive ( that what i got from my manager)

Developers only use the V$ views to solve issues. However even if you have access to v$sql_monitor which is again a special access . The graphical interface is much easier to solve issues. By getting some hands on this Enterprise manager you can request your DBA for graphical outputs so that it is easy to solve issues like ETL load taking long time. Report running for minutes .

So by default this should be installed if you installed oracle correctly but it was not the case with me i found below link help ful

http://blog.mclaughlinsoftware.com/oracle-architecture-configuration/changing-windows-hostname-and-oracle-enterprise-manager/

Basic point to be remembered is
1) try emctl start dbconsole
If you get error like the dbconsole is not configured

2) Try dropping the db console repository using

 emca -deconfig dbcontrol db -repos drop

3) then create the repository using 

emca -config dbcontrol db -repos create

https://localhost:1158/em/console