Troubleshooting
Problem
Oracle Database Upgrade Assistant (dbua) fails with the pop-up message "The Upgrade Assistant failed in bringing up the database".
Symptom
The Oracle dbua utility will return a pop-up message that it failed in bringing up the database.
fn_util startdb or fn_oracle start will log the following error to the fn_util.log:
Starting Oracle relational database
fn_oracle: /usr/ora/920/bin/sqlplus @/fnsw/local/oracle/start_db0.sql
ERROR ORA-00201: controlfile version 8.1.7.0.0 incompatible with ORACLE version
Cause
The compatible parameter in the /fnsw/local/oracle/init.ora file is set to value that does not allow Oracle to start. The value specified in the Oracle pre-upgrade utility utlu111i.sql did not work.
Here is an example of the utlu111i.sql output:
- Update Parameters: [Update Oracle Database 11.1 init.ora or spfile]
**********************************************************************
WARNING: --> "compatible" must be set to at least 10.1.0
Environment
Oracle 11g upgrade from Oracle 9.2.x
Resolving The Problem
Correct the compatible parameter in the inti.ora
1. Exit the dbua program.
2. Edit the /fnsw/local/oracle/init.ora file.
3. Change the compatible to match the original entry.
Eg: Change: "compatible = 10.1.0"
To: compatible = 9.2.0.4
4. Verify that all Oracle process other than the listener are not running using "ps -ef |grep ora"
5. Start the Oracle Assistant "dbua" again.
Was this topic helpful?
Document Information
Modified date:
17 June 2018
UID
swg21442900