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

Technote (troubleshooting)


Problem(Abstract)

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.


Rate this page:

(0 users)Average rating

Add comments

Document information


More support for:

FileNet Image Services
Oracle

Software version:

4.1.1, 4.1.2, 4.2

Operating system(s):

Platform Independent

Reference #:

1442900

Modified date:

2013-05-03

Translate my page

Machine Translation

Content navigation