+ Reply to Thread
Results 1 to 4 of 4
  1. 07-21-2008 01:28 AM #1
    hirani_prashant
    hirani_prashant is offline Junior Member
    Join Date
    Jan 2008
    Posts
    39

    Migration help from oracle 8i to oracle 9i

    Hello all,

    we have oracle 8.1.7 on main server and now want to migrate the database to oracle 9.2.0.

    The things is that "db_block_size" parameter value is 8192 in 8i.

    when i tried to create new database with the help of DBCA in 9i with "db_block_size" value = 8192 then it gives me error "can not create control files with db_block_size = 8192".

    can any one help me out?

    tell me other ways of migration also...

    -- Thanks
    Prashant Hirani
    Reply With Quote Reply With Quote
  2. 07-21-2008 04:18 AM #2
    PAVB's Avatar
    PAVB
    PAVB is offline Senior Advisor
    Join Date
    Mar 2007
    Location
    Ft. Lauderdale, FL
    Posts
    3,503
    Check your init.ora file... look for db_block_size paramenter.

    Next time, please copy/paste/post whole error stack -not your interpretation of it.
    Pablo (Paul) Berzukov

    Author of Understanding Database Administration available at amazon and other bookstores.

    Disclaimer: Advice is provided to the best of my knowledge but no implicit or explicit warranties are provided. Since the advisor explicitly encourages testing any and all suggestions on a test non-production environment advisor should not held liable or responsible for any actions taken based on the given advice.
    Reply With Quote Reply With Quote
  3. 07-21-2008 04:49 AM #3
    hirani_prashant
    hirani_prashant is offline Junior Member
    Join Date
    Jan 2008
    Posts
    39
    Thanks PAVB.

    i know there is problem with db_block_size parameter..

    i think you are not getting my question. i am asking you why it is not possible to create db with 8k block size by using DBCA??
    Reply With Quote Reply With Quote
  4. 07-21-2008 05:18 AM #4
    davey23uk
    davey23uk is offline Senior Advisor
    Join Date
    Sep 2002
    Location
    England
    Posts
    7,323
    post the full error, the parameter file used, the os and the commands used - you are only providing half the information
    Reply With Quote Reply With Quote
« Previous Thread | Next Thread »

Bookmarks

Posting Permissions

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

Forum Rules

 Click Here to Expand Forum to Full Width