This discussion is archived
1 2 Previous Next 16 Replies Latest reply: Feb 2, 2013 5:43 AM by Osama_Mustafa RSS

EM Console Not Working

Venkateshj Newbie
Currently Being Moderated
Hi all

I Installed Oracle 11g R2 in Windows Server 2008 R2 System..

I have two databases as CSDB & ITMS

Now i hav problem with CSDB EMCONSOLE, and ITMS EMCONSOLE Working Fine...

While creating New Repository am getting the below errors..

C:\>emca -config dbcontrol db -repos create

STARTED EMCA at Jan 31, 2013 7:05:50 PM
EM Configuration Assistant, Version 11.2.0.0.2 Production
Copyright (c) 2003, 2005, Oracle. All rights reserved.

Enter the following information:
Database SID: csdb
Database Control is already configured for the database csdb
You have chosen to configure Database Control for managing the database csdb
This will remove the existing configuration and the default settings and perform
a fresh configuration
Do you wish to continue? [yes(Y)/no(N)]: y
Listener ORACLE_HOME [ d:\app\Administrator\product\11.2.0\dbhome_1 ]:
Password for SYS user:
Password for DBSNMP user:
Password for SYSMAN user:
Email address for notifications (optional):
Outgoing Mail (SMTP) server for notifications (optional):
-----------------------------------------------------------------

You have specified the following settings

Database ORACLE_HOME ................ d:\app\Administrator\product\11.2.0\dbhome
_1

Local hostname ................ storage1
Listener ORACLE_HOME ................ d:\app\Administrator\product\11.2.0\dbhome
_1
Listener port number ................ 1521
Database SID ................ csdb
Email address for notifications ...............
Outgoing Mail (SMTP) server for notifications ...............

-----------------------------------------------------------------
Do you wish to continue? [yes(Y)/no(N)]: y
Jan 31, 2013 7:06:10 PM oracle.sysman.emcp.EMConfig perform
INFO: This operation is being logged at d:\app\Administrator\cfgtoollogs\emca\cs
db\emca_2013_01_31_19_05_50.log.
Jan 31, 2013 7:06:11 PM oracle.sysman.emcp.util.DBControlUtil stopOMS
INFO: Stopping Database Control (this may take a while) ...
Jan 31, 2013 7:06:11 PM oracle.sysman.emcp.EMReposConfig createRepository
INFO: Creating the EM repository (this may take a while) ...
Jan 31, 2013 7:06:11 PM oracle.sysman.emcp.EMReposConfig invoke
SEVERE: Error creating the repository
Jan 31, 2013 7:06:11 PM oracle.sysman.emcp.EMReposConfig invoke
INFO: Refer to the log file at d:\app\Administrator\cfgtoollogs\emca\csdb\emca_r
epos_create_<date>.log for more details.
Jan 31, 2013 7:06:11 PM oracle.sysman.emcp.EMConfig perform
SEVERE: Error creating the repository
Refer to the log file at d:\app\Administrator\cfgtoollogs\emca\csdb\emca_2013_01
_31_19_05_50.log for more details.
Could not complete the configuration. Refer to the log file at d:\app\Administra
tor\cfgtoollogs\emca\csdb\emca_2013_01_31_19_05_50.log for more details.

C:\>







Please give a solution for the above problem...


