ORA-01092: Oracle Instance Terminated. Disconnection Forced.
DBAsupport.com Forums - Powered by vBulletin
Results 1 to 4 of 4

Thread: ORA-01092: Oracle Instance Terminated. Disconnection Forced.

  1. #1
    Join Date
    Jun 2001
    Posts
    243

    ORA-01092: Oracle Instance Terminated. Disconnection Forced.

    I'm getting following error when I try to open up a database after when my migration failed (ORA-29521: reference named java/lang/integer could not be found) from 8.1.7 to 9.2.0 with following error.

    ORA-01092: Oracle Instance Terminated. Disconnection Forced.

    I can mount the database, but I cannot open. Is there any way to open up the database?

  2. #2
    Join Date
    Nov 2002
    Location
    New Delhi, INDIA
    Posts
    1,796
    login as sys as sysdba
    do
    SQL> startup migrate
    SQL> spool upgrade.log
    run the upgrade script u0801070.sql again...
    SQL> @?/rdbms/admin/u0801070.sql or @?\rdbms\admin\u0801070.sql

    HTH
    Amar
    "There is a difference between knowing the path and walking the path."

    Amar's Blog  Get Firefox!

  3. #3
    Join Date
    Jun 2001
    Posts
    243
    How about from 8.1.6 to 8.1.7 there is no STARTUP MIGRATE in 8i.. STARTUP RESTRICT give me same error. So how can I open from 8i database?

  4. #4
    Join Date
    Nov 2002
    Location
    New Delhi, INDIA
    Posts
    1,796
    Did you follow the steps in the migration steps properly ??

    show the init parameter file, did you increase the size of the system tablespace, rollback segments...

    you are migrating manually or using DBMA...

    And one thing more ask the question as whole not in piecies... so that you can get better answer at a time...
    Amar
    "There is a difference between knowing the path and walking the path."

    Amar's Blog  Get Firefox!

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