DBUA hung at Pre-Upgrade – 12c
While performing upgrade of Data Guard from 11.2.0.4 to 12.1.0.1, after the pre upgrade script manual run started the upgrade of the primary database using DBUA from new 12.1.0.1 Oracle Home. After selecting the source Oracle Home and the Name/SID to upgrade the next step is to run prerequisite check by DBUA, when this step started there was no response after some time and for forever. So again stopped the entire process and again started DBUA with the same settings but again same result of DBUA hung at prerequisite step.
Now of course the next step is to check the upgrade logs if any information found to know the cause of DBUA hung. Finally from the trace file found the below information as [DatabaseQueryManager.getHost:200] Failed to connect sqlengine.
[oracle@ORA-U1 upgrade3]$ pwd /u01/app/oracle/cfgtoollogs/dbua/ORC1P/upgrade3 [oracle@ORA-U1 upgrade3]$ grep "getHost" * trace.log:[Thread-91] [ 2016-05-22 19:02:25.865 NZST ] [DatabaseQueryManager.getHost:200] Failed to connect sqlengine trace.log: at oracle.sysman.assistants.common.util.DatabaseQueryManager.getHost(DatabaseQueryManager.java:206) [oracle@ORA-U1 upgrade3]$
[Thread-91] [ 2016-05-22 19:02:25.799 NZST ] [OracleHome.getVersion:1058] Current Version From Inventory: 11.2.0.4.0
[Thread-91] [ 2016-05-22 19:02:25.799 NZST ] [OracleHome.getVersion:990] OracleHome.getVersion called. Current Version: 11.2.0.4.0
[Thread-91] [ 2016-05-22 19:02:25.799 NZST ] [OracleHome.getVersion:1058] Current Version From Inventory: 11.2.0.4.0
[Thread-91] [ 2016-05-22 19:02:25.799 NZST ] [SQLPlusEngine.getCmmdParams:225] m_home 11.2.0.4.0
[Thread-91] [ 2016-05-22 19:02:25.799 NZST ] [SQLPlusEngine.getCmmdParams:226] version > 112 true
[Thread-91] [ 2016-05-22 19:02:25.799 NZST ] [OsUtilsBase.getBaseFromOrabase:637] oraBaseUtility /u01/app/oracle/product/11.2.0/dbhome_1/bin/orabase
[Thread-91] [ 2016-05-22 19:02:25.799 NZST ] [OsUtilsBase.getBaseFromOrabase:646] cmds: /u01/app/oracle/product/11.2.0/dbhome_1/bin/orabase
[Thread-91] [ 2016-05-22 19:02:25.799 NZST ] [OsUtilsBase.getBaseFromOrabase:650] envs: ORACLE_HOME=/u01/app/oracle/product/11.2.0/dbhome_1
[Thread-91] [ 2016-05-22 19:02:25.812 NZST ] [OsUtilsBase.getBaseFromOrabase:655] baseLocation from orabase
/u01/app/oracle
[Thread-91] [ 2016-05-22 19:02:25.813 NZST ] [OsUtilsBase.getBaseFromOrabase:680] orabaseLocation= /u01/app/oracle
[Thread-91] [ 2016-05-22 19:02:25.815 NZST ] [SQLEngine.getEnvParams:589] Default NLS_LANG: AMERICAN_AMERICA.AL32UTF8
[Thread-91] [ 2016-05-22 19:02:25.815 NZST ] [SQLEngine.getEnvParams:599] NLS_LANG: AMERICAN_AMERICA.AL32UTF8
[Thread-91] [ 2016-05-22 19:02:25.815 NZST ] [SQLEngine.initialize:349] Execing SQLPLUS/SVRMGR process...
[Thread-91] [ 2016-05-22 19:02:25.816 NZST ] [SQLEngine.initialize:386] m_bReaderStarted: false
[Thread-91] [ 2016-05-22 19:02:25.816 NZST ] [SQLEngine.initialize:390] Starting Reader Thread...
[Thread-91] [ 2016-05-22 19:02:25.851 NZST ] [DatabaseQueryManager.getVersion:153] getVersion11.2.0.4.0
[Thread-91] [ 2016-05-22 19:02:25.852 NZST ] [DatabaseQueryManager.getVersion:163] version from the squrey11.2.0.4.0
[Thread-91] [ 2016-05-22 19:02:25.864 NZST ] [SQLEngine.done:2251] Done called
[Thread-91] [ 2016-05-22 19:02:25.865 NZST ] [DatabaseQueryManager.getHost:200] Failed to connect sqlengine
Exception in thread "Thread-91"
java.lang.NullPointerException
at oracle.sysman.assistants.common.util.DatabaseQueryManager.getHost(DatabaseQueryManager.java:206)
at oracle.sysman.assistants.common.util.DatabaseFactory.getSIDatabase(DatabaseFactory.java:80)
at oracle.sysman.assistants.common.util.DatabaseFactory.getDatabase(DatabaseFactory.java:52)
at oracle.sysman.assistants.dbma.dbux.validation.SupportedOracleVersionsCheck.validate(SupportedOracleVersionsCheck.java:73)
at oracle.sysman.assistants.dbma.wizard.view.ValidationPage.check(ValidationPage.java:1514)
at oracle.sysman.assistants.dbma.wizard.view.ValidationPage$Check.run(ValidationPage.java:1788)
at java.lang.Thread.run(Thread.java:662)
From the highlighted line we can see DBUA failed to connect sql engine and then followed with errors of java lang null pointer exception. Checked if there is any wrong settings of hostname , ip so on and no issues seen.
Next checked the MOS for any bugs and found the same behavior listed as bug with the name Bug 22858130 – 12.1.0.2 DBUA HANGE AT 0% COLLECTING PRE-UPGRADE INFORMATION, even though our Oracle version 12.1.0.1 but the task we are doing and the errors exactly similar hence checked for existing work around, it looks that if the files rconfig.jar and assistantsCommon.jar version is old and these issues may occur, the same note provided those two files so that we can download and use them directly.
[root@ORA-U1 upgrade3]# cd /u01/app/oracle/product/12.1.0/dbhome_1/assistants/jlib/ [root@ORA-U1 jlib]# ls -ltr rconfig.jar -rw-r--r--. 1 oracle oinstall 526807 May 13 2013 rconfig.jar [root@ORA-U1 jlib]# ls -ltr assi* -rw-r--r--. 1 oracle oinstall 4048786 May 13 2013 assistantsCommon.jar [root@ORA-U1 jlib]#
[root@ORA-U1 jlib]# ls -ltr rconfig.jar -rw-r--r--. 1 oracle oinstall 539648 Aug 1 2016 rconfig.jar [root@ORA-U1 jlib]# ls -ltr assi* -rw-r--r--. 1 oracle oinstall 4183202 Aug 1 2016 assistantsCommon.jar [root@ORA-U1 jlib]#
Now we have downloaded and moved to the location “/u01/app/oracle/product/12.1.0/dbhome_1/assistants/jlib/“, now we will test the work around by started DBUA.
Now we have seen the progress of prerequisite check after moving the two new jar files. Do not mistake from the above image of errors, this is because of the few steps which are not performed prior upgrade and hence this can be ignored. In fact we are expecting to know the status of DBUA as it is nothing doing anything initially.
This is very simple and can be found from My Oracle Support but while started writing the article i have searched the word “get host” related to DBUA and no clue seen, so thought to write and it may useful for others and of course me as well. 🙂
