Cause: The instance connected to was terminated abnormally, probably due to a SHUTDOWN ABORT. The current process was forced to disconnect from the instance.
Action: Examine the alert log for more details. Contact the database administrator to determine when the instance is restarted. Attempt to reconnect after the instance is running again
The ORA-01092: ORACLE instance terminated Disconnection forced. is a generic error when Oracle detects a serious problem at database start time.
The ORA-01092: ORACLE instance terminated error can be caused by many factors:
- A shutdown abort
- Bad permissions of BDUMP, CDUMP or UDUMP directories
- Missing datafiles
- Renaming files when Oracle is down
- and many other OS-related causes
[oracle@oracle10g ~]$ oerr ora 01092
01092, 00000, "ORACLE instance terminated. Disconnection forced"
// *Cause: The instance this process was connected to was terminated
// abnormally, probably via a shutdown abort. This process
// was forced to disconnect from the instance.
// *Action: Examine the alert log for more details. When the instance has been
// restarted, retry action.
Example:
While creating database manually i got an error
sql>create database ora11g;
ORA-01092: ORACLE instance terminated. Disconnected forced