ORA-01092: ORACLE instance terminated. Disconnection forced
DBAsupport.com Forums - Powered by vBulletin
Results 1 to 3 of 3

Thread: ORA-01092: ORACLE instance terminated. Disconnection forced

  1. #1
    Join Date
    Mar 2005
    Posts
    143

    ORA-01092: ORACLE instance terminated. Disconnection forced

    I have 2 DB's. DB1 and DB2. Both are test db's, DB2 is brand new. Both 9i on a windows 2000 server. I want to refresh db2 from db1. I shutdown db1 cleanly, coppied all the datafiles to the DB2 directory, and rebuilt the control files for DB2. The control files were created and the database came to a mounted state. I issued the command "alter database open resetlogs;" and got the following error
    alter database open
    *
    ERROR at line 1:
    ORA-01092: ORACLE instance terminated. Disconnection forced
    I have used this method hundreds of times to do refreshes and never had a problem. I looked around on the internet and found a few things. One said to restart the instance and try again. I stoped the db's nt service and started it up. Then connected to the db and issued the same command and it came back saying
    ERROR at line 1:
    ORA-01113: file 1 needs media recovery
    ORA-01110: data file 1: 'F:\ORACLE\ORADATA\DB2\SYSTEM01.DBF'
    I recovered the db with the recover db command and issued the "alter database open; command and got back to the original error message:
    alter database open
    *
    ERROR at line 1:
    ORA-01092: ORACLE instance terminated. Disconnection forced
    could anyone help me out with this?

  2. #2
    Join Date
    Oct 2005
    Location
    Indianapolis
    Posts
    100
    Anything useful in the alert log? File system permissions OK?
    "False data can act only as a distraction. Therefore. I shall refuse to perceive you." - Bomb #20

  3. #3
    Join Date
    Sep 2002
    Location
    England
    Posts
    7,333
    the database is in an inconsistent state, need to do the operation again ,naking sure it is all shutdown this time

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