Database Administration (MOSC)

MOSC Banner

Doubt about "compatible" parameter and upgrade process

edited Aug 13, 2014 8:02PM in Database Administration (MOSC) 7 commentsAnswered ✓

Hi,

I am passing a database from server 1 to server 2.

Binaries in server 2 are 10.2.0.5.0.

Database in server 1 is 10.2.0.2.0

I am setting the parameter compatible=10.2.0.5.0 and :

startup nomount pfile=/u01/oradata/DATABASE/init DATABASEmodificado.ora

alter database mount;

alter database open upgrade;

@$ORACLE_HOME/rdbms/admin/catupgrd.sql;

Shutdown immediate;

After that I was expecting to open the database without using the parameter compatible but I am getting

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

ORA-00202: control file: '/u03/oradata/DATABASE /control01.ctl'

I tried to recreate the control file but:

ORA-01130: database file version 10.2.0.5.0 incompatible with ORACLE version 10.2.0.0.0

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center