8 Replies Latest reply: Mar 13, 2013 7:52 PM by 606331 RSS

    migrating 10g 32bits to 11g 64 bits

    Maahjoor
      dear all,

      i have oracle 10g Release 10.1.0.2.0 on windows server 2003 service pack 2 (both are 32 bit).

      i have oracle 11g Release 11.2.0.1.0 on window server 2012 (both are 64 bit)

      i want to move my 10g database to 11g.

      how to do this?
        • 1. Re: migrating 10g 32bits to 11g 64 bits
          Srini Chavali-Oracle
          How big is the database ? How much downtime can you afford ?

          One option would be export/import - http://docs.oracle.com/cd/E11882_01/server.112/e23633/expimp.htm#i262247

          You cannot upgrade directly (using scripts) unless you first patch the source database to 10.1.0.5 - http://docs.oracle.com/cd/E11882_01/server.112/e23633/preup.htm#i1007814

          Complete Checklist for Manual Upgrades to 11gR2 [ID 837570.1]

          HTH
          Srini
          • 2. Re: migrating 10g 32bits to 11g 64 bits
            Rob_J
            Hi,

            There are also some notes available on how to [url http://www.ora00600.com/articles/10g-to-11g-database-upgrade.html]upgrade from 10g to 11g which might come in handy for you.

            Hope this helps,
            Rob
            • 3. Re: migrating 10g 32bits to 11g 64 bits
              Maahjoor
              hi srini,

              my database is not big enough, it is 3 gb.
              before reading your post, i already has taken the following steps.

              1.startup nomount the new 11g 64bit server.
              2.copy the OLD server control files to the NEW 11g server control files locations.
              3.alter database mount;
              4. copy OLD datafiles and redolog files to the NEW location.
              5.use alter database rename file to 'OLD FILE' to 'NEW FILE'; for all redo and datafiles.
              6.alter database open;
              it give the following error
              ora-01092: ORACLE instance terminated.Disconnection forced
              ora-00704:bootstrap process failure
              ora-39700: database must be opened with upgrade option

              then i search in google and do the following.
              7.startup upgrade;
              database is opened.

              now the problem is this my all schemas exists here, but when i want to connect to any of the schema using command CONN HR/HR it give the following error:
              ORA-only connect as sysdba is allowed when open in UPGRADE mode.
              when i try to issue the command with @ sign, like CONN HR/HR@ORCL it give the follwoing error
              ORA-12526: TNS: Listner all appropriate instances are in restricted mode.


              how to fix it?
              • 4. Re: migrating 10g 32bits to 11g 64 bits
                asahide
                Hi,

                Did you execute "catupgrd.sql" script ?
                Anyway, Check this manual..
                <<http://docs.oracle.com/cd/E11882_01/server.112/e23633/upgrade.htm#CACGGHJC>>

                Regards,
                • 5. Re: migrating 10g 32bits to 11g 64 bits
                  Maahjoor
                  i do not execute this script. what is this for?where should i execute it, on old or on new?
                  In the meanwhile i will read the link you provide.
                  thank youl
                  • 6. Re: migrating 10g 32bits to 11g 64 bits
                    Maahjoor
                    hi srini,

                    i try the import export, there is a problem with it. it do not export ROLES.
                    i export HR schema, but when i try to import it, it says AD_ROLE does not exist.
                    AD_ROLES is one of the role i created.
                    the same error for all the roles.


                    how to completely export a schema with roles with everything?

                    i have a small database, and i could afford it.
                    thanks
                    • 7. Re: migrating 10g 32bits to 11g 64 bits
                      Srini Chavali-Oracle
                      Pl post the complete export and import commands used, along with the first 15 lines of the export and import logs.

                      http://docs.oracle.com/cd/B14117_01/server.101/b10825/exp_imp.htm#i1021654

                      You cannot copy over the database files to the target server and startup the database in upgrade mode and run the upgrade scripts unless your source database version has been patched to version 10.1.0.5

                      HTH
                      Srini
                      • 8. Re: migrating 10g 32bits to 11g 64 bits
                        606331
                        Hi,

                        please refer below notes.....

                        create the structure/skliton (create all what you have in 10g database)...of db on 11g home and then import data...... hope it will resolve the issue...

                        Database Migration With OS Upgrade On Windows Platform [ID 752986.1]
                        How to Upgrade RDBMS and Convert From 32-bit to 64-bit Binaries Directly on Linux or Windows based Intel Platforms Using the Database Upgrade Assistant (DBUA) [ID 757245.1]


                        thanks,
                        DBC,
                        Sr DBA.