My Oracle Support Banner

ORA-1092 Instance Terminated When Creating A Database Via DBCA (Doc ID 159324.1)

Last updated on APRIL 20, 2023

Applies to:

Oracle Database Configuration Assistant - Version and later
Oracle Database - Enterprise Edition - Version and later
Information in this document applies to any platform.


Problem Description

While creating a database with the Oracle Database Configuration
Assistant (DBCA), it fails with the following message:

  ORA-1092: oracle instance terminated.  Disconnection forced.

Reviewing the alert.log for the database, you find the following

    ORA-00379: no free buffers available in buffer pool 
               DEFAULT for block size 8K
    Thu Sep 20 07:01:46 2001
    Error 379 happened during db open, shutting down database
    USER: terminating instance due to error 379
    Instance terminated by USER, pid = 15683
    ORA-1092 signalled during: alter database XBMS open resetlogs...

 NOTE:  If the ORACLE_BASE environment variable is set, then
        the alert.log will be in $ORACLE_BASE/admin/<SID>/bdump.
        If not set, look in $ORACLE_HOME/admin/<SID>/bdump or
        wherever you changed the BACKGROUND_DUMP_DEST database
        initialization parameter.
        For Oracle 11g, please refer to
        Note 438148.1 - Finding alert.log file in 11g


To view full details, sign in with your My Oracle Support account.

Don't have a My Oracle Support account? Click to get started!

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.