Migration from 8.1.7 to 9.2.0
DBAsupport.com Forums - Powered by vBulletin
Results 1 to 5 of 5

Thread: Migration from 8.1.7 to 9.2.0

  1. #1
    Join Date
    Jan 2001
    Posts
    515

    Migration from 8.1.7 to 9.2.0

    I have a test database 8.1.7 on one server and I have 9.2.0 installed on another server. I want to copy the 8.1.7 database to the 9.2.0 server and try to migrate it to 9.2.0. The problem is that when I move it I have tio recreat the control files before I mount it to start the migration because the filesystem is layed out differently.

    Can this be done? I copied all the files except control files to new server. Created an init.ora. Then I logged in as sysdba and ran my create control file script pointing everything to the new directories and I get the following error

    ORA-04031: unable to allocate 11164520 bytes of shared memory ("shared pool","unknown object","sga heap(1,0)","FileOpenBlock")
    CREATE CONTROLFILE SET DATABASE "DBTEST" RESETLOGS NOARCHIVELOG
    *
    ERROR at line 1:
    ORA-01034: ORACLE not available


    ALTER DATABASE MOUNT
    *
    ERROR at line 1:
    ORA-01034: ORACLE not available

  2. #2
    Join Date
    Jul 2002
    Location
    Northampton, England
    Posts
    612
    Did you STARTUP NOMOUNT before CREATE CONTROLFILE to get the instance started?
    Assistance is Futile...

  3. #3
    Join Date
    Jan 2001
    Posts
    515

    Yes

    STARTUP NOMOUNT
    CREATE CONTROLFILE SET DATABASE "DBTEST" RESETLOGS NOARCHIVELOG

  4. #4
    Join Date
    Jul 2002
    Location
    Northampton, England
    Posts
    612
    'course you have otherwise it wouldn't be trying to allocate memory from your shared_pool... Have you tried increasing the size of your shared pool so that Oracle can find a sufficient chuck of memory to allocate to your request?
    Assistance is Futile...

  5. #5
    Join Date
    Jul 2002
    Location
    Northampton, England
    Posts
    612
    Assistance is Futile...

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  



Click Here to Expand Forum to Full Width