Database conversion fails with ORA-00201

Document ID : KB000050893
Last Modified Date : 14/02/2018
Show Technical Document Details

Description:

Issue was caused by recreating the database pfile off of the spfile with the command:

create pfile from spfile;

run from sqlplus. This removes the FILE REVISION NUMBER comment and include lines from the bottom of the init{SID}.ora file.

These lines would look similar to this:

IFILE=<path>/init{SID}.ora.usr # include user overrides to this file
# DONOT REMOVE THIS COMMENT! CONTAINS FILE REVISION NUMBER --> Database Parameters Rev:17

The "IFILE" line is necessary to include any user changes in the initialization paramters.

The removal of the comment line is what caused nhConvertDb to fail in this instance.

nhConvertDb calls nhiUpdateInitOra.

nhiUpdateInitOra keys off of the "Database Parameters Rev." line to know what changes to make to the file.

In the absence of the comment line, nhiUpdateInitOra mistakenly set the database parameter "compatible" to a setting which would not allow the database to open and resulted in this error in the database conversion log when run in debug:

ORA-00201: control file version 10.2.0.0.0 incompatible with ORACLE version 9.2.0.0.0

Problem Ticket: PRD00050381

Solution:

The fix is to put back the IFILE and FILE REVISION NUMBER comment lines.

For the "Database Parameters Rev." reference the version number on a system running the same release of eHealth. Contact CA eHealth Technical Support for this number if necessary. Database conversion should now succeed.