DBUA Fails With Error "SP2-0640 Not Connected" (Doc ID 1384814.1)

Last updated on JULY 14, 2017

Applies to:

Oracle Database - Enterprise Edition - Version 11.2.0.1.0 and later
Information in this document applies to any platform.

Symptoms

DBUA fails with following errors which are shown in trace.log:

Thread-50] [ 2011-12-03 22:22:56.538 GMT+00:00 ] [SQLEngine.initialize:359]  m_bReaderStarted: false
[Thread-50] [ 2011-12-03 22:22:56.541 GMT+00:00 ] [SQLEngine.initialize:363]  Starting Reader Thread... 
[Thread-50] [ 2011-12-03 22:22:56.546 GMT+00:00 ] [SQLEngine.initialize:412]  Waiting for m_bReaderStarted to be true 
[Thread-50] [ 2011-12-03 22:22:56.630 GMT+00:00 ] [OracleHome.initOptions:1256]  Database Option SP2-0640: Not connected is ON 
[Thread-50] [ 2011-12-03 22:22:56.630 GMT+00:00 ] [OracleHome.initOptions:1260]  executing: select version from v$timezone_file
[Thread-50] [ 2011-12-03 22:22:56.632 GMT+00:00 ] [OracleHome.initOptions:1266]  Timezone file version is SP2-0640: Not connected
[Thread-50] [ 2011-12-03 22:22:56.744 GMT+00:00 ] [SQLEngine.done:2167]  Done called
[Thread-50] [ 2011-12-03 22:22:56.746 GMT+00:00 ] [OsUtilsBase.deleteFile:1838]  OsUtilsBase.deleteFile: /oraapps/itstdb/11.2.0/dbs/initDBUA0.ora
[Thread-50] [ 2011-12-03 22:22:56.748 GMT+00:00 ] [OsUtilsBase.deleteFile:1838]  OsUtilsBase.deleteFile: /oraapps/itstdb/11.2.0/dbs/orapwDBUA0
[Thread-50] [ 2011-12-03 22:22:56.749 GMT+00:00 ] [OracleHome.initOptions:1301]  Database Options queried: 1
java.lang.NumberFormatException: For input string: "SP2-0640: Not connected"
at java.lang.NumberFormatException.forInputString(NumberFormatException.java:48)
at java.lang.Integer.parseInt(Integer.java:447)
at java.lang.Integer.parseInt(Integer.java:497)
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.DatabasesPage.doProcessing(DatabasesPage.java:810)
at oracle.sysman.assistants.util.WaitDialog.run(WaitDialog.java:187)
at java.lang.Thread.run(Thread.java:595)

Changes

 

Cause

Sign In with your My Oracle Support account

Don't have a My Oracle Support account? Click to get started

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms