Solved

Oracle Enterprise Manager 11g Database Control

Posted on 2010-08-22
22
1,071 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
 
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
Find Ransomware Secrets With All-Source Analysis

Ransomware has become a major concern for organizations; its prevalence has grown due to past successes achieved by threat actors. While each ransomware variant is different, we’ve seen some common tactics and trends used among the authors of the malware.

 
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

Threat Intelligence Starter Resources

Integrating threat intelligence can be challenging, and not all companies are ready. These resources can help you build awareness and prepare for defense.

Join & Write a Comment

Sometimes people don't understand why download speed shows differently for Windows than Linux.Specially, this article covers and shows the solution for throughput difference for Windows than a Linux machine. For this, I arranged a test scenario.I…
Using SQL Scripts we can save all the SQL queries as files that we use very frequently on our database later point of time. This is one of the feature present under SQL Workshop in Oracle Application Express.
This video shows information on the Oracle Data Dictionary, starting with the Oracle documentation, explaining the different types of Data Dictionary views available by group and permissions as well as giving examples on how to retrieve data from th…
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

762 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

Need Help in Real-Time?

Connect with top rated Experts

19 Experts available now in Live!

Get 1:1 Help Now