This discussion is archived
3 Replies Latest reply: Jan 12, 2013 7:18 AM by 655280 RSS

Configuring enterprise manager ?

889124 Newbie
Currently Being Moderated
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 Newbie
    Currently Being Moderated
    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 Newbie
    Currently Being Moderated
    I am also facing the same issue. Has anybody fixed this error?
  • 3. Re: Configuring enterprise manager ?
    655280 Newbie
    Currently Being Moderated
    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]*

Legend

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