3 Replies Latest reply: Jan 12, 2013 9:18 AM by 655280 RSS

    Configuring enterprise manager ?

    889124
      Oracle 11gR2 / Windowms 2008

      I've removed (dropped) an old repositry / enterprise manager and now I'm trying to configure a fresh installation of it.

      Now, i've used the following command

      emca -config dbcontrol db -repos create

      Up till this point, all is fine.. then

      INFO: Uploading configuration data to EM repository (this may take a while) ...


      Nov 12, 2012 2:28:57 PM oracle.sysman.emcp.EMReposConfig uploadConfigDataToRepository
      CONFIG: Error uploading configuration data to the repository
      oracle.sysman.emdrep.config.ConfigurationException: FATAL Configuration Exceptions

           at oracle.sysman.emdrep.config.EMSchemaConfiguration.perform(EMSchemaConfiguration.java:232)
           at oracle.sysman.emcp.EMReposConfig.uploadConfigDataToRepository(EMReposConfig.java:717)
           at oracle.sysman.emcp.EMReposConfig.invoke(EMReposConfig.java:396)
           at oracle.sysman.emcp.EMReposConfig.invoke(EMReposConfig.java:160)
           at oracle.sysman.emcp.EMConfig.perform(EMConfig.java:253)
           at oracle.sysman.emcp.EMConfigAssistant.invokeEMCA(EMConfigAssistant.java:599)
           at oracle.sysman.emcp.EMConfigAssistant.performConfiguration(EMConfigAssistant.java:1482)
           at oracle.sysman.emcp.EMConfigAssistant.statusMain(EMConfigAssistant.java:583)
           at oracle.sysman.emcp.EMConfigAssistant.main(EMConfigAssistant.java:529)
      Nov 12, 2012 2:28:57 PM oracle.sysman.emcp.EMReposConfig invoke
      INFO: Refer to the log file at C:\app\oracle\cfgtoollogs\emca\PROD\emca_repos_config_<date>.log for more details.
      Nov 12, 2012 2:28:57 PM oracle.sysman.emcp.EMReposConfig invoke
      SEVERE: Error uploading configuration data to the repository
      Nov 12, 2012 2:28:57 PM oracle.sysman.emcp.EMConfig perform
      SEVERE: Error uploading configuration data to the repository
      Refer to the log file at C:\app\oracle\cfgtoollogs\emca\PROD\emca_2012_11_12_14_19_22.log for more details.
      Nov 12, 2012 2:28:57 PM oracle.sysman.emcp.EMConfig perform
      CONFIG: Stack Trace:
      oracle.sysman.emcp.exception.EMConfigException: Error uploading configuration data to the repository
           at oracle.sysman.emcp.EMReposConfig.invoke(EMReposConfig.java:408)
           at oracle.sysman.emcp.EMReposConfig.invoke(EMReposConfig.java:160)
           at oracle.sysman.emcp.EMConfig.perform(EMConfig.java:253)
           at oracle.sysman.emcp.EMConfigAssistant.invokeEMCA(EMConfigAssistant.java:599)
           at oracle.sysman.emcp.EMConfigAssistant.performConfiguration(EMConfigAssistant.java:1482)
           at oracle.sysman.emcp.EMConfigAssistant.statusMain(EMConfigAssistant.java:583)
           at oracle.sysman.emcp.EMConfigAssistant.main(EMConfigAssistant.java:529)
      Nov 12, 2012 2:28:57 PM oracle.sysman.emcp.EMConfig restoreOuiLoc
      CONFIG: Restoring oracle.installer.oui_loc to C:\app\oracle\product\11.2.0\dbhome_1\oui

      Help !!
        • 1. Re: Configuring enterprise manager ?
          889124
          From log file

          Nov 12, 2012 2:25:54 PM oracle.sysman.emdrep.config.EMSchemaConfiguration perform
          INFO: OracleHome:C:\app\oracle\product\11.2.0\dbhome_1
          Nov 12, 2012 2:25:54 PM oracle.sysman.emdrep.config.EMSchemaConfiguration getConfigurationXMLs
          INFO: [C:\app\oracle\product\11.2.0\dbhome_1\sysman\admin\emdrep\sql\core\configuration.xml]
          Nov 12, 2012 2:25:54 PM oracle.sysman.emdrep.config.EMSchemaConfiguration getConfigIntegrations
          INFO: Number of Configuration Instances:1
          Nov 12, 2012 2:25:54 PM oracle.sysman.emdrep.config.EMSchemaConfiguration getConfigIntegrations
          INFO: oracle.sysman.emdrep.util.TransxWrapper
          C:\app\oracle\product\11.2.0\dbhome_1\jlib/transx.zip
          C:\app\oracle\product\11.2.0\dbhome_1\xdk/lib/transx.zip
          C:\app\oracle\product\11.2.0\dbhome_1\lib/transx.zip
          C:\app\oracle\product\11.2.0\dbhome_1\lib/xmlparserv2.jar
          C:\app\oracle\product\11.2.0\dbhome_1\lib/xsu12.jar
          C:\app\oracle\product\11.2.0\dbhome_1\jlib/xdb.jar
          C:\app\oracle\product\11.2.0\dbhome_1\rdbms/jlib/xdb.jar
          C:\app\oracle\product\11.2.0\dbhome_1\oc4j/jdbc/lib/orai18n.jar
          C:\app\oracle\product\11.2.0\dbhome_1\jdbc/lib/ojdbc14.jar
          C:\app\oracle\product\11.2.0\dbhome_1\sysman/jlib/emCORE.jar
          C:\app\oracle\product\11.2.0\dbhome_1\oc4j/jdbc/lib/ojdbc14.jar
          C:\app\oracle\product\11.2.0\dbhome_1\oc4j/jdbc/lib/ojdbc14dms.jar
          C:\app\oracle\product\11.2.0\dbhome_1\jdbc/lib/ojdbc5.jar
          C:\app\oracle\product\11.2.0\dbhome_1\jdbc/lib/ojdbc5dms.jar
          C:\app\oracle\product\11.2.0\dbhome_1\oc4j/lib/dms.jar
          C:\app\oracle\product\11.2.0\dbhome_1\oc4j/jdbc/lib/dms.jar
          C:\app\oracle\product\11.2.0\dbhome_1\dms/lib/dms.jar
          Nov 12, 2012 2:25:54 PM oracle.sysman.emdrep.config.IConfigurationContext createConnection
          INFO: jdbcUrl = jdbc:oracle:thin:@(DESCRIPTION=(ADDRESS_LIST=(ADDRESS=(PROTOCOL=TCP)(HOST=SERVER01)(PORT=1521)))(CONNECT_DATA=(SERVICE_NAME=PROD)))
          Nov 12, 2012 2:26:55 PM oracle.sysman.emdrep.config.IConfigurationContext createConnection
          INFO: jdbcUrl = jdbc:oracle:oci:@(DESCRIPTION=(ADDRESS_LIST=(ADDRESS=(PROTOCOL=TCP)(HOST=SERVER01)(PORT=1521)))(CONNECT_DATA=(SERVICE_NAME=PROD)))
          Nov 12, 2012 2:26:55 PM oracle.sysman.emdrep.config.IConfigurationContext createConnection
          INFO: jdbcUrl = jdbc:oracle:thin:@(DESCRIPTION=(ADDRESS_LIST=(ADDRESS=(PROTOCOL=TCP)(HOST=SERVER01)(PORT=1521)))(CONNECT_DATA=(SERVICE_NAME=PROD)))
          Nov 12, 2012 2:27:56 PM oracle.sysman.emdrep.config.IConfigurationContext createConnection
          INFO: jdbcUrl = jdbc:oracle:oci:@(DESCRIPTION=(ADDRESS_LIST=(ADDRESS=(PROTOCOL=TCP)(HOST=SERVER01)(PORT=1521)))(CONNECT_DATA=(SERVICE_NAME=PROD)))
          Nov 12, 2012 2:28:57 PM oracle.sysman.emdrep.util.TransxWrapper perform
          SEVERE: Error Loading TransX:IO Error: Socket read timed out
          Nov 12, 2012 2:28:57 PM oracle.sysman.emdrep.config.EMSchemaConfiguration$ConfigInstance run
          SEVERE: null
          java.lang.reflect.InvocationTargetException
               at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
               at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39)
               at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
               at java.lang.reflect.Method.invoke(Method.java:592)
               at oracle.sysman.emdrep.config.EMSchemaConfiguration$ConfigInstance.run(EMSchemaConfiguration.java:480)
               at java.lang.Thread.run(Thread.java:595)
          Caused by: oracle.sysman.emdrep.config.ConfigurationException: Loading DLF Exception
          IO Error: Socket read timed out
          java.sql.SQLException: IO Error: Socket read timed out
               at oracle.jdbc.driver.T4CConnection.logon(T4CConnection.java:419)
               at oracle.jdbc.driver.PhysicalConnection.<init>(PhysicalConnection.java:536)
               at oracle.jdbc.driver.T4CConnection.<init>(T4CConnection.java:228)
               at oracle.jdbc.driver.T4CDriverExtension.getConnection(T4CDriverExtension.java:32)
               at oracle.jdbc.driver.OracleDriver.connect(OracleDriver.java:521)
               at java.sql.DriverManager.getConnection(DriverManager.java:525)
               at java.sql.DriverManager.getConnection(DriverManager.java:171)
               at oracle.xml.transx.ConnectionHelper.getConnection(ConnectionHelper.java:59)
               at oracle.xml.transx.TransXImpl.open(TransXImpl.java:79)
               at oracle.sysman.emdrep.util.TransxWrapper.perform(TransxWrapper.java:67)
               at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
               at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39)
               at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
               at java.lang.reflect.Method.invoke(Method.java:592)
               at oracle.sysman.emdrep.config.EMSchemaConfiguration$ConfigInstance.run(EMSchemaConfiguration.java:480)
               at java.lang.Thread.run(Thread.java:595)
          Caused by: oracle.net.ns.NetException: Socket read timed out
               at oracle.net.ns.Packet.receive(Packet.java:321)
               at oracle.net.ns.NSProtocol.connect(NSProtocol.java:287)
               at oracle.jdbc.driver.T4CConnection.connect(T4CConnection.java:1054)
               at oracle.jdbc.driver.T4CConnection.logon(T4CConnection.java:308)
               ... 15 more

               at oracle.sysman.emdrep.util.TransxWrapper.perform(TransxWrapper.java:82)
               ... 6 more
          Caused by: java.sql.SQLException: IO Error: Socket read timed out
               at oracle.jdbc.driver.T4CConnection.logon(T4CConnection.java:419)
               at oracle.jdbc.driver.PhysicalConnection.<init>(PhysicalConnection.java:536)
               at oracle.jdbc.driver.T4CConnection.<init>(T4CConnection.java:228)
               at oracle.jdbc.driver.T4CDriverExtension.getConnection(T4CDriverExtension.java:32)
               at oracle.jdbc.driver.OracleDriver.connect(OracleDriver.java:521)
               at java.sql.DriverManager.getConnection(DriverManager.java:525)
               at java.sql.DriverManager.getConnection(DriverManager.java:171)
               at oracle.xml.transx.ConnectionHelper.getConnection(ConnectionHelper.java:59)
               at oracle.xml.transx.TransXImpl.open(TransXImpl.java:79)
               at oracle.sysman.emdrep.util.TransxWrapper.perform(TransxWrapper.java:67)
               ... 6 more
          Caused by: oracle.net.ns.NetException: Socket read timed out
               at oracle.net.ns.Packet.receive(Packet.java:321)
               at oracle.net.ns.NSProtocol.connect(NSProtocol.java:287)
               at oracle.jdbc.driver.T4CConnection.connect(T4CConnection.java:1054)
               at oracle.jdbc.driver.T4CConnection.logon(T4CConnection.java:308)
               ... 15 more

          Nov 12, 2012 2:28:57 PM oracle.sysman.emdrep.config.EMSchemaConfiguration perform
          WARNING: Exception Occured during Execution of oracle.sysman.emdrep.util.TransxWrapper
          Nov 12, 2012 2:28:57 PM oracle.sysman.emdrep.config.EMSchemaConfiguration perform
          SEVERE: FATAL EXCEPTIONS:
          FATAL Configuration Exceptions
          • 2. Re: Configuring enterprise manager ?
            655280
            I am also facing the same issue. Has anybody fixed this error?
            • 3. Re: Configuring enterprise manager ?
              655280
              Cause: The windows Server 2008 machine is in an active directory and is using IPv6. When the short hostname is pinged, it is resolved via the fully qualified hostname to an IPv6

              I was able to fix the issue by following these steps:

              Add entries into the host file, to force IPv4 style resolution:-

              +1) edit the windows\system32\drivers\etc\hosts file+

              +2) add an entry for the machine of the format:-+

              +<ipaddress> <fully qualified hostname> <short hostname>+

              Document ID: Error Uploading Configuration Data To The Repository" when configuring dbconsole *[ID 1233913.1]*