MacLochlainns Weblog

Michael McLaughlin's Technical Blog

Site Admin

Reconfigure Oracle EM

with 181 comments

One mistake can lead to a lot of work. When you’ve installed Oracle Database 11g, you can’t change the Windows Hostname without reinstalling Oracle Enterprise Manager. If you’re trying to resolve an ORACLE_UNQNAME problem, check another post of mine for that answer.

These are the steps:

1. Change the %ORACLE_HOME%\network\admin\listener.ora file from an IP number to machine name.

2. Change the %ORACLE_HOME%\network\admin\tnsnames.ora file from an IP number to a machine name.

3. Change the C:\WINDOWS\System32\drivers\etc\hosts file by adding this line beneath the default localhost line (for the new Hostname value):

127.0.0.1       localhost
172.16.113.128  mclaughlin11g mclaughlin11g.techtinker.com

4. Change the Windows hostname by navigating: Start > Control Panel > System (classic view) from the random assignment of VMWare Fusion.

5. Reboot the machine to set the networking. Unlock the SYSMAN account because it ensures that emca can drop it and all dependencies. Then, drop the em configuration with the following commands.

C:\Data> set ORACLE_SID=orcl
C:\Data> emca -deconfig dbcontrol db -repos drop

6. You’ll receive the following prompts, enter the Oracle SID and Port number without double quotes but you must enter all passwords with double quotes (at least in Oracle Database 11g):

Oracle Database 11gR1

STARTED EMCA at Jul 13, 2008 8:26:42 AM
EM Configuration Assistant, Version 11.1.0.5.0 Production
Copyright (c) 2003, 2005, Oracle.  All rights reserved.
 
Enter the following information:
Database SID: orcl
Listener port number: 1521
Password for SYS user:
Password for SYSMAN user:
Password for SYSMAN user:
Do you wish to continue? [yes(Y)/no(N)]: y

Oracle Database 11gR2

STARTED EMCA at Sep 3, 2012 7:40:07 PM
EM Configuration Assistant, Version 11.2.0.0.2 Production
Copyright (c) 2003, 2005, Oracle.  All rights reserved.
 
Enter the following information:
Database SID: orcl
Listener port number: 1521
Password for SYS user:
Password for SYSMAN user:
 
Do you wish to continue? [yes(Y)/no(N)]: y

7. If you failed to unlock the SYSMAN account in step #5, you should drop the SYSMAN user manually. If you don’t drop the SYSMAN schema, you’ll raise an error when you try to recreate it:

CONFIG: ORA-20001: SYSMAN already EXISTS..
ORA-06512: at line 17
 
oracle.sysman.assistants.util.sqlEngine.SQLFatalErrorException: ORA-20001: SYSMAN already EXISTS..
ORA-06512: at line 17

The Java stack trace will look like this, more or less based on version and release:

