5 Replies Latest reply: Feb 12, 2013 9:32 AM by Srini Chavali-Oracle RSS

    Oracle upgrade from 10.2.0.4.0 to 11.2.0.2.0 using DBUA (SP2-0640 Error)

    990592
      Dear DBA admins,

      We are trying to upgrade oracle database from 10.2.0.4 to 11.2 using DBUA, but when we try to launch the DB upgrade assistant uisng dbua.sap.sh script, we are getting the below error

      for input string SP2-0640 not connected.

      Please find below last few lines from the logs from location /oracle/cfgtoollogs/dbua/logs/trace.log



      [Thread-13] [ 2013-02-12 14:34:00.002 CET ] [Database.updateNonDefaultInitParams:1199] mts value altered based on db version:null
      [Thread-13] [ 2013-02-12 14:34:00.005 CET ] [CompManager.obtainGenericDbInfo:2436] get number of data files backing up
      [Thread-13] [ 2013-02-12 14:34:00.024 CET ] [CompManager.obtainGenericDbInfo:2470] Source Database Version :=10.2.0.4.0
      [Thread-13] [ 2013-02-12 14:34:00.024 CET ] [CompManager.obtainGenericDbInfo:2479] Source Database Version :=10.2.0.4.0
      [Thread-13] [ 2013-02-12 14:34:00.027 CET ] [CompManager.obtainGenericDbInfo:2605] backupNo =0
      [Thread-13] [ 2013-02-12 14:34:00.032 CET ] [CompManager.setFlashbackMode:9639] Flashback Mode of database is:=false
      [Thread-13] [ 2013-02-12 14:34:00.033 CET ] [CompManager.doClusterDbChecks:2653] CompManager.doClusterDbChecks
      [Thread-13] [ 2013-02-12 14:34:00.033 CET ] [CompManager.doClusterDbChecks:2658] executeQuery: select value from v$parameter where name='parallel_server'
      [Thread-13] [ 2013-02-12 14:34:00.041 CET ] [SQLEngine.done:2167] Done called
      [Thread-13] [ 2013-02-12 14:34:00.042 CET ] [CompManager.doPreMigrationChecks:2832] CompManager.doPreMigrationChecks
      [Thread-13] [ 2013-02-12 14:34:00.050 CET ] [OracleHome.getVersion:885] OracleHome.getVersion called. Current Version: null
      [Thread-13] [ 2013-02-12 14:34:00.056 CET ] [InventoryUtil.getOUIInvSession:347] setting OUI READ level to ACCESSLEVEL_READ_LOCKLESS
      [Thread-13] [ 2013-02-12 14:34:00.057 CET ] [OracleHome.getVersion:904] Homeinfo /oracle/HP1/112_64,1
      [Thread-13] [ 2013-02-12 14:34:01.004 CET ] [OracleHome.getVersion:932] OracleHome.server.getVersion Version: 11.2.0.2.0
      [Thread-13] [ 2013-02-12 14:34:01.005 CET ] [OracleHome.getVersion:953] Current Version From Inventory: 11.2.0.2.0
      [Thread-13] [ 2013-02-12 14:34:01.005 CET ] [OracleHome.getVersion:885] OracleHome.getVersion called. Current Version: 11.2.0.2.0
      [Thread-13] [ 2013-02-12 14:34:01.005 CET ] [OracleHome.getVersion:953] Current Version From Inventory: 11.2.0.2.0
      [Thread-13] [ 2013-02-12 14:34:01.005 CET ] [CommonUtils.createPasswordFile:604] calling new orapwd for 11.1 or higher
      [Thread-13] [ 2013-02-12 14:34:01.007 CET ] [OsUtilsBase.execProg:2158] beginning execProg with input array.
      [Thread-13] [ 2013-02-12 14:34:01.085 CET ] [OsUtilsBase.execProg:2195] finished execProg with input array. Status:0
      [Thread-13] [ 2013-02-12 14:34:01.087 CET ] [OracleHome.initOptions:1226] Initializing Database Options with for dummy sid=DBUA0 using initfile=/oracle/HP1/112_64/dbs/initDBUA0.ora using pwdfile=/oracle/HP1/112_64/dbs/orapwDBUA0
      [Thread-13] [ 2013-02-12 14:34:01.087 CET ] [OracleHome.getVersion:885] OracleHome.getVersion called. Current Version: 11.2.0.2.0
      [Thread-13] [ 2013-02-12 14:34:01.088 CET ] [OracleHome.getVersion:953] Current Version From Inventory: 11.2.0.2.0
      [Thread-13] [ 2013-02-12 14:34:01.088 CET ] [OracleHome.getVersion:885] OracleHome.getVersion called. Current Version: 11.2.0.2.0
      [Thread-13] [ 2013-02-12 14:34:01.088 CET ] [OracleHome.getVersion:953] Current Version From Inventory: 11.2.0.2.0
      [Thread-13] [ 2013-02-12 14:34:01.089 CET ] [OracleHome.getVersion:885] OracleHome.getVersion called. Current Version: 11.2.0.2.0
      [Thread-13] [ 2013-02-12 14:34:01.089 CET ] [OracleHome.getVersion:953] Current Version From Inventory: 11.2.0.2.0
      [Thread-13] [ 2013-02-12 14:34:01.089 CET ] [SQLPlusEngine.getCmmdParams:222] m_home 11.2.0.2.0
      [Thread-13] [ 2013-02-12 14:34:01.090 CET ] [SQLPlusEngine.getCmmdParams:223] version > 112 true
      [Thread-13] [ 2013-02-12 14:34:01.090 CET ] [SQLEngine.getEnvParams:562] NLS_LANG: AMERICAN_AMERICA.UTF8
      [Thread-13] [ 2013-02-12 14:34:01.092 CET ] [SQLEngine.initialize:322] Execing SQLPLUS/SVRMGR process...
      [Thread-13] [ 2013-02-12 14:34:01.149 CET ] [SQLEngine.initialize:359] m_bReaderStarted: false
      [Thread-13] [ 2013-02-12 14:34:01.150 CET ] [SQLEngine.initialize:363] Starting Reader Thread...
      [Thread-13] [ 2013-02-12 14:34:01.226 CET ] [OracleHome.initOptions:1240] executing: startup nomount pfile='/oracle/HP1/112_64/dbs/initDBUA0.ora'
      [Thread-13] [ 2013-02-12 14:34:01.325 CET ] [SQLEngine.done:2167] Done called
      [Thread-13] [ 2013-02-12 14:34:01.326 CET ] [OracleHome.initOptions:1247] ORA-27102: out of memory

      oracle.sysman.assistants.util.sqlEngine.SQLFatalErrorException: ORA-27102: out of memory

      at oracle.sysman.assistants.util.sqlEngine.SQLEngine.executeImpl(SQLEngine.java:1655)
      at oracle.sysman.assistants.util.sqlEngine.SQLEngine.executeSql(SQLEngine.java:1903)
      at oracle.sysman.assistants.util.OracleHome.initOptions(OracleHome.java:1241)
      at oracle.sysman.assistants.dbma.backend.CompManager.doPreMigrationChecks(CompManager.java:2841)
      at oracle.sysman.assistants.dbma.backend.CompManager.obtainDatabaseInformation(CompManager.java:4136)
      at oracle.sysman.assistants.dbma.ui.UpgradeInformationPage.doProcessing(UpgradeInformationPage.java:465)
      at oracle.sysman.assistants.util.WaitDialog.run(WaitDialog.java:187)
      at java.lang.Thread.run(Thread.java:811)
      [Thread-13] [ 2013-02-12 14:34:01.327 CET ] [OracleHome.initOptions:1250] executing: select parameter from v$option where value='TRUE'
      [Thread-13] [ 2013-02-12 14:34:01.328 CET ] [SQLEngine.reInitialize:735] Reinitializing SQLEngine...
      [Thread-13] [ 2013-02-12 14:34:01.328 CET ] [OracleHome.getVersion:885] OracleHome.getVersion called. Current Version: 11.2.0.2.0
      [Thread-13] [ 2013-02-12 14:34:01.328 CET ] [OracleHome.getVersion:953] Current Version From Inventory: 11.2.0.2.0
      [Thread-13] [ 2013-02-12 14:34:01.328 CET ] [OracleHome.getVersion:885] OracleHome.getVersion called. Current Version: 11.2.0.2.0
      [Thread-13] [ 2013-02-12 14:34:01.329 CET ] [OracleHome.getVersion:953] Current Version From Inventory: 11.2.0.2.0
      [Thread-13] [ 2013-02-12 14:34:01.329 CET ] [OracleHome.getVersion:885] OracleHome.getVersion called. Current Version: 11.2.0.2.0
      [Thread-13] [ 2013-02-12 14:34:01.329 CET ] [OracleHome.getVersion:953] Current Version From Inventory: 11.2.0.2.0
      [Thread-13] [ 2013-02-12 14:34:01.330 CET ] [SQLPlusEngine.getCmmdParams:222] m_home 11.2.0.2.0
      [Thread-13] [ 2013-02-12 14:34:01.330 CET ] [SQLPlusEngine.getCmmdParams:223] version > 112 true
      [Thread-13] [ 2013-02-12 14:34:01.331 CET ] [SQLEngine.getEnvParams:562] NLS_LANG: AMERICAN_AMERICA.UTF8
      [Thread-13] [ 2013-02-12 14:34:01.332 CET ] [SQLEngine.initialize:322] Execing SQLPLUS/SVRMGR process...
      [Thread-13] [ 2013-02-12 14:34:01.379 CET ] [SQLEngine.initialize:359] m_bReaderStarted: false
      [Thread-13] [ 2013-02-12 14:34:01.381 CET ] [SQLEngine.initialize:363] Starting Reader Thread...
      [Thread-13] [ 2013-02-12 14:34:01.383 CET ] [SQLEngine.initialize:412] Waiting for m_bReaderStarted to be true
      [Thread-13] [ 2013-02-12 14:34:01.416 CET ] [OracleHome.initOptions:1256] Database Option SP2-0640: Not connected is ON
      [Thread-13] [ 2013-02-12 14:34:01.416 CET ] [OracleHome.initOptions:1260] executing: select version from v$timezone_file
      [Thread-13] [ 2013-02-12 14:34:01.417 CET ] [OracleHome.initOptions:1266] Timezone file version is SP2-0640: Not connected
      [Thread-13] [ 2013-02-12 14:34:01.453 CET ] [SQLEngine.done:2167] Done called
      [Thread-13] [ 2013-02-12 14:34:01.454 CET ] [OsUtilsBase.deleteFile:1838] OsUtilsBase.deleteFile: /oracle/HP1/112_64/dbs/initDBUA0.ora
      [Thread-13] [ 2013-02-12 14:34:01.455 CET ] [OsUtilsBase.deleteFile:1838] OsUtilsBase.deleteFile: /oracle/HP1/112_64/dbs/orapwDBUA0
      [Thread-13] [ 2013-02-12 14:34:01.457 CET ] [OracleHome.initOptions:1301] Database Options queried: 1
      java.lang.NumberFormatException: For input string: "SP2-0640: Not connected"
      at java.lang.NumberFormatException.forInputString(NumberFormatException.java:63)
      at java.lang.Integer.parseInt(Integer.java:481)
      at java.lang.Integer.parseInt(Integer.java:531)
      at oracle.sysman.assistants.dbma.backend.CompManager.doPreMigrationChecks(CompManager.java:2842)
      at oracle.sysman.assistants.dbma.backend.CompManager.obtainDatabaseInformation(CompManager.java:4136)
      at oracle.sysman.assistants.dbma.ui.UpgradeInformationPage.doProcessing(UpgradeInformationPage.java:465)
      at oracle.sysman.assistants.util.WaitDialog.run(WaitDialog.java:187)
      at java.lang.Thread.run(Thread.java:811)
      [AWT-EventQueue-0] [ 2013-02-12 14:36:44.159 CET ] [SQLEngine.done:2167] Done called
      [main] [ 2013-02-12 14:36:44.160 CET ] [SQLEngine.done:2167] Done called


      Please help us in this regard.

      Thanks,
      Vijay G