OracleBrains.Com header image 2

ORA-01092: ORACLE instance terminated. Disconnection forced, error while creating database manually!

December 8th, 2008 by Rajender Singh · 4 Comments

Today while creating the database manually for our development environment, I incurred following error.

When I checked my alter log It showed me as follows:

After that I checked parameter file which showed me value of undo tablespace as follows:

After this I change the name in my create database script same as above i.e. “UNDOTBS”. Once done the database was created without any error.

I hope this will help out somebody!


Tags: Oracle Database · Oracle Installation

4 responses so far ↓

  • 1 // Dec 20, 2008 at 12:21 am

    Thank you very much! Saved me some time.

  • 2 Soumendra Jena // Jan 18, 2009 at 11:14 am

    Wow buddy,thats a great way to fix the error.
    Im not able to find,how to create a database manually in Oracle 9i.
    Can you plz throw some light ??
    Thanks :)

  • 3 Carlos Flores // Mar 7, 2009 at 5:43 am

    Thanks!!!
    It was succesfully!!

  • 4 Deiaa Mohamed // Aug 12, 2009 at 2:50 pm

    thank you , your comments help me also.

Leave a Comment