Tuesday, February 19, 2013

Enterprise manager configuration failed due to the following error - Listener is not up or database service is not registered with it.

So, I installed 64 bit oracle 11.2.0.1 on Windows machine and got this error.

Enterprise manager configuration failed due to the following error - Listener is not up or database service is not registered with it.




Here is what I did to fix it.

1) Since the log file had tons of java errors, I installed the latest version of java. Just go to www.java.com, and install it.

2) Launch Net Configuration Assistant, delete the current Listener, and add a new Listener with the default values.

3) Open Listener.ora, replace IP Address on the hostname with the machine name.

4) Re start listener service

5) launch command prompt, and run emca -config dbcontrol db -repos recreate



Provide values for SID,port number, and passwords for the users.

It will take some time to drop the current repository and recreate a new one

Labels:

28 comments:

  1. AnonymousMay 30, 2013 at 3:14 AM

    Thank you very much!!!

    This worked for me...

    ReplyDelete
  2. AnonymousJune 12, 2013 at 6:38 AM

    thanks

    ReplyDelete
  3. AnonymousAugust 21, 2013 at 2:10 AM

    Worked. Thanks!

    ReplyDelete
  4. UnknownOctober 8, 2013 at 10:25 AM

    thanks a lot!

    ReplyDelete
  5. UnknownDecember 5, 2013 at 3:59 PM

    You genius! Thank you!

    ReplyDelete
  6. UnknownDecember 30, 2013 at 6:09 AM

    thanks but im beginner how can i Open Listener.ora, replace IP Address on the hostname with the machine name?

    ReplyDelete
    Replies
    1. Eric MurithiJanuary 20, 2014 at 7:10 AM

      Thanks man.

      Dker,
      Listener.ora is on C:\app\Administrator\product\11.2.0\dbhome_1\NETWORK\ADMIN if you installed Oracle on Windows C root folder like i did.

      Delete
  7. UnknownFebruary 21, 2014 at 2:36 AM

    How munch time about ?. I waitted about 1,5hour, but it stop in "Dropping the EM repository .."

    ReplyDelete
  8. UnknownFebruary 24, 2014 at 9:08 AM

    in listener.ora exactly what we have to do.. specify in detail pls ?

    ReplyDelete
  9. AnonymousMay 9, 2014 at 12:52 PM

    Thank you very much! :). It save me!

    ReplyDelete
  10. UnknownJune 2, 2014 at 7:02 PM

    Thanks man, you saved me from my 2 days of continuous PAIN.

    Why hasn't oracle fixed this problem?

    ReplyDelete
  11. GabrielleJuly 14, 2014 at 9:15 PM

    Wow, thanks so much! I tried SO many different things before I ended up here, and it worked! I'm so glad you shared!

    ReplyDelete
  12. FrankJanuary 12, 2015 at 11:52 AM

    Thanks. Your solution worked for me too.

    ReplyDelete
  13. UnknownSeptember 10, 2015 at 10:27 AM

    If i delete the java log files, will something happen??

    ReplyDelete
    Replies
    1. UnknownJune 3, 2017 at 6:20 PM

      For More Enterprise Manager Problem Please Watch This Video
      https://www.youtube.com/playlist?list=PLq2wa7hRoFdm0ndJxqFAGvi7huJF6KUYm

      Delete
  14. UnknownOctober 15, 2015 at 5:41 AM

    Hi, I tried doing the same but after giving Database SID it gives error Exception IN Thread main oracle.sysman.emcp.exception.databaseunavailalbeexception databse instance unavaialbe

    ReplyDelete
  15. AnonymousFebruary 5, 2016 at 12:00 PM

    I am experiencing the same error as well.

    ReplyDelete
  16. BrutusBlogJune 3, 2016 at 11:01 AM

    Solve my issue as well.

    ReplyDelete
  17. AnonymousJune 10, 2016 at 2:40 AM

    Thanks, it worked! I appreciate that.

    ReplyDelete
  18. AnonymousJuly 15, 2016 at 3:47 PM

    Thank you sir for the solution

    ReplyDelete
  19. UnknownJune 3, 2017 at 6:18 PM

    This comment has been removed by the author.

    ReplyDelete
  20. UnknownJune 3, 2017 at 6:19 PM

    This is Good,For More Enterprise Manager Problem Please Watch This Video
    https://www.youtube.com/playlist?list=PLq2wa7hRoFdm0ndJxqFAGvi7huJF6KUYm

    ReplyDelete
  21. AnonymousFebruary 1, 2018 at 1:31 AM

    appreciated !

    ReplyDelete
  22. UnknownFebruary 11, 2018 at 3:36 PM

    Thank you! my one day problem is solved now.....

    ReplyDelete
  23. AnonymousMarch 25, 2019 at 5:48 PM

    It worked, it took my whole day,Thanks a ton

    ReplyDelete
  24. UnknownNovember 19, 2019 at 6:29 AM

    Please provide same solution for RAC database.

    ReplyDelete
  25. UnknownJune 12, 2020 at 4:16 PM

    no value was set for the parameter oracle_hostname
    This error occured

    INFO: Uploading configuration data to EM repository (this may take a while) ...
    Jun 13, 2020 1:37:39 AM oracle.sysman.emcp.EMReposConfig invoke
    INFO: Uploaded configuration data successfully
    Jun 13, 2020 1:37:39 AM oracle.sysman.emcp.ParamsManager getParam
    CONFIG: No value was set for the parameter ORACLE_HOSTNAME.
    Jun 13, 2020 1:37:40 AM oracle.sysman.emcp.EMDBCConfig updateEmomsProps
    CONFIG: Updating file C:\app\VishalSingh\product\11.2\dbhome1\sysman\config\emoms.properties ...
    Jun 13, 2020 1:37:40 AM oracle.sysman.emcp.ParamsManager getParam
    CONFIG: No value was set for the parameter ORACLE_HOSTNAME.
    Jun 13, 2020 1:37:40 AM oracle.sysman.emcp.util.FileUtil _deleteFile
    CONFIG: Deleting file C:\app\VishalSingh\product\11.2\dbhome1\sysman\config\emoms.properties
    Jun 13, 2020 1:37:40 AM oracle.sysman.emcp.util.FileUtil copyFile
    CONFIG: exception caught in copyFile:
    oracle.sysman.emcp.exception.FileUtilException: Copying file C:\app\VishalSingh\product\11.2\dbhome1\sysman\config\emoms.properties.emca to C:\app\VishalSingh\product\11.2\dbhome1\sysman\config\emoms.properties
    at oracle.sysman.emcp.util.FileUtil._copyFile(FileUtil.java:277)
    at oracle.sysman.emcp.util.FileUtil.copyFile(FileUtil.java:618)
    at oracle.sysman.emcp.util.FileUtil.copyFile(FileUtil.java:394)
    at oracle.sysman.emcp.EMDBCConfig.updateEmomsProps(EMDBCConfig.java:926)
    at oracle.sysman.emcp.EMDBCConfig.performConfiguration(EMDBCConfig.java:408)
    at oracle.sysman.emcp.EMDBCConfig.invoke(EMDBCConfig.java:174)
    at oracle.sysman.emcp.EMDBCConfig.invoke(EMDBCConfig.java:144)
    at oracle.sysman.emcp.EMConfig.perform(EMConfig.java:255)
    at oracle.sysman.emcp.EMConfigAssistant.invokeEMCA(EMConfigAssistant.java:590)
    at oracle.sysman.emcp.EMConfigAssistant.performConfiguration(EMConfigAssistant.java:1453)
    at oracle.sysman.emcp.EMConfigAssistant.statusMain(EMConfigAssistant.java:574)
    at oracle.sysman.emcp.EMConfigAssistant.main(EMConfigAssistant.java:522)
    Caused by: java.io.FileNotFoundException: C:\app\VishalSingh\product\11.2\dbhome1\sysman\config\emoms.properties (Access is denied)
    at java.io.FileOutputStream.open(Native Method)
    at java.io.FileOutputStream.(FileOutputStream.java:179)
    at java.io.FileOutputStream.(FileOutputStream.java:131)
    at oracle.sysman.emcp.util.FileUtil._copyFile(FileUtil.java:263)
    ... 11 more
    Jun 13, 2020 1:37:40 AM oracle.sysman.emcp.EMDBCConfig updateEmomsProps
    CONFIG: Copying file C:\app\VishalSingh\product\11.2\dbhome1\sysman\config\emoms.properties.emca to C:\app\VishalSingh\product\11.2\dbhome1\sysman\config\emoms.properties
    Jun 13, 2020 1:37:40 AM oracle.sysman.emcp.EMConfig perform
    SEVERE: Error updating C:\app\VishalSingh\product\11.2\dbhome1\sysman\config\emoms.properties
    Refer to the log file at C:\app\VishalSingh\product\cfgtoollogs\emca\orcl\emca_2020_06_13_01_30_29.log for more details.
    Jun 13, 2020 1:37:40 AM oracle.sysman.emcp.EMConfig perform
    CONFIG: Stack Trace:
    oracle.sysman.emcp.exception.EMConfigException: Error updating C:\app\VishalSingh\product\11.2\dbhome1\sysman\config\emoms.properties
    at oracle.sysman.emcp.EMDBCConfig.performConfiguration(EMDBCConfig.java:413)
    at oracle.sysman.emcp.EMDBCConfig.invoke(EMDBCConfig.java:174)
    at oracle.sysman.emcp.EMDBCConfig.invoke(EMDBCConfig.java:144)
    at oracle.sysman.emcp.EMConfig.perform(EMConfig.java:255)
    at oracle.sysman.emcp.EMConfigAssistant.invokeEMCA(EMConfigAssistant.java:590)
    at oracle.sysman.emcp.EMConfigAssistant.performConfiguration(EMConfigAssistant.java:1453)
    at oracle.sysman.emcp.EMConfigAssistant.statusMain(EMConfigAssistant.java:574)
    at oracle.sysman.emcp.EMConfigAssistant.main(EMConfigAssistant.java:522)
    Jun 13, 2020 1:37:40 AM oracle.sysman.emcp.EMConfig restoreOuiLoc
    CONFIG: Restoring oracle.installer.oui_loc to C:\app\VishalSingh\product\11.2\dbhome1\oui

    ReplyDelete

Subscribe to: Post Comments (Atom)