1 2 Previous Next 16 Replies Latest reply: Feb 2, 2013 7:43 AM by Osama_Mustafa RSS

    EM Console Not Working

    Venkateshj
      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
          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
            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
              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.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
                  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
                    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
                      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
                        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
                          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
                            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
                              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
                                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
                                  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
                                    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