DBAsupport.com Forums - Powered by vBulletin
Results 1 to 5 of 5

Thread: Enterprisle Manager Service

  1. #1
    Join Date
    Nov 2003
    Location
    Kuwait
    Posts
    16

    Enterprisle Manager Service

    Hello Everyone,

    I need some advice. We have a 10g standard edition DB and we applied the patch set for 10.2.0.3. After we did the upgrade using the oracle upgrade assistant, the upgrade failed on the enterprise manager part. This caused the windows service called OracleConsoleDB service to disappear. I checked the component using the universal installed and it indicated that the component was installed. I tried re-installing the component only to not avail. Is there anything I need to do to get this restart because I need the enterprise manager to backup my installation.

    Thank you all for the help.

    Randy

  2. #2
    Join Date
    Jul 2002
    Location
    Lake Worth, FL
    Posts
    1,492

    Cool


    You may need to remove (de-install) the EM first and then attempt to re-install using emca.

    From command line it would look like this:
    Code:
    emca -deconfig dbcontrol db -repos drop
    emca -config dbcontrol db -repos create

    "The person who says it cannot be done should not interrupt the person doing it." --Chinese Proverb

  3. #3
    Join Date
    Nov 2003
    Location
    Kuwait
    Posts
    16
    I tried doing the steps but I got the following error:

    Warning: Error retrieving listener for "server name"

    I also got the following error inside the log file:

    CONFIG: Error reading file ORACLE_HOME\install\staticports.ini

    CONFIG: ORA-20401: A job with the specified name already exists
    ORA-06512: at "SYSMAN.MGMT_JOBS", line 196
    ORA-06512: at "SYSMAN.MGMT_JOBS", line 78
    ORA-06512: at line 16

    oracle.sysman.assistants.util.sqlEngine.SQLFatalErrorException: ORA-20401: A job with the specified name already exists
    ORA-06512: at "SYSMAN.MGMT_JOBS", line 196
    ORA-06512: at "SYSMAN.MGMT_JOBS", line 78
    ORA-06512: at line 16

    at oracle.sysman.assistants.util.sqlEngine.SQLEngine.executeImpl(SQLEngine.java:1467)
    at oracle.sysman.assistants.util.sqlEngine.SQLEngine.executeScript(SQLEngine.java:841)
    at oracle.sysman.assistants.util.sqlEngine.SQLPlusEngine.executeScript(SQLPlusEngine.java:265)
    at oracle.sysman.emcp.EMReposConfig.createOutOfBoxJobs(EMReposConfig.java:688)
    at oracle.sysman.emcp.EMReposConfig.invoke(EMReposConfig.java:279)
    at oracle.sysman.emcp.EMReposConfig.invoke(EMReposConfig.java:133)
    at oracle.sysman.emcp.EMConfig.perform(EMConfig.java:142)
    at oracle.sysman.emcp.EMConfigAssistant.invokeEMCA(EMConfigAssistant.java:485)
    at oracle.sysman.emcp.EMConfigAssistant.performConfiguration(EMConfigAssistant.java:1141)
    at oracle.sysman.emcp.EMConfigAssistant.statusMain(EMConfigAssistant.java:469)
    at oracle.sysman.emcp.EMConfigAssistant.main(EMConfigAssistant.java:418)
    May 22, 2007 1:31:10 PM oracle.sysman.emcp.EMReposConfig createOutOfBoxJobs
    CONFIG: Finished executing emreposoutofbox.sql

    CONFIG: Stack trace:
    oracle.sysman.emcp.exception.EMConfigException:
    No listener found in "e:\oracle\product\10.2.0\db_1\network\admin\listener.ora" which is listening on port "5500"

  4. #4
    Join Date
    Jul 2002
    Location
    Lake Worth, FL
    Posts
    1,492

    Cool


    Seems EM is completely screw'd up.
    I would try re-creating the system catalog with the ~/rdbms/admin/catupgrd.sql script and then re-try the EM drop/create.
    Or, you may need to open a Service Request with Oracle Metalink.


    "The person who says it cannot be done should not interrupt the person doing it." --Chinese Proverb

  5. #5
    Join Date
    Nov 2003
    Location
    Kuwait
    Posts
    16
    Hello All,

    I redid the earlier advise but instead of putting 5500 as my listener port, I typed in 1521 and everything configured fine. One thing strange is that EM allocated the config to port 5501 instead of the default 5500.

    Regards,,

    Randy

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  


Click Here to Expand Forum to Full Width