Oracle 12.1.0.2 DBUA hangs on prerequisite checks at 0%.

(Doc ID 2368474.1)

Last updated on MARCH 05, 2018

Applies to:

Oracle Database - Enterprise Edition - Version 11.2.0.3 to 12.2.0.1 [Release 11.2 to 12.2]
Information in this document applies to any platform.

Symptoms

While performing the 11.2.0.4 RAC Database Upgrade to 12.1.0.2, it hans at prerequisite checks.

 

 

Trace.log file shows below error:

[Thread-401] [ 2018-02-14 12:59:28.386 EST ] [OsUtilsBase.getBaseFromOrabase:672] envs: ORACLE_HOME=/u01/app/oracle/product/11.2.0/db_4

[Thread-401] [ 2018-02-14 12:59:28.460 EST ] [OsUtilsBase.getBaseFromOrabase:682] baseLocation from orabase
/u01/app/oracle
[Thread-401] [ 2018-02-14 12:59:28.460 EST ] [OsUtilsBase.getBaseFromOrabase:707] orabaseLocation= /u01/app/oracle
[Thread-401] [ 2018-02-14 12:59:28.460 EST ] [SQLEngine.getEnvParams:602] Default NLS_LANG: AMERICAN_AMERICA.AL32UTF8
[Thread-401] [ 2018-02-14 12:59:28.460 EST ] [SQLEngine.getEnvParams:612] NLS_LANG: AMERICAN_AMERICA.AL32UTF8
[Thread-401] [ 2018-02-14 12:59:28.461 EST ] [SQLEngine.initialize:358] Execing SQLPLUS/SVRMGR process...
[Thread-401] [ 2018-02-14 12:59:28.465 EST ] [SQLEngine.initialize:395] m_bReaderStarted: false
[Thread-401] [ 2018-02-14 12:59:28.465 EST ] [SQLEngine.initialize:399] Starting Reader Thread...
[Thread-401] [ 2018-02-14 12:59:28.466 EST ] [SQLEngine.initialize:448] Waiting for m_bReaderStarted to be true
[Thread-401] [ 2018-02-14 12:59:28.559 EST ] [SQLEngine.done:2278] Done called
[Thread-401] [ 2018-02-14 12:59:28.560 EST ] [PreUpgradeToolGroup.validate:730] Failed to connect to sqlEngine and run pre upgrade sql script.
[Thread-401] [ 2018-02-14 12:59:28.567 EST ] [PreUpgradeToolGroup.validate:731] ORA-01034: ORACLE not available

oracle.sysman.assistants.util.sqlEngine.SQLEngine.executeImpl(SQLEngine.java:1739)
oracle.sysman.assistants.util.sqlEngine.SQLEngine.executeQuery(SQLEngine.java:878)
oracle.sysman.assistants.dbma.dbux.validation.PreUpgradeToolGroup.validate(PreUpgradeToolGroup.java:453)
oracle.sysman.assistants.dbma.wizard.view.ValidationPage.check(ValidationPage.java:1643)
oracle.sysman.assistants.dbma.wizard.view.ValidationPage$Check.run(ValidationPage.java:2040)
java.lang.Thread.run(Thread.java:682)
[Thread-401] [ 2018-02-14 12:59:28.567 EST ] [SQLEngine.done:2278] Done called
Exception in thread "Thread-401"
java.lang.NullPointerException
at oracle.sysman.assistants.dbma.wizard.view.ValidationPage.prepareMaps(ValidationPage.java:1989)
at oracle.sysman.assistants.dbma.wizard.view.ValidationPage.check(ValidationPage.java:1651)
at oracle.sysman.assistants.dbma.wizard.view.ValidationPage$Check.run(ValidationPage.java:2040)
at java.lang.Thread.run(Thread.java:682)
[Thread-416] [ 2018-02-14 12:59:32.697 EST ] [PerlEngine$LogStreamReader.run:1411] Bad file number (errno:9)
java.io.FileInputStream.readBytes(Native Method)
java.io.FileInputStream.read(FileInputStream.java:220)
sun.nio.cs.StreamDecoder.readBytes(StreamDecoder.java:264)
sun.nio.cs.StreamDecoder.implRead(StreamDecoder.java:306)
sun.nio.cs.StreamDecoder.read(StreamDecoder.java:158)
java.io.InputStreamReader.read(InputStreamReader.java:167)
java.io.BufferedReader.fill(BufferedReader.java:136)
java.io.BufferedReader.readLine(BufferedReader.java:299)
java.io.BufferedReader.readLine(BufferedReader.java:362)
oracle.sysman.assistants.util.sqlEngine.PerlEngine$LogStreamReader.readLogOutput(PerlEngine.java:1458)
oracle.sysman.assistants.util.sqlEngine.PerlEngine$LogStreamReader.run(PerlEngine.java:1405)
java.lang.Thread.run(Thread.java:682)
[Thread-421] [ 2018-02-14 12:59:33.137 EST ] [PerlEngine$LogStreamReader.run:1411] Bad file number (errno:9)
java.io.FileInputStream.readBytes(Native Method)
java.io.FileInputStream.read(FileInputStream.java:220)
sun.nio.cs.StreamDecoder.readBytes(StreamDecoder.java:264)
sun.nio.cs.StreamDecoder.implRead(StreamDecoder.java:306)
sun.nio.cs.StreamDecoder.read(StreamDecoder.java:158)
java.io.InputStreamReader.read(InputStreamReader.java:167)
java.io.BufferedReader.fill(BufferedReader.java:136)
java.io.BufferedReader.readLine(BufferedReader.java:299)
java.io.BufferedReader.readLine(BufferedReader.java:362)
oracle.sysman.assistants.util.sqlEngine.PerlEngine$LogStreamReader.readLogOutput(PerlEngine.java:1458)
oracle.sysman.assistants.util.sqlEngine.PerlEngine$LogStreamReader.run(PerlEngine.java:1405)
java.lang.Thread.run(Thread.java:682)

 

 

Changes

 Performing the upgrade of RAC database to 12c using DBUA.

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