Hi guys,
i'm struggling to reconfigure my EM on windows 64bit oracle 11r2 version 3 but fail to do so. i know by following 4 simple step you can configure em easily as many of blogs and forum repeatedly mentioned the process. my situation is pretty different one. i have followed the following process many time but every time get error to while configure dbconsole
et oracle_sid=YourInstanceName
emca -deconfig dbcontrol db
emca -repos recreate
emca -config dbcontrol db
first two statement run successfully but as i tried to config dbconsole it give me error here my complete steps those i took to configure Em
C:\Documents and Settings\ecpidm>emca -repos recreate
STARTED EMCA at 28-Mar-2012 06:09:46
EM Configuration Assistant, Version 11.2.0.3.0 Production
Copyright (c) 2003, 2011, Oracle. All rights reserved.
Enter the following information:
Database SID: orcl
Listener port number: 1521
Password for SYS user:
Password for SYSMAN user:
Password for SYSMAN user:
----------------------------------------------------------------------
WARNING : While repository is dropped the database will be put in quiesce mode.
----------------------------------------------------------------------
Do you wish to continue? [yes(Y)/no(N)]: Y
28-Mar-2012 06:10:08 oracle.sysman.emcp.EMConfig perform
INFO: This operation is being logged at E:\app\ecpidm\cfgtoollogs\emca\orcl\emca
_2012_03_28_06_09_46.log.
28-Mar-2012 06:10:08 oracle.sysman.emcp.EMReposConfig invoke
INFO: Dropping the EM repository (this may take a while) ...
28-Mar-2012 06:10:12 oracle.sysman.emcp.EMReposConfig invoke
INFO: Repository successfully dropped
28-Mar-2012 06:10:13 oracle.sysman.emcp.EMReposConfig createRepository
INFO: Creating the EM repository (this may take a while) ...
28-Mar-2012 06:16:48 oracle.sysman.emcp.EMReposConfig invoke
INFO: Repository successfully created
Enterprise Manager configuration completed successfully
FINISHED EMCA at 28-Mar-2012 06:16:48
C:\Documents and Settings\ecpidm>emca -config dbcontrol db
STARTED EMCA at 28-Mar-2012 06:21:10
EM Configuration Assistant, Version 11.2.0.3.0 Production
Copyright (c) 2003, 2011, Oracle. All rights reserved.
Enter the following information:
Database SID: orcl
Database Control is already configured for the database orcl
You have chosen to configure Database Control for managing the database orcl
This will remove the existing configuration and the default settings and perform
a fresh configuration
Do you wish to continue? [yes(Y)/no(N)]: N
C:\Documents and Settings\ecpidm>emca -deconfig dbcontrol db
STARTED EMCA at 28-Mar-2012 06:23:19
EM Configuration Assistant, Version 11.2.0.3.0 Production
Copyright (c) 2003, 2011, Oracle. All rights reserved.
Enter the following information:
Database SID: orcl
Do you wish to continue? [yes(Y)/no(N)]: Y
28-Mar-2012 06:23:26 oracle.sysman.emcp.EMConfig perform
INFO: This operation is being logged at E:\app\ecpidm\cfgtoollogs\emca\orcl\emca
_2012_03_28_06_23_19.log.
28-Mar-2012 06:23:26 oracle.sysman.emcp.util.DBControlUtil stopOMS
INFO: Stopping Database Control (this may take a while) ...
28-Mar-2012 06:23:27 oracle.sysman.emcp.EMConfig perform
SEVERE: Error de-configuring EM for database orcl.
Refer to the log file at E:\app\ecpidm\cfgtoollogs\emca\orcl\emca_2012_03_28_06_
23_19.log for more details.
Could not complete the configuration. Refer to the log file at E:\app\ecpidm\cfg
toollogs\emca\orcl\emca_2012_03_28_06_23_19.log for more details.
some extract from log file is
rcl, USERDNSDOMAIN=ECPDC.EUROCARPARTS.COM, USERDOMAIN=ECPDC, USERNAME=ecpidm, USERPROFILE=C:\Documents and Settings\ecpidm, WINDIR=C:\WINDOWS]
28-Mar-2012 06:23:26 oracle.sysman.emcp.util.PlatformInterface executeCommand
CONFIG: Starting execution: E:/app/ecpidm/product/11.2.0/dbhome_1/perl/bin\perl.exe E:\app\ecpidm\product\11.2.0\dbhome_1\sysman\admin\scripts\db\sgastop.pl stop orcl ecpidmdata.ecpdc.eurocarparts.com 1521 E:\app\ecpidm\product\11.2.0\dbhome_1
28-Mar-2012 06:23:26 oracle.sysman.emcp.util.PlatformInterface executeCommand
CONFIG: Exit value of 0
28-Mar-2012 06:23:26 oracle.sysman.emcp.util.PlatformInterface executeCommand
CONFIG: Execution of E:/app/ecpidm/product/11.2.0/dbhome_1/perl/bin\perl.exe E:\app\ecpidm\product\11.2.0\dbhome_1\sysman\admin\scripts\db\sgastop.pl stop orcl ecpidmdata.ecpdc.eurocarparts.com 1521 E:\app\ecpidm\product\11.2.0\dbhome_1 completed successfully
28-Mar-2012 06:23:26 oracle.sysman.emcp.util.PlatformInterface executeCommand
CONFIG: nmccollector process does not exist
28-Mar-2012 06:23:26 oracle.sysman.emcp.util.DBControlUtil stopNmccollector
CONFIG: Successfully stopped nmc-collector process
28-Mar-2012 06:23:26 oracle.sysman.emcp.util.PlatformInterface serviceCommand
CONFIG: cmdType: 2
28-Mar-2012 06:23:26 oracle.sysman.emcp.util.PlatformInterface isPre112Home
CONFIG: oracleHome: E:\app\ecpidm\product\11.2.0\dbhome_1 isPre112Home: false
28-Mar-2012 06:23:26 oracle.sysman.emcp.util.PlatformInterface serviceCommand
CONFIG: Service does not exist
28-Mar-2012 06:23:26 oracle.sysman.emcp.ParamsManager getParam
CONFIG: No value was set for the parameter ORACLE_HOSTNAME.
28-Mar-2012 06:23:26 oracle.sysman.emcp.util.ClusterUtil getLocalNode
CONFIG: isLocalNodeDone: true localNode: null
28-Mar-2012 06:23:26 oracle.sysman.emcp.ParamsManager getHost
CONFIG: Host having instnces running for database orcl : ecpidmdata.ecpdc.eurocarparts.com
28-Mar-2012 06:23:26 oracle.sysman.emcp.ParamsManager setParam
CONFIG: Setting param: REP_DB_RUNNING_HOST value: ecpidmdata.ecpdc.eurocarparts.com
28-Mar-2012 06:23:26 oracle.sysman.emcp.ParamsManager getParam
CONFIG: No value was set for the parameter SYSMAN_PWD.
28-Mar-2012 06:23:26 oracle.sysman.emcp.ParamsManager getRepDbPort
CONFIG: Listener Port: 1521
28-Mar-2012 06:23:26 oracle.sysman.emcp.util.GeneralUtil isLocalConnectionRequired
CONFIG: isLocalConnectionRequired: true
28-Mar-2012 06:23:26 oracle.sysman.emcp.util.GeneralUtil initSQLEngine
CONFIG: isLocalConnectionRequired: true. Connecting to database instance locally.
28-Mar-2012 06:23:26 oracle.sysman.emcp.util.GeneralUtil initSQLEngineLoacly
CONFIG: SQLEngine connecting with SID: orcl, oracleHome: E:\app\ecpidm\product\11.2.0\dbhome_1, and user: SYSMAN
28-Mar-2012 06:23:26 oracle.sysman.emcp.util.GeneralUtil initSQLEngineLoacly
CONFIG: SQLEngine created successfully and connected
28-Mar-2012 06:23:27 oracle.sysman.emcp.EMReposConfig stopDBMSJobs
CONFIG: Finished executing admin_remove_dbms_jobs.sql
28-Mar-2012 06:23:27 oracle.sysman.emcp.EMReposConfig invoke
CONFIG: DBMS jobs removed successfully.
28-Mar-2012 06:23:27 oracle.sysman.emcp.EMDBCConfig deleteOC4JDir
CONFIG: Deleting state directories
28-Mar-2012 06:23:27 oracle.sysman.emcp.ParamsManager getParam
CONFIG: No value was set for the parameter ORACLE_HOSTNAME.
28-Mar-2012 06:23:27 oracle.sysman.emcp.util.ClusterUtil getLocalNode
CONFIG: isLocalNodeDone: true localNode: null
28-Mar-2012 06:23:27 oracle.sysman.emcp.EMDBCConfig deleteOC4JDir
CONFIG: Unable to delete E:\app\ecpidm\product\11.2.0\dbhome_1\oc4j\j2ee\OC4J_DBConsole_ecpidmdata.ecpdc.eurocarparts.com_orcl
28-Mar-2012 06:23:27 oracle.sysman.emcp.EMConfig perform
SEVERE: Error de-configuring EM for database orcl.
Refer to the log file at E:\app\ecpidm\cfgtoollogs\emca\orcl\emca_2012_03_28_06_23_19.log for more details.
28-Mar-2012 06:23:27 oracle.sysman.emcp.EMConfig perform
CONFIG: Stack Trace:
oracle.sysman.emcp.exception.EMConfigException: Error de-configuring EM for database orcl.
at oracle.sysman.emcp.EMDBCConfig.performDeconfiguration(EMDBCConfig.java:541)
at oracle.sysman.emcp.EMDBCConfig.invoke(EMDBCConfig.java:170)
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:599)
at oracle.sysman.emcp.EMConfigAssistant.performConfiguration(EMConfigAssistant.java:1482)
at oracle.sysman.emcp.EMConfigAssistant.statusMain(EMConfigAssistant.java:583)
at oracle.sysman.emcp.EMConfigAssistant.main(EMConfigAssistant.java:529)
28-Mar-2012 06:23:27 oracle.sysman.emcp.EMConfig restoreOuiLoc
CONFIG: Restoring oracle.installer.oui_loc to E:\app\ecpidm\product\11.2.0\dbhome_1\oui