How to enable Oracle Enterprise Manager for Oracle 10g Database Control Release 10.2.0.4?

Hey, it easy right. Just type the following command to start the OracleDBConsole:

emctl start dbconsole

But, how about if the following statement came out?

Unable to determine local host from URL REPOSITORY_URL=http://your-url.com.my:%EM_UPLOAD_PORT%/em/upload as shown on picture below:

Hurm, I don’t wanna say why this error come out but to overcome this error is pretty easy.

The very first thing is, add your machine host name in hosts file:

127.0.0.1       localhost
10.xx.xx.xx  machine-host-name(without "http://")


The location of hosts file (in Windows) is C:\WINDOWS\system32\drivers\etc\hosts

Then, drop current Database Console repository by issuing the following command:

emca -deconfig dbcontrol db -repos drop

p/s: Database SID, listener port (default 1521), SYS AND SYSMAN password is required

Wait until “Enterprise Manager configuration completed successfully“. This may take about 10 minutes to drop current Database Console Repository.

Then, we need to create it back with fresh configuration by issuing the following command:

emca -deconfig dbcontrol db -repos create


p/s: Database SID, listener port (default 1521), SYS, DBSNMP AND SYSMAN password is required

Once Enterprise Manager configuration has been completed successfully, the Database Control URL will be given. In my example, the DBConsole given was http://my-host-machine-name:5500/em

Finally, try to access web OEM via the URL given. It should work.

p/s: I am done all this step on Windows Server 2008, but I thought that this step can be apply to other UNIX base operating system as well.