Solved

Oracle Enterprise Manager 11g Database Control

Posted on 2010-08-22
22
1,080 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
Technology Partners: 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 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

Back Up Your Microsoft Windows Server®

Back up all your Microsoft Windows Server – on-premises, in remote locations, in private and hybrid clouds. Your entire Windows Server will be backed up in one easy step with patented, block-level disk imaging. We achieve RTOs (recovery time objectives) as low as 15 seconds.

Question has a verified solution.

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

Suggested Solutions

Title # Comments Views Activity
oracle RMAN - trying to duplicate a database 5 52
Create Index on a Materialized View 5 47
ORA-02288: invalid OPEN mode 2 87
pl/sql parameter is null sometimes 2 25
How to Create User-Defined Aggregates in Oracle Before we begin creating these things, what are user-defined aggregates?  They are a feature introduced in Oracle 9i that allows a developer to create his or her own functions like "SUM", "AVG", and…
Have you ever had to make fundamental changes to a table in Oracle, but haven't been able to get any downtime?  I'm talking things like: * Dropping columns * Shrinking allocated space * Removing chained blocks and restoring the PCTFREE * Re-or…
This video explains at a high level about the four available data types in Oracle and how dates can be manipulated by the user to get data into and out of the database.
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

726 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