1 Reply Latest reply: Jul 9, 2012 12:35 AM by Juergenf-Oracle RSS

    Exception OutOfMemoryError, updating from 11g to 12c

    eli101
      Hi,

      I am trying to upgrade Ops Center 11g to 12c and I am getting an out of heap memory Exception. Dose any one know how I can I increase the java heap size of the installer?
      --------------------------------------------------
      2012-07-08-19:00:50 INFO: moving data for hd_virtswitch_uplink
      2012-07-08-19:00:50 Jul 08, 2012 7:00:50 PM com.oracle.sysman.services.migration.ShovelDriver moveDataRecordSet
      2012-07-08-19:00:50 INFO: moving data for inventory_signature_table
      2012-07-08-19:00:50 Jul 08, 2012 7:00:50 PM com.oracle.sysman.services.migration.ShovelDriver moveDataRecordSet
      2012-07-08-19:00:50 INFO: moving data for inventory_table
      2012-07-08-19:03:37 Exception in thread "main" java.lang.OutOfMemoryError: Java heap space
      2012-07-08-19:03:37 at org.postgresql.core.PGStream.ReceiveTupleV3(PGStream.java:301)
      2012-07-08-19:03:37 at org.postgresql.core.QueryExecutor.receiveTupleV3(QueryExecutor.java:383)
      2012-07-08-19:03:37 at org.postgresql.core.QueryExecutor.executeV3(QueryExecutor.java:141)
      2012-07-08-19:03:37 at org.postgresql.core.QueryExecutor.execute(QueryExecutor.java:100)
      2012-07-08-19:03:37 at org.postgresql.core.QueryExecutor.execute(QueryExecutor.java:43)
      2012-07-08-19:03:37 at org.postgresql.jdbc1.AbstractJdbc1Statement.execute(AbstractJdbc1Statement.java:517)
      2012-07-08-19:03:37 at org.postgresql.jdbc2.AbstractJdbc2Statement.execute(AbstractJdbc2Statement.java:50)
      2012-07-08-19:03:37 at org.postgresql.jdbc1.AbstractJdbc1Statement.executeQuery(AbstractJdbc1Statement.java:233)
      2012-07-08-19:03:37 at org.postgresql.jdbc1.AbstractJdbc1Statement.executeQuery(AbstractJdbc1Statement.java:221)
      2012-07-08-19:03:37 at com.oracle.sysman.services.migration.ShovelDriver.moveDataRecordSet(ShovelDriver.java:122)
      2012-07-08-19:03:37 at com.oracle.sysman.services.migration.ShovelDriver.moveDataRecordSet(ShovelDriver.java:93)
      2012-07-08-19:03:37 at com.oracle.sysman.services.migration.ShovelDriver.moveData(ShovelDriver.java:72)
      2012-07-08-19:03:37 at com.oracle.sysman.services.migration.ShovelDriver.shovelPostgresToOracle(ShovelDriver.java:62)
      2012-07-08-19:03:37 at com.oracle.sysman.services.migration.MoveDataDriver.moveData(MoveDataDriver.java:152)
      2012-07-08-19:03:37 at com.oracle.sysman.services.migration.MoveDataDriver.main(MoveDataDriver.java:106)
      2012-07-08-19:03:37 ERROR: Failed migrate postgres sequences and table data. Non-zero return code=1
      2012-07-08-19:03:37 /var/tmp/OC/update/xvmoc_full_bundle/xvmoc_update_bundle/scripts/database/update: ERROR: failed to perform migration script: /opt/sun/xvm/dbupdates/update.ORCLsysman-db.12.1.0.2001
      2012-07-08-19:03:37 DEBUG: Component:_execit: cmd return code 512(0x200)
      2012-07-08-19:03:37 ERROR: Update of component "database" failed, status=2
      [...]

      Thanks,
      -Eli
        • 1. Re: Exception OutOfMemoryError, updating from 11g to 12c
          Juergenf-Oracle
          Hi Eli,

          you should open a Service Request to get this resolved !

          The actual java command which failed is located here:

          # cat /opt/sun/xvm/dbupdates/update.ORCLsysman-db.12.1.0.2001
          ...
          $JAVA_HOME/bin/java -classpath $DB_ROOT_DIR/lib/ORCLsysman-db-migration.jar:/opt/sun/n1gc/lib/oracle/ojdbc6.jar:/opt/sun/n1gc/lib/persistence/postgresql.jar com.oracle.sysman.services.migration.MoveDataDriver $remoteDBCredsFile

          You could manually increase the max heap space parameter here, but this file is part of package ORCLsysman-db which gets installed only during the upgrade process.

          So you would have to "adjust" the script on the fly before it gets called ...

          My 2 cents
          Juergen