Solved

Oracle Enterprise Manager 11g Database Control

Posted on 2010-08-22
22
1,081 Views
Last Modified: 2013-11-11
I am unable to start Oracle Enterprise Manager 11g Database Control, and I got an error.
Anyone knows how to fix it?
I'm using Windows XP...
emctl.jpg
0
Comment
Question by:mawingho
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 12
  • 10
22 Comments
 
LVL 7

Accepted Solution

by:
sumit2906 earned 500 total points
ID: 33498000
try doing this:
set ORACLE_UNQNAME=<db unique name>
emctl start dbconsole
0
 

Author Comment

by:mawingho
ID: 33498091
It doesn't work...
What the db_unique_name should be?
How do I find out?

emctl.jpg
0
 
LVL 7

Assisted Solution

by:sumit2906
sumit2906 earned 500 total points
ID: 33498102
select DB_UNIQUE_NAME from v$database;
0
Revamp Your Training Process

Drastically shorten your training time with WalkMe's advanced online training solution that Guides your trainees to action.

 
LVL 7

Assisted Solution

by:sumit2906
sumit2906 earned 500 total points
ID: 33498116
Also, did you did any changes in your server recently, like changing the host name/ip address, that could cause issue with EM.
0
 

Author Comment

by:mawingho
ID: 33498121
no...............I don't know much about oracle...I am just learning...
0
 

Author Comment

by:mawingho
ID: 33498130
the db_unique_name should be orcl
now another problem is Oracle_Unqname

db-unique-name.jpg
emctl.jpg
0
 
LVL 7

Assisted Solution

by:sumit2906
sumit2906 earned 500 total points
ID: 33498146
try this:
set ORACLE_UNQNAME=orcl
0
 

Author Comment

by:mawingho
ID: 33498155
the error message is different now...but still doesn't work...
 

emctl.jpg
0
 
LVL 7

Assisted Solution

by:sumit2906
sumit2906 earned 500 total points
ID: 33498162
check whether you have the above directory existing, I mean:
D:\app\bin\product.....
0
 

Author Comment

by:mawingho
ID: 33498169
no...

dir.jpg
0
 

Author Comment

by:mawingho
ID: 33498175
why oracle used my computer name and domain name?
It should be localhost...
don't know whether oracle installer has a problem...
0
 
LVL 7

Assisted Solution

by:sumit2906
sumit2906 earned 500 total points
ID: 33498254
I think you have two options now:
1) recreate the EM configuration, you can use:
emca -config dbcontrol db -repos recreate

2) the second option(a faster one) is to edit your emctl.bat file which is avaialbel in oracle_home/bin directory, and add following lines after setlocal:
set HOST=localhost
set HOSTNAME=localhost
set ORACLE_HOSTNAME=localhost
0
 

Author Comment

by:mawingho
ID: 33498265
I did the first option just now...
but still have the same problem...
0
 
LVL 7

Assisted Solution

by:sumit2906
sumit2906 earned 500 total points
ID: 33498274
try the second one..add those three lines in your emctl.bat file.
0
 

Author Comment

by:mawingho
ID: 33498291
I tried the second options and executed the bat file
still doesn't work...
still got the same message.
0
 
LVL 7

Assisted Solution

by:sumit2906
sumit2906 earned 500 total points
ID: 33498387
what is the error message?
0
 

Author Comment

by:mawingho
ID: 33499171
same as the previous one
emctl.jpg
0
 
LVL 7

Assisted Solution

by:sumit2906
sumit2906 earned 500 total points
ID: 33499177
you need to do following :
1) edit the emctl.bat (open in notepad) file and add those three SET commands:
set HOST=localhost
set HOSTNAME=localhost
set ORACLE_HOSTNAME=localhost
2) save the emctl.bat file
3)from the command prompt run:
set ORACLE_UNQNAME=orcl
emctl start dbconsole
0
 

Author Comment

by:mawingho
ID: 33499221
I did that already
0
 

Author Comment

by:mawingho
ID: 33499228
it is ok now :)
0
 

Author Comment

by:mawingho
ID: 33499240
in fact, why I have such problem?
0
 
LVL 7

Assisted Solution

by:sumit2906
sumit2906 earned 500 total points
ID: 33499255
seems to me a bug, also aftetr configuring you EM, if you change your machine name or host name, this could happen as host name is used in config files. you can try metalink for more info.great that the workaround worked for you.
0

Featured Post

Free Tool: Port Scanner

Check which ports are open to the outside world. Helps make sure that your firewall rules are working as intended.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Configuring and using Oracle Database Gateway for ODBC Introduction First, a brief summary of what a Database Gateway is.  A Gateway is a set of driver agents and configurations that allow an Oracle database to communicate with other platforms…
How to Unravel a Tricky Query Introduction If you browse through the Oracle zones or any of the other database-related zones you'll come across some complicated solutions and sometimes you'll just have to wonder how anyone came up with them.  â€¦
This video shows setup options and the basic steps and syntax for duplicating (cloning) a database from one instance to another. Examples are given for duplicating to the same machine and to different machines
Via a live example, show how to take different types of Oracle backups using RMAN.

688 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question