at oracle.sysman.assistants.util.sqlEngine.SQLEngine.executeImpl(SQLEngine.java:1530)
at oracle.sysman.assistants.util.sqlEngine.SQLEngine.executeScript(SQLEngine.java:880)
at oracle.sysman.assistants.util.sqlEngine.SQLPlusEngine.executeScript(SQLPlusEngine.java
at oracle.sysman.assistants.util.sqlEngine.SQLPlusEngine.executeScript(SQLPlusEngine.java
at oracle.sysman.emcp.EMReposConfig.createRepository(EMReposConfig.java:492)
at oracle.sysman.emcp.EMReposConfig.invoke(EMReposConfig.java:218)
at oracle.sysman.emcp.EMReposConfig.invoke(EMReposConfig.java:147)
at oracle.sysman.emcp.EMConfig.perform(EMConfig.java:222)
at oracle.sysman.emcp.EMConfigAssistant.invokeEMCA(EMConfigAssistant.java:535)
at oracle.sysman.emcp.EMConfigAssistant.performConfiguration(EMConfigAssistant.java:1215)
at oracle.sysman.emcp.EMConfigAssistant.statusMain(EMConfigAssistant.java:519)
at oracle.sysman.emcp.EMConfigAssistant.main(EMConfigAssistant.java:468)

Drop the user and dependent on version a few other objects, like:

DROP USER sysman CASCADE;
DROP PUBLIC SYNONYM setemviewusercontext;
DROP ROLE mgmt_user;
DROP PUBLIC SYNONYM mgmt_target_blackouts;
DROP USER mgmt_view;

8. You can then create the em environment with the following syntax:

C:\Data> emca -config dbcontrol db -repos create

9. Again, you’ll receive the following prompts, enter the Oracle SID and Port number without double quotes but you must enter all passwords with double quotes (at least in Oracle Database 11g):

STARTED EMCA at Jul 13, 2008 8:28:48 AM
EM Configuration Assistant, Version 11.1.0.5.0 Production
Copyright (c) 2003, 2005, Oracle.  ALL rights reserved.
 
Enter the following information:
DATABASE SID: orcl
Listener port NUMBER: 1521
Password FOR SYS USER:
Password FOR DBSNMP USER:
Password FOR SYSMAN USER:
Password FOR SYSMAN USER: Email address FOR notifications (optional):
Outgoing Mail (SMTP) server FOR notifications (optional):
-----------------------------------------------------------------
 
You have specified the following settings
 
DATABASE ORACLE_HOME ................ C:\app\Administrator\product\11.1.0\db_1
 
LOCAL hostname ................ mclaughlin11g
Listener port NUMBER ................ 1521
DATABASE SID ................ orcl
Email address FOR notifications ...............
Outgoing Mail (SMTP) server FOR notifications ...............
 
-----------------------------------------------------------------
 
Do you wish TO continue? [yes(Y)/no(N)]: y

A note to me, remember haste makes waste. I’m just glad that rebuilding the MarkLogic server was easy.

Written by maclochlainn

July 13th, 2008 at 9:40 am

Posted in Uncategorized

181 Responses to 'Reconfigure Oracle EM'

Subscribe to comments with RSS or TrackBack to 'Reconfigure Oracle EM'.

  1. Great, this works fine for me. Thanks a lot

    Shahul

    13 Jan 09 at 4:15 am

  2. Thanks for this post! It helped me a lot!

    Rob Cilissen

    16 Jan 09 at 8:18 am

  3. […] Dank aan: MacLochlainns Weblog […]

  4. Thank you so much. It worked for me. :)

    Mohammed Yehia

    1 Feb 09 at 1:44 am

  5. […] Another method from MacLochLainns Weblog: […]

  6. I followed the steps but the EM is still not configured.
    Server: error creating the repository
    When I see the log i got this error:
    Oracle.sysman.emcp.exception.EMConfigException: Error creating the repository

    Waqas

    6 May 09 at 2:37 am

  7. I’d need to know what OS, what database version, et cetera to try and help you. Can you send that information?

    maclochlainn

    6 May 09 at 11:32 am

  8. Dear Sir,

    I followed your steps as described above, but no succes. I am running Oracle EBS R12 on a Windows XP plattform, I am able to drop the repository succesfully but when I try to create is gives the following error:

    Check if repos user already exists.

    OLD   6:    WHERE username=UPPER('&EM_REPOS_USER');
    NEW   6:    WHERE username=UPPER('SYSMAN');
    OLD   8:   IF ( '&EM_CHECK_TYPE' = 'EXISTS') THEN
    NEW   8:   IF ( 'NOT_EXISTS' = 'EXISTS') THEN
    OLD  11:       raise_application_error(-20000, '&EM_REPOS_USER does not exists..');
    NEW  11:       raise_application_error(-20000, 'SYSMAN does not exists..');
    OLD  14:   ELSIF ( '&EM_CHECK_TYPE' = 'NOT_EXISTS' ) THEN
    NEW  14:   ELSIF ( 'NOT_EXISTS' = 'NOT_EXISTS' ) THEN
    OLD  17:       raise_application_error(-20001, '&EM_REPOS_USER already exists..');
    NEW  17:       raise_application_error(-20001, 'SYSMAN already exists..');
    OLD  21:       raise_application_error(-20002, 'Invalid Check type &EM_CHECK_TYPE');
    NEW  21:       raise_application_error(-20002, 'Invalid Check type NOT_EXISTS');
    DECLARE
    *
    ERROR at line 1:
    ORA-20001: SYSMAN already EXISTS..
    ORA-06512: at line 17

    When i try to launch EM (knowing dat the repository is dropped) the following happens:

    G:\oracle\PROD\db\tech_st\10.2.0\BIN> emctl start dbconsole
    OC4J Configuration issue. G:\oracle\PROD\db\tech_st\10.2.0/oc4j/j2ee/OC4J_DBConsole_EEBSE01_PROD not found.

    But as I said if I try to create the repository is doesn’t work.

    Could you point out what’s wrong?

    Michael: Check here for what I think you’re looking for as an answer.

    Best regard ans thanx in advance,

    Yours sincerely Maruti Bhanot

    Maruti Bhanot

    16 May 09 at 1:06 pm

  9. You’re not working with OEM. When you’ve installed the Oracle EBS R12, it’s the Oracle Applications Enterprise Manager (OAEM). It has different dependencies because it often leverages Java repackaged by the Oracle Applications development group. It appears that you might need some grants between scheme, but I’m not sure which ones. I’ve got this in a test plan for a situation like that but the project’s not scheduled until June.

    maclochlainn

    16 May 09 at 3:33 pm

  10. Thanx for your relpy!

    Yours sincerely Maruti Bhanot

    Maruti Bhanot

    18 May 09 at 3:01 pm

  11. Hi,
    I have oracle 10g installed on my system, but due to some IT policies they, IT, changed the computer host name!! I changed the host name in listener.ora and tnsnames.ora, and thereby SQL*Plus works. Unfortunately, I am not able to run enterprise database manager control when following the steps in the post above.

    Milind Pangarkar

    5 Jun 09 at 5:16 am

  12. There’s really not a lot of information to go on in your comment. However, based on the fact that the IT department changed the machine hostname, I’ll make some assumptions. Assuming that you have an account that has administrative rights on the local machine but not within the Windows domain, Oracle may have been installed using the Administrator account rather than yours. You can confirm if this or similar problems exist by attempting to log in as the privileged user:

    C:\> sqlplus '/ as sysdba'

    If it says that you lack permissions to run that command, then your account doesn’t have adequate permissions. By the way, the single quotes aren’t necessary on newer releases of Oracle.

    Second assumption, the IT department has a license monitoring software installed on your PC. This is frequently the case with IT governance policies. I’d suggest that you disable the software because they interfere with Oracle’s operation on Windows. Hope this helps, but if not could you provide some more detail?

    maclochlainn

    7 Jun 09 at 4:17 pm

  13. I have 2 network cards in use on my server. The server belongs to a workgroup, but the 2nd network connection connects to a different network. When I run this procedure the local hostname returned to me is the ip address of the 2nd network card, but I desire the ip address of the 1st network card or either the alias I created in the hosts file.

    The line in my hosts file is this
    150.1.1.50 SPM2_L2_ONLINE APPSERVER

    In my listener.ora and my tnsnames.ora my alias APPSERVER is used. There is no entry in the hosts file for the ip address belonging to the 2nd network card. What am I doind wrong?

    P Hunt

    22 Jun 09 at 3:36 pm

  14. I was able to get the correct ip address to be listed as the local hostname, but now I have a new error. Here is the part of my error log where things appear to start going wrong

    Jun 22, 2009 5:51:11 PM oracle.sysman.emcp.util.OUIInventoryUtil getInstallInventory
    CONFIG: Error accessing inventory.
    oracle.sysman.oii.oiit.OiitTargetLockNotAvailableException: The inventory C:\Program Files\Oracle\Inventory cannot be read since it is being written to by another session. Please close all the other(write) sessions for accessing inventory.
     
    Jun 22, 2009 5:51:11 PM oracle.sysman.emcp.util.PortManager markAllUsedPorts
    CONFIG: Homes to scan for used ports: [D:\app\Administrator\product\11.1.0\db_1]
    Jun 22, 2009 5:51:11 PM oracle.sysman.emcp.util.PortManager markAllUsedPorts
    CONFIG: Searching all DBConsole instances for used ports under ORACLE_HOME D:\app\Administrator\product\11.1.0\db_1
    Jun 22, 2009 5:51:11 PM oracle.sysman.emcp.util.PortManager markAllUsedPorts
    CONFIG: Marking JMS port: null from D:\app\Administrator\product\11.1.0\db_1\oc4j\j2ee\OC4J_DBConsole
    Jun 22, 2009 5:51:11 PM oracle.sysman.emcp.util.PortManager markAllUsedPorts
    CONFIG: Marking RMI port: null from D:\app\Administrator\product\11.1.0\db_1\oc4j\j2ee\OC4J_DBConsole
    Jun 22, 2009 5:51:11 PM oracle.sysman.emcp.util.PortManager markAllUsedPorts
    CONFIG: Marking HTTP port: null from D:\app\Administrator\product\11.1.0\db_1\oc4j\j2ee\OC4J_DBConsole
    Jun 22, 2009 5:51:11 PM oracle.sysman.emcp.util.PortManager getAgentPort
    CONFIG: Cannot parse EMD_URL correctly. No port identified
    Jun 22, 2009 5:51:11 PM oracle.sysman.emcp.util.PortManager markAllUsedPorts
    CONFIG: Marking Agent port: null from D:\app\Administrator\product\11.1.0\db_1\sysman\config\emd.properties
    Jun 22, 2009 5:51:11 PM oracle.sysman.emcp.util.PortManager markAllUsedPorts
    CONFIG: Cannnot parse EMD_URL correctly. No port identified
    Jun 22, 2009 5:51:11 PM oracle.sysman.emcp.util.FileUtil getProperties
    CONFIG: Error reading file D:\app\Administrator\product\11.1.0\db_1\install\staticports.ini
    Jun 22, 2009 5:51:11 PM oracle.sysman.emcp.util.PortManager getFreePorts
    CONFIG: D:\app\Administrator\product\11.1.0\db_1:150.1.1.50:null:orcl:{}:null:{DBCONTROL_HTTP_PORT=1158, RMI_PORT=5520, JMS_PORT=5540, AGENT_PORT=3938}
    Jun 22, 2009 5:51:11 PM oracle.sysman.emcp.ParamsManager getParam
    CONFIG: No value was set for the parameter AGENT_PORT_orcl.
    Jun 22, 2009 5:51:11 PM oracle.sysman.emcp.ParamsManager setParam
    CONFIG: Setting param: AGENT_PORT_orcl value: 3938
    Jun 22, 2009 5:51:11 PM oracle.sysman.emcp.ParamsManager getParam
    CONFIG: No value was set for the parameter DBCONTROL_HTTP_PORT_orcl.
    Jun 22, 2009 5:51:11 PM oracle.sysman.emcp.ParamsManager setParam
    CONFIG: Setting param: DBCONTROL_HTTP_PORT_orcl value: 1158
    Jun 22, 2009 5:51:11 PM oracle.sysman.emcp.ParamsManager getParam
    CONFIG: No value was set for the parameter JMS_PORT_orcl.
    Jun 22, 2009 5:51:11 PM oracle.sysman.emcp.ParamsManager setParam
    CONFIG: Setting param: JMS_PORT_orcl value: 5540
    Jun 22, 2009 5:51:11 PM oracle.sysman.emcp.ParamsManager getParam
    CONFIG: No value was set for the parameter RMI_PORT_orcl.
    Jun 22, 2009 5:51:11 PM oracle.sysman.emcp.ParamsManager setParam
    CONFIG: Setting param: RMI_PORT_orcl value: 5520
    Jun 22, 2009 5:51:11 PM oracle.sysman.emcp.EMDBPreConfig getFreePorts
    CONFIG: Ports assigned for SID: orcl : {DBCONTROL_HTTP_PORT=1158, RMI_PORT=5520, JMS_PORT=5540, AGENT_PORT=3938}
    Jun 22, 2009 5:51:11 PM oracle.sysman.emcp.ParamsManager getParam
    CONFIG: No value was set for the parameter ORACLE_HOSTNAME.
    Jun 22, 2009 5:51:11 PM oracle.sysman.emcp.util.ClusterUtil getLocalNode
    CONFIG: isLocalNodeDone: true localNode: null
    Jun 22, 2009 5:51:11 PM oracle.sysman.emcp.EMDBPreConfig copyAgentTimeStampFile
    CONFIG: File: D:\app\Administrator\product\11.1.0\db_1\150.1.1.50_orcl\sysman\emd\agntstmp.txt:150.1.1.50 does not exists.
    Jun 22, 2009 5:51:11 PM oracle.sysman.emcp.util.GeneralUtil initSQLEngine
    CONFIG: SQLEngine connecting with SID: orcl, oracleHome: D:\app\Administrator\product\11.1.0\db_1, and user: SYS
    Jun 22, 2009 5:51:11 PM oracle.sysman.emcp.util.GeneralUtil initSQLEngine
    CONFIG: SQLEngine created successfully and connected
    Jun 22, 2009 5:51:11 PM oracle.sysman.emcp.EMReposConfig createRepository
    CONFIG: Spooling to D:\app\Administrator\cfgtoollogs\emca\orcl\emca_repos_create_2009_06_22_17_51_11.log
    Jun 22, 2009 5:51:11 PM oracle.sysman.emcp.EMReposConfig createRepository
    INFO: Creating the EM repository (this may take a while) ...
    Jun 22, 2009 5:52:43 PM oracle.sysman.emcp.EMReposConfig createRepository
    CONFIG: ORA-00955: name is already used by an existing object
     
    oracle.sysman.assistants.util.sqlEngine.SQLFatalErrorException: ORA-00955: name is already used by an existing object
     
    	at oracle.sysman.assistants.util.sqlEngine.SQLEngine.executeImpl(SQLEngine.java:1530)
    	at oracle.sysman.assistants.util.sqlEngine.SQLEngine.executeScript(SQLEngine.java:880)
    	at oracle.sysman.assistants.util.sqlEngine.SQLPlusEngine.executeScript(SQLPlusEngine.java:270)
    	at oracle.sysman.assistants.util.sqlEngine.SQLPlusEngine.executeScript(SQLPlusEngine.java:311)
    	at oracle.sysman.emcp.EMReposConfig.createRepository(EMReposConfig.java:492)
    	at oracle.sysman.emcp.EMReposConfig.invoke(EMReposConfig.java:218)
    	at oracle.sysman.emcp.EMReposConfig.invoke(EMReposConfig.java:147)
    	at oracle.sysman.emcp.EMConfig.perform(EMConfig.java:222)
    	at oracle.sysman.emcp.EMConfigAssistant.invokeEMCA(EMConfigAssistant.java:535)
    	at oracle.sysman.emcp.EMConfigAssistant.performConfiguration(EMConfigAssistant.java:1215)
    	at oracle.sysman.emcp.EMConfigAssistant.statusMain(EMConfigAssistant.java:519)
    	at oracle.sysman.emcp.EMConfigAssistant.main(EMConfigAssistant.java:468)
    Jun 22, 2009 5:52:43 PM oracle.sysman.emcp.EMReposConfig invoke
    SEVERE: Error creating the repository
    Jun 22, 2009 5:52:43 PM oracle.sysman.emcp.EMReposConfig invoke
    INFO: Refer to the log file at D:\app\Administrator\cfgtoollogs\emca\orcl\emca_repos_create_.log for more details.
    Jun 22, 2009 5:52:43 PM oracle.sysman.emcp.EMConfig perform
    SEVERE: Error creating the repository
    Refer to the log file at D:\app\Administrator\cfgtoollogs\emca\orcl\emca_2009_06_22_17_50_34.log for more details.
    Jun 22, 2009 5:52:43 PM oracle.sysman.emcp.EMConfig perform
    CONFIG: Stack Trace: 
    oracle.sysman.emcp.exception.EMConfigException: Error creating the repository
    	at oracle.sysman.emcp.EMReposConfig.invoke(EMReposConfig.java:230)
    	at oracle.sysman.emcp.EMReposConfig.invoke(EMReposConfig.java:147)
    	at oracle.sysman.emcp.EMConfig.perform(EMConfig.java:222)
    	at oracle.sysman.emcp.EMConfigAssistant.invokeEMCA(EMConfigAssistant.java:535)
    	at oracle.sysman.emcp.EMConfigAssistant.performConfiguration(EMConfigAssistant.java:1215)
    	at oracle.sysman.emcp.EMConfigAssistant.statusMain(EMConfigAssistant.java:519)
    	at oracle.sysman.emcp.EMConfigAssistant.main(EMConfigAssistant.java:468)

    Any help would be appreciated.

    P Hunt

    23 Jun 09 at 7:36 am

  15. The errors in general, and the log throwing an ORA-00955 error may indicate that you neeed to manually drop the SYSMAN schema after deconfiguring Oracle EM. Have you tried a manual drop of the SYSMAN schema (step #7)?

    The other error that’s interesting is the concurrency control lock. Is it possible that you’ve two domains on the single box? I ask because Oracle lives in a single domain on Windows, and when you’ve two or more domains permissions and access to components differ substantially. Can you let me know if you’ve got two domains on that server?

    maclochlainn

    23 Jun 09 at 9:43 am

  16. I did do the manual drop of sysman. I looked at the emca_repos_create… file and saw that it was complaining about some MGMT% synonyms already existing so it could not create the synonym. I have been dropping these synonyms one by one to see if I can get somewhere. I saw a solution on another website where all the synonyms had to be dropped manually in addition to the sysman user. I do not know if I have 2 domains on the server. What I do know is the server belongs to a workgroup. The ip address for the 1st network card corresponds to this workgroup. The 2nd network card is used for level 3 access. It’s ip address belongs to the level 3 network which I assume is part of a domain.

    P Hunt

    23 Jun 09 at 1:38 pm

  17. Which NIC does 150.1.1.50 belong to, the primary or secondary? Which NIC should the EM run on?
    You’re installing as the Administrator user account from the logs, but just want to confirm that?
    Synonyms creation failure shouldn’t cause a fatal failure because they’re created to mirror the old ones, they just won’t translate in between rebuilding SYSMAN. Did you’re log indicate that the process stopped completed at those synonym creation statements?
    What’s in this or a more recent equivalent log file: D:\app\Administrator\cfgtoollogs\emca\orcl\emca_2009_06_22_17_50_34.log?

    maclochlainn

    23 Jun 09 at 10:49 pm

  18. 150.1.1.50 belongs to network connection 1. This is where the EM should run. Yes the install is being done as administrator. Here is the last line of file emca_repos_create_2009_06_23_16_29_17.log

    CREATE PUBLIC SYNONYM MGMT_USER FOR MGMT_USER
                          *
    ERROR at line 1:
    ORA-00955: name is already used by an existing object
     
    This is where the program stops.  Here is the accompanying file emca_2009_06_23_16_29_03.log (well the portion where the error begins)
     
    CONFIG: ORA-00955: name is already used by an existing object
     
    oracle.sysman.assistants.util.sqlEngine.SQLFatalErrorException: ORA-00955: name is already used by an existing object
     
    	at oracle.sysman.assistants.util.sqlEngine.SQLEngine.executeImpl(SQLEngine.java:1530)
    	at oracle.sysman.assistants.util.sqlEngine.SQLEngine.executeScript(SQLEngine.java:880)
    	at oracle.sysman.assistants.util.sqlEngine.SQLPlusEngine.executeScript(SQLPlusEngine.java:270)
    	at oracle.sysman.assistants.util.sqlEngine.SQLPlusEngine.executeScript(SQLPlusEngine.java:311)
    	at oracle.sysman.emcp.EMReposConfig.createRepository(EMReposConfig.java:492)
    	at oracle.sysman.emcp.EMReposConfig.invoke(EMReposConfig.java:218)
    	at oracle.sysman.emcp.EMReposConfig.invoke(EMReposConfig.java:147)
    	at oracle.sysman.emcp.EMConfig.perform(EMConfig.java:222)
    	at oracle.sysman.emcp.EMConfigAssistant.invokeEMCA(EMConfigAssistant.java:535)
    	at oracle.sysman.emcp.EMConfigAssistant.performConfiguration(EMConfigAssistant.java:1215)
    	at oracle.sysman.emcp.EMConfigAssistant.statusMain(EMConfigAssistant.java:519)
    	at oracle.sysman.emcp.EMConfigAssistant.main(EMConfigAssistant.java:468)
    Jun 23, 2009 4:30:43 PM oracle.sysman.emcp.EMReposConfig invoke
    SEVERE: Error creating the repository
    Jun 23, 2009 4:30:43 PM oracle.sysman.emcp.EMReposConfig invoke
    INFO: Refer to the log file at D:\app\Administrator\cfgtoollogs\emca\orcl\emca_repos_create_.log for more details.
    Jun 23, 2009 4:30:43 PM oracle.sysman.emcp.EMConfig perform
    SEVERE: Error creating the repository
    Refer to the log file at D:\app\Administrator\cfgtoollogs\emca\orcl\emca_2009_06_23_16_29_03.log for more details.
    Jun 23, 2009 4:30:43 PM oracle.sysman.emcp.EMConfig perform
    CONFIG: Stack Trace: 
    oracle.sysman.emcp.exception.EMConfigException: Error creating the repository
    	at oracle.sysman.emcp.EMReposConfig.invoke(EMReposConfig.java:230)
    	at oracle.sysman.emcp.EMReposConfig.invoke(EMReposConfig.java:147)
    	at oracle.sysman.emcp.EMConfig.perform(EMConfig.java:222)
    	at oracle.sysman.emcp.EMConfigAssistant.invokeEMCA(EMConfigAssistant.java:535)
    	at oracle.sysman.emcp.EMConfigAssistant.performConfiguration(EMConfigAssistant.java:1215)
    	at oracle.sysman.emcp.EMConfigAssistant.statusMain(EMConfigAssistant.java:519)
    	at oracle.sysman.emcp.EMConfigAssistant.main(EMConfigAssistant.java:468)

    I have a concern that if I do get this working, my dual network cards will cause me a problem. When I try to use the emctl start command, it constructs a folder name with the ip address of network connection 2. Perhaps I’ll address this if I get to this point.

    P Hunt

    24 Jun 09 at 7:39 am

  19. Worked perfectly for me !!
    (was necessary after 10g XE upgraded to full version 10g 10.2.0.4 on another machine)

    Reinhold Seifert

    29 Jun 09 at 5:50 am

  20. I have recreated OEM configuration. Oracle 11g dbconsole is running. OEM is running but when I am trying to open database control on internet explorer, it is not displaying the page.

    Rajiv

    9 Jul 09 at 4:37 pm

  21. Have you tried Firefox? What’s your URL that;s failing?

    maclochlainn

    9 Jul 09 at 6:08 pm

  22. Hello,

    I posted a while ago about EM on Windows enviroment which wasn’t working for me, I switched to CentOS 5.3 running my R12 and the following steps worked for me:

    Configure OEM Database Control on R12

    Source enviroment the of the database tier. Env. file location is in my case /ERP/db/tech_st/11.1.0/

    [oracle@localhost 11.1.0]$ . VIS_localhost.env
     
    [oracle@localhost bin]$ ./emca -config dbcontrol db -repos recreate -SID VIS -PORT 1521 -DBCONTROL_HTTP_PORT 5500
     
    STARTED EMCA at Aug 13, 2009 1:57:51 PM
    EM Configuration Assistant, Version 11.1.0.7.0 Production
    Copyright (c) 2003, 2005, Oracle.  All rights reserved.
     
    Enter the following information:
    Password for SYSMAN user: Email address for notifications (optional): 
    Outgoing Mail (SMTP) server for notifications (optional): 
    -----------------------------------------------------------------
     
    You have specified the following settings
     
    Database ORACLE_HOME ................ /ERP/db/tech_st/11.1.0
     
    Local hostname ................ localhost.localdomain
    Listener port number ................ 1521
    Database SID ................ VIS
    Email address for notifications ............... 
    Outgoing Mail (SMTP) server for notifications ............... 
    -----------------------------------------------------------------
    Do you wish to continue? [yes(Y)/no(N)]: Y
    Aug 13, 2009 2:01:03 PM oracle.sysman.emcp.EMConfig perform
    INFO: This operation is being logged at /ERP/db/tech_st/11.1.0/cfgtoollogs/emca/VIS/emca_2009_08_13_13_57_51.log.
    Aug 13, 2009 2:01:14 PM oracle.sysman.emcp.EMReposConfig invoke
    INFO: Dropping the EM repository (this may take a while) ...
    Aug 13, 2009 2:18:41 PM oracle.sysman.emcp.EMReposConfig invoke
    INFO: Repository successfully dropped
    Aug 13, 2009 2:18:42 PM oracle.sysman.emcp.EMReposConfig createRepository
    INFO: Creating the EM repository (this may take a while) ...
    Aug 13, 2009 2:51:16 PM oracle.sysman.emcp.EMReposConfig invoke
    INFO: Repository successfully created
    Aug 13, 2009 2:51:48 PM oracle.sysman.emcp.EMReposConfig uploadConfigDataToRepository
    INFO: Uploading configuration data to EM repository (this may take a while) ...
    Aug 13, 2009 2:55:52 PM oracle.sysman.emcp.EMReposConfig invoke
    INFO: Uploaded configuration data successfully
    Aug 13, 2009 2:56:11 PM oracle.sysman.emcp.util.DBControlUtil configureSoftwareLib
    INFO: Software library configured successfully.
    Aug 13, 2009 2:56:11 PM oracle.sysman.emcp.EMDBPostConfig configureSoftwareLibrary
    INFO: Deploying Provisioning archives ...
    Aug 13, 2009 2:56:54 PM oracle.sysman.emcp.EMDBPostConfig configureSoftwareLibrary
    INFO: Provisioning archives deployed successfully.
    Aug 13, 2009 2:56:54 PM oracle.sysman.emcp.util.DBControlUtil secureDBConsole
    INFO: Securing Database Control (this may take a while) ...
    Aug 13, 2009 2:57:43 PM oracle.sysman.emcp.util.DBControlUtil secureDBConsole
    INFO: Database Control secured successfully.
    Aug 13, 2009 2:57:43 PM oracle.sysman.emcp.util.DBControlUtil startOMS
    INFO: Starting Database Control (this may take a while) ...
    Aug 13, 2009 3:02:16 PM oracle.sysman.emcp.EMDBPostConfig performConfiguration
    INFO: Database Control started successfully
    Aug 13, 2009 3:02:17 PM oracle.sysman.emcp.EMDBPostConfig performConfiguration
    INFO: >>>>>>>>>>> The Database Control URL is https://localhost.localdomain:5500/em <<<<<<<<<<<
    Aug 13, 2009 3:02:53 PM oracle.sysman.emcp.EMDBPostConfig invoke
    WARNING: 
    ************************  WARNING  ************************
     
    Management Repository has been placed in secure mode wherein Enterprise Manager data will be encrypted.  The encryption key has been placed in the file: /ERP/db/tech_st/11.1.0/localhost.localdomain_VIS/sysman/config/emkey.ora.   Please ensure this file is backed up as the encrypted data will become unusable if this file is lost. 
     
    ***********************************************************
    Enterprise Manager configuration completed successfully
    FINISHED EMCA at Aug 13, 2009 3:02:53 PM

    Afterwards, open a browser and enter:

    https://<localhost>.<localdomain>:5500/em/console/

    Accept te certificate and there you go….

    I got the main info of this site:

    http://orafin.blogspot.com/2008/09/enable-database-enterprise-manager.html

    So it is working now fine for me, perhaps on a Windows enviroment if you use de Windows commands it should perhaps work, not tried still…

    Regards,

    Maruti

    Maruti Bhanot

    14 Aug 09 at 4:02 am

  23. This was a neat and clear help. thanks a lot.

    Rakesh Vyas

    22 Sep 09 at 1:10 am

  24. Thanks !!!
    I didn’t see see the forest for the trees.
    ETC/host is the solution for my challenges with the console.
    This article is short and to the point
    great

    Gerd

    28 Sep 09 at 1:48 am

  25. thanks for your help!
    but i have another error after the reconfiguration of em: Unable to determine local host from URL REPOSITORY_URL=http://ORACLE-LAPTOP:%EM_UPLOAD_PORT%/em/upload/
    could you help me again please!!!!!!

    Patricia

    21 Oct 09 at 8:13 am

  26. The public synonym for SYSMAN objects will not be dropped although the user is drooped by using the command:

    DROP USER sysman CASCADE;

    After user is dropped, all the public synonyms that tie to it hv to be dropped manually.

    SELECT 'drop public synonym ' || a.object_name || ';'
    FROM all_objects a
    WHERE a.object_type='SYNONYM'
    AND a.owner = 'PUBLIC'
    AND a.STATUS = 'INVALID'

    yapkang

    7 Jan 10 at 9:53 pm

  27. I have a problem about reconfiguration of ports
    When I execute emca -config dbcontrol db, the password of SYS is accepted.
    When I execute emca -reconfig ports -…… the password of SYS (the same as before of course) is rejected.
    Could you help me with this issue? I’m installing Oracle 11g on Windows 7 (32bit).
    Thanks a lot.

    Marcela

    10 Jan 10 at 5:36 pm

  28. Thanks you too much sir its really help full, long live DBA

    saif

    16 Jan 10 at 11:56 pm

  29. Thank you, thank you, thank you.

    dto

    22 Jan 10 at 9:09 am

  30. Marcela, What’s the exact error message that you get?

    maclochlainn

    22 Jan 10 at 10:35 am

  31. Hi;

    Thanks for sharing this information! I was struggling to reconfigure em control and this has helped me make some progress.

    I was able to deconfigure using emca.

    The sysman user and other ‘residuals’ were also all gone. (maybe this got more thorough in 11.2.0).

    I am having no luck when I try to reconfigure however. Despite the Java exception messages you’ll see below, the database is happily up and running. Any ideas would be appreciated.

    Thank you, Jack

    C:\app\product\11.2.0\dbhome_1\BIN>set
    ALLUSERSPROFILE=C:\Documents and Settings\All Users
    APPDATA=C:\Documents and Settings\Administrator\Application Data
    CLIENTNAME=Console
    CommonProgramFiles=C:\Program Files\Common Files
    COMPUTERNAME=JACKXPPRO
    ComSpec=C:\WINDOWS\system32\cmd.exe
    FP_NO_HOST_CHECK=NO
    HOMEDRIVE=C:
    HOMEPATH=\Documents and Settings\Administrator
    LOGONSERVER=\\JACKXPPRO
    NUMBER_OF_PROCESSORS=2
    oracle_home=c:\app\product\11.2.0\dbhome_1
    oracle_sid=orcl
    ORACLE_UNQNAME=orcl
    OS=Windows_NT
    Path=C:\app\product\11.2.0\dbhome_1\bin;C:\app\product\11.1.0\db_1\bin;C:\WINDOWS\system32;C:\WINDOW
    S;C:\WINDOWS\System32\Wbem
    PATHEXT=.COM;.EXE;.BAT;.CMD;.VBS;.VBE;.JS;.JSE;.WSF;.WSH
    PROCESSOR_ARCHITECTURE=x86
    PROCESSOR_IDENTIFIER=x86 Family 6 Model 23 Stepping 6, GenuineIntel
    PROCESSOR_LEVEL=6
    PROCESSOR_REVISION=1706
    ProgramFiles=C:\Program Files
    PROMPT=$P$G
    SESSIONNAME=Console
    SystemDrive=C:
    SystemRoot=C:\WINDOWS
    TEMP=C:\DOCUME~1\ADMINI~1\LOCALS~1\Temp
    TMP=C:\DOCUME~1\ADMINI~1\LOCALS~1\Temp
    TNS_ADMIN=C:\app\product\11.2.0\db_home1\network\admin
    USERDOMAIN=JACKXPPRO
    USERNAME=Jack Reid
    USERPROFILE=C:\Documents and Settings\Administrator
    windir=C:\WINDOWS
     
    C:\app\product\11.2.0\dbhome_1\BIN> emca -config dbcontrol db -repos create
     
    STARTED EMCA at May 6, 2010 10:43:03 PM
    EM Configuration Assistant, Version 11.2.0.0.2 Production
    Copyright (c) 2003, 2005, Oracle.  All rights reserved.
     
    Enter the following information:
    Database SID: orcl
    Exception in thread "main" oracle.sysman.emcp.exception.DatabaseUnavailableException: Database instance unavailable.
            at oracle.sysman.emcp.DatabaseChecks.throwDBUnavailableException(DatabaseChecks.java:151)
            at oracle.sysman.emcp.DatabaseChecks.checkDbAvailabilityImpl(DatabaseChecks.java:144)
            at oracle.sysman.emcp.DatabaseChecks.checkDbAvailability(DatabaseChecks.java:163)
            at oracle.sysman.emcp.DatabaseChecks.getDbServiceName(DatabaseChecks.java:582)
            at oracle.sysman.emcp.EMConfigAssistant.performConfiguration(EMConfigAssistant.java:1272)
            at oracle.sysman.emcp.EMConfigAssistant.statusMain(EMConfigAssistant.java:574)
            at oracle.sysman.emcp.EMConfigAssistant.main(EMConfigAssistant.java:522)
     
    C:\app\product\11.2.0\dbhome_1\BIN>

    Jack

    6 May 10 at 8:46 pm

  32. thank you very much. It did not require me to drop any users/schemas.

    sushant

    9 May 10 at 8:43 pm

  33. Hi Maclochlainn,

    Because of some replication problem my production server has gone to hanging mode, so, I force to restart my production server. After restarting every thing working fine except my OEM unable to restart. I followed your steps, but at the end I am getting “SEVERE: Error starting Database Control”. Checked the log file, repository created successfully, but unable to start the repository. mailing you end part of the log file. Please help me to start the OEM.

    Creating directories...
    Creating targets.xml...
    Done.
     
    May 29, 2010 9:05:18 AM oracle.sysman.emcp.EMAgentConfig instantiateEMConfigFiles
    CONFIG: Successfully deployed state dirs for oracledb.jll.com
    May 29, 2010 9:05:18 AM oracle.sysman.emcp.EMAgentConfig performConfiguration
    CONFIG: Successfully updated agent config files
    May 29, 2010 9:05:18 AM oracle.sysman.emcp.util.FileUtil _copyFile
    CONFIG: Copying file C:\oracle\product\10.2.0\db_1\sysman\config\emd.properties.emca.tmp to C:\oracle\product\10.2.0\db_1\sysman\config\emd.properties
    May 29, 2010 9:05:18 AM oracle.sysman.emcp.util.FileUtil backupFile
    CONFIG: The original file C:\oracle\product\10.2.0\db_1\sysman\config\emd.properties.emca.tmp has been copied to C:\oracle\product\10.2.0\db_1\sysman\config\emd.properties
    May 29, 2010 9:05:18 AM oracle.sysman.emcp.util.FileUtil _copyFile
    CONFIG: Copying file C:\oracle\product\10.2.0\db_1\sysman\emd\targets.xml.emca.tmp to C:\oracle\product\10.2.0\db_1\sysman\emd\targets.xml
    May 29, 2010 9:05:18 AM oracle.sysman.emcp.util.FileUtil backupFile
    CONFIG: The original file C:\oracle\product\10.2.0\db_1\sysman\emd\targets.xml.emca.tmp has been copied to C:\oracle\product\10.2.0\db_1\sysman\emd\targets.xml
    May 29, 2010 9:05:18 AM oracle.sysman.emcp.util.ClusterUtil getLocalNode
    CONFIG: isLocalNodeDone: true localNode: null
    May 29, 2010 9:05:18 AM oracle.sysman.emcp.util.ClusterUtil getLocalNode
    CONFIG: isLocalNodeDone: true localNode: null
    May 29, 2010 9:05:18 AM oracle.sysman.emcp.util.PortManager addPortEntries
    CONFIG: Updating file C:\oracle\product\10.2.0\db_1\install\portlist.ini ...
    May 29, 2010 9:05:18 AM oracle.sysman.emcp.util.FileUtil _copyFile
    CONFIG: Copying file C:\oracle\product\10.2.0\db_1\install\portlist.ini to C:\oracle\product\10.2.0\db_1\install\portlist.ini.emca.util.tmp
    May 29, 2010 9:05:18 AM oracle.sysman.emcp.util.FileUtil backupFile
    CONFIG: The original file C:\oracle\product\10.2.0\db_1\install\portlist.ini has been copied to C:\oracle\product\10.2.0\db_1\install\portlist.ini.emca.util.tmp
    May 29, 2010 9:05:18 AM oracle.sysman.emcp.util.PortManager addPortEntries
    CONFIG: Removing existing entries from portlist.ini Enterprise Manager Console HTTP Port (JLLDB) = 1158
    May 29, 2010 9:05:19 AM oracle.sysman.emcp.util.PortManager addPortEntries
    CONFIG: Writing the selected ports to portlist.ini
    May 29, 2010 9:05:19 AM oracle.sysman.emcp.util.FileUtil _copyFile
    CONFIG: Copying file C:\oracle\product\10.2.0\db_1\install\portlist.ini.emca.util.tmp to C:\oracle\product\10.2.0\db_1\install\portlist.ini
    May 29, 2010 9:05:19 AM oracle.sysman.emcp.util.PortManager addPortEntries
    CONFIG: File C:\oracle\product\10.2.0\db_1\install\portlist.ini is successfully updated
    May 29, 2010 9:05:19 AM oracle.sysman.emcp.util.PortManager addPortEntries
    CONFIG: Updating file C:\oracle\product\10.2.0\db_1\install\portlist.ini ...
    May 29, 2010 9:05:19 AM oracle.sysman.emcp.util.FileUtil _copyFile
    CONFIG: Copying file C:\oracle\product\10.2.0\db_1\install\portlist.ini to C:\oracle\product\10.2.0\db_1\install\portlist.ini.emca.util.tmp
    May 29, 2010 9:05:19 AM oracle.sysman.emcp.util.FileUtil backupFile
    CONFIG: The original file C:\oracle\product\10.2.0\db_1\install\portlist.ini has been copied to C:\oracle\product\10.2.0\db_1\install\portlist.ini.emca.util.tmp
    May 29, 2010 9:05:19 AM oracle.sysman.emcp.util.PortManager addPortEntries
    CONFIG: Removing existing entries from portlist.ini Enterprise Manager Agent Port (JLLDB) = 3938
    May 29, 2010 9:05:19 AM oracle.sysman.emcp.util.PortManager addPortEntries
    CONFIG: Writing the selected ports to portlist.ini
    May 29, 2010 9:05:19 AM oracle.sysman.emcp.util.FileUtil _copyFile
    CONFIG: Copying file C:\oracle\product\10.2.0\db_1\install\portlist.ini.emca.util.tmp to C:\oracle\product\10.2.0\db_1\install\portlist.ini
    May 29, 2010 9:05:19 AM oracle.sysman.emcp.util.PortManager addPortEntries
    CONFIG: File C:\oracle\product\10.2.0\db_1\install\portlist.ini is successfully updated
    May 29, 2010 9:05:19 AM oracle.sysman.emcp.ParamsManager getParam
    CONFIG: No value was set for the parameter ORACLE_HOSTNAME.
    May 29, 2010 9:05:19 AM oracle.sysman.emcp.util.DBControlUtil startOMS
    INFO: Starting Database Control (this may take a while) ...
    May 29, 2010 9:05:19 AM oracle.sysman.emcp.util.PlatformInterface serviceCommand
    CONFIG: cmdType: 0
    May 29, 2010 9:05:19 AM oracle.sysman.emcp.util.PlatformInterface serviceCommand
    CONFIG: Starting Windows service...OracleDBConsoleJLLDB
    May 29, 2010 9:05:19 AM oracle.sysman.emcp.util.PlatformInterface serviceCommand
    CONFIG: Waiting for service 'OracleDBConsoleJLLDB' to fully start
    May 29, 2010 9:05:29 AM oracle.sysman.emcp.util.PlatformInterface serviceCommand
    CONFIG: Waiting for service 'OracleDBConsoleJLLDB' to fully start
    May 29, 2010 9:05:39 AM oracle.sysman.emcp.util.PlatformInterface serviceCommand
    CONFIG: Waiting for service 'OracleDBConsoleJLLDB' to fully start
    May 29, 2010 9:05:49 AM oracle.sysman.emcp.util.PlatformInterface serviceCommand
    CONFIG: Waiting for service 'OracleDBConsoleJLLDB' to fully start
    May 29, 2010 9:05:59 AM oracle.sysman.emcp.util.PlatformInterface serviceCommand
    CONFIG: Waiting for service 'OracleDBConsoleJLLDB' to fully start
    May 29, 2010 9:06:09 AM oracle.sysman.emcp.util.PlatformInterface serviceCommand
    CONFIG: Waiting for service 'OracleDBConsoleJLLDB' to fully start
    May 29, 2010 9:06:19 AM oracle.sysman.emcp.util.PlatformInterface serviceCommand
    CONFIG: Waiting for service 'OracleDBConsoleJLLDB' to fully start
    May 29, 2010 9:06:29 AM oracle.sysman.emcp.util.PlatformInterface serviceCommand
    CONFIG: Waiting for service 'OracleDBConsoleJLLDB' to fully start
    May 29, 2010 9:06:39 AM oracle.sysman.emcp.util.PlatformInterface serviceCommand
    CONFIG: Waiting for service 'OracleDBConsoleJLLDB' to fully start
    May 29, 2010 9:06:49 AM oracle.sysman.emcp.util.PlatformInterface serviceCommand
    CONFIG: Waiting for service 'OracleDBConsoleJLLDB' to fully start
    May 29, 2010 9:06:59 AM oracle.sysman.emcp.util.PlatformInterface serviceCommand
    CONFIG: Waiting for service 'OracleDBConsoleJLLDB' to fully start
    May 29, 2010 9:07:09 AM oracle.sysman.emcp.util.PlatformInterface serviceCommand
    CONFIG: Waiting for service 'OracleDBConsoleJLLDB' to fully start
    May 29, 2010 9:07:19 AM oracle.sysman.emcp.util.PlatformInterface serviceCommand
    CONFIG: Waiting for service 'OracleDBConsoleJLLDB' to fully start
    May 29, 2010 9:07:29 AM oracle.sysman.emcp.util.PlatformInterface serviceCommand
    CONFIG: Waiting for service 'OracleDBConsoleJLLDB' to fully start
    May 29, 2010 9:07:39 AM oracle.sysman.emcp.util.PlatformInterface serviceCommand
    CONFIG: Waiting for service 'OracleDBConsoleJLLDB' to fully start
    May 29, 2010 9:07:49 AM oracle.sysman.emcp.util.PlatformInterface serviceCommand
    CONFIG: Waiting for service 'OracleDBConsoleJLLDB' to fully start
    May 29, 2010 9:07:59 AM oracle.sysman.emcp.util.PlatformInterface serviceCommand
    CONFIG: Waiting for service 'OracleDBConsoleJLLDB' to fully start
    May 29, 2010 9:08:09 AM oracle.sysman.emcp.util.PlatformInterface serviceCommand
    CONFIG: Waiting for service 'OracleDBConsoleJLLDB' to fully start
    May 29, 2010 9:08:19 AM oracle.sysman.emcp.util.PlatformInterface serviceCommand
    CONFIG: Waiting for service 'OracleDBConsoleJLLDB' to fully start
    May 29, 2010 9:08:29 AM oracle.sysman.emcp.util.PlatformInterface serviceCommand
    CONFIG: Waiting for service 'OracleDBConsoleJLLDB' to fully start
    May 29, 2010 9:08:39 AM oracle.sysman.emcp.util.PlatformInterface serviceCommand
    CONFIG: Waiting for service 'OracleDBConsoleJLLDB' to fully start
    May 29, 2010 9:08:49 AM oracle.sysman.emcp.util.PlatformInterface serviceCommand
    CONFIG: Waiting for service 'OracleDBConsoleJLLDB' to fully start
    May 29, 2010 9:08:59 AM oracle.sysman.emcp.util.PlatformInterface serviceCommand
    CONFIG: Waiting for service 'OracleDBConsoleJLLDB' to fully start
    May 29, 2010 9:09:09 AM oracle.sysman.emcp.util.PlatformInterface serviceCommand
    CONFIG: Waiting for service 'OracleDBConsoleJLLDB' to fully start
    May 29, 2010 9:09:19 AM oracle.sysman.emcp.util.PlatformInterface serviceCommand
    CONFIG: Waiting for service 'OracleDBConsoleJLLDB' to fully start
    May 29, 2010 9:09:29 AM oracle.sysman.emcp.util.PlatformInterface serviceCommand
    CONFIG: Waiting for service 'OracleDBConsoleJLLDB' to fully start
    May 29, 2010 9:09:39 AM oracle.sysman.emcp.util.PlatformInterface serviceCommand
    CONFIG: Waiting for service 'OracleDBConsoleJLLDB' to fully start
    May 29, 2010 9:09:49 AM oracle.sysman.emcp.util.PlatformInterface serviceCommand
    CONFIG: Waiting for service 'OracleDBConsoleJLLDB' to fully start
    May 29, 2010 9:09:59 AM oracle.sysman.emcp.util.PlatformInterface serviceCommand
    CONFIG: Waiting for service 'OracleDBConsoleJLLDB' to fully start
    May 29, 2010 9:10:09 AM oracle.sysman.emcp.util.PlatformInterface serviceCommand
    CONFIG: Waiting for service 'OracleDBConsoleJLLDB' to fully start
    May 29, 2010 9:10:19 AM oracle.sysman.emcp.EMConfig perform
    SEVERE: Error starting Database Control
    Refer to the log file at C:\oracle\product\10.2.0\db_1\cfgtoollogs\emca\JLLDB\emca_2010-05-29_09-00-58-AM.log for more details.
    May 29, 2010 9:10:19 AM oracle.sysman.emcp.EMConfig perform
    CONFIG: Stack Trace: 
    oracle.sysman.emcp.exception.EMConfigException: Error starting Database Control
    	at oracle.sysman.emcp.EMDBPostConfig.performConfiguration(EMDBPostConfig.java:569)
    	at oracle.sysman.emcp.EMDBPostConfig.invoke(EMDBPostConfig.java:181)
    	at oracle.sysman.emcp.EMDBPostConfig.invoke(EMDBPostConfig.java:150)
    	at oracle.sysman.emcp.EMConfig.perform(EMConfig.java:155)
    	at oracle.sysman.emcp.EMConfigAssistant.invokeEMCA(EMConfigAssistant.java:479)
    	at oracle.sysman.emcp.EMConfigAssistant.performConfiguration(EMConfigAssistant.java:1123)
    	at oracle.sysman.emcp.EMConfigAssistant.statusMain(EMConfigAssistant.java:463)
    	at oracle.sysman.emcp.EMConfigAssistant.main(EMConfigAssistant.java:412)

    Sfi

    28 May 10 at 9:51 pm

  34. Hi,

    in step 3 you suggets adding a new line in etc/hosts file.
    Is this the new hostname with current IP address, or old hostname with current IP address?

    Christos

    1 Jun 10 at 4:18 am

  35. Yes, it’s the new hostname value.

    maclochlainn

    1 Jun 10 at 9:43 am

  36. It appears that the Windows Service is corrupted. Have you tried dropping it and recreating it?

    maclochlainn

    2 Jun 10 at 1:29 am

  37. Excellent post, it worked for me. Thank you very much. I highly recommend it.

    Hugo Mendoza

    4 Jun 10 at 10:22 am

  38. I think that dropping/recreating the Windows Service would help. Would you give me an idea of where that is documented?

    I have hunted through the Utilities doc but don’t see it in there. (But I wouldn’t be surprised to find that my interpretation of what Oracle’s trying to tell me is wrong either.)

    Thank you, Jack

    Jack

    13 Jun 10 at 1:10 pm

  39. The ORADIM utility creates, maintains, and deletes Windows services for the database.

    Create an instance by specifying the following options:

    -NEW -SID sid | -SRVC srvc | -ASMSID sid | -ASMSRVC srvc [-SYSPWD pass] [-STARTMODE auto|manual] [-SRVCSTART system|demand] [-PFILE file | -SPFILE [-SHUTMODE normal|immediate|abort] [-TIMEOUT secs] [-RUNAS osusr/ospass]

    Edit an instance by specifying the following options:

    -EDIT -SID sid | -ASMSID sid [-SYSPWD pass] [-STARTMODE auto|manual] [-SRVCSTART system|demand] [-PFILE file | -SPFILE] [-SHUTMODE normal|immediate|abort] [-SHUTTYPE srvc|inst] [-RUNAS osusr/ospass]

    Delete instances by specifying the following options:

    -DELETE -SID sid | -ASMSID sid | -SRVC srvc | -ASMSRVC srvc

    Startup services and instance by specifying the following options:

    -STARTUP -SID sid | -ASMSID sid [-SYSPWD pass] [-STARTTYPE srvc|inst|srvc,inst] [-PFILE filename | -SPFILE]

    Shutdown service and instance by specifying the following options:

    -SHUTDOWN -SID sid | -ASMSID sid [-SYSPWD pass] [-SHUTTYPE srvc|inst|srvc,inst] [-SHUTMODE normal|immediate|abort]

    Query for help by specifying the following parameters:

    -? | -h | -help

    maclochlainn

    13 Jun 10 at 2:02 pm

  40. This is a very helpfull article.
    But I am still not able to configure em

    I followed the given steps.

    Here is the error that i get.

    D:\app\324923\product\11.1.0\db_3\BIN>emca -config dbcontrol db -repos create
    STARTED EMCA at Jun 16, 2010 3:23:34 AM
    EM Configuration Assistant, Version 11.1.0.7.0 Production
    Copyright (c) 2003, 2005, Oracle.  All rights reserved.
     
    Enter the following information:
    Database SID: migis
    Listener port number: 1521
    Password for SYS user:
    Password for DBSNMP user:
    Password for SYSMAN user:
    Password for SYSMAN user: Email address for notifications (optional):
    Outgoing Mail (SMTP) server for notifications (optional):
    -----------------------------------------------------------------
     
    You have specified the following settings
     
    Database ORACLE_HOME ................ D:\app\324923\product\11.1.0\db_3
     
    Local hostname ................ 01HW265735.India.TCS.com
    Listener port number ................ 1521
    Database SID ................ migis
    Email address for notifications ...............
    Outgoing Mail (SMTP) server for notifications ...............
     
    -----------------------------------------------------------------
    Do you wish to continue? [yes(Y)/no(N)]: y
    Jun 16, 2010 3:24:20 AM oracle.sysman.emcp.EMConfig perform
    INFO: This operation is being logged at D:\app\324923\cfgtoollogs\emca\migis\e
    mca_2010_06_16_03_23_34.log.
    Jun 16, 2010 3:24:21 AM oracle.sysman.emcp.EMReposConfig createRepository
    INFO: Creating the EM repository (this may take a while) ...
    Jun 16, 2010 3:31:17 AM oracle.sysman.emcp.EMReposConfig invoke
    INFO: Repository successfully created
    Jun 16, 2010 3:31:30 AM oracle.sysman.emcp.EMReposConfig uploadConfigDataToRepos
    itory
    INFO: Uploading configuration data to EM repository (this may take a while) ...
    Jun 16, 2010 3:31:33 AM oracle.sysman.emcp.EMReposConfig invoke
    INFO: Refer to the log file at D:\app\324923\cfgtoollogs\emca\migis\emca_repos
    _config_.log for more details.
    Jun 16, 2010 3:31:33 AM oracle.sysman.emcp.EMReposConfig invoke
    SEVERE: Error uploading configuration data to the repository
    Jun 16, 2010 3:31:33 AM oracle.sysman.emcp.EMConfig perform
    SEVERE: Error uploading configuration data to the repository
    Refer to the log file at D:\app\324923\cfgtoollogs\emca\migis\emca_2010_06_16_
    03_23_34.log for more details.
    Could not complete the configuration. Refer to the log file at D:\app\324923\cfg
    toollogs\emca\migis\emca_2010_06_16_03_23_34.log for more details.

    Contents of log file are as below:

    INFO: [D:\app\324923\product\11.1.0\db_3\sysman\admin\emdrep\sql\core\configuration.xml]
    Jun 16, 2010 3:31:30 AM oracle.sysman.emdrep.config.EMSchemaConfiguration getConfigIntegrations
    INFO: Number of Configuration Instances:1
    Jun 16, 2010 3:31:30 AM oracle.sysman.emdrep.config.EMSchemaConfiguration getConfigIntegrations
    INFO: oracle.sysman.emdrep.util.TransxWrapper
        D:\app\324923\product\11.1.0\db_3\jlib/transx.zip
        D:\app\324923\product\11.1.0\db_3\xdk/lib/transx.zip
        D:\app\324923\product\11.1.0\db_3\lib/transx.zip
        D:\app\324923\product\11.1.0\db_3\lib/xmlparserv2.jar
        D:\app\324923\product\11.1.0\db_3\lib/xsu12.jar
        D:\app\324923\product\11.1.0\db_3\jlib/xdb.jar
        D:\app\324923\product\11.1.0\db_3\rdbms/jlib/xdb.jar
        D:\app\324923\product\11.1.0\db_3\oc4j/jdbc/lib/orai18n.jar
        D:\app\324923\product\11.1.0\db_3\jdbc/lib/ojdbc14.jar
        D:\app\324923\product\11.1.0\db_3\sysman/jlib/emCORE.jar
        D:\app\324923\product\11.1.0\db_3\oc4j/jdbc/lib/ojdbc14.jar
        D:\app\324923\product\11.1.0\db_3\oc4j/jdbc/lib/ojdbc14dms.jar
        D:\app\324923\product\11.1.0\db_3\jdbc/lib/ojdbc5.jar
        D:\app\324923\product\11.1.0\db_3\jdbc/lib/ojdbc5dms.jar
        D:\app\324923\product\11.1.0\db_3\oc4j/lib/dms.jar
        D:\app\324923\product\11.1.0\db_3\oc4j/jdbc/lib/dms.jar
        D:\app\324923\product\11.1.0\db_3\dms/lib/dms.jar
    Jun 16, 2010 3:31:31 AM oracle.sysman.emdrep.config.IConfigurationContext createConnection
    INFO: jdbcUrl = jdbc:oracle:thin:@(DESCRIPTION=(ADDRESS_LIST=(ADDRESS=(PROTOCOL=TCP)(HOST=01HW265735.India.TCS.com)(PORT=1521)))(CONNECT_DATA=(SERVICE_NAME=dgmigis)))
    Jun 16, 2010 3:31:32 AM oracle.sysman.emdrep.config.IConfigurationContext createConnection
    INFO: jdbcUrl = jdbc:oracle:oci:@(DESCRIPTION=(ADDRESS_LIST=(ADDRESS=(PROTOCOL=TCP)(HOST=01HW265735.India.TCS.com)(PORT=1521)))(CONNECT_DATA=(SERVICE_NAME=dgmigis)))
    Jun 16, 2010 3:31:32 AM oracle.sysman.emdrep.config.IConfigurationContext createConnection
    INFO: jdbcUrl = jdbc:oracle:thin:@(DESCRIPTION=(ADDRESS_LIST=(ADDRESS=(PROTOCOL=TCP)(HOST=01HW265735.India.TCS.com)(PORT=1521)))(CONNECT_DATA=(SERVICE_NAME=dgmigis)))
    Jun 16, 2010 3:31:33 AM oracle.sysman.emdrep.config.IConfigurationContext createConnection
    INFO: jdbcUrl = jdbc:oracle:oci:@(DESCRIPTION=(ADDRESS_LIST=(ADDRESS=(PROTOCOL=TCP)(HOST=01HW265735.India.TCS.com)(PORT=1521)))(CONNECT_DATA=(SERVICE_NAME=dgmigis)))
    Jun 16, 2010 3:31:33 AM oracle.sysman.emdrep.config.EMSchemaConfiguration$ConfigInstance run
    SEVERE: null
    java.lang.reflect.InvocationTargetException
    	at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
    	at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39)
    	at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
    	at java.lang.reflect.Method.invoke(Method.java:585)
    	at oracle.sysman.emdrep.config.EMSchemaConfiguration$ConfigInstance.run(EMSchemaConfiguration.java:469)
    	at java.lang.Thread.run(Thread.java:595)
    Caused by: oracle.sysman.emdrep.config.ConfigurationException: Cannot Create Connection:(DESCRIPTION=(ADDRESS_LIST=(ADDRESS=(PROTOCOL=TCP)(HOST=01HW265735.India.TCS.com)(PORT=1521)))(CONNECT_DATA=(SERVICE_NAME=dgmigis)))
    SYSMAN
    normal
    ORA-01017: invalid username/password; logon denied
     
    java.sql.SQLException: ORA-01017: invalid username/password; logon denied
     
    	at oracle.jdbc.driver.SQLStateMapping.newSQLException(SQLStateMapping.java:70)
    	at oracle.jdbc.driver.DatabaseError.newSQLException(DatabaseError.java:131)
    	at oracle.jdbc.driver.DatabaseError.throwSqlException(DatabaseError.java:204)
    	at oracle.jdbc.driver.T2CConnection.checkError(T2CConnection.java:693)
    	at oracle.jdbc.driver.T2CConnection.logon(T2CConnection.java:338)
    	at oracle.jdbc.driver.PhysicalConnection.(PhysicalConnection.java:508)
    	at oracle.jdbc.driver.T2CConnection.(T2CConnection.java:133)
    	at oracle.jdbc.driver.T2CDriverExtension.getConnection(T2CDriverExtension.java:53)
    	at oracle.jdbc.driver.OracleDriver.connect(OracleDriver.java:510)
    	at java.sql.DriverManager.getConnection(DriverManager.java:525)
    	at java.sql.DriverManager.getConnection(DriverManager.java:140)
    	at oracle.sysman.emdrep.config.IConfigurationContext.createConnection(IConfigurationContext.java:201)
    	at oracle.sysman.emdrep.config.IConfigurationContext.createConnection(IConfigurationContext.java:240)
    	at oracle.sysman.emdrep.config.IConfigurationContext.getConnection(IConfigurationContext.java:194)
    	at oracle.sysman.emdrep.config.IConfigurationContext.init(IConfigurationContext.java:98)
    	at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
    	at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39)
    	at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
    	at java.lang.reflect.Method.invoke(Method.java:585)
    	at oracle.sysman.emdrep.config.EMSchemaConfiguration$ConfigInstance.run(EMSchemaConfiguration.java:469)
    	at java.lang.Thread.run(Thread.java:595)
     
    	at oracle.sysman.emdrep.config.IConfigurationContext.createConnection(IConfigurationContext.java:245)
    	at oracle.sysman.emdrep.config.IConfigurationContext.getConnection(IConfigurationContext.java:194)
    	at oracle.sysman.emdrep.config.IConfigurationContext.init(IConfigurationContext.java:98)
    	... 6 more
    Caused by: java.sql.SQLException: ORA-01017: invalid username/password; logon denied
     
    	at oracle.jdbc.driver.SQLStateMapping.newSQLException(SQLStateMapping.java:70)
    	at oracle.jdbc.driver.DatabaseError.newSQLException(DatabaseError.java:131)
    	at oracle.jdbc.driver.DatabaseError.throwSqlException(DatabaseError.java:204)
    	at oracle.jdbc.driver.T2CConnection.checkError(T2CConnection.java:693)
    	at oracle.jdbc.driver.T2CConnection.logon(T2CConnection.java:338)
    	at oracle.jdbc.driver.PhysicalConnection.(PhysicalConnection.java:508)
    	at oracle.jdbc.driver.T2CConnection.(T2CConnection.java:133)
    	at oracle.jdbc.driver.T2CDriverExtension.getConnection(T2CDriverExtension.java:53)
    	at oracle.jdbc.driver.OracleDriver.connect(OracleDriver.java:510)
    	at java.sql.DriverManager.getConnection(DriverManager.java:525)
    	at java.sql.DriverManager.getConnection(DriverManager.java:140)
    	at oracle.sysman.emdrep.config.IConfigurationContext.createConnection(IConfigurationContext.java:201)
    	at oracle.sysman.emdrep.config.IConfigurationContext.createConnection(IConfigurationContext.java:240)
    	... 8 more
     
    Jun 16, 2010 3:31:33 AM oracle.sysman.emdrep.config.EMSchemaConfiguration perform
    WARNING: Exception Occured during Execution of oracle.sysman.emdrep.util.TransxWrapper
    Jun 16, 2010 3:31:33 AM oracle.sysman.emdrep.config.EMSchemaConfiguration perform
    SEVERE: FATAL EXCEPTIONS:
    FATAL Configuration Exceptions

    Regards,
    prabhjot

    prabhjot

    16 Jun 10 at 4:40 am

  41. The log is truncated in length. If you open it in an editor, could you re-paste it. It appears that the error occurs trying to createConnection, the initial question becomes was your %TNS_ADMIN% set in your session, and is the listener running?

    maclochlainn

    17 Jun 10 at 9:25 pm

  42. maclochlainn;

    Thank you! Deleting/re-creating the Windows service through ORADIM allowed me to run EMCA successfully to recreate the DBConsole service.

    I appreciate you sharing your expertise.

    Jack ‘donnachaich’

    Jack

    19 Jun 10 at 1:26 pm

  43. Thank you, after a 24 hour struggle to fix EM, I gave up and followed your instructions, EM was back to normal in 5 minutes.
    Many thanks.

    Semih BATTAL

    4 Aug 10 at 4:23 pm

  44. Very useful! Thanks a lot~

    Amy

    30 Sep 10 at 12:21 am

  45. I’m taking a class and have to install Oracle 11g on my windows 7 Professional x64. Everything installs thru the database config assistant. The text tells me to make note of the url for em on the last screen. The url is always empty. Prior to the last page I get a popup error saying no listener but I would not be able to get past the text’s step 4 withot listener. I make it to the bitter end and then get a popup error about the listener. When I click OK, I get the screen the book references but the url is empty. Any suggestions for someone learning Oracle?

    Zero

    15 Oct 10 at 2:49 am

  46. Thanks, The steps provided is very helpful and informative. Thanks again

    Antony Rajesh

    29 Oct 10 at 5:45 am

  47. Did not need to remove the SYSMAN user. (10.2.0)
    Modified windows domain name and recreated EM.
    Thanks a lot!
    Luc

    Luc Vinck

    16 Nov 10 at 6:37 am

  48. Will following these steps and recreating EM delete my scheduled jobs? Thanks for posting this by the way. Very informative!

    Dave

    14 Dec 10 at 7:54 pm

  49. I’m a new Oracle DBA. The environment I’m working in has no documentation. After a couple of days, I can’t seem to get EM running. Is there a way to install EM after Oracle has been installed and running? Oracle is installed in a linux environment btw. Any suggestions? Thank you.

    Giovanni

    28 Dec 10 at 8:34 am

  50. Most likely you need to uninstall and re-install if it’s damaged, as covered in the blog post. However, you may not need to do this, what are the errors when you try to start it?

    maclochlainn

    28 Dec 10 at 10:16 am

  51. Thank you for your blog on recreating EM repository. This is very helpful for me.
    I had a problem the first time trying to recreate the repository. It asked me for DBSNMP password which is only accepted if the password is enclosed with double quote. Another note is the drop repository somehow did not drop PUBLIC SYNONYM MGMT_AVAILABILITY the first time.

    David Himawan

    23 Jan 11 at 12:40 pm

  52. Hi,

    I’m taking Oracle Adm class and I’m unable to get my OEM console to launch. I’ve intalled oracle 11g R2 on Windows 7. I’ve tried followed the suggestions at the beginning of the blog by modifying the ip to hostname. I’m stuck on step 4 and 5. On step 5, do I have to login as sys or sysdba to execute the statements? Which data file are you referring on on step 5? Any feed back will be appreciated.

    Thanks,

    Kim

    Kim

    26 Jan 11 at 1:39 am

  53. Hi,

    I tried to recreate EM from the beginning of step 8 and finished successfully to step 9. But when I select yest to continue I received this stack trace

    WARNING: Error executing CMD /C C:\Users\kdang\Documents\ORACLE\product\11.2.0\dbhome_1\bin\nmesrvops.exe delete OracleDBConsoleKIMDB
    Jan 25, 2011 11:58:36 PM oracle.sysman.emcp.EMConfig perform
    SEVERE: Can't find file C:\Users\kdang\Documents\ORACLE\product\11.2.0\dbhome_1\L-MV-KIMDANG.CYBS.CORP_KIMDB\sysman\config\emoms.properties
    Refer to the log file at C:\Users\kdang\Documents\ORACLE\cfgtoollogs\emca\KIMDB\emca_2011_01_25_23_57_57.log for more details.
    Could not complete the configuration. Refer to the log file at C:\Users\kdang\Documents\ORACLE\cfgtoollogs\emca\KIMDB\emca_2011_01_25_23_57_57.log for more details.

    I’ve reviewed the logs and this is what it shows:

    "CONFIG: Couldn't get listener port. File C:\Users\kdang\Documents\ORACLE\product\11.2.0\dbhome_1\L-MV-KIMDANG.CYBS.CORP_null\sysman\config\emoms.properties does not exists
    Jan 26, 2011 12:07:14 AM oracle.sysman.emcp.ParamsManager getParam
    CONFIG: No value was set for the parameter SERVICE_NAME.
    Jan 26, 2011 12:07:14 AM oracle.sysman.emcp.util.GeneralUtil isLocalConnectionRequired
    CONFIG: isLocalConnectionRequired: true
    Jan 26, 2011 12:07:14 AM oracle.sysman.emcp.util.GeneralUtil initSQLEngine
    CONFIG: isLocalConnectionRequired: true. Connecting to database instance locally.
    Jan 26, 2011 12:07:14 AM oracle.sysman.emcp.util.GeneralUtil initSQLEngineLoacly
    CONFIG: SQLEngine connecting with SID: orcl, oracleHome: C:\Users\kdang\Documents\ORACLE\product\11.2.0\dbhome_1, and user: 
    Jan 26, 2011 12:07:15 AM oracle.sysman.emcp.util.GeneralUtil initSQLEngineLoacly
    CONFIG: ORA-12560: TNS:protocol adapter error
     
    oracle.sysman.assistants.util.sqlEngine.SQLFatalErrorException: ORA-12560: TNS:protocol adapter error
     
    	at oracle.sysman.assistants.util.sqlEngine.SQLEngine.executeImpl(SQLEngine.java:1655)
    	at oracle.sysman.assistants.util.sqlEngine.SQLEngine.connect(SQLEngine.java:978)
    	at oracle.sysman.emcp.util.GeneralUtil.initSQLEngineLoacly(GeneralUtil.java:445)
    	at oracle.sysman.emcp.util.GeneralUtil.initSQLEngine(GeneralUtil.java:637)
    	at oracle.sysman.emcp.DatabaseChecks.checkDbAvailabilityImpl(DatabaseChecks.java:118)
    	at oracle.sysman.emcp.DatabaseChecks.checkDbAvailability(DatabaseChecks.java:163)
    	at oracle.sysman.emcp.DatabaseChecks.getDbServiceName(DatabaseChecks.java:582)
    	at oracle.sysman.emcp.EMConfigAssistant.performConfiguration(EMConfigAssistant.java:1272)
    	at oracle.sysman.emcp.EMConfigAssistant.statusMain(EMConfigAssistant.java:574)
    	at oracle.sysman.emcp.EMConfigAssistant.main(EMConfigAssistant.java:522)

    Which line should I be looking for the listener port in the property file:

    C:\Users\kdang\Documents\ORACLE\product\11.2.0\dbhome_1\L-MV-KIMDANG.CYBS.CORP_KIMDB\sysman\config\emoms

    Thanks,

    Kim

    Kim

    26 Jan 11 at 2:19 am

  54. There aren’t any ports set in that emons.properties.ecma file. The port and service name that this message is complaining about relate to the standard listener and tnsnames.ora file. My hunch is that the driver of this problem lies some place else. Could you review all steps and post the full log files?

    maclochlainn

    27 Jan 11 at 9:36 pm

  55. Dear sir

    I have problem when I install Oracle 10.2.0.2.1 Enterprise Management Grid Control on window 2003 and window xp. It appear error “OUI:25031: Some of the configuration assistant failed……….” in OMS Configuration section.

    Your help will be appreciated.

    sovanndy

    4 Feb 11 at 9:50 pm

  56. Did you pass a relative as opposed to absolute path parameter during the installation? Check this forum entry or this Metalink Doc ID 352357.1 document.

    maclochlainn

    4 Feb 11 at 10:37 pm

  57. Could you explain me how to pass absolute path parameter during installation on window?

    And I don’t know to get Metalink Doc ID ID 352357.1.

    Thank for your help…..

    sovanndy

    5 Feb 11 at 6:37 am

  58. Thank you very much. It really worked.

    aod

    9 Feb 11 at 11:52 pm

  59. Hi I am using Amazon AMI to do some prototyping and whenever I stop the instance, the IP and hostname changes. I still have not getting any success reconfigure it yet….It does not give me any error while I am running the procedure describes above but EM just hangs…

    Neric

    12 Apr 11 at 6:18 pm

  60. When you say you restart the instance, does that mean the Oracle instance or the Operating System? Generally, the IP and hostname only change when you restart the OS. I’ve a hunch that it’s the latter. It appears that Amazon AMI boots a kernel as available on shared resources. In this type of cloud configuration, the IP and hostname are automatically assigned from a pool of resources and your registry files mapped to a standard kernel set of resources.

    maclochlainn

    12 Apr 11 at 9:33 pm

  61. […] changing windows hostname […]

    oracle em

    16 Apr 11 at 4:16 am

  62. Thanks for this post! It helped me a lot!

    MASK

    17 Apr 11 at 9:02 am

  63. em once worked, but now the console login says the db is not running. it is running. There was a time it was running fine. The db name was changed. Would that create a need to drop SYS and work through the listed steps?

    Is there any other way to correct for a wrong database name? How do you see the emconsole set up in Windows?

    johncr

    28 Apr 11 at 8:05 am

  64. Yes, the database name change would break it. Yes, you can edit and replace but it’s more work than reconfiguring it.

    maclochlainn

    28 Apr 11 at 2:17 pm

  65. You can set the properties in VBA, like this.

    maclochlainn

    28 Apr 11 at 2:25 pm

  66. […] كل شيء! الرابط هو: How to reconfigure Oracle Enterprise Manager on Windows – MacLochlainns Weblog نجاح خطوات الحل وتشغيل Oracle Enterprise Manager من […]

  67. awesome post!! thanks

    pfeiffer

    22 May 11 at 3:51 am

  68. The following is just a sample, a single example of a repeated result. Every time I add the new Object to drop, another is found to exist. Should I manually drop all synonyms owned by SYSMAN?

    Several pages of NO ERROR entries are then followed by the one error.. always a different, new object to drop.

    (See the end of the listing for all objects now being dropped each attempt)

    ****************
    ....TYPE body created.
     
    No errors.
     
    TYPE body created.
     
    No errors.
     
    TYPE body created.
     
    No errors.
     
    TYPE body created.
     
    No errors.
     
    TYPE body created.
     
    No errors.
     
    TYPE body created.
     
    No errors.
     
    TYPE body created.
     
    No errors.
     
    Synonym created.
     
     
    Synonym created.
     
     
    Synonym created.
     
    CREATE PUBLIC SYNONYM MGMT_SEVERITY_ARRAY FOR MGMT_SEVERITY_ARRAY
                          *
    ERROR at line 1:
    ORA-00955: name IS already used BY an existing object
    ************************
     
    Have dropped the following:
    DROP USER sysman CASCADE;
    DROP PUBLIC SYNONYM setemviewusercontext;
    DROP PUBLIC SYNONYM mgmt_severity_obj
    DROP PUBLIC SYNONYM mgmt_availability
    DROP PUBLIC SYNONYM MGMT_CURRENT_AVAILABILITY
    DROP PUBLIC SYNONYM MGMT_GUID_OBJ 
    DROP PUBLIC SYNONYM MGMT_SEVERITY_ARRAY
    DROP ROLE mgmt_user;
    DROP PUBLIC SYNONYM mgmt_target_blackouts;
    DROP USER mgmt_view;

    johncr

    24 May 11 at 12:39 pm

  69. As releases change additional synonyms require drops. Add to your list and retry. Having done this so long the incremental approach hs always worked best for me.

    maclochlainn

    24 May 11 at 5:57 pm

  70. Thank You, The first 6 steps worked like a charm

    Vasu

    29 May 11 at 9:33 pm

  71. Hi, My name is Mohammed Alam,

    From last one month i am facing a Problem while Installing 11g R1 in to my Windows 7 – 32 bit, its giving Error OUI – 25031, i format my Lappy lots of time but every time i am getting the same Error, i am realy tired, now i feel i am not able to learn Oracle, please please any one Help me in this. Pleaseeee

    Mohammed Alam

    15 Jun 11 at 8:06 am

  72. Do you have a white space in a folder name? You can’t have a white space in any of the folders of the Oracle home path. If that’s not it, let me know when the errors raised?

    maclochlainn

    18 Jun 11 at 9:47 am

  73. Use this following to delete the dependencies.. and also password requires “” is something weird

    SHUTDOWN IMMEDIATE;
    STARTUP RESTRICT;
    DROP USER sysman CASCADE;
    DROP ROLE mgmt_user;
    DROP USER mgmt_view;
    DECLARE
      CURSOR c1 IS
      SELECT owner, synonym_name name
      FROM dba_synonyms
      WHERE table_owner = 'SYSMAN';
    BEGIN
      FOR r1 IN c1 LOOP
        IF r1.owner = 'PUBLIC' THEN
          EXECUTE IMMEDIATE 'DROP PUBLIC SYNONYM '||r1.name;
        ELSE 
         EXECUTE IMMEDIATE 'DROP SYNONYM '||r1.owner||'.'||r1.name;
        END IF;
    END LOOP;
    END;
    /
    ALTER SYSTEM DISABLE RESTRICTED SESSION;

    Sarath

    29 Jun 11 at 5:55 am

  74. Thanks a lot.. It worked for me.

    Balakrishna

    16 Aug 11 at 8:50 am

  75. Hello,

    I am using OEM Grid control 10g for monitoring/reporting purposes and a bit new to OEM.

    I am able to generate database alerts sent via email say for DB_abc1 and also generate reports.

    I installed Oracle 10g agent on a another box and lets say with DB_abc2 running on it,and did not realise that there was a database control already installed on that box, so I

    1.Uninstalled database control on DB_abc2 box.
    2.Uninstalled Oracle 10g agent and re-installed it on DB_abc2 box.
    2.Was able to configure the DB_abc2 database from OEM Grid control gui ie the dbsnmp user password and was able to connect to it.

    But when I put in alert for things like ORA-XXXX errors I am not getting any emails, also when I put in database usage reports(to be sent via emails) the reports are not picking up any data, they are empty.

    I checked the agent on the box in question and the heart beat is OK, and I manually uploaded using “emctl upload” and it is sucessful.

    The only alerts I am getting for DB_abc1 is the agent up/down thats it.

    DB_abc1 is a 9208 database and DB_abc2 is 10201 database.

    Just wondering what I am missing ….any insight will be much appreciated as I am stuck here.

    Nicholas

    19 Aug 11 at 6:02 pm

  76. Unable to determine local host from URL REPOSITORY_URL=http://ud:%EM_UPLOAD_PORT
    %/em/upload/
    .

    pls sir give me solution which type of error is this ………

    udit

    20 Aug 11 at 3:00 am

  77. thanks bro… My em is working fine now. Thanks for ur great help….

    sam

    3 Sep 11 at 8:30 am

  78. Good Mr. McLaughlin,

    If you have the time. I have been trying to drop and create our 11.2.0 test EM for a bit now. It is on a windows machine which I need to connect to using remote connection. No luck.

    My apologies for typing it out, I can’t email from the remote machine.

    I have:

    1) restarted the EM (shutdown immediate followed by start up)
    2) checked the SID with:
    Select instance from v$thread;
    3) checked the port number of the listener with:
    Lsnrctl -> status
    4) Verified the instance is up and the listener is on
    5) Checked unique name with:
    show parameter DB_UNIQUE_NAME;

    yields appdevdbtest1

    6) set ORACLE_SID=appdevdbtest
    7) emca -deconfig dbcontrol db -repos drop

    Enter the following information:
    DATABASE SID: appdevdbtest
    Listener port NUMBER: 1521
    Password FOR SYS USER: "password"
    Password FOR SYSMAN USER: "password"
     
    Do you wish TO continue? [yes/no]: y
     
    WARNING: addining log file C:\oracle\cfgtoologs\emca\SP2-0640: NOT connected\emca_2011_09_08_08_27_19.log

    The log file states:

    Config: No DATABASE UNIQUE name available. will try TO retrieve it FROM the DB itself
     
    Config: Setting param: DB_UNIQUE_NAME VALUE: SP2-0640: NOT connected

    (which we know is appdevdbtest1)

    Thanks
    Tim

    Tim

    8 Sep 11 at 8:30 am

  79. Generally, the error from your log file occurs when TNS can’t resolve an address. Did you change your hostname? Why don’t you provide your tnsnames.ora file.

    maclochlainn

    11 Sep 11 at 11:13 pm

  80. The %EM_UPLOAD_PORT% is the environment variable for uploads. If you’re getting an error with it, the port may be in use. Is that what you needed? I’m not sure what you need.

    maclochlainn

    13 Sep 11 at 1:16 am

  81. You probably already surmised this but you’ve got one configuration value from the agent installation that wasn’t replaced by the grid installation. I’ve not troubleshot this one in a while and don’t recall where it is off-hand. I’d suggest you push this to Oracle Support, but I’d like to know what they tell you.

    maclochlainn

    13 Sep 11 at 1:20 am

  82. Note:

    I also added a

    SET ORACLE_UNQNAME=

    that wasn’t in the directions.

    I will be rebuilding this week, if I note any other direction changes I will update.

    Tim

    13 Sep 11 at 9:01 am

  83. Thanks a lot….

    Merwin

    30 Sep 11 at 12:13 am

  84. This is the most useful explanation I’ve found for this after searching for 2 days. I’ve bookmarked your blog in case I run into more trouble later, so I can look here first. Thank you for including the details like using double quotes for the passwords. Enormously helpful!

    Deseray

    14 Oct 11 at 2:20 pm

  85. Thanks a lot, it worked for me too under RedHat

    nicche

    28 Oct 11 at 9:38 am

  86. […] delighted to find a simple solution … that showed how to get a New EM […]

  87. Hi, i dropped my repository using

    emca -deconfig dbcontrol db -repos

    and, i re-created it using

    emca -config dbcontrol db -repos create

    now I’m getting an error

    Nov 10, 2011 2:43:44 AM oracle.sysman.emcp.EMDBPostConfig invoke
    WARNING:
    ************************  WARNING  ************************
    Management Repository has been placed in secure mode wherein Enterprise Manager data will be encrypted. The encryption key has been placed in the file: C:/product/11.2.0/dbhome_1/MADIMAD-B533821_smsDev/sysman/config/emkey.ora. Please ensure this file is backed up as the encrypted data will become unusable if this file is lost.
    ***********************************************************
    Nov 10, 2011 2:43:44 AM oracle.sysman.emcp.EMDBPostConfig invoke
    WARNING:
    Error starting Database Control. Please execute the following command(s).
     
     1) Set the environment variable ORACLE_UNQNAME to Database unique name
     2) C:\product\11.2.0\dbhome_1\bin\emctl.bat start dbconsole

    I did set my ORACLE_SID and am running in window xp with oracle version:

    Oracle Database 11g Enterprise Edition Release 11.2.0.1.0 - Production
    PL/SQL Release 11.2.0.1.0 - Production
    CORE    11.2.0.1.0      Production
    TNS for 32-bit Windows: Version 11.2.0.1.0 - Production
    NLSRTL Version 11.2.0.1.0 - Production

    desmond

    9 Nov 11 at 6:01 am

  88. Have you set the environment variable %ORACLE_UNQNAME% and run the emctl utility?

    maclochlainn

    9 Nov 11 at 10:07 pm

  89. yes i have set ORACLE_UNQNAME=smsdev
    set oracle_sid=smsdev
    and also my oracle_home=C:\product\11.2.0\dbhome_1
    but still getting same error

    desmond

    18 Nov 11 at 3:38 am

  90. I am running the the emca . but it hangs at the line mentioned.. doesn’t do anything in the background.
    not sure why is it asking dbsnmp password twice?

    I appreciate your help.

    Thanks,
    Sravanthi.

    D:\>emca -config dbcontrol db -repos create

    STARTED EMCA at Nov 27, 2011 9:52:30 PM
    EM Configuration Assistant, Version 11.1.0.5.0 Production
    Copyright (c) 2003, 2005, Oracle. All rights reserved.

    Enter the following information:
    Database SID: pnc11
    Listener port number: 1521
    Password for SYS user:
    Password for DBSNMP user:
    Password for DBSNMP user:

    srav

    27 Nov 11 at 11:01 pm

  91. Hi Sir,
    Iam using Oracle11g on my machine and i sucessfully uninstalled the emca and followed your above steps.
    I have dropped the sysman user but still i get the Java stack and it stops.

    —Done this Sucessfully—-

    DROP USER sysman CASCADE;
    DROP PUBLIC SYNONYM setemviewusercontext;
    DROP ROLE mgmt_user;
    DROP PUBLIC SYNONYM mgmt_target_blackouts;
    DROP USER mgmt_view;

    STARTED EMCA at DEC 10, 2011 1:17:37 AM
    EM Configuration Assistant, Version 11.2.0.0.2 Production
    Copyright (c) 2003, 2005, Oracle.  ALL rights reserved.
     
    Enter the following information:
    DATABASE SID: orcl
    Exception IN thread "main" oracle.sysman.emcp.exception.DatabaseUnavailableException: DATABASE instance unavailable.
    at oracle.sysman.emcp.DatabaseChecks.throwDBUnavailableException(DatabaseChecks.java:151)
            at oracle.sysman.emcp.DatabaseChecks.checkDbAvailabilityImpl(DatabaseChecks.java:144)
            at oracle.sysman.emcp.DatabaseChecks.checkDbAvailability(DatabaseChecks.java:163)
            at oracle.sysman.emcp.DatabaseChecks.getDbServiceName(DatabaseChecks.java:582)
            at oracle.sysman.emcp.EMConfigAssistant.performConfiguration(EMConfigAssistant.java:1272)
            at oracle.sysman.emcp.EMConfigAssistant.statusMain(EMConfigAssistant.java:574)
            at oracle.sysman.emcp.EMConfigAssistant.main(EMConfigAssistant.java:522)

    Your help will be appreciated.
    Thanks Sir.

    Muhammed

    9 Dec 11 at 2:19 pm

  92. It appears that the database instance wasn’t running based on the error message. Was that the case?

    maclochlainn

    9 Dec 11 at 6:27 pm

  93. Hi Sir,
    Thanks for reply
    please see below

    C:\>set SID_ORACLE=orcl
     
    C:\>emca -config dbcontrol db -repos create
     
    STARTED EMCA at Dec 10, 2011 9:18:30 PM
    EM Configuration Assistant, Version 11.2.0.0.2 Production
    Copyright (c) 2003, 2005, Oracle.  All rights reserved.
     
    Enter the following information:
    Database SID: orcl
    Exception in thread "main" oracle.sysman.emcp.exception.DatabaseUnavailableException: Database instance unavailable.
            at oracle.sysman.emcp.DatabaseChecks.throwDBUnavailableException(DatabaseChecks.java:151)
            at oracle.sysman.emcp.DatabaseChecks.checkDbAvailabilityImpl(DatabaseChecks.java:144)
            at oracle.sysman.emcp.DatabaseChecks.checkDbAvailability(DatabaseChecks.java:163)
            at oracle.sysman.emcp.DatabaseChecks.getDbServiceName(DatabaseChecks.java:582)
            at oracle.sysman.emcp.EMConfigAssistant.performConfiguration(EMConfigAssistant.java:1272)
            at oracle.sysman.emcp.EMConfigAssistant.statusMain(EMConfigAssistant.java:574)
            at oracle.sysman.emcp.EMConfigAssistant.main(EMConfigAssistant.java:522)
     
    C:\>

    Muhammed Faraz

    10 Dec 11 at 10:20 am

  94. Enterprise manager onfiguration failed due to the following error –
    Error uploading configuration data to the repository

    SOLUTION:

    My problem was, I`ve instaled 3 ethernet cards in the server. I had to turned off 2 of them and then reinstal database.
    This solve my problem and EM start to work correctly.

    janko

    20 Dec 11 at 8:16 am

  95. He! Its working

    Thanks

    sandesh

    5 Jan 12 at 3:20 am

  96. Sir
    Host IP address has been changed from 10.x.y.z to 10.m.n.o in database server due to network issue.EM is not working in oracle 11g with solaris 10 Operating System after this change.Is there any change required in any file of EM to start EM.If so ,kindly give details in which file the IP has to be changed.
    Thanks
    Regards
    Raju
    Mumbai

    raju

    13 Jan 12 at 6:29 pm

  97. Rebuilding the Oracle EM is the safest course. Anything else requires knowing all the database values that must change as well as configuration files.

    maclochlainn

    13 Jan 12 at 6:42 pm

  98. Hello,
    This worked perfectly on my other database server.
    I encountered problem with starting database control.
    I am getting this error even I manually dropped sysman and other described above.

    Do you wish TO continue? [yes(Y)/no(N)]: y
    18/01/2012 01:25:36 π oracle.sysman.emcp.EMConfig perform
    INFO: This operation IS being logged at E:\oracle\product\10.2.0\db_1\cfgtoollogs\emca\APPDB\emca_2012-01-18_01-25-10-π.log.
    18/01/2012 01:25:45 π oracle.sysman.emcp.EMReposConfig createRepository
    INFO: Creating the EM repository (this may take a while) ...
    18/01/2012 01:28:20 π oracle.sysman.emcp.EMReposConfig invoke
    INFO: Repository successfully created
    18/01/2012 01:28:30 π oracle.sysman.emcp.util.DBControlUtil secureDBConsole
    INFO: Securing DATABASE Control (this may take a while) ...
    18/01/2012 01:28:49 π oracle.sysman.emcp.util.DBControlUtil secureDBConsole
    INFO: DATABASE Control secured successfully.
    18/01/2012 01:28:49 π oracle.sysman.emcp.util.DBControlUtil startOMS
    INFO: Starting DATABASE Control (this may take a while) ...
    18/01/2012 01:38:09 π oracle.sysman.emcp.EMConfig perform
    SEVERE: Error starting DATABASE Control
    Refer TO the log file at E:\oracle\product\10.2.0\db_1\cfgtoollogs\emca\APPDB\emca_2012-01-18_01-25-10-π.log FOR more details.
    Could NOT complete the configuration. Refer TO the log file at E:\oracle\product
    \10.2.0\db_1\cfgtoollogs\emca\APPDB\emca_2012-01-18_01-25-10-π.log FOR more details.

    In the Log file I able to find this,

    CONFIG: ORA-01031: insufficient privileges
     
    oracle.sysman.assistants.util.sqlEngine.SQLFatalErrorException: ORA-01031: insufficient privileges
     
    	at oracle.sysman.assistants.util.sqlEngine.SQLEngine.executeImpl(SQLEngine.java:1474)
    	at oracle.sysman.assistants.util.sqlEngine.SQLEngine.CONNECT(SQLEngine.java:821)
    	at oracle.sysman.emcp.util.GeneralUtil.initSQLEngine(GeneralUtil.java:363)
    	at oracle.sysman.emcp.DatabaseChecks.checkDbAvailabilityImpl(DatabaseChecks.java:104)
    	at oracle.sysman.emcp.DatabaseChecks.checkDbAvailability(DatabaseChecks.java:146)
    	at oracle.sysman.emcp.DatabaseChecks.isASMDb(DatabaseChecks.java:718)
    	at oracle.sysman.emcp.EMConfigAssistant.getParamsWarnsList(EMConfigAssistant.java:1812)
    	at oracle.sysman.emcp.EMConfigAssistant.getDisplayAndPromptWarnsParms(EMConfigAssistant.java:2295)
    	at oracle.sysman.emcp.EMConfigAssistant.performConfiguration(EMConfigAssistant.java:947)
    	at oracle.sysman.emcp.EMConfigAssistant.statusMain(EMConfigAssistant.java:470)
    	at oracle.sysman.emcp.EMConfigAssistant.main(EMConfigAssistant.java:419)
    18/01/2012 01:25:15 ã oracle.sysman.emcp.DatabaseChecks isASMDb
    CONFIG: DATABASE instance unavailable.

    Appreciate your time and attention,

    Anil Koyalkar

    18 Jan 12 at 4:12 am

  99. Is this an eBusiness Suite installation?

    maclochlainn

    18 Jan 12 at 6:29 pm

  100. No, Its a databaser server running GIS applications behind.

    Anil Koyalkar

    19 Jan 12 at 12:24 am

  101. Is it connecting to a single instance, or multiple instances? It appears from the log that the second database may have been off line.

    maclochlainn

    19 Jan 12 at 2:15 am

  102. wanted to install dbconsole on Oracle 11g but running into problems.First emca is saying incorect usage and is listing options and parameters. When l start dbconsole service through services.mcs it fails and will be running a lot of(3 or 4) perl.exe java.exe and cmd which are consuming all memory.Please help.

    Ngoni

    24 Jan 12 at 4:52 am

  103. Hey, I was stuck on this for like 2 days! This concise procedure worked like a charm!! thank you!! :)

    dude from canada

    26 Jan 12 at 1:14 pm

  104. Thanks..this post really helped me!

    Sujan

    31 Jan 12 at 7:45 pm

  105. Thanks for this – I was iteratively going through and deleting public synonyms and then re-running the script. Fixing and problems then re-running.

    This has saved me hours!

    Thanks :-)

    DavrosFromSkaro

    3 Feb 12 at 12:55 am

  106. Having same problem as KIM. (FileNotFOUND exception)
    Following is my log file. Please help!

    05-Feb-2012 14:16:09 oracle.sysman.emcp.util.OUIInventoryUtil setOUILoc
    CONFIG: Setting oracle.installer.oui_loc TO E:\app\Zawiya\product\11.2.0\dbhome_1\oui
    05-Feb-2012 14:16:10 oracle.sysman.emcp.util.ClusterUtil isHASInstalled
    CONFIG: isHAInstalled: FALSE

    KS

    5 Feb 12 at 12:11 pm

  107. It appears the it can’t find the OUIInventory file.

    maclochlainn

    5 Feb 12 at 1:50 pm

  108. Thanks a lot. This is exactly what I wanted.

    Yousuf

    7 Feb 12 at 10:05 pm

  109. You have no replied this post please help
    wanted to install dbconsole on Oracle 11g but running into problems.First emca is saying incorect usage and is listing options and parameters. When l start dbconsole service through services.mcs it fails and will be running a lot of(3 or 4) perl.exe java.exe and cmd which are consuming all memory.Please help.

    Ngoni

    13 Feb 12 at 11:00 pm

  110. Ngoni,

    Sometimes my schedule doesn’t allow for assisting with individual debugging. After all, that’s the role of Oracle Worldwide Support. ;-)

    If you’d post the following I’ll try to take a look tomorrow:

    What’s in the log file from your reconfiguration?
    What error logs do you have from your starting attempts?
    What is the version of the database?
    Is the database a standalone instance or running Oracle Applications?

    maclochlainn

    13 Feb 12 at 11:19 pm

  111. Hie
    Sorry to sound bit demanding.l am learning.
    Here is the copy of the emdctl.trc

    2012-01-23 11:07:11 Thread-1280 WARN  http: snmehl_connect: CONNECT failed TO (ormac:80): No connection could be made because the target machine actively refused it. (error = 10061)
    2012-01-23 11:07:11 Thread-1280 ERROR main: nmectlr_reload: Can NOT CONNECT TO emdURL:http://ormac:/emd/main/
    2012-01-23 11:07:11 Thread-1280 ERROR main: nmectl.c:,reload failed WITH ret=1,num tries=1
    2012-01-23 11:07:36 Thread-2896 WARN  http: snmehl_connect: CONNECT failed TO (ormac:80): No connection could be made because the target machine actively refused it. (error = 10061)
    2012-01-23 11:08:18 Thread-3288 WARN  http: snmehl_connect: CONNECT failed TO (ormac:80): No connection could be made because the target machine actively refused it. (error = 10061)
    2012-01-23 11:08:18 Thread-3288 ERROR main: nmectla_agentctl: Error connecting TO http://ormac:/emd/main/. Returning STATUS code 1
    2012-01-23 11:23:51 Thread-1952 WARN  http: snmehl_connect: CONNECT failed TO (ormac:5100): No connection could be made because the target machine actively refused it. (error = 10061)
    2012-01-23 11:23:51 Thread-1952 ERROR main: nmectla_agentctl: Error connecting TO http://ormac:5100/emd/main/. Returning STATUS code 1
    2012-01-23 11:24:06 Thread-2900 WARN  http: snmehl_connect: CONNECT failed TO (ormac:5100): No connection could be made because the target machine actively refused it. (error = 10061)

    if l run this command

    emca -config dbcontrol db -repos CREATE

    it respond as follows
    Incorrect usage:

    oracle.sysman.emcp.EMCongfigAssistant options /parameter
     
    EMCA
    Started EMCA at DATE..............
    Exception IN thread main java.lang.NoClass.DeefFoundError: oracle/sysman/emSDK/conf/Platform

    Database Version OraDB11g.
    Its running Oracle Forms Application that l am currently developing{learning}.

    Hope the information is helpful

    Ngoni

    14 Feb 12 at 7:54 am

  112. Helo sir,

    I am vinay, i have installed Oracle 10g so i created some tables in the database also but its not opening Database home page but i am able to get through using the sql command plz help me how to get the data with out reinstall……send to
    vnkmr355@gmail.com

    vinay

    4 Mar 12 at 1:15 am

  113. […] reconfiguring OEM with Windows hostname change […]

  114. Hi Michael
    Thanks from me too for the post. Running 11.2.0.1.
    While I managed to recreate EM, i get an error “Failed to unlock all EM-related accounts”. Any help appreciated. Many thanks.

    Alexis

    6 Mar 12 at 10:03 am

  115. Speaking at UTOUG, I’ll redo a 11.2 this weekend.

    maclochlainn

    6 Mar 12 at 10:25 am

  116. Hi Michael!
    Thanks a lot for your article. Please, help me to understand what my mistake. I take all steps which you described, but I can’t create the em environment.

    26.03.2012 17:31:49 oracle.sysman.emcp.EMConfig perform
    INFO: This operation IS being logged at /oracle/app/oracle/cfgtoollogs/emca/iias/emca_2012_03_26_17_30_56.log.
    26.03.2012 17:31:49 oracle.sysman.emcp.EMReposConfig createRepository
    INFO: Creating the EM repository (this may take a while) ...
    26.03.2012 17:38:38 oracle.sysman.emcp.EMReposConfig invoke
    INFO: Repository successfully created
    26.03.2012 17:38:42 oracle.sysman.emcp.EMReposConfig uploadConfigDataToRepository
    INFO: Uploading configuration DATA TO EM repository (this may take a while) ...
    26.03.2012 17:39:39 oracle.sysman.emcp.EMReposConfig invoke
    INFO: Uploaded configuration DATA successfully
    log4j:WARN No appenders could be found FOR logger (emSDK.config).
    log4j:WARN Please initialize the log4j system properly.
    26.03.2012 17:39:41 oracle.sysman.emcp.EMAgentConfig updateTargets
    SEVERE: Error parsing target FROM file /oracle/app/oracle/product/11.2.0/dbhome_1/sysman/emd/targets.xml :: Expected 'EOF'.
    26.03.2012 17:39:41 oracle.sysman.emcp.EMConfig perform
    SEVERE: Error updating /oracle/app/oracle/product/11.2.0/dbhome_1/sysman/emd/targets.xml
    Refer TO the log file at /oracle/app/oracle/cfgtoollogs/emca/iias/emca_2012_03_26_17_30_56.log FOR more details.
    Could NOT complete the configuration. Refer TO the log file at /oracle/app/oracle/cfgtoollogs/emca/iias/emca_2012_03_26_17_30_56.log FOR more details.

    Maria

    26 Mar 12 at 6:54 am

  117. I’ve a hunch from the path statements that you’re working in an eBusiness Suite environment. Which version is it?

    maclochlainn

    26 Mar 12 at 11:07 am

  118. As far as I can know, we don’t work in an eBusiness Suite environment. But I am not a professional and I can be mistaken, if you prompt as it to find out, I will execute all steps which you tell. Thank you very much.

    Maria

    27 Mar 12 at 2:44 am

  119. Where are at you any ideas how to solve my problem? I will be very grateful.

    Maria

    29 Mar 12 at 6:57 am

  120. It’s a busy time for me. I won’t be able to create the test case until the next weekend. I’m pretty sure, it’ll be done then. I’ll update you when I get it done.

    maclochlainn

    2 Apr 12 at 1:09 am

  121. Great job , this work for me also , thanks fot tip

    Catalin

    19 Apr 12 at 10:52 am

  122. good I have a problem with the installation of oracle 10g enterprise something the installation in a notebook in the house of a friend of mine works perfect but when I’m in mine does not connect Unable to connect win7 is installed on the hard b
    http://casa-pc:1158/em/console/database/home

    Firefox can not Establish connection to the server to at home-pc: 1158.

    Could the site be temporarily unavailable or too busy. Try again in a FEW
    moments.
    If you are unable to load Any pages, check your computer’s network
    connection.
    If your computer or network is protected by a firewall or proxy, make sure
    That Firefox is permitted to access the Web.

    carrpet

    26 Apr 12 at 10:31 pm

  123. Hi,
    I installed 11g Standard Edition with Enterprise Manager. I imported data from 10g. I am now getting a problem when trying to access em from the browser (502 Service Unavailable). The em_application log is below:

    12/05/14 16:31:26.470 em: Servlet error
    javax.servlet.UnavailableException: Service IS NOT initialized correctly. OMS version 10.2.0.4.2 IS NOT compatible WITH repository version 10.1.0.2.0.
    	at oracle.sysman.eml.app.ContextInitFilter.doFilter(ContextInitFilter.java:253)
    	at com.evermind[Oracle Containers FOR J2EE 10g (10.1.3.4.0) ].server.http.FileRequestDispatcher.handleWithFilter(FileRequestDispatcher.java:135)
    	at com.evermind[Oracle Containers FOR J2EE 10g (10.1.3.4.0)].server.http.FileRequestDispatcher.unprivileged_forwardInternal(FileRequestDispatcher.java:283)
    	at com.evermind[Oracle Containers FOR J2EE 10g (10.1.3.4.0)].server.http.FileRequestDispatcher.access$100(FileRequestDispatcher.java:29)
    	at com.evermind[Oracle Containers FOR J2EE 10g (10.1.3.4.0)].server.http.FileRequestDispatcher$2.oc4jRun(FileRequestDispatcher.java:254)
    	at oracle.oc4j.security.OC4JSecurity.doPrivileged(OC4JSecurity.java:284)
    	at com.evermind[Oracle Containers FOR J2EE 10g (10.1.3.4.0) ].server.http.FileRequestDispatcher.forwardInternal(FileRequestDispatcher.java:259)
    	at com.evermind[Oracle Containers FOR J2EE 10g (10.1.3.4.0)].server.http.HttpRequestHandler.doProcessRequest(HttpRequestHandler.java:868)
    	at com.evermind[Oracle Containers FOR J2EE 10g (10.1.3.4.0)].server.http.HttpRequestHandler.processRequest(HttpRequestHandler.java:453)
    	at com.evermind[Oracle Containers FOR J2EE 10g (10.1.3.4.0)].server.http.HttpRequestHandler.serveOneRequest(HttpRequestHandler.java:221)
    	at com.evermind[Oracle Containers FOR J2EE 10g (10.1.3.4.0) ].server.http.HttpRequestHandler.run(HttpRequestHandler.java:122)
    	at com.evermind[Oracle Containers FOR J2EE 10g (10.1.3.4.0) ].server.http.HttpRequestHandler.run(HttpRequestHandler.java:111)
    	at oracle.oc4j.network.ServerSocketReadHandler$SafeRunnable.run(ServerSocketReadHandler.java:260)
    	at com.evermind[Oracle Containers FOR J2EE 10g (10.1.3.4.0)].util.ReleasableResourcePooledExecutor$MyWorker.run(ReleasableResourcePooledExecutor.java:303)
    	at java.lang.Thread.run(Thread.java:595)

    How do I fix this (I am new to database installs)?
    Any info would be much appreciated.
    Regards,
    Carl

    carl

    15 May 12 at 4:01 am

  124. The core error message is that “10.2.0.4.2 IS NOT compatible WITH repository version 10.1.0.2.0″. This appears to mean that your imported repository isn’t compatible with the Oracle 11g executables. You’ll need to rebuild the repository in Oracle 11g.

    maclochlainn

    15 May 12 at 9:08 am

  125. When trying to recreate the EM repository get this error in the log:

    Check if repos user already exists.

    OLD   6:    WHERE username=UPPER('&amp;EM_REPOS_USER');
    NEW   6:    WHERE username=UPPER('SYSMAN');
    OLD   8:   IF ( '&amp;EM_CHECK_TYPE' = 'EXISTS') THEN
    NEW   8:   IF ( 'NOT_EXISTS' = 'EXISTS') THEN
    OLD  11:       raise_application_error(-20000, '&amp;EM_REPOS_USER does not exists..');
    NEW  11:       raise_application_error(-20000, 'SYSMAN does not exists..');
    OLD  14:   ELSIF ( '&amp;EM_CHECK_TYPE' = 'NOT_EXISTS' ) THEN
    NEW  14:   ELSIF ( 'NOT_EXISTS' = 'NOT_EXISTS' ) THEN
    OLD  17:       raise_application_error(-20001, '&amp;EM_REPOS_USER already exists..');
    NEW  17:       raise_application_error(-20001, 'SYSMAN already exists..');
    OLD  21:       raise_application_error(-20002, 'Invalid Check type &amp;EM_CHECK_TYPE');
    NEW  21:       raise_application_error(-20002, 'Invalid Check type NOT_EXISTS');
     
    CREATE SYSMAN USER.
     
    No errors.
    DECLARE
    *
    ERROR at line 1:
    ORA-04042: PROCEDURE, FUNCTION, package, OR package body does NOT exist
    ORA-06512: at line 11
     
    CONFIG: ORA-04042: PROCEDURE, FUNCTION, package, OR package body does NOT exist
    ORA-06512: at line 11
     
    oracle.sysman.assistants.util.sqlEngine.SQLFatalErrorException: ORA-04042: PROCEDURE, FUNCTION, package, OR package body does NOT exist
    ORA-06512: at line 11
     
    	at oracle.sysman.assistants.util.sqlEngine.SQLEngine.executeImpl(SQLEngine.java:1474)
    	at oracle.sysman.assistants.util.sqlEngine.SQLEngine.executeScript(SQLEngine.java:848)
    	at oracle.sysman.assistants.util.sqlEngine.SQLPlusEngine.executeScript(SQLPlusEngine.java:267)
    	at oracle.sysman.assistants.util.sqlEngine.SQLPlusEngine.executeScript(SQLPlusEngine.java:308)
    	at oracle.sysman.emcp.EMReposConfig.createRepository(EMReposConfig.java:422)
    	at oracle.sysman.emcp.EMReposConfig.invoke(EMReposConfig.java:192)
    	at oracle.sysman.emcp.EMReposConfig.invoke(EMReposConfig.java:134)
    	at oracle.sysman.emcp.EMConfig.perform(EMConfig.java:171)
    	at oracle.sysman.emcp.EMConfigAssistant.invokeEMCA(EMConfigAssistant.java:486)
    	at oracle.sysman.emcp.EMConfigAssistant.performConfiguration(EMConfigAssistant.java:1142)
    	at oracle.sysman.emcp.EMConfigAssistant.statusMain(EMConfigAssistant.java:470)
    	at oracle.sysman.emcp.EMConfigAssistant.main(EMConfigAssistant.java:419)

    Eddy

    18 Jun 12 at 10:41 am

  126. Hello,

    very nice article.

    I am having trouble with Oracle Enterprise Manager.
    I would like to apply you for help.
    When I am starting service DBConsoleName, I get the error message with error code 2.

    I tried find out information, how to solve it, but I was unsuccesful.
    I tried to check some logfiles and some settings but I am newbie in this topic.
    Please, could somebody help me with this problem?
    Thank you for any help…
    Zdenek

    My email is zidz(at)email.cz.

    zdenek

    9 Jul 12 at 11:20 pm

  127. Can you provide some more information about the error(s) you’re encountering?

    maclochlainn

    10 Jul 12 at 2:04 am

  128. Thank you very much. this solved my problem

    Jasem Tell

    10 Jul 12 at 2:17 pm

  129. Thanks for the article, really helpful. I just wanna share what I experienced and for you to let me know if it is a good practice or not. I was just been curious though!!!.
    I omitted step 1-4, 7 and went straight to the goal.

    The installation was successful with minor errors noticed (probably because I let the system went into sleep mode).

    Everything worked really fine. I am using Windows 7. Do I need to check on those errors..or just let it be?

    These are the errors:

    WARNING: Error initializing SQL connection. SQL operations cannot be performed
    Jul 15, 2012 10:17:27 PM oracle.sysman.emcp.EMReposConfig invoke
    WARNING: Unable TO remove DBMS jobs.
    Jul 15, 2012 10:17:59 PM oracle.sysman.emcp.ParamsManager checkListenerStatusForDBControl
    WARNING: Error initializing SQL connection. SQL operations cannot be performed
    Jul 15, 2012 10:17:59 PM oracle.sysman.emcp.EMReposConfig invoke
    INFO: Dropping the EM repository (this may take a while) ...
    WARNING: Error executing CMD /C C:\app\Oracle\product\11.2.0\dbhome_1\bin\PARDeploy.bat -action deploy -parDir C:\app\Oracle\product\11.2.0\dbhome_1\sysman\prov\paf -force
    Jul 16, 2012 9:58:57 AM oracle.sysman.emcp.EMDBPostConfig configureSoftwareLibrary

    Ak lami

    22 Jul 12 at 9:24 am

  130. It appears that theses are all warnings, and it’s likely that your fine.

    maclochlainn

    22 Jul 12 at 1:26 pm

  131. Thanks…..

    Ak lami

    22 Jul 12 at 10:10 pm

  132. […] sort out how to run the DB Console […]

  133. Finally, after so much effort with so many methods, this one fixed the EM!

    THANK YOU!

    David Zhon

    27 Sep 12 at 5:59 pm

  134. I changed the IP address for an Oracle Windows server.
    I didn’t need to reinstall OEM (admittedly under older version of Oracle). In listener.ora I added an ADDRESS_LIST instead of the single old ADDRESS which had host=hostname. In the ADDRESS_LIST I added multiple addresses, these had HOST= to the following 127.0.0.1 and original IP address and new IP address. Also I added the host name to this. Additionally in the etc/hosts file for the platform I made the original host name an alias for the new IP address.

    Toby Chaloner

    28 Sep 12 at 4:06 am

  135. Hi Michael and every guru:

    I have run the same problem but with different error message:

    1)I issued:

    emca -deconfig dbcontrol db -repos drop

    Enterprise Manager configuration completed successfully

    2) I checked the SYSMAN user no longer existed and related role also dropped.

    3) Then issued:

     emca -config dbcontrol db -repos create

    Error message are :

    CONFIG: isCRSInstalled: false
    Nov 6, 2012 3:31:34 PM oracle.sysman.emcp.util.ClusterUtil isHASInstalled
    CONFIG: isHAInstalled: false
    Nov 6, 2012 3:31:39 PM oracle.sysman.emcp.ParamsManager setParam
    CONFIG: Setting param: SID value: MDORCL3
    Nov 6, 2012 3:31:39 PM oracle.sysman.emcp.DatabaseChecks getDbServiceName
    CONFIG: No service name available. Will try to set db_unique_name.db_domain
    Nov 6, 2012 3:31:39 PM oracle.sysman.emcp.ParamsManager getParam
    CONFIG: No value was set for the parameter REP_DB_RUNNING_HOST.
    Nov 6, 2012 3:31:39 PM oracle.sysman.emcp.ParamsManager getParam
    CONFIG: No value was set for the parameter DB_UNIQUE_NAME.
    Nov 6, 2012 3:31:39 PM oracle.sysman.emcp.ParamsManager getParam
    CONFIG: No value was set for the parameter ORACLE_HOSTNAME.
    Nov 6, 2012 3:31:39 PM oracle.sysman.emcp.ParamsManager getHost
    CONFIG: Host having instnces running for database null : MD-ORCL3.PERKINELMER.NET
    Nov 6, 2012 3:31:39 PM oracle.sysman.emcp.ParamsManager setParam
    CONFIG: Setting param: REP_DB_RUNNING_HOST value: MD-ORCL3.PERKINELMER.NET
    Nov 6, 2012 3:31:39 PM oracle.sysman.emcp.ParamsManager getParam
    CONFIG: No value was set for the parameter SYSMAN_PWD.
    Nov 6, 2012 3:31:39 PM oracle.sysman.emcp.ParamsManager getParam
    CONFIG: No value was set for the parameter PORT.
    Nov 6, 2012 3:31:39 PM oracle.sysman.emcp.ParamsManager getParam
    CONFIG: No value was set for the parameter ORACLE_HOSTNAME.
    Nov 6, 2012 3:31:39 PM oracle.sysman.emcp.util.ClusterUtil isCRSInstalled
    CONFIG: isCRSInstalled: false
    Nov 6, 2012 3:31:39 PM oracle.sysman.emcp.util.ClusterUtil getLocalNode
    CONFIG: Cluster.isCluster: false. Skip call to getLocalNode
    Nov 6, 2012 3:31:39 PM oracle.sysman.emcp.util.ClusterUtil getLocalNode
    CONFIG: isLocalNodeDone: true localNode: null
    Nov 6, 2012 3:31:39 PM oracle.sysman.emcp.ParamsManager getParam
    CONFIG: No value was set for the parameter DB_UNIQUE_NAME.
    Nov 6, 2012 3:31:39 PM oracle.sysman.emcp.ParamsManager getRepDbPort
    CONFIG: Couldn't get listener port. File C:\app\lium\product\11.2.0\dbhome_1\MD-ORCL3.PERKINELMER.NET_null\sysman\config\emoms.properties does not exists
    Nov 6, 2012 3:31:39 PM oracle.sysman.emcp.ParamsManager getParam
    CONFIG: No value was set for the parameter SERVICE_NAME.
    Nov 6, 2012 3:31:39 PM oracle.sysman.emcp.util.GeneralUtil isLocalConnectionRequired
    CONFIG: isLocalConnectionRequired: true
    Nov 6, 2012 3:31:39 PM oracle.sysman.emcp.util.GeneralUtil initSQLEngine
    CONFIG: isLocalConnectionRequired: true. Connecting to database instance locally.
    Nov 6, 2012 3:31:39 PM oracle.sysman.emcp.util.GeneralUtil initSQLEngineLoacly
    CONFIG: SQLEngine connecting with SID: MDORCL3, oracleHome: C:\app\lium\product\11.2.0\dbhome_1, and user: 
    Nov 6, 2012 3:31:41 PM oracle.sysman.emcp.util.GeneralUtil initSQLEngineLoacly
    CONFIG: ORA-01031: insufficient privileges
     
    oracle.sysman.assistants.util.sqlEngine.SQLFatalErrorException: ORA-01031: insufficient privileges
    	at oracle.sysman.assistants.util.sqlEngine.SQLEngine.executeImpl(SQLEngine.java:1655)
    	at oracle.sysman.assistants.util.sqlEngine.SQLEngine.connect(SQLEngine.java:978)
    	at oracle.sysman.emcp.util.GeneralUtil.initSQLEngineLoacly(GeneralUtil.java:445)
    	at oracle.sysman.emcp.util.GeneralUtil.initSQLEngine(GeneralUtil.java:637)
    	at oracle.sysman.emcp.DatabaseChecks.checkDbAvailabilityImpl(DatabaseChecks.java:118)
    	at oracle.sysman.emcp.DatabaseChecks.checkDbAvailability(DatabaseChecks.java:163)
    	at oracle.sysman.emcp.DatabaseChecks.getDbServiceName(DatabaseChecks.java:582)
    	at oracle.sysman.emcp.EMConfigAssistant.performConfiguration(EMConfigAssistant.java:1272)
    	at oracle.sysman.emcp.EMConfigAssistant.statusMain(EMConfigAssistant.java:574)
    	at oracle.sysman.emcp.EMConfigAssistant.main(EMConfigAssistant.java:522)

    Please help to provide any hint.

    Greatly appreciate any helps!

    Ming

    Ming Liu

    6 Nov 12 at 1:52 pm

  136. Ming,

    Does the operating system user have access to the SYS account? You can check that by running the following from the command line:

    sqlplus '/ as sysdba'

    The quotes should no longer be required but they provide comfort to some folks (memories of a bygone point in time).

    maclochlainn

    10 Nov 12 at 1:58 pm

  137. I ended up having to use a slightly modified script to the one you provided in step 7 above.

    DROP USER sysman CASCADE;
    DROP PUBLIC SYNONYM setemviewusercontext;
    DROP ROLE mgmt_user;
    DROP PUBLIC SYNONYM mgmt_target_blackouts;
    DROP USER mgmt_view;
    spool .\synonyms.SQL
    SELECT 'drop public synonym '||object_name||';' FROM dba_objects WHERE object_type='SYNONYM' AND (object_name LIKE 'MGMT_%' OR object_name LIKE 'SMP_%' OR object_name LIKE 'EMD_%' OR object_name LIKE 'ECM_%') AND STATUS='INVALID';
    spool off
    @.\synonyms.SQL

    Finto

    12 Dec 12 at 6:36 am

  138. I was not able to configure the EM; I am unable to detect the error. Could you please help me locate it?
    thank you:

    STARTED EMCA at DEC 14, 2012 1:08:48 PM
    EM Configuration Assistant, Version 10.2.0.1.0 Production
    Copyright (c) 2003, 2005, Oracle.  ALL rights reserved.
     
    Enter the following information:
    DATABASE SID: oracle
    Listener port NUMBER: 1521
    Password FOR SYS USER:
    Password FOR DBSNMP USER:
    Password FOR SYSMAN USER:
    Password FOR SYSMAN USER: Email address FOR notifications (optional):
    Outgoing Mail (SMTP) server FOR notifications (optional):
    -----------------------------------------------------------------
     
    You have specified the following settings
     
    DATABASE ORACLE_HOME ................ d:\oracle\product\10.2.0\db_1
     
    DATABASE hostname ................ hostname.us.company.com
    Listener port NUMBER ................ 1521
    DATABASE SID ................ oracle
    Email address FOR notifications ...............
    Outgoing Mail (SMTP) server FOR notifications ...............
     
    -----------------------------------------------------------------
    Do you wish TO continue? [yes(Y)/no(N)]: Y
    DEC 14, 2012 1:09:45 PM oracle.sysman.emcp.util.EMCALogManager addLogFileInternal
    WARNING: Adding log file d:\oracle\product\10.2.0\db_1\cfgtoollogs\emca\SP2-0640: NOT connected\emca_2012-12-14_01-08-48-PM.log failed. Messages will NOT be logged IN this file.
    DEC 14, 2012 1:09:46 PM oracle.sysman.emcp.EMConfig perform
    INFO: This operation IS being logged at d:\oracle\product\10.2.0\db_1\cfgtoollogs\emca\SP2-0640: NOT connected\emca_2012-12-14_01-08-48-PM.log.
    DEC 14, 2012 1:09:47 PM oracle.sysman.emcp.EMReposConfig createRepository
    INFO: Creating the EM repository (this may take a while) ...
    DEC 14, 2012 1:09:47 PM oracle.sysman.emcp.EMReposConfig invoke SEVERE: Error creating the repository
    DEC 14, 2012 1:09:47 PM oracle.sysman.emcp.EMReposConfig invoke INFO: Refer TO the log file at d:\oracle\product\10.2.0\db_1\cfgtoollogs\emca\SP 2-0640: NOT connected\emca_repos_create_.log FOR more details.
    DEC 14, 2012 1:09:47 PM oracle.sysman.emcp.EMConfig perform
    SEVERE: Error creating the repository
    Refer TO the log file at d:\oracle\product\10.2.0\db_1\cfgtoollogs\emca\SP2-0640: NOT connected\emca_2012-12-14_01-08-48-PM.log FOR more details.
    Could NOT complete the configuration. Refer TO the log file at d:\oracle\product\10.2.0\db_1\cfgtoollogs\emca\SP2-0640: NOT connected\emca_2012-12-14_01-08-48-PM.log FOR more details.

    Daffodil

    14 Dec 12 at 3:26 am

  139. Sure, when in a position to do so. Only you can see what’s posted at present.

    maclochlainn

    14 Dec 12 at 4:08 pm

  140. Hallo,I have run a problem with error message:

    a. I issued:

    emca -config dbcontrol db -repos recreate

    b. then i have this error:

    "SEVERE: Cannot start Database Control. The following ports are already in use: [
    EM agent port:3938]."

    Logs:
    You have specified the following settings

    Database ORACLE_HOME ................ 
     
    E:\oracle\product\10.2.0\db_1
    Database hostname ................ srv-cdbqs01.enercon.de
    Listener port number ................ 1521
    Database SID ................ orcl
     
    Jan 31, 2013 2:21:36 PM oracle.sysman.emcp.EMReposConfig invoke
    INFO: Repository successfully created
    java.io.IOException: The handle is invalid
            at java.io.FileInputStream.close0(Native Method)
            at java.io.FileInputStream.close(FileInputStream.java:245)
            at sun.nio.cs.StreamDecoder$CharsetSD.implClose(StreamDecoder.java:505)
            at sun.nio.cs.StreamDecoder.close(StreamDecoder.java:198)
            at java.io.InputStreamReader.close(InputStreamReader.java:187)
            at java.io.BufferedReader.close(BufferedReader.java:502)
            at oracle.sysman.assistants.util.sqlEngine.SQLEngine$ErrorStreamReader.run(SQLEngine.java:2406)
            at java.lang.Thread.run(Thread.java:595)
    Jan 31, 2013 2:21:45 PM oracle.sysman.emcp.EMConfig perform
    SEVERE: Cannot start Database Control. The following ports are already in use: [EM agent port:3938].
    Refer to the log file at E:\oracle\product\10.2.0\db_1\cfgtoollogs\emca\orcl\emca_2013-01-31_01-21-24-PM.log for more details.
    java.io.IOException: The handle is invalid
            at java.io.FileInputStream.close0(Native Method)
            at java.io.FileInputStream.close(FileInputStream.java:245)
            at sun.nio.cs.StreamDecoder$CharsetSD.implClose(StreamDecoder.java:505)
            at sun.nio.cs.StreamDecoder.close(StreamDecoder.java:198)
            at java.io.InputStreamReader.close(InputStreamReader.java:187)
            at java.io.BufferedReader.close(BufferedReader.java:502)
            at oracle.sysman.assistants.util.sqlEngine.SQLEngine$ErrorStreamReader.run(SQLEngine.java:2406)
            at java.lang.Thread.run(Thread.java:595)
    Could not complete the configuration. Refer to the log file at E:\oracle\product\10.2.0\db_1\cfgtoollogs\emca\orcl\emca_2013-01-31_01-21-24-PM.log for more details.

    Jo

    1 Feb 13 at 12:27 am

  141. The error message is telling you that the ports are already in use that Oracle Enterprise Manager is trying to use. Check the log file (emca_2013-01-31_01-21-24-PM.log) that’s referenced, and you can use the Perl socket code provided in this older blog to check whether the ports are open or not.

    maclochlainn

    3 Feb 13 at 10:46 am

  142. thanks! the ports 1158,3938,5540 are open, i’ve verified with the “Perl socket” server and cliente. and again execute:

    emca -deconfig dbcontrol db -repos drop

    and again a Warning and error:

    STARTED EMCA at Feb 8, 2013 10:35:59 AM
    EM Configuration Assistant, Version 10.2.0.1.0 Production
    Copyright (c) 2003, 2005, Oracle.  All rights reserved.
     
    Enter the following information:
    Database SID: orcl
    Listener port number: 1521
    Password for SYS user:
    Password for SYSMAN user:
     
    Do you wish to continue? [yes(Y)/no(N)]: Y
    Feb 8, 2013 10:36:41 AM oracle.sysman.emcp.EMConfig perform
    INFO: This operation is being logged at E:\oracle\product\10.2.0\db_1\cfgtoollog
    s\emca\orcl\emca_2013-02-08_10-35-59-AM.log.
    Feb 8, 2013 10:36:45 AM oracle.sysman.emcp.EMDBPreConfig performDeconfiguration
    WARNING: EM is not configured for this database. No EM-specific actions can be performed.
    Feb 8, 2013 10:36:45 AM oracle.sysman.emcp.EMReposConfig dropRepository
    INFO: Dropping the EM repository (this may take a while) ...
    Feb 8, 2013 10:37:29 AM oracle.sysman.emcp.EMReposConfig invoke
    INFO: Repository successfully dropped
    java.io.IOException: The handle is invalidEnterprise Manager configuration compl
    eted successfully
            at java.io.FileInputStream.close0(Native Method)FINISHED EMCA at Feb 8, 2013 10:37:29 AM
            at java.io.FileInputStream.close(FileInputStream.java:245)
            at sun.nio.cs.StreamDecoder$CharsetSD.implClose(StreamDecoder.java:505)
            at sun.nio.cs.StreamDecoder.close(StreamDecoder.java:198)
            at java.io.InputStreamReader.close(InputStreamReader.java:187)
            at java.io.BufferedReader.close(BufferedReader.java:502)
            at oracle.sysman.assistants.util.sqlEngine.SQLEngine$ErrorStreamReader.run(SQLEngine.java:2406)
            at java.lang.Thread.run(Thread.java:595)

    The user SYSMAN and Role MGMT_USER, MGMT_VIEW and synonym MGMT_TARGET_BLACKOUTS, SETEMVIEWUSERCONTEXT are dropped and the variable (Oracle_SID, Oracle_home, Oracle_hostname, Oracle_unqname) set.

    Any ideas how to solve my problem? I will be very grateful:)

    Jo

    8 Feb 13 at 5:04 am

  143. the socket (perl) is running ok, but telnet no:

    E:\oracle\product\10.2.0\db_1\BIN> telnet 100.1.8.1 5500
    Connecting To 100.1.8.1...Could not open connection to the host, on port 5500: Connect failed.

    and in the logs emagent.trc ist

    2013-02-08 14:29:30 Thread-5744 WARN  http: snmehl_connect: connect failed to (srv-server:5500): No connection could be made because the target machine actively refused it.
     (error = 10061)
    2013-02-08 14:29:31 Thread-4564 ERROR ssl: 400: snmehl_read: error on read: An existing connection was forcibly closed by the remote host.
     (error = 10054)
    2013-02-08 14:29:31 Thread-4564 ERROR ssl: nzos_Handshake failed, ret=28862
    2013-02-08 14:29:31 Thread-4564 ERROR http: 400: Unable to initialize ssl connection with server, aborting connection attempt
    2013-02-08 14:29:37 Thread-4108 WARN  http: snmehl_connect: connect failed to (srv-server:5500): No connection could be made because the target machine actively refused it.
     (error = 10061)

    i don’t understand, what happened?

    Jo

    8 Feb 13 at 6:48 am

  144. :( the firewall is Off, maybe it is a problem with VM? … but how could i know…

    pls i need help..

    Jo

    12 Feb 13 at 2:31 am

  145. They’re working with localhost or a hostname?

    maclochlainn

    16 Feb 13 at 12:33 am

  146. They (the Perl sockets) are working with localhost or a hostname?

    maclochlainn

    16 Feb 13 at 12:33 am

  147. This post on setting up a static IP address may help some, but I’ve a hunch that you’re blocking ICMP communication. Check Step #9 in this older post for opening ICMP layer communication on Windows.

    maclochlainn

    16 Feb 13 at 12:39 am

  148. I installed Oracle 11g on a Windows 2008 R2 Standard Edition Server.
    After installation, I am not able to open the Enterprise Manager Console.
    When I do “emctl start dbconsole”, it says that the console has started successfully.
    But when I go to https://localhost:1158/em/, it just keeps saying that “there is a problem with website’s certificate”, even when I click on “Continue to this website (not recommended” link.
    I have done similar installation on another server and it worked just great, but on this server it is giving me a hard time.

    MJ

    20 Feb 13 at 12:15 am

  149. Have you verified that the listener is running on port 1158?

    maclochlainn

    20 Feb 13 at 8:05 pm

  150. Hello maclochlainn,

    your procedure is good, I was trying to configure EMCA from many days :(. After following your steps I successfully configured it, Thanks :)

    I have doubts regarding the procedure…
    1) is it advisable/permissible to edit “System32″ file?
    2) reboot a production server for changes to come in effect?

    Kindly clear my doubts as I configured on my local machine…
    thanks:)

    Mohib

    2 Apr 13 at 3:56 am

  151. You need to enter the IP resolution in the hosts file, but you don’t need to reboot the server for that to take effect.

    maclochlainn

    2 Apr 13 at 9:40 am

  152. Thanks. That worked for me too.

    Gaurav

    2 Apr 13 at 10:28 am

  153. Hi, i successfully configured in 1 system, but on my laptop it says I wont get configured… i will paste files for your reference, kindly help me out..

    actually i did procedure as mentioned by you, ie; drop, i did it, got errors then drop sysman etc then i created..

    Microsoft Windows [Version 6.2.9200]
    (c) 2012 Microsoft Corporation. All rights reserved.

    C:\Users\Mohib>set ORACLE_SID=oracle

    C:\Users\Mohib>emca -config dbcontrol db -repos create

    STARTED EMCA at Apr 7, 2013 2:39:55 PM
    EM Configuration Assistant, Version 11.1.0.5.0 Production
    Copyright (c) 2003, 2005, Oracle. All rights reserved.

    Enter the following information:

    Database SID: oracle
    Database Control is already configured for the database oracle
    You have chosen to configure Database Control for managing the database oracle
    This will remove the existing configuration and the default settings and perform
     a fresh configuration
    Do you wish to continue? [yes(Y)/no(N)]: yes
    Listener port number: 1521
    Password for SYS user:
    Password for DBSNMP user:
    Password for SYSMAN user:
    Password for SYSMAN user: Email address for notifications (optional):
    Outgoing Mail (SMTP) server for notifications (optional):
    -----------------------------------------------------------------
     
    You have specified the following settings
     
    Database ORACLE_HOME ................ F:\Oracle\app\Mohib\product\11.1.0\db_1
     
    Local hostname ................ hppc
    Listener port number ................ 1521
    Database SID ................ oracle
    Email address for notifications ...............
    Outgoing Mail (SMTP) server for notifications ...............
     
    -----------------------------------------------------------------
    Do you wish to continue? [yes(Y)/no(N)]: yes
    Apr 7, 2013 2:40:21 PM oracle.sysman.emcp.EMConfig perform
    INFO: This operation is being logged at F:\Oracle\app\Mohib\cfgtoollogs\emca\oracle\emca_2013_04_07_14_39_5.log.
    Apr 7, 2013 2:40:22 PM oracle.sysman.emcp.util.FileUtil backupFile
    WARNING: Could not backup file F:\Oracle\app\Mohib\product\11.1.0\db_1\sysman\config\emd.properties
    Apr 7, 2013 2:40:22 PM oracle.sysman.emcp.util.FileUtil backupFile
    WARNING: Could not backup file F:\Oracle\app\Mohib\product\11.1.0\db_1\sysman\config\emoms.properties
    Apr 7, 2013 2:40:22 PM oracle.sysman.emcp.util.FileUtil backupFile
    WARNING: Could not backup file F:\Oracle\app\Mohib\product\11.1.0\db_1\sysman\emd\targets.xml
    Apr 7, 2013 2:40:23 PM oracle.sysman.emcp.util.DBControlUtilstopOMS
    INFO: Stopping Database Control (this may take a while) ...
    Apr 7, 2013 2:40:23 PM oracle.sysman.emcp.EMReposConfig createRepository
    INFO: Creating the EM repository (this may take a while) ...
    Apr 7, 2013 2:42:27 PM oracle.sysman.emcp.EMReposConfig invoke
    SEVERE: Error creating the repository
    Apr 7, 2013 2:42:27 PM oracle.sysman.emcp.EMReposConfig invoke
    INFO: Refer to the log file at F:\Oracle\app\Mohib\cfgtoollogs\emca\oracle\emca_
    repos_create_.log for more details.
    Apr 7, 2013 2:42:27 PM oracle.sysman.emcp.EMConfig perform
    SEVERE: Error creating the repository
    Refer to the log file at F:\Oracle\app\Mohib\cfgtoollogs\emca\oracle\emca_2013_04_07_14_39_55.log for more details.
    Could not complete the configuration. Refer to the log file at F:\Oracle\app\Mohib\cfgtoollogs\emca\oracle\emca_2013_04_07_14_39_55.log for more details.
    #################hosts file#############
    localhost name resolution is handled within DNS itself.
    #	127.0.0.1       localhost
    #	172.16.113.128  mclaughlin11g mclaughlin11g.techtinker.com
    ###################listener.ora###########
    LISTENER =
      (DESCRIPTION_LIST =
        (DESCRIPTION =
          (ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC1522))
          (ADDRESS = (PROTOCOL = TCP)(HOST = hppc)(PORT = 1521))
        )
      )
     
    ##############tnsnames.ora############
    ORACLE =
      (DESCRIPTION =
        (ADDRESS = (PROTOCOL = TCP)(HOST = hppc)(PORT = 1521))
        (CONNECT_DATA =
          (SERVER = DEDICATED)
          (SERVICE_NAME = oracle)
        )
      )
     
    LISTENER_ORACLE =
      (ADDRESS = (PROTOCOL = TCP)(HOST = hppc)(PORT = 1521))

    if any more info needed plz let me know….

    Mohib

    7 Apr 13 at 3:21 am

  154. Mohib, It appears that it fails on configuration of the Windows Oracle Service. Did you attempt a previous installation? If so, you need to recover a prior registry and try again. You should always backup your registry before installing Oracle because if something goes one the registry doesn’t get properly cleaned up. A damaged registry would cause a failure like the you’ve encountered.

    maclochlainn

    7 Apr 13 at 11:00 am

  155. yes i had tried to configure EM before…ok so what should i do next?

    Mohib

    7 Apr 13 at 11:45 am

  156. Unfortunately, if you didn’t keep a backup of the Windows Registry, you should re-install the Windows Operating System or manually cleanup all residual Oracle values from the Windows Registry.

    maclochlainn

    7 Apr 13 at 2:33 pm

  157. its better to try with Oracle values in windows registry rather than reinstalling windows….ok “cleanup all residual Oracle values from the Windows Registry” in the sense should i deinstall oracle and again reinstall(with deleting oracle respective folder in windows registry)?
    thanks for your patience :)

    Mohib

    8 Apr 13 at 12:11 am

  158. Yes, if you’re going to cleanup the registry you should first try to uninstall Oracle, and then delete all the physical files. After that, you should cleanup the registry.

    maclochlainn

    8 Apr 13 at 12:19 am

  159. Thanks :) it worked!! just deleted everything of Oracle (2 DB’s) n removed Oracle folder from registry n then installed fresh Oracle, got the “EM URL” after setup/installation was complete ;)

    Mohib

    8 Apr 13 at 8:56 pm

  160. Just finished a fresh 11gr2 install on Windows 7 32 bit. Static IP prior to dbms install seems to be critical. The web connection to default ORCL db works fine (1158) but I can’t connect to my one locally created (5500) db. Just doesn’t want to find anything at that port. This is not the certificate error – just can’t find it. Any ideas? Thanks.

  161. I’m having problems with step 6. There is an exception being thrown when I try to enter my SYS password. See below. I’m a novice when it comes to DBA activities, but trying to learn, so let me know if you need any other information from me.

    STARTED EMCA at May 8, 2013 5:13:01 PM
    EM Configuration Assistant, Version 11.2.0.0.2 Production
    Copyright (c) 2003, 2005, Oracle.  All rights reserved.
     
    Enter the following information:
    Database SID: ldemodb
    Listener port number: 1521
    Password for SYS user:
    Password for SYS user: Exception in thread "main" java.lang.NoClassDefFoundError: HTTPClient/ProtocolNotSuppException
            at oracle.sysman.emd.targetIntg.agent.AgentTargetInstaller.(AgentTargetInstaller.java:235)
            at oracle.sysman.emcp.target.TargetManager.getAgentTargetInstaller(TargetManager.java:1008)
            at oracle.sysman.emcp.target.TargetManager.getLocalHost(TargetManager.java:1033)
            at oracle.sysman.emcp.ParamsManager.getLocalHost(ParamsManager.java:1037)
            at oracle.sysman.emcp.ParamsManager.getHost(ParamsManager.java:3020)
            at oracle.sysman.emcp.DatabaseChecks.validateUserCredentials(DatabaseChecks.java:1066)
            at oracle.sysman.emcp.ParamsManager.validatePassword(ParamsManager.java:3417)
            at oracle.sysman.emcp.EMConfigAssistant.promptForData(EMConfigAssistant.java:701)
            at oracle.sysman.emcp.EMConfigAssistant.promptForParams(EMConfigAssistant.java:2979)
            at oracle.sysman.emcp.EMConfigAssistant.displayWarnsAndPromptParams(EMConfigAssistant.java:3008)
            at oracle.sysman.emcp.EMConfigAssistant.getDisplayAndPromptWarnsParms(EMConfigAssistant.java:3033)
            at oracle.sysman.emcp.EMConfigAssistant.performConfiguration(EMConfigAssistant.java:1397)
            at oracle.sysman.emcp.EMConfigAssistant.statusMain(EMConfigAssistant.java:574)
            at oracle.sysman.emcp.EMConfigAssistant.main(EMConfigAssistant.java:522)

    Charlie

    8 May 13 at 3:46 pm

  162. Are you on Windows Home edition? It appears you can’t create a socket, which would point to missing network components in the OS or a network setup problem.

    maclochlainn

    9 May 13 at 8:19 am

  163. Dear maclochlainn
    Well l managed to figure out why em was failing to configure.The issue in the installation of the database.There are three options (General purpose/tra.., custom and warehouse..) if you choose the default, em will not be installed properly, but if you choose general purpose option it will install em perfectly.

    Good day

    Ngoni

    18 Jul 13 at 12:40 am

  164. I am using Windows Server 2012 with Oracle 11gR2
    each time I tried configuring the EM with orcl db I keep getting Severe: Error loading TransX: Socket read timed out. Every other thing works fine save the enterprise manager configuration.

    Interestly, this problem didn’t occur when my server was just a normal server. I promoted the machine to a primary domain controller and reinstall Oracle, then appeared the problem. my domain take structure “my-local.local”, so the full computer name is like “machine.my-local.local”

    I saw an article on Oracle forum on similar error, and it was resolved by setting the hosts file and turning firewall off. I tried that but no head way.

    I then saw your post, and follow the procedures but yet again, to no avail. Please kindly help

    Damilola

    21 Jul 13 at 1:23 pm

  165. Damilola, How much real memory is available to Windows?

    maclochlainn

    26 Jul 13 at 2:25 pm

  166. i have a issue while login during OEM internal error

    adnan

    3 Aug 13 at 2:45 am

  167. Adnan, An internal error? Do you mean an ORA-00600 or an OEM error?

    maclochlainn

    3 Aug 13 at 3:20 pm

  168. I am running Oracle 11gR2 on Windows 2003. I have followed the steps above multiple times, and am able to drop and create ok, get a fail to start dbconsole at the end. After that, when I try “emctl start dbconsole”, it takes forever (with bunch of dots output) and then fails.

    Looking at the emagent.log and emagent.trc, it looks like it’s trying to connect to https://:5500/em/etc., BUT, nothing is listening on port 5500!

    This is a pretty much out-of-box Oracle installation.

    Is there some bug that is causing it to try to connect to port 5500 vs. 1158, or is there a step to configure it to use 1158 vs. 5500?

    I’ve search support.oracle.com, but didn’t find anything.

    Thanks,
    Jim

    ohaya

    5 Oct 13 at 11:13 am

  169. Ohaya, check whether the service ever starts. If not, verify your network settings and configurations.

    maclochlainn

    12 Oct 13 at 9:22 pm

  170. Thanks so much!!! I lost during one day for solution this problem.

    Dop

    15 Nov 13 at 9:49 pm

  171. it did the thank you very much

    peter

    22 Nov 13 at 7:28 am

  172. it did the work

    peter

    22 Nov 13 at 7:30 am

  173. thanks, very helpful

    arifdeni

    3 Dec 13 at 6:46 pm

  174. Hello sir I am new in DBA career
    so i installed OEL 5.5 on virtual machine and
    have set the setting as you said and droped the sysman and its related components and again tried to install the dbconsole but i got the error as :

    Dec 27, 2013 12:12:59 PM oracle.sysman.emcp.EMReposConfig createRepository
    INFO: Creating the EM repository (this may take a while) ...
    Dec 27, 2013 12:24:16 PM oracle.sysman.emcp.EMReposConfig invoke
    INFO: Repository successfully created
    Dec 27, 2013 12:25:28 PM oracle.sysman.emcp.EMReposConfig invoke
    SEVERE: Failed to unlock all EM-related accounts
    Dec 27, 2013 12:25:28 PM oracle.sysman.emcp.EMConfig perform
    SEVERE: Failed to unlock all EM-related accounts
    Refer to the log file at /u01/app/oracle/cfgtoollogs/emca/ora11g/emca_2013_12_27_12_12_06.log for more details.
    Could not complete the configuration. Refer to the log file at /u01/app/oracle/cfgtoollogs/emca/ora11g/emca_2013_12_27_12_12_06.log for more details.

    So i again tried to use the reconfigure the database with the dbca but it said failed to create the em due to error null so try executing manually emca

    please any one can help what is going on
    i have wasted more then 2 days for this

    dralmost

    26 Dec 13 at 11:59 pm

  175. Dralmost, I assume you’ve fixed it. To help you more, I need to see the relevant and “referred to” log file.

    maclochlainn

    31 Dec 13 at 2:10 pm

  176. I am seeing thr below errors in SYSMAN log even after recreating the DBCONSOLE dropping and creating it again…..

    Not sure if it has something to do with listener…

    2014-02-07 10:38:32,247 [EMUI_10_38_32_/console/rac/racSitemap] ERROR rac.services updateServerPoolsInfo.210 - Server pool information could not be upda
    ted. Existing pool information maybe inaccurate.
    2014-02-07 10:38:32,248 [EMUI_10_38_32_/console/rac/racSitemap] ERROR rac.services updateServerPoolsInfo.210 - Server pool information could not be upda
    ted. Existing pool information maybe inaccurate.
    2014-02-07 10:39:33,698 [EMUI_10_39_33_/console/rac/racSitemap] ERROR db.rac setDatabaseType.2682 - Could not retrieve Database Type information. Settin
    g it to NONE. Exception: ORA-20206:
    ORA-06512: at "SYSMAN.EMD_RAC", line 2617
    ORA-01403: no data found
    ORA-06512: at line 1
     
    2014-02-07 10:39:33,718 [EMUI_10_39_33_/console/rac/racSitemap] ERROR rac.services updateServerPoolsInfo.210 - Server pool information could not be upda
    ted. Existing pool information maybe inaccurate.
    2014-02-07 10:39:33,719 [EMUI_10_39_33_/console/rac/racSitemap] ERROR rac.services updateServerPoolsInfo.210 - Server pool information could not be upda
    ted. Existing pool information maybe inaccurate.

    Ramita Garg

    7 Feb 14 at 9:10 am

  177. Take a look at this discussion. This is typically an agent process not an Oracle listener.

    maclochlainn

    8 Feb 14 at 12:34 pm

  178. Very Nice document. I was facing this issue from a long time.

    Ali

    12 Mar 14 at 6:54 am

  179. Thanks a lot. It worked for me.

    Priyanka Gupta

    26 Oct 14 at 11:40 pm

Leave a Reply