IBM Support

FileNet Image Services: Oracle Database Upgrade Assistant (dbua) fails to start database - ERROR ORA-00201

Technote (troubleshooting)


Oracle Database Upgrade Assistant (dbua) fails with the pop-up message "The Upgrade Assistant failed in bringing up the database".


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 incompatible with ORACLE version


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


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 =

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.

Document information

More support for: FileNet Image Services

Software version: 4.1.1, 4.1.2, 4.2

Operating system(s): Platform Independent

Reference #: 1442900

Modified date: 07 December 2016

Translate this page: