Hi,
In an attempt to re-create db control repository, I got the following:
C:\Documents and Settings\Administrator>emca -deconfig dbcontrol db -repos drop
STARTED EMCA at Apr 2, 2010 5:05:21 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: ora11g
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
Apr 2, 2010 5:05:42 PM oracle.sysman.emcp.EMConfig perform
INFO: This operation is being logged at C:\oracle\cfgtoollogs\emca\ora11g\emca_2
010_04_02_17_05_21.log.
Apr 2, 2010 5:05:43 PM oracle.sysman.emcp.EMDBPreConfig performDeconfiguration
WARNING: EM is not configured for this database. No EM-specific actions can be p
erformed.
Apr 2, 2010 5:05:43 PM oracle.sysman.emcp.EMReposConfig invoke
INFO: Dropping the EM repository (this may take a while) ...
Apr 2, 2010 5:07:51 PM oracle.sysman.emcp.EMReposConfig invoke
INFO: Repository successfully dropped
Enterprise Manager configuration completed successfully
FINISHED EMCA at Apr 2, 2010 5:07:51 PM
C:\Documents and Settings\Administrator>emca -config dbcontrol db -repos create
STARTED EMCA at Apr 2, 2010 5:08:11 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: ora11g
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):
ASM ORACLE_HOME [ C:\oracle\oracledb11g ]:
ASM SID [ +ASM ]:
ASM port [ 1521 ]:
ASM user role [ SYSDBA ]:
ASM username [ SYS ]:
ASM user password:
ASM user password: -------------------------------------------------------------
----
You have specified the following settings
Database ORACLE_HOME ................ C:\oracle\oracledb11g
Local hostname ................ PC01
Listener port number ................ 1521
Database SID ................ ora11g
Email address for notifications ...............
Outgoing Mail (SMTP) server for notifications ...............
ASM ORACLE_HOME ................ C:\oracle\oracledb11g
ASM SID ................ +ASM
ASM port ................ 1521
ASM user role ................ SYSDBA
ASM username ................ SYS
-----------------------------------------------------------------
Do you wish to continue? [yes(Y)/no(N)]: Y
Apr 2, 2010 5:08:40 PM oracle.sysman.emcp.EMConfig perform
INFO: This operation is being logged at C:\oracle\cfgtoollogs\emca\ora11g\emca_2
010_04_02_17_08_11.log.
Apr 2, 2010 5:08:41 PM oracle.sysman.emcp.EMReposConfig createRepository
INFO: Creating the EM repository (this may take a while) ...
Apr 2, 2010 5:12:59 PM oracle.sysman.emcp.EMReposConfig invoke
INFO: Repository successfully created
Apr 2, 2010 5:13:03 PM oracle.sysman.emcp.EMReposConfig uploadConfigDataToReposi
tory
INFO: Uploading configuration data to EM repository (this may take a while) ...
Apr 2, 2010 5:13:48 PM oracle.sysman.emcp.EMReposConfig invoke
INFO: Uploaded configuration data successfully
Apr 2, 2010 5:13:49 PM oracle.sysman.emcp.util.DBControlUtil configureSoftwareLi
b
INFO: Software library configured successfully.
Apr 2, 2010 5:13:49 PM oracle.sysman.emcp.EMDBPostConfig configureSoftwareLibrar
y
INFO: Deploying Provisioning archives ...
Apr 2, 2010 5:13:58 PM oracle.sysman.emcp.EMDBPostConfig configureSoftwareLibrar
y
INFO: Provisioning archives deployed successfully.
Apr 2, 2010 5:13:58 PM oracle.sysman.emcp.util.DBControlUtil secureDBConsole
INFO: Securing Database Control (this may take a while) ...
Apr 2, 2010 5:14:09 PM oracle.sysman.emcp.util.DBControlUtil secureDBConsole
INFO: Database Control secured successfully.
Apr 2, 2010 5:14:09 PM oracle.sysman.emcp.util.DBControlUtil startOMS
INFO: Starting Database Control (this may take a while) ...
Apr 2, 2010 5:19:09 PM oracle.sysman.emcp.EMConfig perform
SEVERE: Error starting Database Control
Refer to the log file at C:\oracle\cfgtoollogs\emca\ora11g\emca_2010_04_02_17_08
_11.log for more details.
Could not complete the configuration. Refer to the log file at C:\oracle\cfgtool
logs\emca\ora11g\emca_2010_04_02_17_08_11.log for more details.
Errors displayed in emca_2010_04_02_17_08_11.log are as follows:
..
CONFIG: Waiting for service 'OracleDBConsoleora11g' to fully start
Apr 2, 2010 5:18:59 PM oracle.sysman.emcp.util.PlatformInterface serviceCommand
CONFIG: Waiting for service 'OracleDBConsoleora11g' to fully start
Apr 2, 2010 5:19:09 PM oracle.sysman.emcp.EMConfig perform
SEVERE: Error starting Database Control
Refer to the log file at C:\oracle\cfgtoollogs\emca\ora11g\emca_2010_04_02_17_08_11.log for more details.
Apr 2, 2010 5:19:09 PM 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:869)
at oracle.sysman.emcp.EMDBPostConfig.invoke(EMDBPostConfig.java:250)
at oracle.sysman.emcp.EMDBPostConfig.invoke(EMDBPostConfig.java:213)
at oracle.sysman.emcp.EMConfig.perform(EMConfig.java:235)
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)
When I tried to re-start the OracleDBConsoleora11g service manually in Windows, it failed.
Oracle 11g R1
Windows XP Pro.
How can I successfully create the db repository?
Thanks in advance.