9 Replies Latest reply: May 17, 2013 7:51 AM by Srini Chavali-Oracle RSS

    Copy Database : compatibility beetwen 10.2.0.5 down to 10.2.0.1

    1009312
      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
          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
            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
              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
                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
                  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
                    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
                      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
                        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
                          Updating internal Oracle objects is not supported - it may result in your database being corrupted beyond repair

                          Srini