ORA-10827: database must be opened with MIGRATE option.
DBAsupport.com Forums - Powered by vBulletin
Results 1 to 2 of 2

Thread: ORA-10827: database must be opened with MIGRATE option.

Hybrid View

  1. #1
    Join Date
    May 2005
    Posts
    1

    ORA-10827: database must be opened with MIGRATE option.

    Hi,
    We are trying to migrate an Oracle 8.1.7 database to an Oracle 9i(9.2) database. I moved all the database files to the appr folder and I created a new instance using:
    oradim -new -sid PROD -intpwd Oracle -startmode a -pfile C:\oracle\OraDb\Neuropace\initPROD.ORA.
    I checked the alter log file and I get the following error:
    ORA-10827: database must be opened with MIGRATE option.
    When I create the instance.

    How should one go about restoring a database (different versions). I went ahead with the migration. I opened the database using
    alter database open resetlogs migrate.
    But when i log into the database, I get an internal code error.
    Any pointers would be appreciated?.
    Regards,
    Sachin.

  2. #2
    Join Date
    Nov 2000
    Location
    greenwich.ct.us
    Posts
    9,092
    Which migration path did you follow? http://download-west.oracle.com/docs...a96530/toc.htm
    Jeff Hunter
    marist89@yahoo.com
    http://marist89.blogspot.com/
    Get Firefox!
    "I pledge to stop eating sharks fin soup and will not do so under any circumstances."

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