This discussion is archived
9 Replies Latest reply: May 17, 2013 5:51 AM by Srini Chavali-Oracle RSS

Copy Database : compatibility beetwen 10.2.0.5 down to 10.2.0.1

1009312 Newbie
Currently Being Moderated
Hi to all,
I used to "copy" db from one server to another (same configuration / SID on both servers)
But now it's not working, I got errors in alert.log file :
...
ORA-00704: bootstrap process failure
ORA-39700: database must be opened with UPGRADE option

Thu May 16 12:01:22 Romance Daylight Time 2013
Error 704 happened during db open, shutting down database
USER: terminating instance due to error 704
Instance terminated by USER, pid = 6452
ORA-1092 signalled during: ALTER DATABASE OPEN...

I wonder if it's mandatory to have the ORACLE version beetwen the 2 servers?
One is in 10.2.0.5 and other 10.2.0.1.

Command :
SELECT name, value, description FROM v$parameter
WHERE name = 'compatible';
get the following result :
Compatible 10.2.0.1.0

Thanks for your help
Pascal
  • 1. Re: Copy Database : compatibility beetwen 10.2.0.5 down to 10.2.0.1
    clementeOTN Explorer
    Currently Being Moderated
    Hi
    Is not mandatory to have the two oracle version between the two servers, but as the error log says, you must open it with startup upgrade.

    Maybe there will be another solution, this is to edit the parameter file and remove the "compatible" line.

    You can do this :

    Origin database
    -> Create pfile='/tmp/pfile_temp.ora' from spfile
    -> vi /tmp/pfile_temp.ora ( (remove compatible=10.2.0.5 )
    -> Copy /tmp/pfile_temp.ora to destination server

    destination database
    -sqlplus "/as sysdba"
    -starttup pfile=/tmp/pfile_temp.ora





    The best solution is to have the same version or to pen it with upgrade clausule,but I think the second one could works ;-)




    EDited
    Sorry , I readed it worng. I thought you was talking about upload version, not download it :-(
    I'm not sure that the "second option" will work in a downgrade of version, At first , it seems that 10.2.0.5 down to 10.2.0.1 are the same 10.2.0.X so it probably works, but I don't know if the database will be stable :-(

    Edited by: clementeOTN on 16-may-2013 13:10
  • 2. Re: Copy Database : compatibility beetwen 10.2.0.5 down to 10.2.0.1
    1009312 Newbie
    Currently Being Moderated
    Thank you.

    I need to be more precise and explain whtat I did in the meantime.

    Oracle 1 Version : 10.2.0.5.0
    Oracle 1 Comptatible : 10.2.0.1.0 (in db and in spfile)

    Oracle 2 Version : 10.2.0.1.0
    Oracle 2 Comptatible : 10.2.0.1.0 (in db and in spfile)

    Copy db from Oracle 1 to Oracle 2 server.

    Test : remove compatible statement in pfile : error ORA-00201 and 00202 on control file (control file version 10.2.0.1.0 incompatible with ORACLE version 10.2.0.0.0)

    So, I decided to reverse the process.
    Create a db on Oracle 2 server, copy db files on Oracle 1 server, startup.
    Same error : uneed to updgrade db. So, I upgrade and it's working : db can be started without error.

    So, I think the answer is : same version !

    New question : what is the purpose of Comptatible statement in spfile ?
  • 3. Re: Copy Database : compatibility beetwen 10.2.0.5 down to 10.2.0.1
    Srini Chavali-Oracle Oracle ACE Director
    Currently Being Moderated
    For COMPATIBILITY, pl see the documentation

    http://docs.oracle.com/cd/B19306_01/server.102/b14237/initparams028.htm#REFRN10019
    http://docs.oracle.com/cd/B19306_01/server.102/b14231/create.htm#sthref417
    http://docs.oracle.com/cd/B19306_01/server.102/b14238/compat.htm#sthref155

    HTH
    Srini
  • 4. Re: Copy Database : compatibility beetwen 10.2.0.5 down to 10.2.0.1
    1009312 Newbie
    Currently Being Moderated
    Thank you Srini,
    What I understand is that should work on my configuration because compatible parameter is set to the lower level 10.2.0.1.0.

    But why my database copied from a 10.2.0.1.0 server must be upgraded on a 10.2.0.5.0 server with compatible parameter correctly set on both side to 10.2.0.1.0 ?

    Regards,
    Pascal
  • 5. Re: Copy Database : compatibility beetwen 10.2.0.5 down to 10.2.0.1
    Srini Chavali-Oracle Oracle ACE Director
    Currently Being Moderated
    You will have to perform a downgrade or upgrade if you want to copy databases between different versions. The COMPATIBILITY parameter is only relevant for features within the database.

    HTH
    Srini
  • 6. Re: Copy Database : compatibility beetwen 10.2.0.5 down to 10.2.0.1
    1009312 Newbie
    Currently Being Moderated
    I tried to downgrade it to 10.2.0.1 but it stiil in 10.2.0.5.0.
    SELECT prv_version FROM registry$ command mentions still 10.2.0.5.0 objects in db.

    What should I do except upgrading Oracle 2 server to 10.2.0.5.0?

    Pascal
  • 7. Re: Copy Database : compatibility beetwen 10.2.0.5 down to 10.2.0.1
    Srini Chavali-Oracle Oracle ACE Director
    Currently Being Moderated
    Pl elaborate exact steps you took to downgrade from 10.2.0.5 to 10.2.0.1 - you will need to follow the steps in the README for patch 10.2.0.5.

    HTH
    Srini
  • 8. Re: Copy Database : compatibility beetwen 10.2.0.5 down to 10.2.0.1
    1009312 Newbie
    Currently Being Moderated
    Hi to all,
    Problem solved !

    So I used the following steps:
    On Oracle 1 server (10.2.0.5.0)
    1 - Upgrade (startup upgrade and run script catupgrd)
    2 - Update previous version info otherwise error in next step (can be done before 1 I guess)
    update registry$ set prv_version='10.2.0.1.0' where cid='CATPROC';
    update registry$ set prv_version='10.2.0.1.0' where cid='CATALOG';
    update registry$ set prv_version='10.2.0.1.0' where cid='OWM';
    update registry$ set prv_version='10.2.0.1.0' where cid='JAVAVM';
    update registry$ set prv_version='10.2.0.1.0' where cid='XML';
    update registry$ set prv_version='10.2.0.1.0' where cid='CATJAVA';
    update registry$ set prv_version='10.2.0.1.0' where cid='EXF';
    update registry$ set prv_version='10.2.0.1.0' where cid='ODM';
    update registry$ set prv_version='10.2.0.1.0' where cid='CONTEXT';
    update registry$ set prv_version='10.2.0.1.0' where cid='XDB';
    update registry$ set prv_version='10.2.0.1.0' where cid='RUL';
    update registry$ set prv_version='10.2.0.1.0' where cid='ORDIM';
    update registry$ set prv_version='10.2.0.1.0' where cid='EM';
    3 - Downgrade (startup downgrade and run script catdwgrd)
    4 - Copy datafile on Oracle 2 server (10.2.0.1.0)
    5 - Upgrade (startup upgrade and run script catupgrd)

    That's all folks!

    Thanks to all for helping me and big up to Google !

    Pascal
  • 9. Re: Copy Database : compatibility beetwen 10.2.0.5 down to 10.2.0.1
    Srini Chavali-Oracle Oracle ACE Director
    Currently Being Moderated
    Updating internal Oracle objects is not supported - it may result in your database being corrupted beyond repair

    Srini

Legend

  • Correct Answers - 10 points
  • Helpful Answers - 5 points