Thanks in advance..
  • 1. Re: EM Console Not Working
    Osama_Mustafa Oracle ACE
    Currently Being Moderated
    Post logs please
    > d:\app\Administrator\cfgtoollogs\emca\csdb\emca_2013_01_31_19_05_50.log for more details.
  • 2. Re: EM Console Not Working
    Venkateshj Newbie
    Currently Being Moderated
    CONFIG: Could not find or correctly parse file d:\app\Administrator\product\11.2.0\dbhome_1\oc4j\j2ee\OC4J_DBConsole_storage1_csdb\config\http-web-site.xml in searching for tag web-site with attribute port
    java.io.FileNotFoundException: d:\app\Administrator\product\11.2.0\dbhome_1\oc4j\j2ee\OC4J_DBConsole_storage1_csdb\config\http-web-site.xml (The system cannot find the path specified)
         at java.io.FileInputStream.open(Native Method)
         at java.io.FileInputStream.<init>(FileInputStream.java:106)
         at java.io.FileInputStream.<init>(FileInputStream.java:66)
         at java.io.FileReader.<init>(FileReader.java:41)
         at oracle.sysman.emcp.util.PortManager.findUsedPortsFromXML(PortManager.java:296)
         at oracle.sysman.emcp.util.PortManager.getConfiguredPorts(PortManager.java:484)
         at oracle.sysman.emcp.EMDBPreConfig.getConfiguredPorts(EMDBPreConfig.java:3043)
         at oracle.sysman.emcp.EMDBPreConfig.getConfiguredPorts(EMDBPreConfig.java:2946)
         at oracle.sysman.emcp.EMDBPreConfig.checkPorts(EMDBPreConfig.java:2661)
         at oracle.sysman.emcp.EMDBPreConfig.performConfiguration(EMDBPreConfig.java:864)
         at oracle.sysman.emcp.EMDBPreConfig.invoke(EMDBPreConfig.java:282)
         at oracle.sysman.emcp.EMDBPreConfig.invoke(EMDBPreConfig.java:195)
         at oracle.sysman.emcp.EMConfig.perform(EMConfig.java:250)
         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)
    Jan 31, 2013 7:06:11 PM oracle.sysman.emcp.util.PortManager getConfiguredPorts
    CONFIG: Incomplete EM configuration detected in file d:\app\Administrator\product\11.2.0\dbhome_1\oc4j\j2ee\OC4J_DBConsole_storage1_csdb\config\jms.xml.
    Jan 31, 2013 7:06:11 PM oracle.sysman.emcp.EMDBPreConfig getConfiguredPorts
    CONFIG: Incomplete EM configuration detected in file d:\app\Administrator\product\11.2.0\dbhome_1\oc4j\j2ee\OC4J_DBConsole_storage1_csdb\config\jms.xml.
    Jan 31, 2013 7:06:11 PM oracle.sysman.emcp.EMDBPreConfig checkPorts
    CONFIG: Error retrieving existing Database Control ports.
    Jan 31, 2013 7:06:11 PM oracle.sysman.emcp.ParamsManager getParam
    CONFIG: No value was set for the parameter ORACLE_HOSTNAME.
    Jan 31, 2013 7:06:11 PM oracle.sysman.emcp.ParamsManager getParam
    CONFIG: No value was set for the parameter PORTS_FILE.
    Jan 31, 2013 7:06:11 PM oracle.sysman.emcp.util.ClusterUtil getLocalNode
    CONFIG: isLocalNodeDone: true localNode: null
    Jan 31, 2013 7:06:11 PM oracle.sysman.emcp.ParamsManager getParam
    CONFIG: No value was set for the parameter JMS_PORT_storage1.
    Jan 31, 2013 7:06:11 PM oracle.sysman.emcp.ParamsManager getParam
    CONFIG: No value was set for the parameter JMS_PORT.
    Jan 31, 2013 7:06:11 PM oracle.sysman.emcp.ParamsManager getParam
    CONFIG: No value was set for the parameter RMI_PORT_storage1.
    Jan 31, 2013 7:06:11 PM oracle.sysman.emcp.ParamsManager getParam
    CONFIG: No value was set for the parameter RMI_PORT.
    Jan 31, 2013 7:06:11 PM oracle.sysman.emcp.ParamsManager getParam
    CONFIG: No value was set for the parameter DBCONTROL_HTTP_PORT_storage1.
    Jan 31, 2013 7:06:11 PM oracle.sysman.emcp.ParamsManager getParam
    CONFIG: No value was set for the parameter DBCONTROL_HTTP_PORT.
    Jan 31, 2013 7:06:11 PM oracle.sysman.emcp.ParamsManager getParam
    CONFIG: No value was set for the parameter AGENT_PORT_storage1.
    Jan 31, 2013 7:06:11 PM oracle.sysman.emcp.ParamsManager getParam
    CONFIG: No value was set for the parameter AGENT_PORT.
    Jan 31, 2013 7:06:11 PM oracle.sysman.emcp.util.OUIInventoryUtil setOUILoc
    CONFIG: Setting oracle.installer.oui_loc to d:\app\Administrator\product\11.2.0\dbhome_1\oui
    Jan 31, 2013 7:06:11 PM oracle.sysman.emcp.util.PortManager markAllUsedPorts
    CONFIG: Homes to scan for used ports: [d:\app\Administrator\product\11.2.0\dbhome_1]
    Jan 31, 2013 7:06:11 PM oracle.sysman.emcp.util.PortManager markAllUsedPorts
    CONFIG: Searching all DBConsole instances for used ports under ORACLE_HOME d:\app\Administrator\product\11.2.0\dbhome_1
    Jan 31, 2013 7:06:11 PM oracle.sysman.emcp.util.PortManager markAllUsedPorts
    CONFIG: Marking JMS port: null from d:\app\Administrator\product\11.2.0\dbhome_1\oc4j\j2ee\OC4J_DBConsole
    Jan 31, 2013 7:06:11 PM oracle.sysman.emcp.util.PortManager markAllUsedPorts
    CONFIG: Marking RMI port: null from d:\app\Administrator\product\11.2.0\dbhome_1\oc4j\j2ee\OC4J_DBConsole
    Jan 31, 2013 7:06:11 PM oracle.sysman.emcp.util.PortManager markAllUsedPorts
    CONFIG: Marking HTTP port: null from d:\app\Administrator\product\11.2.0\dbhome_1\oc4j\j2ee\OC4J_DBConsole
    Jan 31, 2013 7:06:11 PM oracle.sysman.emcp.util.PortManager markAllUsedPorts
    CONFIG: Marking JMS port: null from d:\app\Administrator\product\11.2.0\dbhome_1\oc4j\j2ee\OC4J_DBConsole1_D
    Jan 31, 2013 7:06:11 PM oracle.sysman.emcp.util.PortManager markAllUsedPorts
    CONFIG: Marking RMI port: null from d:\app\Administrator\product\11.2.0\dbhome_1\oc4j\j2ee\OC4J_DBConsole1_D
    Jan 31, 2013 7:06:11 PM oracle.sysman.emcp.util.PortManager markAllUsedPorts
    CONFIG: Marking HTTP port: null from d:\app\Administrator\product\11.2.0\dbhome_1\oc4j\j2ee\OC4J_DBConsole1_D
    Jan 31, 2013 7:06:11 PM oracle.sysman.emcp.util.PortManager markAllUsedPorts
    CONFIG: Marking JMS port: 5540 from d:\app\Administrator\product\11.2.0\dbhome_1\oc4j\j2ee\OC4J_DBConsole_STORAGE1.EFFTRONICS.LOCAL_csdb
    Jan 31, 2013 7:06:11 PM oracle.sysman.emcp.util.PortManager markAllUsedPorts
    CONFIG: Marking RMI port: 5520 from d:\app\Administrator\product\11.2.0\dbhome_1\oc4j\j2ee\OC4J_DBConsole_STORAGE1.EFFTRONICS.LOCAL_csdb
    Jan 31, 2013 7:06:11 PM oracle.sysman.emcp.util.PortManager markAllUsedPorts
    CONFIG: Marking HTTP port: 1158 from d:\app\Administrator\product\11.2.0\dbhome_1\oc4j\j2ee\OC4J_DBConsole_STORAGE1.EFFTRONICS.LOCAL_csdb
    Jan 31, 2013 7:06:11 PM oracle.sysman.emcp.util.PortManager findUsedPortsFromXML
    CONFIG: Could not find or correctly parse file d:\app\Administrator\product\11.2.0\dbhome_1\oc4j\j2ee\OC4J_DBConsole_storage1_csdb\config\jms.xml in searching for tag jms-server with attribute port
    java.io.FileNotFoundException: d:\app\Administrator\product\11.2.0\dbhome_1\oc4j\j2ee\OC4J_DBConsole_storage1_csdb\config\jms.xml (The system cannot find the path specified)
         at java.io.FileInputStream.open(Native Method)
         at java.io.FileInputStream.<init>(FileInputStream.java:106)
         at java.io.FileInputStream.<init>(FileInputStream.java:66)
         at java.io.FileReader.<init>(FileReader.java:41)
         at oracle.sysman.emcp.util.PortManager.findUsedPortsFromXML(PortManager.java:296)
         at oracle.sysman.emcp.util.PortManager.markAllUsedPorts(PortManager.java:1297)
         at oracle.sysman.emcp.util.PortManager.getFreePorts(PortManager.java:592)
         at oracle.sysman.emcp.EMDBPreConfig.getFreePorts(EMDBPreConfig.java:2742)
         at oracle.sysman.emcp.EMDBPreConfig.checkPorts(EMDBPreConfig.java:2677)
         at oracle.sysman.emcp.EMDBPreConfig.performConfiguration(EMDBPreConfig.java:864)
         at oracle.sysman.emcp.EMDBPreConfig.invoke(EMDBPreConfig.java:282)
         at oracle.sysman.emcp.EMDBPreConfig.invoke(EMDBPreConfig.java:195)
         at oracle.sysman.emcp.EMConfig.perform(EMConfig.java:250)
         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)
    Jan 31, 2013 7:06:11 PM oracle.sysman.emcp.util.PortManager markAllUsedPorts
    CONFIG: Marking JMS port: null from d:\app\Administrator\product\11.2.0\dbhome_1\oc4j\j2ee\OC4J_DBConsole_storage1_csdb
    Jan 31, 2013 7:06:11 PM oracle.sysman.emcp.util.PortManager findUsedPortsFromXML
    CONFIG: Could not find or correctly parse file d:\app\Administrator\product\11.2.0\dbhome_1\oc4j\j2ee\OC4J_DBConsole_storage1_csdb\config\rmi.xml in searching for tag rmi-server with attribute port
    java.io.FileNotFoundException: d:\app\Administrator\product\11.2.0\dbhome_1\oc4j\j2ee\OC4J_DBConsole_storage1_csdb\config\rmi.xml (The system cannot find the path specified)
         at java.io.FileInputStream.open(Native Method)
         at java.io.FileInputStream.<init>(FileInputStream.java:106)
         at java.io.FileInputStream.<init>(FileInputStream.java:66)
         at java.io.FileReader.<init>(FileReader.java:41)
         at oracle.sysman.emcp.util.PortManager.findUsedPortsFromXML(PortManager.java:296)
         at oracle.sysman.emcp.util.PortManager.markAllUsedPorts(PortManager.java:1301)
         at oracle.sysman.emcp.util.PortManager.getFreePorts(PortManager.java:592)
         at oracle.sysman.emcp.EMDBPreConfig.getFreePorts(EMDBPreConfig.java:2742)
         at oracle.sysman.emcp.EMDBPreConfig.checkPorts(EMDBPreConfig.java:2677)
         at oracle.sysman.emcp.EMDBPreConfig.performConfiguration(EMDBPreConfig.java:864)
         at oracle.sysman.emcp.EMDBPreConfig.invoke(EMDBPreConfig.java:282)
         at oracle.sysman.emcp.EMDBPreConfig.invoke(EMDBPreConfig.java:195)
         at oracle.sysman.emcp.EMConfig.perform(EMConfig.java:250)
         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)
    Jan 31, 2013 7:06:11 PM oracle.sysman.emcp.util.PortManager markAllUsedPorts
    CONFIG: Marking RMI port: null from d:\app\Administrator\product\11.2.0\dbhome_1\oc4j\j2ee\OC4J_DBConsole_storage1_csdb
    Jan 31, 2013 7:06:11 PM oracle.sysman.emcp.util.PortManager findUsedPortsFromXML
    CONFIG: Could not find or correctly parse file d:\app\Administrator\product\11.2.0\dbhome_1\oc4j\j2ee\OC4J_DBConsole_storage1_csdb\config\http-web-site.xml in searching for tag web-site with attribute port
    java.io.FileNotFoundException: d:\app\Administrator\product\11.2.0\dbhome_1\oc4j\j2ee\OC4J_DBConsole_storage1_csdb\config\http-web-site.xml (The system cannot find the path specified)
         at java.io.FileInputStream.open(Native Method)
         at java.io.FileInputStream.<init>(FileInputStream.java:106)
         at java.io.FileInputStream.<init>(FileInputStream.java:66)
         at java.io.FileReader.<init>(FileReader.java:41)
         at oracle.sysman.emcp.util.PortManager.findUsedPortsFromXML(PortManager.java:296)
         at oracle.sysman.emcp.util.PortManager.markAllUsedPorts(PortManager.java:1305)
         at oracle.sysman.emcp.util.PortManager.getFreePorts(PortManager.java:592)
         at oracle.sysman.emcp.EMDBPreConfig.getFreePorts(EMDBPreConfig.java:2742)
         at oracle.sysman.emcp.EMDBPreConfig.checkPorts(EMDBPreConfig.java:2677)
         at oracle.sysman.emcp.EMDBPreConfig.performConfiguration(EMDBPreConfig.java:864)
         at oracle.sysman.emcp.EMDBPreConfig.invoke(EMDBPreConfig.java:282)
         at oracle.sysman.emcp.EMDBPreConfig.invoke(EMDBPreConfig.java:195)
         at oracle.sysman.emcp.EMConfig.perform(EMConfig.java:250)
         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)
    Jan 31, 2013 7:06:11 PM oracle.sysman.emcp.util.PortManager markAllUsedPorts
    CONFIG: Marking HTTP port: null from d:\app\Administrator\product\11.2.0\dbhome_1\oc4j\j2ee\OC4J_DBConsole_storage1_csdb
    Jan 31, 2013 7:06:11 PM oracle.sysman.emcp.util.PortManager markAllUsedPorts
    CONFIG: Marking JMS port: 5541 from d:\app\Administrator\product\11.2.0\dbhome_1\oc4j\j2ee\OC4J_DBConsole_storage1_ITTMPDB
    Jan 31, 2013 7:06:11 PM oracle.sysman.emcp.util.PortManager markAllUsedPorts
    CONFIG: Marking RMI port: 5521 from d:\app\Administrator\product\11.2.0\dbhome_1\oc4j\j2ee\OC4J_DBConsole_storage1_ITTMPDB
    Jan 31, 2013 7:06:11 PM oracle.sysman.emcp.util.PortManager markAllUsedPorts
    CONFIG: Marking HTTP port: 5500 from d:\app\Administrator\product\11.2.0\dbhome_1\oc4j\j2ee\OC4J_DBConsole_storage1_ITTMPDB
    Jan 31, 2013 7:06:11 PM oracle.sysman.emcp.util.PortManager markAllUsedPorts
    CONFIG: Marking Agent port: 3938 from d:\app\Administrator\product\11.2.0\dbhome_1\storage1_csdb\sysman\config\emd.properties
    Jan 31, 2013 7:06:11 PM oracle.sysman.emcp.util.PortManager markAllUsedPorts
    CONFIG: Marking Agent port: 1830 from d:\app\Administrator\product\11.2.0\dbhome_1\storage1_ITTMPDB\sysman\config\emd.properties
    Jan 31, 2013 7:06:11 PM oracle.sysman.emcp.util.PortManager getAgentPort
    CONFIG: Cannot parse EMD_URL correctly. No port identified
    Jan 31, 2013 7:06:11 PM oracle.sysman.emcp.util.PortManager markAllUsedPorts
    CONFIG: Marking Agent port: null from d:\app\Administrator\product\11.2.0\dbhome_1\sysman\config\emd.properties
    Jan 31, 2013 7:06:11 PM oracle.sysman.emcp.util.PortManager markAllUsedPorts
    CONFIG: Cannnot parse EMD_URL correctly. No port identified
    Jan 31, 2013 7:06:11 PM oracle.sysman.emcp.util.FileUtil getProperties
    CONFIG: Error reading file d:\app\Administrator\product\11.2.0\dbhome_1\install\staticports.ini
    Jan 31, 2013 7:06:11 PM oracle.sysman.emcp.util.PortManager getFreePorts
    CONFIG: d:\app\Administrator\product\11.2.0\dbhome_1:storage1:null:csdb:{}:null:{DBCONTROL_HTTP_PORT=5502, RMI_PORT=5523, JMS_PORT=5542, AGENT_PORT=3938}
    Jan 31, 2013 7:06:11 PM oracle.sysman.emcp.ParamsManager getParam
    CONFIG: No value was set for the parameter AGENT_PORT_storage1.
    Jan 31, 2013 7:06:11 PM oracle.sysman.emcp.ParamsManager setParam
    CONFIG: Setting param: AGENT_PORT_storage1 value: 3938
    Jan 31, 2013 7:06:11 PM oracle.sysman.emcp.ParamsManager getParam
    CONFIG: No value was set for the parameter DBCONTROL_HTTP_PORT_storage1.
    Jan 31, 2013 7:06:11 PM oracle.sysman.emcp.ParamsManager setParam
    CONFIG: Setting param: DBCONTROL_HTTP_PORT_storage1 value: 5502
    Jan 31, 2013 7:06:11 PM oracle.sysman.emcp.ParamsManager getParam
    CONFIG: No value was set for the parameter JMS_PORT_storage1.
    Jan 31, 2013 7:06:11 PM oracle.sysman.emcp.ParamsManager setParam
    CONFIG: Setting param: JMS_PORT_storage1 value: 5542
    Jan 31, 2013 7:06:11 PM oracle.sysman.emcp.ParamsManager getParam
    CONFIG: No value was set for the parameter RMI_PORT_storage1.
    Jan 31, 2013 7:06:11 PM oracle.sysman.emcp.ParamsManager setParam
    CONFIG: Setting param: RMI_PORT_storage1 value: 5523
    Jan 31, 2013 7:06:11 PM oracle.sysman.emcp.EMDBPreConfig getFreePorts
    CONFIG: Ports assigned for Node: storage1 : {DBCONTROL_HTTP_PORT=5502, RMI_PORT=5523, JMS_PORT=5542, AGENT_PORT=3938}
    Jan 31, 2013 7:06:11 PM oracle.sysman.emcp.util.DBControlUtil stopOMS
    INFO: Stopping Database Control (this may take a while) ...
    Jan 31, 2013 7:06:11 PM oracle.sysman.emcp.util.PlatformInterface serviceCommand
    CONFIG: cmdType: 1
    Jan 31, 2013 7:06:11 PM oracle.sysman.emcp.util.PlatformInterface isPre112Home
    CONFIG: oracleHome: d:\app\Administrator\product\11.2.0\dbhome_1 isPre112Home: false
    Jan 31, 2013 7:06:11 PM oracle.sysman.emcp.util.PlatformInterface serviceCommand
    CONFIG: Service does not exist
    Jan 31, 2013 7:06:11 PM oracle.sysman.emcp.util.ClusterUtil getLocalNode
    CONFIG: isLocalNodeDone: true localNode: null
    Jan 31, 2013 7:06:11 PM oracle.sysman.emcp.util.PlatformInterface getSortedEnvArray
    CONFIG: New Env List: [ALLUSERSPROFILE=C:\ProgramData, APPDATA=C:\Users\Administrator\AppData\Roaming, CLASSPATH=d:\app\Administrator\product\11.2.0\dbhome_1\jlib\emca.jar;d:\app\Administrator\product\11.2.0\dbhome_1\jlib\srvm.jar;d:\app\Administrator\product\11.2.0\dbhome_1\jlib\srvmasm.jar;d:\app\Administrator\product\11.2.0\dbhome_1\jlib\cvu.jar;d:\app\Administrator\product\11.2.0\dbhome_1\jlib\emConfigInstall.jar;d:\app\Administrator\product\11.2.0\dbhome_1\jlib\ldapjclnt11.jar;d:\app\Administrator\product\11.2.0\dbhome_1\jlib\ldap.jar;d:\app\Administrator\product\11.2.0\dbhome_1\jlib\share.jar;d:\app\Administrator\product\11.2.0\dbhome_1\jlib\srvmhas.jar;d:\app\Administrator\product\11.2.0\dbhome_1\jlib\netcfg.jar;d:\app\Administrator\product\11.2.0\dbhome_1\jlib\http_client.jar;d:\app\Administrator\product\11.2.0\dbhome_1\lib\http_client.jar;d:\app\Administrator\product\11.2.0\dbhome_1\lib\xmlparserv2.jar;d:\app\Administrator\product\11.2.0\dbhome_1\assistants\jlib\assistantsCommon.jar;d:\app\Administrator\product\11.2.0\dbhome_1\sysman\jlib\emCORE.jar;d:\app\Administrator\product\11.2.0\dbhome_1\sysman\jlib\emagentSDK.jar;d:\app\Administrator\product\11.2.0\dbhome_1\oui\jlib\OraInstaller.jar;d:\app\Administrator\product\11.2.0\dbhome_1\oui\jlib\OraPrereq.jar;d:\app\Administrator\product\11.2.0\dbhome_1\inventory\prereqs\oui\OraPrereqChecks.jar;d:\app\Administrator\product\11.2.0\dbhome_1\oui\jlib\OraPrereqChecks.jar;, CLIENTNAME=EFF-CPU-426, COMMONPROGRAMFILES=C:\Program Files\Common Files, COMMONPROGRAMFILES(X86)=C:\Program Files (x86)\Common Files, COMMONPROGRAMW6432=C:\Program Files\Common Files, COMPUTERNAME=STORAGE1, COMSPEC=C:\Windows\system32\cmd.exe, EMCA_JAR=d:\app\Administrator\product\11.2.0\dbhome_1\jlib\emca.jar, EMDROOT=d:\app\Administrator\product\11.2.0\dbhome_1, FP_NO_HOST_CHECK=NO, HOMEDRIVE=C:, HOMEPATH=\Users\Administrator, JRE_JAVA=d:\app\Administrator\product\11.2.0\dbhome_1\jdk\jre\bin\java, LD_LIBRARY_PATH=d:\app\Administrator\product\11.2.0\dbhome_1\lib32;d:\app\Administrator\product\11.2.0\dbhome_1\lib;d:\app\Administrator\product\11.2.0\dbhome_1\perl\lib;null, LIB_DIR=d:\app\Administrator\product\11.2.0\dbhome_1\jlib, LOCALAPPDATA=C:\Users\Administrator\AppData\Local, LOGONSERVER=\\STORAGE1, NUMBER_OF_PROCESSORS=12, OH=d:\app\Administrator\product\11.2.0\dbhome_1, ORACLE_UNQNAME=D:\app\Administrator\product\11.2.0\dbhome_1\STORAGE1.EFFTRONICS.LOCAL_csdb, OS=Windows_NT, PATH=d:\app\Administrator\product\11.2.0\dbhome_1\bin;d:\app\Administrator\product\11.2.0\dbhome_1\jdk\jre\bin\server;d:\app\Administrator\product\11.2.0\dbhome_1\bin;d:\app\Administrator\product\11.2.0\dbhome_1\bin;C:\Windows\system32;C:\Windows;C:\Windows\System32\Wbem;C:\Windows\System32\WindowsPowerShell\v1.0\;C:\Program Files (x86)\Dell\SysMgt\shared\bin;C:\Program Files (x86)\Dell\SysMgt\oma\bin;C:\Program Files (x86)\Dell\SysMgt\idrac;D:\app\Administrator\product\11.2.0\dbhome_1\STORAGE1.EFFTRONICS.LOCAL_csdb, PATHEXT=.COM;.EXE;.BAT;.CMD;.VBS;.VBE;.JS;.JSE;.WSF;.WSH;.MSC, PERL5LIB=d:\app\Administrator\product\11.2.0\dbhome_1\sysman\admin\scripts;d:\app\Administrator\product\11.2.0\dbhome_1\bin;, PROCESSOR_ARCHITECTURE=AMD64, PROCESSOR_IDENTIFIER=Intel64 Family 6 Model 44 Stepping 2, GenuineIntel, PROCESSOR_LEVEL=6, PROCESSOR_REVISION=2c02, PROGRAMDATA=C:\ProgramData, PROGRAMFILES=C:\Program Files, PROGRAMFILES(X86)=C:\Program Files (x86), PROGRAMW6432=C:\Program Files, PROMPT=$P$G, PSMODULEPATH=C:\Windows\system32\WindowsPowerShell\v1.0\Modules\, PUBLIC=C:\Users\Public, SESSIONNAME=RDP-Tcp#0, SYSTEMDRIVE=C:, SYSTEMROOT=C:\Windows, TEMP=C:\Users\ADMINI~1\AppData\Local\Temp\2, TMP=C:\Users\ADMINI~1\AppData\Local\Temp\2, USERDOMAIN=STORAGE1, USERNAME=Administrator, USERPROFILE=C:\Users\Administrator, WINDIR=C:\Windows, WINDOWS_TRACING_FLAGS=3, WINDOWS_TRACING_LOGFILE=C:\BVTBin\Tests\installpackage\csilogfile.log]
    Jan 31, 2013 7:06:11 PM oracle.sysman.emcp.util.PlatformInterface executeCommand
    CONFIG: Starting execution: d:/app/Administrator/product/11.2.0/dbhome_1/perl/bin\perl.exe d:\app\Administrator\product\11.2.0\dbhome_1\sysman\admin\scripts\db\sgastop.pl stop csdb storage1 1521 d:\app\Administrator\product\11.2.0\dbhome_1
    Jan 31, 2013 7:06:11 PM oracle.sysman.emcp.util.PlatformInterface executeCommand
    CONFIG: Exit value of 0
    Jan 31, 2013 7:06:11 PM oracle.sysman.emcp.util.PlatformInterface executeCommand
    CONFIG: Execution of d:/app/Administrator/product/11.2.0/dbhome_1/perl/bin\perl.exe d:\app\Administrator\product\11.2.0\dbhome_1\sysman\admin\scripts\db\sgastop.pl stop csdb storage1 1521 d:\app\Administrator\product\11.2.0\dbhome_1 completed successfully
    Jan 31, 2013 7:06:11 PM oracle.sysman.emcp.util.PlatformInterface executeCommand
    CONFIG: nmccollector process does not exist

    Jan 31, 2013 7:06:11 PM oracle.sysman.emcp.util.DBControlUtil stopNmccollector
    CONFIG: Successfully stopped nmc-collector process
    Jan 31, 2013 7:06:11 PM oracle.sysman.emcp.util.PlatformInterface serviceCommand
    CONFIG: cmdType: 2
    Jan 31, 2013 7:06:11 PM oracle.sysman.emcp.util.PlatformInterface isPre112Home
    CONFIG: oracleHome: d:\app\Administrator\product\11.2.0\dbhome_1 isPre112Home: false
    Jan 31, 2013 7:06:11 PM oracle.sysman.emcp.util.PlatformInterface serviceCommand
    CONFIG: Service does not exist
    Jan 31, 2013 7:06:11 PM oracle.sysman.emcp.ParamsManager getParam
    CONFIG: No value was set for the parameter ORACLE_HOSTNAME.
    Jan 31, 2013 7:06:11 PM oracle.sysman.emcp.util.ClusterUtil getLocalNode
    CONFIG: isLocalNodeDone: true localNode: null
    Jan 31, 2013 7:06:11 PM oracle.sysman.emcp.EMDBPreConfig copyAgentTimeStampFile
    CONFIG: Copying file: d:\app\Administrator\product\11.2.0\dbhome_1\storage1_csdb\sysman\emd\agntstmp.txt to d:\app\Administrator\product\11.2.0\dbhome_1\sysman\emd\agntstmp.txt.csdb
    Jan 31, 2013 7:06:11 PM oracle.sysman.emcp.util.FileUtil _copyFile
    CONFIG: Copying file d:\app\Administrator\product\11.2.0\dbhome_1\storage1_csdb\sysman\emd\agntstmp.txt to d:\app\Administrator\product\11.2.0\dbhome_1\sysman\emd\agntstmp.txt.csdb
    Jan 31, 2013 7:06:11 PM oracle.sysman.emcp.EMDBPreConfig copyAgentTimeStampFile
    CONFIG: File copied successfully.
    Jan 31, 2013 7:06:11 PM oracle.sysman.emcp.ParamsManager getHost
    CONFIG: Host having instnces running for database csdb : storage1
    Jan 31, 2013 7:06:11 PM oracle.sysman.emcp.ParamsManager setParam
    CONFIG: Setting param: REP_DB_RUNNING_HOST value: storage1
    Jan 31, 2013 7:06:11 PM oracle.sysman.emcp.ParamsManager getRepDbPort
    CONFIG: Listener Port: 1521
    Jan 31, 2013 7:06:11 PM oracle.sysman.emcp.util.GeneralUtil isLocalConnectionRequired
    CONFIG: isLocalConnectionRequired: true
    Jan 31, 2013 7:06:11 PM oracle.sysman.emcp.util.GeneralUtil initSQLEngine
    CONFIG: isLocalConnectionRequired: true. Connecting to database instance locally.
    Jan 31, 2013 7:06:11 PM oracle.sysman.emcp.util.GeneralUtil initSQLEngineLoacly
    CONFIG: SQLEngine connecting with SID: csdb, oracleHome: d:\app\Administrator\product\11.2.0\dbhome_1, and user: SYS
    Jan 31, 2013 7:06:11 PM oracle.sysman.emcp.util.GeneralUtil initSQLEngineLoacly
    CONFIG: SQLEngine created successfully and connected
    Jan 31, 2013 7:06:11 PM oracle.sysman.emcp.EMReposConfig createRepository
    CONFIG: Spooling to d:\app\Administrator\cfgtoollogs\emca\csdb\emca_repos_create_2013_01_31_19_06_11.log
    Jan 31, 2013 7:06:11 PM oracle.sysman.emcp.EMReposConfig createRepository
    INFO: Creating the EM repository (this may take a while) ...
    Jan 31, 2013 7:06:11 PM 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)
    Jan 31, 2013 7:06:11 PM oracle.sysman.emcp.EMReposConfig invoke
    SEVERE: Error creating the repository
    Jan 31, 2013 7:06:11 PM oracle.sysman.emcp.EMReposConfig invoke
    INFO: Refer to the log file at d:\app\Administrator\cfgtoollogs\emca\csdb\emca_repos_create_<date>.log for more details.
    Jan 31, 2013 7:06:11 PM oracle.sysman.emcp.EMConfig perform
    SEVERE: Error creating the repository
    Refer to the log file at d:\app\Administrator\cfgtoollogs\emca\csdb\emca_2013_01_31_19_05_50.log for more details.
    Jan 31, 2013 7:06:11 PM 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)
    Jan 31, 2013 7:06:11 PM oracle.sysman.emcp.EMConfig restoreOuiLoc
    CONFIG: Restoring oracle.installer.oui_loc to d:\app\Administrator\product\11.2.0\dbhome_1\oui
  • 3. Re: EM Console Not Working
    asahide Expert
    Currently Being Moderated
    Hi,

    Let's try reconfig..
    <<http://gerardnico.com/wiki/database/oracle/oracledb_emca_how_to_reconfigure>>

    Regards,
  • 4. Re: EM Console Not Working
    Osama_Mustafa Oracle ACE
    Currently Being Moderated
    oracle.sysman.assistants.util.sqlEngine.SQLFatalErrorException: ORA-20001: SYSMAN already exists..
    ORA-06512: at line 17
    emca -deconfig dbcontrol db -repos drop
    emca -config dbcontrol db -repos create
  • 5. Re: EM Console Not Working
    Venkateshj Newbie
    Currently Being Moderated
    Osama_mustafa wrote:
    oracle.sysman.assistants.util.sqlEngine.SQLFatalErrorException: ORA-20001: SYSMAN already exists..
    ORA-06512: at line 17
    emca -deconfig dbcontrol db -repos drop
    emca -config dbcontrol db -repos create
    C:\>emca -deconfig dbcontrol db -repos drop

    STARTED EMCA at Jan 31, 2013 7:29:24 PM
    EM Configuration Assistant, Version 11.2.0.0.2 Production
    Copyright (c) 2003, 2005, Oracle. All rights reserved.

    Enter the following information:
    Database SID: csdb
    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
    Jan 31, 2013 7:29:40 PM oracle.sysman.emcp.EMConfig perform
    INFO: This operation is being logged at d:\app\Administrator\cfgtoollogs\emca\cs
    db\emca_2013_01_31_19_29_24.log.
    Jan 31, 2013 7:29:40 PM oracle.sysman.emcp.util.DBControlUtil stopOMS
    INFO: Stopping Database Control (this may take a while) ...
    Jan 31, 2013 7:29:41 PM oracle.sysman.emcp.EMReposConfig stopDBMSJobs
    WARNING: Error initializing SQL connection. SQL operations cannot be performed
    Jan 31, 2013 7:29:41 PM oracle.sysman.emcp.EMReposConfig invoke
    WARNING: Unable to remove DBMS jobs.
    Jan 31, 2013 7:29:41 PM oracle.sysman.emcp.ParamsManager checkListenerStatusForD
    BControl
    WARNING: Error initializing SQL connection. SQL operations cannot be performed
    Jan 31, 2013 7:29:41 PM oracle.sysman.emcp.EMReposConfig invoke
    INFO: Dropping the EM repository (this may take a while) ...
    Jan 31, 2013 7:29:42 PM oracle.sysman.emcp.EMReposConfig invoke
    INFO: Repository successfully dropped
    Jan 31, 2013 7:29:42 PM oracle.sysman.emcp.EMConfig perform
    SEVERE: Error de-configuring EM for database csdb.
    Refer to the log file at d:\app\Administrator\cfgtoollogs\emca\csdb\emca_2013_01
    _31_19_29_24.log for more details.
    Could not complete the configuration. Refer to the log file at d:\app\Administra
    tor\cfgtoollogs\emca\csdb\emca_2013_01_31_19_29_24.log for more details.

    C:\>



    These are the errors getting sir...
  • 6. Re: EM Console Not Working
    Venkateshj Newbie
    Currently Being Moderated
    Venkateshj wrote:
    Osama_mustafa wrote:
    oracle.sysman.assistants.util.sqlEngine.SQLFatalErrorException: ORA-20001: SYSMAN already exists..
    ORA-06512: at line 17
    emca -deconfig dbcontrol db -repos drop
    emca -config dbcontrol db -repos create
    C:\>emca -deconfig dbcontrol db -repos drop

    STARTED EMCA at Jan 31, 2013 7:29:24 PM
    EM Configuration Assistant, Version 11.2.0.0.2 Production
    Copyright (c) 2003, 2005, Oracle. All rights reserved.

    Enter the following information:
    Database SID: csdb
    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
    Jan 31, 2013 7:29:40 PM oracle.sysman.emcp.EMConfig perform
    INFO: This operation is being logged at d:\app\Administrator\cfgtoollogs\emca\cs
    db\emca_2013_01_31_19_29_24.log.
    Jan 31, 2013 7:29:40 PM oracle.sysman.emcp.util.DBControlUtil stopOMS
    INFO: Stopping Database Control (this may take a while) ...
    Jan 31, 2013 7:29:41 PM oracle.sysman.emcp.EMReposConfig stopDBMSJobs
    WARNING: Error initializing SQL connection. SQL operations cannot be performed
    Jan 31, 2013 7:29:41 PM oracle.sysman.emcp.EMReposConfig invoke
    WARNING: Unable to remove DBMS jobs.
    Jan 31, 2013 7:29:41 PM oracle.sysman.emcp.ParamsManager checkListenerStatusForD
    BControl
    WARNING: Error initializing SQL connection. SQL operations cannot be performed
    Jan 31, 2013 7:29:41 PM oracle.sysman.emcp.EMReposConfig invoke
    INFO: Dropping the EM repository (this may take a while) ...
    Jan 31, 2013 7:29:42 PM oracle.sysman.emcp.EMReposConfig invoke
    INFO: Repository successfully dropped
    Jan 31, 2013 7:29:42 PM oracle.sysman.emcp.EMConfig perform
    SEVERE: Error de-configuring EM for database csdb.
    Refer to the log file at d:\app\Administrator\cfgtoollogs\emca\csdb\emca_2013_01
    _31_19_29_24.log for more details.
    Could not complete the configuration. Refer to the log file at d:\app\Administra
    tor\cfgtoollogs\emca\csdb\emca_2013_01_31_19_29_24.log for more details.

    C:\>



    These are the errors getting sir...
    Logfile:-

    CONFIG: New Env List: [ALLUSERSPROFILE=C:\ProgramData, APPDATA=C:\Users\Administrator\AppData\Roaming, CLASSPATH=d:\app\Administrator\product\11.2.0\dbhome_1\jlib\emca.jar;d:\app\Administrator\product\11.2.0\dbhome_1\jlib\srvm.jar;d:\app\Administrator\product\11.2.0\dbhome_1\jlib\srvmasm.jar;d:\app\Administrator\product\11.2.0\dbhome_1\jlib\cvu.jar;d:\app\Administrator\product\11.2.0\dbhome_1\jlib\emConfigInstall.jar;d:\app\Administrator\product\11.2.0\dbhome_1\jlib\ldapjclnt11.jar;d:\app\Administrator\product\11.2.0\dbhome_1\jlib\ldap.jar;d:\app\Administrator\product\11.2.0\dbhome_1\jlib\share.jar;d:\app\Administrator\product\11.2.0\dbhome_1\jlib\srvmhas.jar;d:\app\Administrator\product\11.2.0\dbhome_1\jlib\netcfg.jar;d:\app\Administrator\product\11.2.0\dbhome_1\jlib\http_client.jar;d:\app\Administrator\product\11.2.0\dbhome_1\lib\http_client.jar;d:\app\Administrator\product\11.2.0\dbhome_1\lib\xmlparserv2.jar;d:\app\Administrator\product\11.2.0\dbhome_1\assistants\jlib\assistantsCommon.jar;d:\app\Administrator\product\11.2.0\dbhome_1\sysman\jlib\emCORE.jar;d:\app\Administrator\product\11.2.0\dbhome_1\sysman\jlib\emagentSDK.jar;d:\app\Administrator\product\11.2.0\dbhome_1\oui\jlib\OraInstaller.jar;d:\app\Administrator\product\11.2.0\dbhome_1\oui\jlib\OraPrereq.jar;d:\app\Administrator\product\11.2.0\dbhome_1\inventory\prereqs\oui\OraPrereqChecks.jar;d:\app\Administrator\product\11.2.0\dbhome_1\oui\jlib\OraPrereqChecks.jar;, CLIENTNAME=EFF-CPU-426, COMMONPROGRAMFILES=C:\Program Files\Common Files, COMMONPROGRAMFILES(X86)=C:\Program Files (x86)\Common Files, COMMONPROGRAMW6432=C:\Program Files\Common Files, COMPUTERNAME=STORAGE1, COMSPEC=C:\Windows\system32\cmd.exe, EMCA_JAR=d:\app\Administrator\product\11.2.0\dbhome_1\jlib\emca.jar, FP_NO_HOST_CHECK=NO, HOMEDRIVE=C:, HOMEPATH=\Users\Administrator, JRE_JAVA=d:\app\Administrator\product\11.2.0\dbhome_1\jdk\jre\bin\java, LIB_DIR=d:\app\Administrator\product\11.2.0\dbhome_1\jlib, LOCALAPPDATA=C:\Users\Administrator\AppData\Local, LOGONSERVER=\\STORAGE1, NUMBER_OF_PROCESSORS=12, OH=d:\app\Administrator\product\11.2.0\dbhome_1, ORACLE_HOME=d:\app\Administrator\product\11.2.0\dbhome_1, ORACLE_SID=csdb, ORACLE_UNQNAME=D:\app\Administrator\product\11.2.0\dbhome_1\STORAGE1.EFFTRONICS.LOCAL_csdb, OS=Windows_NT, PATH=d:\app\Administrator\product\11.2.0\dbhome_1\bin;d:\app\Administrator\product\11.2.0\dbhome_1\bin;C:\Windows\system32;C:\Windows;C:\Windows\System32\Wbem;C:\Windows\System32\WindowsPowerShell\v1.0\;C:\Program Files (x86)\Dell\SysMgt\shared\bin;C:\Program Files (x86)\Dell\SysMgt\oma\bin;C:\Program Files (x86)\Dell\SysMgt\idrac;D:\app\Administrator\product\11.2.0\dbhome_1\STORAGE1.EFFTRONICS.LOCAL_csdb, PATHEXT=.COM;.EXE;.BAT;.CMD;.VBS;.VBE;.JS;.JSE;.WSF;.WSH;.MSC, PROCESSOR_ARCHITECTURE=AMD64, PROCESSOR_IDENTIFIER=Intel64 Family 6 Model 44 Stepping 2, GenuineIntel, PROCESSOR_LEVEL=6, PROCESSOR_REVISION=2c02, PROGRAMDATA=C:\ProgramData, PROGRAMFILES=C:\Program Files, PROGRAMFILES(X86)=C:\Program Files (x86), PROGRAMW6432=C:\Program Files, PROMPT=$P$G, PSMODULEPATH=C:\Windows\system32\WindowsPowerShell\v1.0\Modules\, PUBLIC=C:\Users\Public, SESSIONNAME=RDP-Tcp#0, SYSTEMDRIVE=C:, SYSTEMROOT=C:\Windows, TEMP=C:\Users\ADMINI~1\AppData\Local\Temp\2, TMP=C:\Users\ADMINI~1\AppData\Local\Temp\2, USERDOMAIN=STORAGE1, USERNAME=Administrator, USERPROFILE=C:\Users\Administrator, WINDIR=C:\Windows, WINDOWS_TRACING_FLAGS=3, WINDOWS_TRACING_LOGFILE=C:\BVTBin\Tests\installpackage\csilogfile.log]
    Jan 31, 2013 7:29:41 PM oracle.sysman.emcp.util.PlatformInterface executeCommand
    CONFIG: Starting execution: CMD /C d:\app\Administrator\product\11.2.0\dbhome_1\sysman\admin\emdrep\bin\RepManager.bat -connect (DESCRIPTION=(ADDRESS_LIST=(ADDRESS=(PROTOCOL=TCP)(HOST=storage1)(PORT=1521)))(CONNECT_DATA=(SERVICE_NAME=csdb))) -repos_user SYSMAN -action drop -verbose -output_file d:\app\Administrator\cfgtoollogs\emca\csdb\emca_repos_drop_2013_01_31_19_29_41.log
    Jan 31, 2013 7:29:42 PM oracle.sysman.emcp.util.PlatformInterface executeCommand
    CONFIG: Exit value of 0
    Jan 31, 2013 7:29:42 PM oracle.sysman.emcp.util.PlatformInterface executeCommand
    CONFIG: Execution of CMD /C d:\app\Administrator\product\11.2.0\dbhome_1\sysman\admin\emdrep\bin\RepManager.bat -connect (DESCRIPTION=(ADDRESS_LIST=(ADDRESS=(PROTOCOL=TCP)(HOST=storage1)(PORT=1521)))(CONNECT_DATA=(SERVICE_NAME=csdb))) -repos_user SYSMAN -action drop -verbose -output_file d:\app\Administrator\cfgtoollogs\emca\csdb\emca_repos_drop_2013_01_31_19_29_41.log completed successfully
    Jan 31, 2013 7:29:42 PM oracle.sysman.emcp.util.PlatformInterface executeCommand
    CONFIG: Enter SYS user's password :
    Getting temporary tablespace from database...
    Found temporary tablespace: TEMP
    Environment :
    ORACLE HOME = d:/app/Administrator/product/11.2.0/dbhome_1
    REPOSITORY HOME = d:/app/Administrator/product/11.2.0/dbhome_1
    SQLPLUS = d:/app/Administrator/product/11.2.0/dbhome_1/bin/sqlplus
    SQL SCRIPT ROOT = d:/app/Administrator/product/11.2.0/dbhome_1/sysman/admin/emdrep/sql
    EXPORT = d:/app/Administrator/product/11.2.0/dbhome_1/bin/exp
    IMPORT = d:/app/Administrator/product/11.2.0/dbhome_1/bin/imp
    LOADJAVA = d:/app/Administrator/product/11.2.0/dbhome_1/bin/loadjava
    JAR FILE ROOT = d:/app/Administrator/product/11.2.0/dbhome_1/sysman/admin/emdrep/lib
    JOB TYPES ROOT = d:/app/Administrator/product/11.2.0/dbhome_1/sysman/admin/emdrep/bin
    Arguments :
    Connect String = (DESCRIPTION=(ADDRESS_LIST=(ADDRESS=(PROTOCOL=TCP)(HOST=storage1)(PORT=1521)))(CONNECT_DATA=(SERVICE_NAME=csdb)))
    Action = drop
    Repos User = SYSMAN
    Default tablespace = MGMT_TABLESPACE
    Default Data file = mgmt.dbf
    Dflt Dfile Init size = 20m
    Dflt Dfile Ext size = 20m
    ECM tablespace = MGMT_ECM_DEPOT_TS
    ECM Data file = mgmt_ecm_depot1.dbf
    ECM Dfile Init size = 100m
    ECM Dfile Ext size = 100m
    ECM CSA tablespace = MGMT_TABLESPACE
    ECM CSA Data file = mgmt_ecm_csa1.dbf
    ECM CSA Dfile Init size = 100m
    ECM CSA Dfile Ext size = 100m
    TEMP tablespace = TEMP
    Create options = 3
    Verbose output = 1
    Output File = d:\app\Administrator\cfgtoollogs\emca\csdb\emca_repos_drop_2013_01_31_19_29_41.log
    Repos creation mode = CENTRAL
    MetaLink user name = NOTAVAILABLE_
    MetaLink URL = http://updates.oracle.com
    Export Directory = d:/app/Administrator/product/11.2.0/dbhome_1/sysman/log
    Import Directory = d:/app/Administrator/product/11.2.0/dbhome_1/sysman/log
    Path Separator = "\;"
    Checking SYS Credentials ... rem error switch
    Return code = 1.Failed
    rem error switch
    SYS credentials or connect string is invalid.

    Jan 31, 2013 7:29:42 PM oracle.sysman.emcp.util.PlatformInterface executeCommand
    CONFIG: 'stty' is not recognized as an internal or external command,
    operable program or batch file.
    'stty' is not recognized as an internal or external command,
    operable program or batch file.

    Jan 31, 2013 7:29:42 PM oracle.sysman.emcp.EMReposConfig invoke
    INFO: Repository successfully dropped
    Jan 31, 2013 7:29:42 PM oracle.sysman.emcp.EMDBCConfig deleteOC4JDir
    CONFIG: Deleting state directories
    Jan 31, 2013 7:29:42 PM oracle.sysman.emcp.ParamsManager getParam
    CONFIG: No value was set for the parameter ORACLE_HOSTNAME.
    Jan 31, 2013 7:29:42 PM oracle.sysman.emcp.util.ClusterUtil getLocalNode
    CONFIG: isLocalNodeDone: true localNode: null
    Jan 31, 2013 7:29:42 PM oracle.sysman.emcp.EMDBCConfig deleteOC4JDir
    CONFIG: Unable to delete d:\app\Administrator\product\11.2.0\dbhome_1\oc4j\j2ee\OC4J_DBConsole_storage1_csdb
    Jan 31, 2013 7:29:42 PM oracle.sysman.emcp.EMConfig perform
    SEVERE: Error de-configuring EM for database csdb.
    Refer to the log file at d:\app\Administrator\cfgtoollogs\emca\csdb\emca_2013_01_31_19_29_24.log for more details.
    Jan 31, 2013 7:29:42 PM oracle.sysman.emcp.EMConfig perform
    CONFIG: Stack Trace:
    oracle.sysman.emcp.exception.EMConfigException: Error de-configuring EM for database csdb.
         at oracle.sysman.emcp.EMDBCConfig.performDeconfiguration(EMDBCConfig.java:533)
         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: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)
    Jan 31, 2013 7:29:42 PM oracle.sysman.emcp.EMConfig restoreOuiLoc
    CONFIG: Restoring oracle.installer.oui_loc to d:\app\Administrator\product\11.2.0\dbhome_1\oui
  • 7. Re: EM Console Not Working
    Osama_Mustafa Oracle ACE
    Currently Being Moderated
    post logs again
    d:\app\Administrator\cfgtoollogs\emca\csdb\emca_2013_01_31_19_29_24.log for more details.
  • 8. Re: EM Console Not Working
    Venkateshj Newbie
    Currently Being Moderated
    Osama_mustafa wrote:
    post logs again
    d:\app\Administrator\cfgtoollogs\emca\csdb\emca_2013_01_31_19_29_24.log for more details.
    CONFIG: Setting param: DB_UNIQUE_NAME value:
    Jan 31, 2013 7:29:40 PM oracle.sysman.emcp.ParamsManager getParam
    CONFIG: No value was set for the parameter DB_UNIQUE_NAME.
    Jan 31, 2013 7:29:40 PM oracle.sysman.emcp.DatabaseChecks getDbUniqueName
    CONFIG: No Database unique name available. Will try to retrieve it from DB itself
    Jan 31, 2013 7:29:40 PM oracle.sysman.emcp.ParamsManager setParam
    CONFIG: Setting param: DB_UNIQUE_NAME value: csdb
    Jan 31, 2013 7:29:40 PM oracle.sysman.emcp.ParamsManager getParam
    CONFIG: No value was set for the parameter DB_DOMAIN.
    Jan 31, 2013 7:29:40 PM oracle.sysman.emcp.DatabaseChecks getDbDomain
    CONFIG: No db domain available. Will query db for db_domain parameter
    Jan 31, 2013 7:29:40 PM oracle.sysman.emcp.ParamsManager setParam
    CONFIG: Setting param: DB_UNIQUE_NAME value: csdb
    Jan 31, 2013 7:29:40 PM oracle.sysman.emcp.ParamsManager setParam
    CONFIG: Setting param: SERVICE_NAME value: csdb
    Jan 31, 2013 7:29:40 PM oracle.sysman.emcp.ParamsManager setFlag
    CONFIG: Flag 'db' set to true
    Jan 31, 2013 7:29:40 PM oracle.sysman.emcp.ParamsManager getParam
    CONFIG: No value was set for the parameter MODIFY_SID.
    Jan 31, 2013 7:29:40 PM oracle.sysman.emcp.DatabaseChecks getDbServiceName
    CONFIG: No service name available. Will try to set db_unique_name.db_domain
    Jan 31, 2013 7:29:40 PM oracle.sysman.emcp.ParamsManager getHost
    CONFIG: Host having instnces running for database csdb : storage1
    Jan 31, 2013 7:29:40 PM oracle.sysman.emcp.ParamsManager setParam
    CONFIG: Setting param: REP_DB_RUNNING_HOST value: storage1
    Jan 31, 2013 7:29:40 PM oracle.sysman.emcp.ParamsManager getRepDbPort
    CONFIG: Listener Port: 1521
    Jan 31, 2013 7:29:40 PM oracle.sysman.emcp.util.GeneralUtil isLocalConnectionRequired
    CONFIG: isLocalConnectionRequired: true
    Jan 31, 2013 7:29:40 PM oracle.sysman.emcp.util.GeneralUtil initSQLEngine
    CONFIG: isLocalConnectionRequired: true. Connecting to database instance locally.
    Jan 31, 2013 7:29:40 PM oracle.sysman.emcp.util.GeneralUtil initSQLEngineLoacly
    CONFIG: SQLEngine connecting with SID: csdb, oracleHome: d:\app\Administrator\product\11.2.0\dbhome_1, and user: SYS
    Jan 31, 2013 7:29:40 PM oracle.sysman.emcp.util.GeneralUtil initSQLEngineLoacly
    CONFIG: SQLEngine created successfully and connected
    Jan 31, 2013 7:29:40 PM oracle.sysman.emcp.ParamsManager setParam
    CONFIG: Setting param: DB_UNIQUE_NAME value:
    Jan 31, 2013 7:29:40 PM oracle.sysman.emcp.ParamsManager getParam
    CONFIG: No value was set for the parameter DB_UNIQUE_NAME.
    Jan 31, 2013 7:29:40 PM oracle.sysman.emcp.DatabaseChecks getDbUniqueName
    CONFIG: No Database unique name available. Will try to retrieve it from DB itself
    Jan 31, 2013 7:29:40 PM oracle.sysman.emcp.ParamsManager setParam
    CONFIG: Setting param: DB_UNIQUE_NAME value: csdb
    Jan 31, 2013 7:29:40 PM oracle.sysman.emcp.ParamsManager getParam
    CONFIG: No value was set for the parameter DB_DOMAIN.
    Jan 31, 2013 7:29:40 PM oracle.sysman.emcp.DatabaseChecks getDbDomain
    CONFIG: No db domain available. Will query db for db_domain parameter
    Jan 31, 2013 7:29:40 PM oracle.sysman.emcp.ParamsManager setParam
    CONFIG: Setting param: DB_UNIQUE_NAME value: csdb
    Jan 31, 2013 7:29:40 PM oracle.sysman.emcp.ParamsManager setParam
    CONFIG: Setting param: SERVICE_NAME value: csdb
    Jan 31, 2013 7:29:40 PM oracle.sysman.emcp.ParamsManager getParam
    CONFIG: No value was set for the parameter ASM_OH.
    Jan 31, 2013 7:29:40 PM oracle.sysman.emcp.ParamsManager getHost
    CONFIG: Host having instnces running for database csdb : storage1
    Jan 31, 2013 7:29:40 PM oracle.sysman.emcp.ParamsManager setParam
    CONFIG: Setting param: REP_DB_RUNNING_HOST value: storage1
    Jan 31, 2013 7:29:40 PM oracle.sysman.emcp.ParamsManager getRepDbPort
    CONFIG: Listener Port: 1521
    Jan 31, 2013 7:29:40 PM oracle.sysman.emcp.util.GeneralUtil isLocalConnectionRequired
    CONFIG: isLocalConnectionRequired: true
    Jan 31, 2013 7:29:40 PM oracle.sysman.emcp.util.GeneralUtil initSQLEngine
    CONFIG: isLocalConnectionRequired: true. Connecting to database instance locally.
    Jan 31, 2013 7:29:40 PM oracle.sysman.emcp.util.GeneralUtil initSQLEngineLoacly
    CONFIG: SQLEngine connecting with SID: csdb, oracleHome: d:\app\Administrator\product\11.2.0\dbhome_1, and user: SYS
    Jan 31, 2013 7:29:40 PM oracle.sysman.emcp.util.GeneralUtil initSQLEngineLoacly
    CONFIG: SQLEngine created successfully and connected
    Jan 31, 2013 7:29:40 PM oracle.sysman.emcp.ParamsManager getParam
    CONFIG: No value was set for the parameter ORACLE_HOSTNAME.
    Jan 31, 2013 7:29:40 PM oracle.sysman.emcp.ParamsManager getParam
    CONFIG: No value was set for the parameter MODIFY_SID.
    Jan 31, 2013 7:29:40 PM oracle.sysman.emcp.ParamsManager getParam
    CONFIG: No value was set for the parameter MODIFY_SID.
    Jan 31, 2013 7:29:40 PM oracle.sysman.emcp.ParamsManager getParam
    CONFIG: No value was set for the parameter GLOBAL_DB_UNIQUE_NAME.
    Jan 31, 2013 7:29:40 PM oracle.sysman.emcp.DatabaseChecks getGlobalDbUniqueName
    CONFIG: No Global database unique name available. Will try to retrieve it from DB itself
    Jan 31, 2013 7:29:40 PM oracle.sysman.emcp.ParamsManager getHost
    CONFIG: Host having instnces running for database csdb : storage1
    Jan 31, 2013 7:29:40 PM oracle.sysman.emcp.ParamsManager setParam
    CONFIG: Setting param: REP_DB_RUNNING_HOST value: storage1
    Jan 31, 2013 7:29:40 PM oracle.sysman.emcp.ParamsManager getRepDbPort
    CONFIG: Listener Port: 1521
    Jan 31, 2013 7:29:40 PM oracle.sysman.emcp.util.GeneralUtil isLocalConnectionRequired
    CONFIG: isLocalConnectionRequired: true
    Jan 31, 2013 7:29:40 PM oracle.sysman.emcp.util.GeneralUtil initSQLEngine
    CONFIG: isLocalConnectionRequired: true. Connecting to database instance locally.
    Jan 31, 2013 7:29:40 PM oracle.sysman.emcp.util.GeneralUtil initSQLEngineLoacly
    CONFIG: SQLEngine connecting with SID: csdb, oracleHome: d:\app\Administrator\product\11.2.0\dbhome_1, and user: SYS
    Jan 31, 2013 7:29:40 PM oracle.sysman.emcp.util.GeneralUtil initSQLEngineLoacly
    CONFIG: SQLEngine created successfully and connected
    Jan 31, 2013 7:29:40 PM oracle.sysman.emcp.ParamsManager getParam
    CONFIG: No value was set for the parameter DB_DOMAIN.
    Jan 31, 2013 7:29:40 PM oracle.sysman.emcp.DatabaseChecks getDbDomain
    CONFIG: No db domain available. Will query db for db_domain parameter
    Jan 31, 2013 7:29:40 PM oracle.sysman.emcp.ParamsManager setParam
    CONFIG: Setting param: GLOBAL_DB_UNIQUE_NAME value: csdb
    Jan 31, 2013 7:29:40 PM oracle.sysman.emcp.util.ClusterUtil isHASInstalled
    CONFIG: isHAInstalled: false
    Jan 31, 2013 7:29:40 PM oracle.sysman.emcp.ParamsManager getParam
    CONFIG: No value was set for the parameter ORACLE_HOSTNAME.
    Jan 31, 2013 7:29:40 PM oracle.sysman.emcp.util.ClusterUtil isCRSInstalled
    CONFIG: isCRSInstalled: false
    Jan 31, 2013 7:29:40 PM oracle.sysman.emcp.util.ClusterUtil getLocalNode
    CONFIG: Cluster.isCluster: false. Skip call to getLocalNode
    Jan 31, 2013 7:29:40 PM oracle.sysman.emcp.util.ClusterUtil getLocalNode
    CONFIG: isLocalNodeDone: true localNode: null
    Jan 31, 2013 7:29:40 PM oracle.sysman.emcp.util.CentralAgentUtil isCentralAgentConfigured
    CONFIG: Sid: csdb Host: storage1 Node: null OH: d:\app\Administrator\product\11.2.0\dbhome_1 agentHome: null isCentral: false
    Jan 31, 2013 7:29:40 PM oracle.sysman.emcp.util.DBControlUtil isDBConsoleConfigured
    CONFIG: Sid: csdb Host: storage1 Node: null OH: d:\app\Administrator\product\11.2.0\dbhome_1 isDBC: true
    Jan 31, 2013 7:29:40 PM oracle.sysman.emcp.ParamsManager setFlag
    CONFIG: Flag 'IS_CENTRAL_AGENT_CONFIGURED' set to false
    Jan 31, 2013 7:29:40 PM oracle.sysman.emcp.ParamsManager setFlag
    CONFIG: Flag 'IS_DBCONTROL_CONFIGURED' set to true
    Jan 31, 2013 7:29:40 PM oracle.sysman.emcp.util.DBControlUtil stopOMS
    INFO: Stopping Database Control (this may take a while) ...
    Jan 31, 2013 7:29:40 PM oracle.sysman.emcp.util.PlatformInterface serviceCommand
    CONFIG: cmdType: 1
    Jan 31, 2013 7:29:40 PM oracle.sysman.emcp.util.PlatformInterface isPre112Home
    CONFIG: oracleHome: d:\app\Administrator\product\11.2.0\dbhome_1 isPre112Home: false
    Jan 31, 2013 7:29:40 PM oracle.sysman.emcp.util.PlatformInterface serviceCommand
    CONFIG: Service does not exist
    Jan 31, 2013 7:29:40 PM oracle.sysman.emcp.util.ClusterUtil getLocalNode
    CONFIG: isLocalNodeDone: true localNode: null
    Jan 31, 2013 7:29:40 PM oracle.sysman.emcp.util.PlatformInterface getSortedEnvArray
    CONFIG: New Env List: [ALLUSERSPROFILE=C:\ProgramData, APPDATA=C:\Users\Administrator\AppData\Roaming, CLASSPATH=d:\app\Administrator\product\11.2.0\dbhome_1\jlib\emca.jar;d:\app\Administrator\product\11.2.0\dbhome_1\jlib\srvm.jar;d:\app\Administrator\product\11.2.0\dbhome_1\jlib\srvmasm.jar;d:\app\Administrator\product\11.2.0\dbhome_1\jlib\cvu.jar;d:\app\Administrator\product\11.2.0\dbhome_1\jlib\emConfigInstall.jar;d:\app\Administrator\product\11.2.0\dbhome_1\jlib\ldapjclnt11.jar;d:\app\Administrator\product\11.2.0\dbhome_1\jlib\ldap.jar;d:\app\Administrator\product\11.2.0\dbhome_1\jlib\share.jar;d:\app\Administrator\product\11.2.0\dbhome_1\jlib\srvmhas.jar;d:\app\Administrator\product\11.2.0\dbhome_1\jlib\netcfg.jar;d:\app\Administrator\product\11.2.0\dbhome_1\jlib\http_client.jar;d:\app\Administrator\product\11.2.0\dbhome_1\lib\http_client.jar;d:\app\Administrator\product\11.2.0\dbhome_1\lib\xmlparserv2.jar;d:\app\Administrator\product\11.2.0\dbhome_1\assistants\jlib\assistantsCommon.jar;d:\app\Administrator\product\11.2.0\dbhome_1\sysman\jlib\emCORE.jar;d:\app\Administrator\product\11.2.0\dbhome_1\sysman\jlib\emagentSDK.jar;d:\app\Administrator\product\11.2.0\dbhome_1\oui\jlib\OraInstaller.jar;d:\app\Administrator\product\11.2.0\dbhome_1\oui\jlib\OraPrereq.jar;d:\app\Administrator\product\11.2.0\dbhome_1\inventory\prereqs\oui\OraPrereqChecks.jar;d:\app\Administrator\product\11.2.0\dbhome_1\oui\jlib\OraPrereqChecks.jar;, CLIENTNAME=EFF-CPU-426, COMMONPROGRAMFILES=C:\Program Files\Common Files, COMMONPROGRAMFILES(X86)=C:\Program Files (x86)\Common Files, COMMONPROGRAMW6432=C:\Program Files\Common Files, COMPUTERNAME=STORAGE1, COMSPEC=C:\Windows\system32\cmd.exe, EMCA_JAR=d:\app\Administrator\product\11.2.0\dbhome_1\jlib\emca.jar, EMDROOT=d:\app\Administrator\product\11.2.0\dbhome_1, FP_NO_HOST_CHECK=NO, HOMEDRIVE=C:, HOMEPATH=\Users\Administrator, JRE_JAVA=d:\app\Administrator\product\11.2.0\dbhome_1\jdk\jre\bin\java, LD_LIBRARY_PATH=d:\app\Administrator\product\11.2.0\dbhome_1\lib32;d:\app\Administrator\product\11.2.0\dbhome_1\lib;d:\app\Administrator\product\11.2.0\dbhome_1\perl\lib;null, LIB_DIR=d:\app\Administrator\product\11.2.0\dbhome_1\jlib, LOCALAPPDATA=C:\Users\Administrator\AppData\Local, LOGONSERVER=\\STORAGE1, NUMBER_OF_PROCESSORS=12, OH=d:\app\Administrator\product\11.2.0\dbhome_1, ORACLE_UNQNAME=D:\app\Administrator\product\11.2.0\dbhome_1\STORAGE1.EFFTRONICS.LOCAL_csdb, OS=Windows_NT, PATH=d:\app\Administrator\product\11.2.0\dbhome_1\bin;d:\app\Administrator\product\11.2.0\dbhome_1\jdk\jre\bin\server;d:\app\Administrator\product\11.2.0\dbhome_1\bin;d:\app\Administrator\product\11.2.0\dbhome_1\bin;C:\Windows\system32;C:\Windows;C:\Windows\System32\Wbem;C:\Windows\System32\WindowsPowerShell\v1.0\;C:\Program Files (x86)\Dell\SysMgt\shared\bin;C:\Program Files (x86)\Dell\SysMgt\oma\bin;C:\Program Files (x86)\Dell\SysMgt\idrac;D:\app\Administrator\product\11.2.0\dbhome_1\STORAGE1.EFFTRONICS.LOCAL_csdb, PATHEXT=.COM;.EXE;.BAT;.CMD;.VBS;.VBE;.JS;.JSE;.WSF;.WSH;.MSC, PERL5LIB=d:\app\Administrator\product\11.2.0\dbhome_1\sysman\admin\scripts;d:\app\Administrator\product\11.2.0\dbhome_1\bin;, PROCESSOR_ARCHITECTURE=AMD64, PROCESSOR_IDENTIFIER=Intel64 Family 6 Model 44 Stepping 2, GenuineIntel, PROCESSOR_LEVEL=6, PROCESSOR_REVISION=2c02, PROGRAMDATA=C:\ProgramData, PROGRAMFILES=C:\Program Files, PROGRAMFILES(X86)=C:\Program Files (x86), PROGRAMW6432=C:\Program Files, PROMPT=$P$G, PSMODULEPATH=C:\Windows\system32\WindowsPowerShell\v1.0\Modules\, PUBLIC=C:\Users\Public, SESSIONNAME=RDP-Tcp#0, SYSTEMDRIVE=C:, SYSTEMROOT=C:\Windows, TEMP=C:\Users\ADMINI~1\AppData\Local\Temp\2, TMP=C:\Users\ADMINI~1\AppData\Local\Temp\2, USERDOMAIN=STORAGE1, USERNAME=Administrator, USERPROFILE=C:\Users\Administrator, WINDIR=C:\Windows, WINDOWS_TRACING_FLAGS=3, WINDOWS_TRACING_LOGFILE=C:\BVTBin\Tests\installpackage\csilogfile.log]
    Jan 31, 2013 7:29:40 PM oracle.sysman.emcp.util.PlatformInterface executeCommand
    CONFIG: Starting execution: d:/app/Administrator/product/11.2.0/dbhome_1/perl/bin\perl.exe d:\app\Administrator\product\11.2.0\dbhome_1\sysman\admin\scripts\db\sgastop.pl stop csdb storage1 1521 d:\app\Administrator\product\11.2.0\dbhome_1
    Jan 31, 2013 7:29:41 PM oracle.sysman.emcp.util.PlatformInterface executeCommand
    CONFIG: Exit value of 0
    Jan 31, 2013 7:29:41 PM oracle.sysman.emcp.util.PlatformInterface executeCommand
    CONFIG: Execution of d:/app/Administrator/product/11.2.0/dbhome_1/perl/bin\perl.exe d:\app\Administrator\product\11.2.0\dbhome_1\sysman\admin\scripts\db\sgastop.pl stop csdb storage1 1521 d:\app\Administrator\product\11.2.0\dbhome_1 completed successfully
    Jan 31, 2013 7:29:41 PM oracle.sysman.emcp.util.PlatformInterface executeCommand
    CONFIG: nmccollector process does not exist

    Jan 31, 2013 7:29:41 PM oracle.sysman.emcp.util.DBControlUtil stopNmccollector
    CONFIG: Successfully stopped nmc-collector process
    Jan 31, 2013 7:29:41 PM oracle.sysman.emcp.util.PlatformInterface serviceCommand
    CONFIG: cmdType: 2
    Jan 31, 2013 7:29:41 PM oracle.sysman.emcp.util.PlatformInterface isPre112Home
    CONFIG: oracleHome: d:\app\Administrator\product\11.2.0\dbhome_1 isPre112Home: false
    Jan 31, 2013 7:29:41 PM oracle.sysman.emcp.util.PlatformInterface serviceCommand
    CONFIG: Service does not exist
    Jan 31, 2013 7:29:41 PM oracle.sysman.emcp.ParamsManager getParam
    CONFIG: No value was set for the parameter ORACLE_HOSTNAME.
    Jan 31, 2013 7:29:41 PM oracle.sysman.emcp.util.ClusterUtil getLocalNode
    CONFIG: isLocalNodeDone: true localNode: null
    Jan 31, 2013 7:29:41 PM oracle.sysman.emcp.ParamsManager getHost
    CONFIG: Host having instnces running for database csdb : storage1
    Jan 31, 2013 7:29:41 PM oracle.sysman.emcp.ParamsManager setParam
    CONFIG: Setting param: REP_DB_RUNNING_HOST value: storage1
    Jan 31, 2013 7:29:41 PM oracle.sysman.emcp.ParamsManager getRepDbPort
    CONFIG: Listener Port: 1521
    Jan 31, 2013 7:29:41 PM oracle.sysman.emcp.util.GeneralUtil isLocalConnectionRequired
    CONFIG: isLocalConnectionRequired: true
    Jan 31, 2013 7:29:41 PM oracle.sysman.emcp.util.GeneralUtil initSQLEngine
    CONFIG: isLocalConnectionRequired: true. Connecting to database instance locally.
    Jan 31, 2013 7:29:41 PM oracle.sysman.emcp.util.GeneralUtil initSQLEngineLoacly
    CONFIG: SQLEngine connecting with SID: csdb, oracleHome: d:\app\Administrator\product\11.2.0\dbhome_1, and user: SYSMAN
    Jan 31, 2013 7:29:41 PM oracle.sysman.emcp.util.GeneralUtil initSQLEngineLoacly
    CONFIG: ORA-28000: the account is locked

    oracle.sysman.assistants.util.sqlEngine.SQLFatalErrorException: ORA-28000: the account is locked

         at oracle.sysman.assistants.util.sqlEngine.SQLEngine.executeImpl(SQLEngine.java:1655)
         at oracle.sysman.assistants.util.sqlEngine.SQLEngine.connect(SQLEngine.java:978)
         at oracle.sysman.assistants.util.sqlEngine.SQLEngine.connect(SQLEngine.java:917)
         at oracle.sysman.emcp.util.GeneralUtil.initSQLEngineLoacly(GeneralUtil.java:441)
         at oracle.sysman.emcp.util.GeneralUtil.initSQLEngine(GeneralUtil.java:637)
         at oracle.sysman.emcp.util.GeneralUtil.initSQLEngine(GeneralUtil.java:626)
         at oracle.sysman.emcp.EMReposConfig.stopDBMSJobs(EMReposConfig.java:1194)
         at oracle.sysman.emcp.EMReposConfig.invoke(EMReposConfig.java:187)
         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)
    Jan 31, 2013 7:29:41 PM oracle.sysman.emcp.EMReposConfig stopDBMSJobs
    WARNING: Error initializing SQL connection. SQL operations cannot be performed
    Jan 31, 2013 7:29:41 PM oracle.sysman.emcp.EMReposConfig invoke
    WARNING: Unable to remove DBMS jobs.
    Jan 31, 2013 7:29:41 PM oracle.sysman.emcp.ParamsManager getParam
    CONFIG: No value was set for the parameter ORACLE_HOSTNAME.
    Jan 31, 2013 7:29:41 PM oracle.sysman.emcp.ParamsManager checkListenerStatusForDBControl
    CONFIG: connectDesc : (DESCRIPTION=(ADDRESS_LIST=(ADDRESS=(PROTOCOL=TCP)(HOST=storage1)(PORT=1521)))(CONNECT_DATA=(SERVICE_NAME=csdb)))
    Jan 31, 2013 7:29:41 PM oracle.sysman.emcp.ParamsManager getHost
    CONFIG: Host having instnces running for database csdb : storage1
    Jan 31, 2013 7:29:41 PM oracle.sysman.emcp.ParamsManager setParam
    CONFIG: Setting param: REP_DB_RUNNING_HOST value: storage1
    Jan 31, 2013 7:29:41 PM oracle.sysman.emcp.ParamsManager getRepDbPort
    CONFIG: Listener Port: 1521
    Jan 31, 2013 7:29:41 PM oracle.sysman.emcp.util.GeneralUtil isLocalConnectionRequired
    CONFIG: isLocalConnectionRequired: true
    Jan 31, 2013 7:29:41 PM oracle.sysman.emcp.util.GeneralUtil initSQLEngine
    CONFIG: isLocalConnectionRequired: true. Connecting to database instance locally.
    Jan 31, 2013 7:29:41 PM oracle.sysman.emcp.util.GeneralUtil initSQLEngineLoacly
    CONFIG: SQLEngine connecting with SID: csdb, oracleHome: d:\app\Administrator\product\11.2.0\dbhome_1, and user: SYSMAN
    Jan 31, 2013 7:29:41 PM oracle.sysman.emcp.util.GeneralUtil initSQLEngineLoacly
    CONFIG: ORA-28000: the account is locked

    oracle.sysman.assistants.util.sqlEngine.SQLFatalErrorException: ORA-28000: the account is locked

         at oracle.sysman.assistants.util.sqlEngine.SQLEngine.executeImpl(SQLEngine.java:1655)
         at oracle.sysman.assistants.util.sqlEngine.SQLEngine.connect(SQLEngine.java:978)
         at oracle.sysman.assistants.util.sqlEngine.SQLEngine.connect(SQLEngine.java:917)
         at oracle.sysman.emcp.util.GeneralUtil.initSQLEngineLoacly(GeneralUtil.java:441)
         at oracle.sysman.emcp.util.GeneralUtil.initSQLEngine(GeneralUtil.java:637)
         at oracle.sysman.emcp.ParamsManager.checkListenerStatusForDBControl(ParamsManager.java:3220)
         at oracle.sysman.emcp.EMReposConfig.invoke(EMReposConfig.java:204)
         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)
    Jan 31, 2013 7:29:41 PM oracle.sysman.emcp.ParamsManager checkListenerStatusForDBControl
    WARNING: Error initializing SQL connection. SQL operations cannot be performed
    Jan 31, 2013 7:29:41 PM oracle.sysman.emcp.EMReposConfig invoke
    INFO: Dropping the EM repository (this may take a while) ...
    Jan 31, 2013 7:29:41 PM oracle.sysman.emcp.util.PlatformInterface isInView
    CONFIG: IN_VIEW marker not instantiated in d:\app\Administrator\product\11.2.0\dbhome_1\sysman\config\emca.properties
    Jan 31, 2013 7:29:41 PM oracle.sysman.emcp.ParamsManager getParam
    CONFIG: No value was set for the parameter ORACLE_HOSTNAME.
    Jan 31, 2013 7:29:41 PM oracle.sysman.emcp.util.PlatformInterface getEnvProps
    CONFIG: Returning env array from cache
    Jan 31, 2013 7:29:41 PM oracle.sysman.emcp.util.PlatformInterface getSortedEnvArray
    CONFIG: New Env List: [ALLUSERSPROFILE=C:\ProgramData, APPDATA=C:\Users\Administrator\AppData\Roaming, CLASSPATH=d:\app\Administrator\product\11.2.0\dbhome_1\jlib\emca.jar;d:\app\Administrator\product\11.2.0\dbhome_1\jlib\srvm.jar;d:\app\Administrator\product\11.2.0\dbhome_1\jlib\srvmasm.jar;d:\app\Administrator\product\11.2.0\dbhome_1\jlib\cvu.jar;d:\app\Administrator\product\11.2.0\dbhome_1\jlib\emConfigInstall.jar;d:\app\Administrator\product\11.2.0\dbhome_1\jlib\ldapjclnt11.jar;d:\app\Administrator\product\11.2.0\dbhome_1\jlib\ldap.jar;d:\app\Administrator\product\11.2.0\dbhome_1\jlib\share.jar;d:\app\Administrator\product\11.2.0\dbhome_1\jlib\srvmhas.jar;d:\app\Administrator\product\11.2.0\dbhome_1\jlib\netcfg.jar;d:\app\Administrator\product\11.2.0\dbhome_1\jlib\http_client.jar;d:\app\Administrator\product\11.2.0\dbhome_1\lib\http_client.jar;d:\app\Administrator\product\11.2.0\dbhome_1\lib\xmlparserv2.jar;d:\app\Administrator\product\11.2.0\dbhome_1\assistants\jlib\assistantsCommon.jar;d:\app\Administrator\product\11.2.0\dbhome_1\sysman\jlib\emCORE.jar;d:\app\Administrator\product\11.2.0\dbhome_1\sysman\jlib\emagentSDK.jar;d:\app\Administrator\product\11.2.0\dbhome_1\oui\jlib\OraInstaller.jar;d:\app\Administrator\product\11.2.0\dbhome_1\oui\jlib\OraPrereq.jar;d:\app\Administrator\product\11.2.0\dbhome_1\inventory\prereqs\oui\OraPrereqChecks.jar;d:\app\Administrator\product\11.2.0\dbhome_1\oui\jlib\OraPrereqChecks.jar;, CLIENTNAME=EFF-CPU-426, COMMONPROGRAMFILES=C:\Program Files\Common Files, COMMONPROGRAMFILES(X86)=C:\Program Files (x86)\Common Files, COMMONPROGRAMW6432=C:\Program Files\Common Files, COMPUTERNAME=STORAGE1, COMSPEC=C:\Windows\system32\cmd.exe, EMCA_JAR=d:\app\Administrator\product\11.2.0\dbhome_1\jlib\emca.jar, FP_NO_HOST_CHECK=NO, HOMEDRIVE=C:, HOMEPATH=\Users\Administrator, JRE_JAVA=d:\app\Administrator\product\11.2.0\dbhome_1\jdk\jre\bin\java, LIB_DIR=d:\app\Administrator\product\11.2.0\dbhome_1\jlib, LOCALAPPDATA=C:\Users\Administrator\AppData\Local, LOGONSERVER=\\STORAGE1, NUMBER_OF_PROCESSORS=12, OH=d:\app\Administrator\product\11.2.0\dbhome_1, ORACLE_HOME=d:\app\Administrator\product\11.2.0\dbhome_1, ORACLE_SID=csdb, ORACLE_UNQNAME=D:\app\Administrator\product\11.2.0\dbhome_1\STORAGE1.EFFTRONICS.LOCAL_csdb, OS=Windows_NT, PATH=d:\app\Administrator\product\11.2.0\dbhome_1\bin;d:\app\Administrator\product\11.2.0\dbhome_1\bin;C:\Windows\system32;C:\Windows;C:\Windows\System32\Wbem;C:\Windows\System32\WindowsPowerShell\v1.0\;C:\Program Files (x86)\Dell\SysMgt\shared\bin;C:\Program Files (x86)\Dell\SysMgt\oma\bin;C:\Program Files (x86)\Dell\SysMgt\idrac;D:\app\Administrator\product\11.2.0\dbhome_1\STORAGE1.EFFTRONICS.LOCAL_csdb, PATHEXT=.COM;.EXE;.BAT;.CMD;.VBS;.VBE;.JS;.JSE;.WSF;.WSH;.MSC, PROCESSOR_ARCHITECTURE=AMD64, PROCESSOR_IDENTIFIER=Intel64 Family 6 Model 44 Stepping 2, GenuineIntel, PROCESSOR_LEVEL=6, PROCESSOR_REVISION=2c02, PROGRAMDATA=C:\ProgramData, PROGRAMFILES=C:\Program Files, PROGRAMFILES(X86)=C:\Program Files (x86), PROGRAMW6432=C:\Program Files, PROMPT=$P$G, PSMODULEPATH=C:\Windows\system32\WindowsPowerShell\v1.0\Modules\, PUBLIC=C:\Users\Public, SESSIONNAME=RDP-Tcp#0, SYSTEMDRIVE=C:, SYSTEMROOT=C:\Windows, TEMP=C:\Users\ADMINI~1\AppData\Local\Temp\2, TMP=C:\Users\ADMINI~1\AppData\Local\Temp\2, USERDOMAIN=STORAGE1, USERNAME=Administrator, USERPROFILE=C:\Users\Administrator, WINDIR=C:\Windows, WINDOWS_TRACING_FLAGS=3, WINDOWS_TRACING_LOGFILE=C:\BVTBin\Tests\installpackage\csilogfile.log]
    Jan 31, 2013 7:29:41 PM oracle.sysman.emcp.util.PlatformInterface executeCommand
    CONFIG: Starting execution: CMD /C d:\app\Administrator\product\11.2.0\dbhome_1\sysman\admin\emdrep\bin\RepManager.bat -connect (DESCRIPTION=(ADDRESS_LIST=(ADDRESS=(PROTOCOL=TCP)(HOST=storage1)(PORT=1521)))(CONNECT_DATA=(SERVICE_NAME=csdb))) -repos_user SYSMAN -action drop -verbose -output_file d:\app\Administrator\cfgtoollogs\emca\csdb\emca_repos_drop_2013_01_31_19_29_41.log
    Jan 31, 2013 7:29:42 PM oracle.sysman.emcp.util.PlatformInterface executeCommand
    CONFIG: Exit value of 0
    Jan 31, 2013 7:29:42 PM oracle.sysman.emcp.util.PlatformInterface executeCommand
    CONFIG: Execution of CMD /C d:\app\Administrator\product\11.2.0\dbhome_1\sysman\admin\emdrep\bin\RepManager.bat -connect (DESCRIPTION=(ADDRESS_LIST=(ADDRESS=(PROTOCOL=TCP)(HOST=storage1)(PORT=1521)))(CONNECT_DATA=(SERVICE_NAME=csdb))) -repos_user SYSMAN -action drop -verbose -output_file d:\app\Administrator\cfgtoollogs\emca\csdb\emca_repos_drop_2013_01_31_19_29_41.log completed successfully
    Jan 31, 2013 7:29:42 PM oracle.sysman.emcp.util.PlatformInterface executeCommand
    CONFIG: Enter SYS user's password :
    Getting temporary tablespace from database...
    Found temporary tablespace: TEMP
    Environment :
    ORACLE HOME = d:/app/Administrator/product/11.2.0/dbhome_1
    REPOSITORY HOME = d:/app/Administrator/product/11.2.0/dbhome_1
    SQLPLUS = d:/app/Administrator/product/11.2.0/dbhome_1/bin/sqlplus
    SQL SCRIPT ROOT = d:/app/Administrator/product/11.2.0/dbhome_1/sysman/admin/emdrep/sql
    EXPORT = d:/app/Administrator/product/11.2.0/dbhome_1/bin/exp
    IMPORT = d:/app/Administrator/product/11.2.0/dbhome_1/bin/imp
    LOADJAVA = d:/app/Administrator/product/11.2.0/dbhome_1/bin/loadjava
    JAR FILE ROOT = d:/app/Administrator/product/11.2.0/dbhome_1/sysman/admin/emdrep/lib
    JOB TYPES ROOT = d:/app/Administrator/product/11.2.0/dbhome_1/sysman/admin/emdrep/bin
    Arguments :
    Connect String = (DESCRIPTION=(ADDRESS_LIST=(ADDRESS=(PROTOCOL=TCP)(HOST=storage1)(PORT=1521)))(CONNECT_DATA=(SERVICE_NAME=csdb)))
    Action = drop
    Repos User = SYSMAN
    Default tablespace = MGMT_TABLESPACE
    Default Data file = mgmt.dbf
    Dflt Dfile Init size = 20m
    Dflt Dfile Ext size = 20m
    ECM tablespace = MGMT_ECM_DEPOT_TS
    ECM Data file = mgmt_ecm_depot1.dbf
    ECM Dfile Init size = 100m
    ECM Dfile Ext size = 100m
    ECM CSA tablespace = MGMT_TABLESPACE
    ECM CSA Data file = mgmt_ecm_csa1.dbf
    ECM CSA Dfile Init size = 100m
    ECM CSA Dfile Ext size = 100m
    TEMP tablespace = TEMP
    Create options = 3
    Verbose output = 1
    Output File = d:\app\Administrator\cfgtoollogs\emca\csdb\emca_repos_drop_2013_01_31_19_29_41.log
    Repos creation mode = CENTRAL
    MetaLink user name = NOTAVAILABLE_
    MetaLink URL = http://updates.oracle.com
    Export Directory = d:/app/Administrator/product/11.2.0/dbhome_1/sysman/log
    Import Directory = d:/app/Administrator/product/11.2.0/dbhome_1/sysman/log
    Path Separator = "\;"
    Checking SYS Credentials ... rem error switch
    Return code = 1.Failed
    rem error switch
    SYS credentials or connect string is invalid.

    Jan 31, 2013 7:29:42 PM oracle.sysman.emcp.util.PlatformInterface executeCommand
    CONFIG: 'stty' is not recognized as an internal or external command,
    operable program or batch file.
    'stty' is not recognized as an internal or external command,
    operable program or batch file.

    Jan 31, 2013 7:29:42 PM oracle.sysman.emcp.EMReposConfig invoke
    INFO: Repository successfully dropped
    Jan 31, 2013 7:29:42 PM oracle.sysman.emcp.EMDBCConfig deleteOC4JDir
    CONFIG: Deleting state directories
    Jan 31, 2013 7:29:42 PM oracle.sysman.emcp.ParamsManager getParam
    CONFIG: No value was set for the parameter ORACLE_HOSTNAME.
    Jan 31, 2013 7:29:42 PM oracle.sysman.emcp.util.ClusterUtil getLocalNode
    CONFIG: isLocalNodeDone: true localNode: null
    Jan 31, 2013 7:29:42 PM oracle.sysman.emcp.EMDBCConfig deleteOC4JDir
    CONFIG: Unable to delete d:\app\Administrator\product\11.2.0\dbhome_1\oc4j\j2ee\OC4J_DBConsole_storage1_csdb
    Jan 31, 2013 7:29:42 PM oracle.sysman.emcp.EMConfig perform
    SEVERE: Error de-configuring EM for database csdb.
    Refer to the log file at d:\app\Administrator\cfgtoollogs\emca\csdb\emca_2013_01_31_19_29_24.log for more details.
    Jan 31, 2013 7:29:42 PM oracle.sysman.emcp.EMConfig perform
    CONFIG: Stack Trace:
    oracle.sysman.emcp.exception.EMConfigException: Error de-configuring EM for database csdb.
         at oracle.sysman.emcp.EMDBCConfig.performDeconfiguration(EMDBCConfig.java:533)
         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: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)
    Jan 31, 2013 7:29:42 PM oracle.sysman.emcp.EMConfig restoreOuiLoc
    CONFIG: Restoring oracle.installer.oui_loc to d:\app\Administrator\product\11.2.0\dbhome_1\oui
  • 9. Re: EM Console Not Working
    Osama_Mustafa Oracle ACE
    Currently Being Moderated
    ORA-28000: the account is locked
    i don't know what you did

    sqlplus / as sysdba
    alter user sysman account unlock
  • 10. Re: EM Console Not Working
    Venkateshj Newbie
    Currently Being Moderated
    Osama_mustafa wrote:
    ORA-28000: the account is locked
    i don't know what you did

    sqlplus / as sysdba
    alter user sysman account unlock
    Hi sir,

    i unlocked the sysman user..

    but while creating new repository am getting errors...

    is there any other way to create EMCONSOLE sir?



    check errors sir..

    Jan 31, 2013 7:54:37 PM oracle.sysman.emcp.util.PlatformInterface getSortedEnvArray
    CONFIG: New Env List: [ALLUSERSPROFILE=C:\ProgramData, APPDATA=C:\Users\Administrator\AppData\Roaming, CLASSPATH=d:\app\Administrator\product\11.2.0\dbhome_1\jlib\emca.jar;d:\app\Administrator\product\11.2.0\dbhome_1\jlib\srvm.jar;d:\app\Administrator\product\11.2.0\dbhome_1\jlib\srvmasm.jar;d:\app\Administrator\product\11.2.0\dbhome_1\jlib\cvu.jar;d:\app\Administrator\product\11.2.0\dbhome_1\jlib\emConfigInstall.jar;d:\app\Administrator\product\11.2.0\dbhome_1\jlib\ldapjclnt11.jar;d:\app\Administrator\product\11.2.0\dbhome_1\jlib\ldap.jar;d:\app\Administrator\product\11.2.0\dbhome_1\jlib\share.jar;d:\app\Administrator\product\11.2.0\dbhome_1\jlib\srvmhas.jar;d:\app\Administrator\product\11.2.0\dbhome_1\jlib\netcfg.jar;d:\app\Administrator\product\11.2.0\dbhome_1\jlib\http_client.jar;d:\app\Administrator\product\11.2.0\dbhome_1\lib\http_client.jar;d:\app\Administrator\product\11.2.0\dbhome_1\lib\xmlparserv2.jar;d:\app\Administrator\product\11.2.0\dbhome_1\assistants\jlib\assistantsCommon.jar;d:\app\Administrator\product\11.2.0\dbhome_1\sysman\jlib\emCORE.jar;d:\app\Administrator\product\11.2.0\dbhome_1\sysman\jlib\emagentSDK.jar;d:\app\Administrator\product\11.2.0\dbhome_1\oui\jlib\OraInstaller.jar;d:\app\Administrator\product\11.2.0\dbhome_1\oui\jlib\OraPrereq.jar;d:\app\Administrator\product\11.2.0\dbhome_1\inventory\prereqs\oui\OraPrereqChecks.jar;d:\app\Administrator\product\11.2.0\dbhome_1\oui\jlib\OraPrereqChecks.jar;, CLIENTNAME=EFF-CPU-426, COMMONPROGRAMFILES=C:\Program Files\Common Files, COMMONPROGRAMFILES(X86)=C:\Program Files (x86)\Common Files, COMMONPROGRAMW6432=C:\Program Files\Common Files, COMPUTERNAME=STORAGE1, COMSPEC=C:\Windows\system32\cmd.exe, EMCA_JAR=d:\app\Administrator\product\11.2.0\dbhome_1\jlib\emca.jar, FP_NO_HOST_CHECK=NO, HOMEDRIVE=C:, HOMEPATH=\Users\Administrator, JRE_JAVA=d:\app\Administrator\product\11.2.0\dbhome_1\jdk\jre\bin\java, LIB_DIR=d:\app\Administrator\product\11.2.0\dbhome_1\jlib, LOCALAPPDATA=C:\Users\Administrator\AppData\Local, LOGONSERVER=\\STORAGE1, NUMBER_OF_PROCESSORS=12, OH=d:\app\Administrator\product\11.2.0\dbhome_1, ORACLE_HOME=d:\app\Administrator\product\11.2.0\dbhome_1, ORACLE_SID=csdb, ORACLE_UNQNAME=D:\app\Administrator\product\11.2.0\dbhome_1\STORAGE1.EFFTRONICS.LOCAL_csdb, OS=Windows_NT, PATH=d:\app\Administrator\product\11.2.0\dbhome_1\bin;d:\app\Administrator\product\11.2.0\dbhome_1\bin;C:\Windows\system32;C:\Windows;C:\Windows\System32\Wbem;C:\Windows\System32\WindowsPowerShell\v1.0\;C:\Program Files (x86)\Dell\SysMgt\shared\bin;C:\Program Files (x86)\Dell\SysMgt\oma\bin;C:\Program Files (x86)\Dell\SysMgt\idrac;D:\app\Administrator\product\11.2.0\dbhome_1\STORAGE1.EFFTRONICS.LOCAL_csdb, PATHEXT=.COM;.EXE;.BAT;.CMD;.VBS;.VBE;.JS;.JSE;.WSF;.WSH;.MSC, PROCESSOR_ARCHITECTURE=AMD64, PROCESSOR_IDENTIFIER=Intel64 Family 6 Model 44 Stepping 2, GenuineIntel, PROCESSOR_LEVEL=6, PROCESSOR_REVISION=2c02, PROGRAMDATA=C:\ProgramData, PROGRAMFILES=C:\Program Files, PROGRAMFILES(X86)=C:\Program Files (x86), PROGRAMW6432=C:\Program Files, PROMPT=$P$G, PSMODULEPATH=C:\Windows\system32\WindowsPowerShell\v1.0\Modules\, PUBLIC=C:\Users\Public, SESSIONNAME=RDP-Tcp#0, SYSTEMDRIVE=C:, SYSTEMROOT=C:\Windows, TEMP=C:\Users\ADMINI~1\AppData\Local\Temp\2, TMP=C:\Users\ADMINI~1\AppData\Local\Temp\2, USERDOMAIN=STORAGE1, USERNAME=Administrator, USERPROFILE=C:\Users\Administrator, WINDIR=C:\Windows, WINDOWS_TRACING_FLAGS=3, WINDOWS_TRACING_LOGFILE=C:\BVTBin\Tests\installpackage\csilogfile.log]
    Jan 31, 2013 7:54:37 PM oracle.sysman.emcp.util.PlatformInterface executeCommand
    CONFIG: Starting execution: CMD /C d:\app\Administrator\product\11.2.0\dbhome_1\sysman\admin\emdrep\bin\RepManager.bat -connect (DESCRIPTION=(ADDRESS_LIST=(ADDRESS=(PROTOCOL=TCP)(HOST=storage1)(PORT=1521)))(CONNECT_DATA=(SERVICE_NAME=csdb))) -repos_user SYSMAN -action drop -verbose -output_file d:\app\Administrator\cfgtoollogs\emca\csdb\emca_repos_drop_2013_01_31_19_54_37.log
    Jan 31, 2013 7:54:38 PM oracle.sysman.emcp.util.PlatformInterface executeCommand
    CONFIG: Exit value of 0
    Jan 31, 2013 7:54:38 PM oracle.sysman.emcp.util.PlatformInterface executeCommand
    CONFIG: Execution of CMD /C d:\app\Administrator\product\11.2.0\dbhome_1\sysman\admin\emdrep\bin\RepManager.bat -connect (DESCRIPTION=(ADDRESS_LIST=(ADDRESS=(PROTOCOL=TCP)(HOST=storage1)(PORT=1521)))(CONNECT_DATA=(SERVICE_NAME=csdb))) -repos_user SYSMAN -action drop -verbose -output_file d:\app\Administrator\cfgtoollogs\emca\csdb\emca_repos_drop_2013_01_31_19_54_37.log completed successfully
    Jan 31, 2013 7:54:38 PM oracle.sysman.emcp.util.PlatformInterface executeCommand
    CONFIG: Enter SYS user's password :
    Getting temporary tablespace from database...
    Found temporary tablespace: TEMP
    Environment :
    ORACLE HOME = d:/app/Administrator/product/11.2.0/dbhome_1
    REPOSITORY HOME = d:/app/Administrator/product/11.2.0/dbhome_1
    SQLPLUS = d:/app/Administrator/product/11.2.0/dbhome_1/bin/sqlplus
    SQL SCRIPT ROOT = d:/app/Administrator/product/11.2.0/dbhome_1/sysman/admin/emdrep/sql
    EXPORT = d:/app/Administrator/product/11.2.0/dbhome_1/bin/exp
    IMPORT = d:/app/Administrator/product/11.2.0/dbhome_1/bin/imp
    LOADJAVA = d:/app/Administrator/product/11.2.0/dbhome_1/bin/loadjava
    JAR FILE ROOT = d:/app/Administrator/product/11.2.0/dbhome_1/sysman/admin/emdrep/lib
    JOB TYPES ROOT = d:/app/Administrator/product/11.2.0/dbhome_1/sysman/admin/emdrep/bin
    Arguments :
    Connect String = (DESCRIPTION=(ADDRESS_LIST=(ADDRESS=(PROTOCOL=TCP)(HOST=storage1)(PORT=1521)))(CONNECT_DATA=(SERVICE_NAME=csdb)))
    Action = drop
    Repos User = SYSMAN
    Default tablespace = MGMT_TABLESPACE
    Default Data file = mgmt.dbf
    Dflt Dfile Init size = 20m
    Dflt Dfile Ext size = 20m
    ECM tablespace = MGMT_ECM_DEPOT_TS
    ECM Data file = mgmt_ecm_depot1.dbf
    ECM Dfile Init size = 100m
    ECM Dfile Ext size = 100m
    ECM CSA tablespace = MGMT_TABLESPACE
    ECM CSA Data file = mgmt_ecm_csa1.dbf
    ECM CSA Dfile Init size = 100m
    ECM CSA Dfile Ext size = 100m
    TEMP tablespace = TEMP
    Create options = 3
    Verbose output = 1
    Output File = d:\app\Administrator\cfgtoollogs\emca\csdb\emca_repos_drop_2013_01_31_19_54_37.log
    Repos creation mode = CENTRAL
    MetaLink user name = NOTAVAILABLE_
    MetaLink URL = http://updates.oracle.com
    Export Directory = d:/app/Administrator/product/11.2.0/dbhome_1/sysman/log
    Import Directory = d:/app/Administrator/product/11.2.0/dbhome_1/sysman/log
    Path Separator = "\;"
    Checking SYS Credentials ... rem error switch
    Return code = 1.Failed
    rem error switch
    SYS credentials or connect string is invalid.

    Jan 31, 2013 7:54:38 PM oracle.sysman.emcp.util.PlatformInterface executeCommand
    CONFIG: 'stty' is not recognized as an internal or external command,
    operable program or batch file.
    'stty' is not recognized as an internal or external command,
    operable program or batch file.

    Jan 31, 2013 7:54:38 PM oracle.sysman.emcp.EMReposConfig invoke
    INFO: Repository successfully dropped
    Jan 31, 2013 7:54:38 PM oracle.sysman.emcp.EMDBCConfig deleteOC4JDir
    CONFIG: Deleting state directories
    Jan 31, 2013 7:54:38 PM oracle.sysman.emcp.ParamsManager getParam
    CONFIG: No value was set for the parameter ORACLE_HOSTNAME.
    Jan 31, 2013 7:54:38 PM oracle.sysman.emcp.util.ClusterUtil getLocalNode
    CONFIG: isLocalNodeDone: true localNode: null
    Jan 31, 2013 7:54:38 PM oracle.sysman.emcp.EMDBCConfig deleteOC4JDir
    CONFIG: Unable to delete d:\app\Administrator\product\11.2.0\dbhome_1\oc4j\j2ee\OC4J_DBConsole_storage1_csdb
    Jan 31, 2013 7:54:38 PM oracle.sysman.emcp.EMConfig perform
    SEVERE: Error de-configuring EM for database csdb.
    Refer to the log file at d:\app\Administrator\cfgtoollogs\emca\csdb\emca_2013_01_31_19_54_20.log for more details.
    Jan 31, 2013 7:54:38 PM oracle.sysman.emcp.EMConfig perform
    CONFIG: Stack Trace:
    oracle.sysman.emcp.exception.EMConfigException: Error de-configuring EM for database csdb.
         at oracle.sysman.emcp.EMDBCConfig.performDeconfiguration(EMDBCConfig.java:533)
         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: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)
    Jan 31, 2013 7:54:38 PM oracle.sysman.emcp.EMConfig restoreOuiLoc
    CONFIG: Restoring oracle.installer.oui_loc to d:\app\Administrator\product\11.2.0\dbhome_1\oui
  • 11. Re: EM Console Not Working
    Osama_Mustafa Oracle ACE
    Currently Being Moderated
    CONFIG: Unable to delete d:\app\Administrator\product\11.2.0\dbhome_1\oc4j\j2ee\OC4J_DBConsole_storage1_csdb
    Check if you have valid session in v$Session , stop emctl before start drop and create ,

    also Start --> run --> services.msc --> "Oracledbconsoleorcl" stop this services.

    and retry again using drop --- > create
  • 12. Re: EM Console Not Working
    Venkateshj Newbie
    Currently Being Moderated
    Osama_mustafa wrote:
    CONFIG: Unable to delete d:\app\Administrator\product\11.2.0\dbhome_1\oc4j\j2ee\OC4J_DBConsole_storage1_csdb
    Check if you have valid session in v$Session , stop emctl before start drop and create ,

    also Start --> run --> services.msc --> "Oracledbconsoleorcl" stop this services.

    and retry again using drop --- > create
    i did wat u said sir...

    but still am unable to create new EM Console...

    For testing i created Two databases in my Personal PC...
    It is opened for 1st time... after restarting my pc it is not getting open,only one EMCONSOLE is opening...
    Another DBConsole service is disabled automatically...
  • 13. Re: EM Console Not Working
    Osama_Mustafa Oracle ACE
    Currently Being Moderated
    i don't know what exactly you are doing ? if you followed mt steps you should be able to create it without any problem.

    1- Shutdown dbcontrol services
    2- using command that i gave you earlier Drop first
    3- Create using emca.

    Simple doing these steps and then post logs here.
  • 14. Re: EM Console Not Working
    Venkateshj Newbie
    Currently Being Moderated
    Osama_mustafa wrote:
    i don't know what exactly you are doing ? if you followed mt steps you should be able to create it without any problem.

    1- Shutdown dbcontrol services
    2- using command that i gave you earlier Drop first
    3- Create using emca.

    Simple doing these steps and then post logs here.
    Am created new listener File, then by creating emca the repository created successfully...

    Now am able to connect to emconsole at atime...

    Thanks u so much sir...
1 2 Previous Next

Legend

  • Correct Answers - 10 points
  • Helpful Answers - 5 points