Monday, January 30, 2012

Upgrade an Oracle database from 10.2.0.1.0 to 11.2.0.1.0 using DBUA

While trying to upgrade the database from 10.2.0.1.0 to 11.2.0.1.0 using DBUA I got the following message:
Could not get database version from the Oracle Server component. The CEP file rdbmsup.sql does not provide the version directive.

Reason:
To upgrade from 10.2.0.1.0 to 11.2.0.1.0 , we need to first upgrade from 10.2.0.1.0 to 10.2.0.4 using Oracle Patchset 10.2.0.4 (6810189).

Here is a link to an excellent blogs that gives all the details on installing the Patchset.

Once I upgraded to Oracle 10.2.0.4, I could upgrade to 11.2.0.1.0 using DBUA.

Also, this blog gives all the details on using DBUA for the upgrade.

No comments: