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
Solved

Oracle Enterprise Manager 11g Database Control

Posted on 2010-08-22
22
1,078 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
  • 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
U.S. Department of Agriculture and Acronis Access

With the new era of mobile computing, smartphones and tablets, wireless communications and cloud services, the USDA sought to take advantage of a mobilized workforce and the blurring lines between personal and corporate computing resources.

 
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

Three Reasons Why Backup is Strategic

Backup is strategic to your business because your data is strategic to your business. Without backup, your business will fail. This white paper explains why it is vital for you to design and immediately execute a backup strategy to protect 100 percent of your data.

Question has a verified solution.

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

Suggested Solutions

Note: this article covers simple compression. Oracle introduced in version 11g release 2 a new feature called Advanced Compression which is not covered here. General principle of Oracle compression Oracle compression is a way of reducing the d…
Issue: Unstable cursor in Windows XP and Windows runs extremely slow in that any click will bring up the Hour glass (sometimes for several seconds before giving you what you want) . Troubleshooting Process and the FINAL FIX: This issue see…
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 recover a database from a user managed backup

856 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