-
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
-
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
-
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"
-
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
-
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
-
Forum Rules
|
Click Here to Expand Forum to Full Width
|