DBUA Silent Mode Fails With The Upgrade Assistant failed in executing any query on the database (Doc ID 1994727.1)

Last updated on MAY 31, 2017

Applies to:

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

Symptoms

 

DBUA in silent mode failing

Customer executed the DBUA usuing silent mode.Upgrade was failing with the below error message as seen in the silent.log under $ORACLE_BASE/cfgtoollogs/dbua/logs directory

These parameters may cause an error when you start the database after upgrading to the "11.2.0.4.0" version. Replace the environment variables with the actual value (for example, the path or string) that you want to assign to the initialization parameter. Then restart the database with this parameter file and run the Database Upgrade Assistant again.


The Upgrade Assistant failed in executing any query on the database DBUPG1. Oracle Home /u01/DBUPG/11.2.0.3 obtained from file /etc/oratab was used to connect to the database. Either the database is not running from Oracle Home /u01/DBUPG/11.2.0.3 or its not in OPEN status. Correct the error and run the Upgrade Assistant again.


Could not proceed with Upgrade due to errors.

Fix the errors and restart again!

 

Changes

 Customer was upgrading the database instance from 11.2.0.3.nnn to 11.2.0.4.nnn

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