7 Replies Latest reply: Jun 24, 2013 4:16 PM by TSharma-Oracle RSS

    Upgrade from 8i to 11g

    1012008


      Hi All,

      We are upgrading from 8i(solaris) to 11g(linux)

      created new 11g database

      thought of doing export import since thats the only option but databse is like 300GB

      now export is stuck for two days ... is there any other option of

      transferring the data from 8i to 11g  Endians are not matching

        • 1. Re: Upgrade from 8i to 11g
          TSharma-Oracle

          300 GB database export should not be taking 2 days. What kind of servers you have? You can try making your export faster.

          You can  try exporting at schema level. start multiple export sessions at the same time. This is a sort of parallel processing your export. Make sure your export dump files are not being written on same physical disk or any NFS mounted disk.

           

          How can one improve Import/ Export performance?

           

          http://www.orafaq.com/wiki/Import_Export_FAQ

           

          • 2. Re: Upgrade from 8i to 11g
            1012008

            Hi,

            its upgrading prod database if we go for schema level "full export. It gets not only schema's but "public" things too (eg: it gets public synonyms - a schema or object level export would not)"

            • 3. Re: Upgrade from 8i to 11g
              DK2010

              Hi,

               

              Where its stuck, what shows in import log file.. is your DB in Archive log mode, Have you excluded  Indexes during import..

              • 4. Re: Upgrade from 8i to 11g
                TSharma-Oracle

                For public synonym, you can make your own scripts using SELECT DBMS_METADATA.GET_DDL or use any third party tool like TOAD, SQL developer etc and just run that in a new database. For synonyms:

                 

                spool publicsynonyms.sql

                 

                select      'create public synonym ' || table_name || ' for ' || table_owner || '.' || table_name || ';'  from      dba_synonyms

                where      owner='PUBLIC' and table_owner not in ('SYS', 'SYSTEM')

                order by  table_owner;

                 

                spool off

                 

                You can also TRACE the export session to see where it is stuck.

                • 5. Re: Upgrade from 8i to 11g
                  1012008

                  Thank you all

                  Sorry for using the wrong word its not stuck its too slow. The exp command is FULL=y and 10 dumpfiles with 30GB each. mount point is NFS  .. OS SunOS  5.8 it is still running cant post entire details  i mean log contents and all since its prod please bear with me.

                  I know NFS is really slow but i dont have any other mount points with enough space

                  • 6. Re: Upgrade from 8i to 11g
                    1012008

                    It ran for 3 days total .Is this all because of "NFS" drive because thats only thing we can blame as of now but if we get space in

                    local drives and if it slows again then all fingers would be pointed to us. I have asked for 300GB space in local file system will increase buffer size and give direct=y

                    and statistics=none i am guessing that would work any thoughts on that. Any suggestion or experience with slowness


                    I had started a different discussion since the question was different i got this reply from dean i had asked if starting multiple exports of schemas serve same purpose as full=y

                     

                    "If you need the complete contents of the database, then you need to do full=y.  Some objects are not owned by a schema so they would be be exported in a schema mode export.


                    I'm not sure if there is a way to do what you want.


                    Dean"

                    • 7. Re: Upgrade from 8i to 11g
                      TSharma-Oracle

                      I think just by moving from NFS to local should do the trick and setting all other parameters is a plus. I think even if you just export your all the schemas, you will be good. I had already given you a query to copy all PUBLIC objects.

                      Also there used to be a BUG which used to skip the jobs created with DBMS_JOB.

                      But after you are done with the IMPORT, you can always compare your old and new databases by using any third party tool such as SQL developer or TOAD etc.