DBAsupport.com Forums - Powered by vBulletin
Results 1 to 2 of 2

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

  1. 06-07-2005, 01:50 PM #1
    sachin_wal
    sachin_wal is offline Junior Member
    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.
    Reply With Quote Reply With Quote
  2. 06-07-2005, 02:01 PM #2
    marist89's Avatar
    marist89
    marist89 is offline Super-Genius
    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
    Reply With Quote Reply With Quote
« Previous Thread | Next Thread »

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