Ugh help, been at this for hours! I messed up my oracle dbconsole and now the dbconsole service itself is gone! (I checked services.msc on my windows xp pro) I'm on oracle 11gR2
So I dropped and recreate em repo but got the ff error msg:
C:\Documents and Settings\abigail>emca -repos create
STARTED EMCA at Oct 11, 2013 5:17:51 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
Listener port number: 1521
Password for SYS user:
Password for SYSMAN user:
Do you wish to continue? [yes(Y)/no(N)]: y
Oct 11, 2013 5:18:08 AM oracle.sysman.emcp.util.EMCALogManager addLogFileInterna
l
WARNING: Adding log file E:\app\abigail\cfgtoollogs\emca\SP2-0640: Not connected
\emca_2013_10_11_05_17_51.log failed. Messages will not be logged in this file.
Oct 11, 2013 5:18:08 AM oracle.sysman.emcp.EMConfig perform
INFO: This operation is being logged at E:\app\abigail\cfgtoollogs\emca\SP2-0640
: Not connected\emca_2013_10_11_05_17_51.log.
Oct 11, 2013 5:18:08 AM oracle.sysman.emcp.EMReposConfig createRepository
INFO: Creating the EM repository (this may take a while) ...
Oct 11, 2013 5:18:08 AM oracle.sysman.emcp.EMReposConfig invoke
SEVERE: Error creating the repository
Oct 11, 2013 5:18:08 AM oracle.sysman.emcp.EMReposConfig invoke
INFO: Refer to the log file at E:\app\abigail\cfgtoollogs\emca\SP2-0640: Not con
nected\emca_repos_create_<date>.log for more details.
Oct 11, 2013 5:18:08 AM oracle.sysman.emcp.EMConfig perform
SEVERE: Error creating the repository
Refer to the log file at E:\app\abigail\cfgtoollogs\emca\SP2-0640: Not connected
\emca_2013_10_11_05_17_51.log for more details.
Could not complete the configuration. Refer to the log file at E:\app\abigail\cf
gtoollogs\emca\SP2-0640: Not connected\emca_2013_10_11_05_17_51.log for more det
ails.
My Log file
CONFIG: Spooling to E:\app\abigail\cfgtoollogs\emca\orcl\emca_repos_create_2013_10_11_05_13_56.log
Oct 11, 2013 5:13:56 AM oracle.sysman.emcp.EMReposConfig createRepository
INFO: Creating the EM repository (this may take a while) ...
Oct 11, 2013 5:13:56 AM oracle.sysman.emcp.EMReposConfig createRepository
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
at oracle.sysman.assistants.util.sqlEngine.SQLEngine.executeImpl(SQLEngine.java:1655)
at oracle.sysman.assistants.util.sqlEngine.SQLEngine.executeScript(SQLEngine.java:1005)
at oracle.sysman.assistants.util.sqlEngine.SQLPlusEngine.executeScript(SQLPlusEngine.java:339)
at oracle.sysman.assistants.util.sqlEngine.SQLPlusEngine.executeScript(SQLPlusEngine.java:380)
at oracle.sysman.emcp.EMReposConfig.createRepository(EMReposConfig.java:511)
at oracle.sysman.emcp.EMReposConfig.invoke(EMReposConfig.java:229)
at oracle.sysman.emcp.EMReposConfig.invoke(EMReposConfig.java:158)
at oracle.sysman.emcp.EMConfig.perform(EMConfig.java:253)
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)
Oct 11, 2013 5:13:56 AM oracle.sysman.emcp.EMReposConfig invoke
SEVERE: Error creating the repository
Oct 11, 2013 5:13:56 AM oracle.sysman.emcp.EMReposConfig invoke
INFO: Refer to the log file at E:\app\abigail\cfgtoollogs\emca\orcl\emca_repos_create_<date>.log for more details.
Oct 11, 2013 5:13:56 AM oracle.sysman.emcp.EMConfig perform
SEVERE: Error creating the repository
Refer to the log file at E:\app\abigail\cfgtoollogs\emca\orcl\emca_2013_10_11_05_13_31.log for more details.
Oct 11, 2013 5:13:56 AM 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:241)
at oracle.sysman.emcp.EMReposConfig.invoke(EMReposConfig.java:158)
at oracle.sysman.emcp.EMConfig.perform(EMConfig.java:253)
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)
Oct 11, 2013 5:13:56 AM oracle.sysman.emcp.EMConfig restoreOuiLoc
CONFIG: Restoring oracle.installer.oui_loc to E:\app\abigail\product\11.2.0\dbhome_1\oui