Want to win a PS4? Go Premium and enter to win our High-Tech Treats giveaway. Enter to Win

x
?
Solved

Oracle Enterprise Manager 11g Database Control

Posted on 2010-08-22
22
Medium Priority
?
1,095 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 2000 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 2000 total points
ID: 33498102
select DB_UNIQUE_NAME from v$database;
0
Industry Leaders: We Want Your Opinion!

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

 
LVL 7

Assisted Solution

by:sumit2906
sumit2906 earned 2000 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 2000 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 2000 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 2000 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 2000 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 2000 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 2000 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 2000 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

Tech or Treat!

Submit an article about your scariest tech experience—and the solution—and you’ll be automatically entered to win one of 4 fantastic tech gadgets.

Question has a verified solution.

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

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.  …
Checking the Alert Log in AWS RDS Oracle can be a pain through their user interface.  I made a script to download the Alert Log, look for errors, and email me the trace files.  In this article I'll describe what I did and share my script.
This videos aims to give the viewer a basic demonstration of how a user can query current session information by using the SYS_CONTEXT function
This video shows how to configure and send email from and Oracle database using both UTL_SMTP and UTL_MAIL, as well as comparing UTL_SMTP to a manual SMTP conversation with a mail server.

636 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