7 Replies Latest reply: May 16, 2012 9:42 AM by 933205 RSS

    Move database 10GR2 from Windows Server 2003 to Windows Server 2008

    933205
      Hi,

      I have to move the database to a new server.
      The database is an Enterprise 10GR2 (10.2.0.3.0) with the Partitionning option on a Windows Server 2003 x64.
      The new server is a Windows Server 2008 x64.

      All the files (admin, flash recovery area and oradata) are on one disk. So when I have to do this, usually I just install a new instance on the new server and toggle the disk to the new server, start directly the database and everything is ok !

      However it seems that the version 10.2.0.3 is not available for Windows 2008 x64 (in the Downloads part of oracle.com), I saw that I have to Install 10.2.0.4 or higher.
      I'm newbie on patching a database, so what I have to do ? First upgrade the database on the 2003 server and then install 10.2.0.4 on the new server ? Or other ?

      Thanks.

      Edited by: 930202 on 25 avr. 2012 08:33

      Edited by: 930202 on 25 avr. 2012 08:35

      Edited by: 930202 on 25 avr. 2012 08:36
        • 1. Re: Move database 10GR2 from Windows Server 2003 to Windows Server 2008
          Srini Chavali-Oracle
          You will need to upgrade to 10.2.0.4 on your current server first. Then clone the ORACLE_HOME binaries from the source to target using these instructions

          http://docs.oracle.com/cd/B19306_01/em.102/b16227/oui7_cloning.htm

          You will then need to shout down the database and copy it over to the new server.

          How To Make A Copy Of An Open Database For Duplication To A Different Machine [ID 224274.1] …

          HTH
          Srini
          • 2. Re: Move database 10GR2 from Windows Server 2003 to Windows Server 2008
            933205
            Hi,

            Thanks for the response.

            In fact for cloning the DB we use an other method and it takes 1 min (the network admin takes a clone of the disk which contains all the DB files, that is to say the folders admin/flash recovery area/oradata,
            and mount a new disk on the new server with this clone). The ORACLE_HOME is on another disk (C:) so usually I install a new instance on the new server.

            It was urgent for me to do that so I tested one method and it seems to work : )

            So I install Oracle Database 10g Release 2 10.2.0.4.0 Enterprise on the new server, then the 10.2.0.5 patchset (I had to install this patchset because the new server is under Windows 2008 R2),
            and finally upgrade (with the upgrade assistant) the DB on the new server directly. During the upgrade I had only 2 errors which seem to be "normal" according Oracle.

            Do you think it's correct doing like this ?

            Thanks for taking time to response.
            • 3. Re: Move database 10GR2 from Windows Server 2003 to Windows Server 2008
              Srini Chavali-Oracle
              Pl post details of the two errors - are you able to startup and use the database successfully on the target host ?

              HTH
              Srini
              • 4. Re: Move database 10GR2 from Windows Server 2003 to Windows Server 2008
                933205
                Hi,

                The first error was :
                ORA-29382: validation of pending area failed
                ORA-29375: sum of values 190 for level 3, plan SYSTEM_PLAN exceeds 100
                ORA-06512: at "SYS.DBMS_RMIN, line 989
                ORA-06512: at line 1

                After searching on the oracle support, I verified in the appropriate view and the percentages didn't exceed 100, so I finally tired to do this on the source DB : ALTER SYSTEM SET RESOURCE_MANAGER_PLAN = '';
                because it was SYSTEM_PLAN, I made the upgrade from the beginning with a new clone but still had the error so I just ignored it.

                The second error was : ORA-04043: object xdb_datastore_proc does not exist. It's a normal error, it's because I don't have Oracle Text.

                The DB seems ok, no particular problems at startup, there is just the first error that is annoying, I hope this will not cause problems.



                edit : for information, there is a bug with the 10.2.0.5.0 version to start the database control, it's necessary to apply the patch 8350262, hope it could help ; )

                Edited by: 930202 on 30 avr. 2012 01:57
                • 5. Re: Move database 10GR2 from Windows Server 2003 to Windows Server 2008
                  933205
                  Up !

                  Any idea about the first error ? Anyone resolved it ? I didn't find any solution working for me...

                  The first error was :
                  ORA-29382: validation of pending area failed
                  ORA-29375: sum of values 190 for level 3, plan SYSTEM_PLAN exceeds 100
                  ORA-06512: at "SYS.DBMS_RMIN, line 989
                  ORA-06512: at line 1
                  • 6. Re: Move database 10GR2 from Windows Server 2003 to Windows Server 2008
                    Srini Chavali-Oracle
                    Pl see this MOS Doc

                    ORA-29375 plan SYSTEM_PLAN exceeds 100 [ID 734030.1]     

                    and these other discussions

                    https://forums.oracle.com/forums/search.jspa?threadID=&q=ORA-29382&objID=c84&dateRange=all&userID=&numResults=15

                    HTH
                    Srini
                    • 7. Re: Move database 10GR2 from Windows Server 2003 to Windows Server 2008
                      933205
                      Hi,

                      Thanks for your reponse, I had already sawn this doc and the solution given didn't work because I had the error when I try the upgrade again...

                      I didn't find any elements in the other discussions.

                      So just ignore the error and go on ; )

                      Thanks.
                      Julien.