DBAsupport.com Forums - Powered by vBulletin
Results 1 to 3 of 3

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

  1. #1
    Join Date
    Apr 2009
    Posts
    6

    ORA-01092: ORACLE instance terminated. Disconnection forced

    Greetings,

    I am having a problem and request any help, thanks in advance.

    I am on 10g, Solaris.

    My create db statement is as follows:
    CREATE DATABASE saidb
    USER SYS IDENTIFIED BY sai_sys
    USER SYSTEM IDENTIFIED BY sai_system
    LOGFILE GROUP 1 ('/u01/oradata/saidb/redo01.log') SIZE 10M,
    GROUP 2 ('/u01/oradata/saidb/redo02.log') SIZE 10M,
    GROUP 3 ('/u01/oradata/saidb/redo03.log') SIZE 10M
    MAXLOGFILES 5
    MAXLOGMEMBERS 5
    MAXLOGHISTORY 1
    MAXDATAFILES 20
    MAXINSTANCES 1
    CHARACTER SET US7ASCII
    NATIONAL CHARACTER SET AL16UTF16
    DATAFILE '/u01/oradata/saidb/system01.dbf' SIZE 20M REUSE
    EXTENT MANAGEMENT LOCAL
    SYSAUX DATAFILE '/u01/oradata/saidb/sysaux01.dbf' SIZE 20M REUSE
    DEFAULT TEMPORARY TABLESPACE tempts1
    TEMPFILE '/u01/oradata/saidb/temp01.dbf'
    SIZE 20M REUSE
    UNDO TABLESPACE undotbs
    DATAFILE '/u01/oradata/saidb/undotbs01.dbf'
    SIZE 20M REUSE AUTOEXTEND ON MAXSIZE UNLIMITED

    Getting the following error when run the create db statement:
    CREATE DATABASE saidb
    *
    ERROR at line 1:
    ORA-01092: ORACLE instance terminated. Disconnection forced

    Getting the following error in the logs:

    Completed: create tablespace SYSTEM datafile '/u01/oradata/saidb/system01.dbf'
    SIZE 20M REUSE
    EXTENT MANAGEMENT LOCAL online
    Thu Apr 16 17:58:47 2009
    create rollback segment SYSTEM tablespace SYSTEM
    storage (initial 50K next 50K)
    Completed: create rollback segment SYSTEM tablespace SYSTEM
    storage (initial 50K next 50K)
    Thu Apr 16 17:58:57 2009
    Errors in file /u01/app/oracle/admin/saidb/udump/saidb_ora_10954.trc:
    ORA-00604: error occurred at recursive SQL level 2
    ORA-00942: table or view does not exist
    Thu Apr 16 17:58:57 2009
    Errors in file /u01/app/oracle/admin/saidb/udump/saidb_ora_10954.trc:
    ORA-01501: CREATE DATABASE failed
    ORA-01519: error while processing file '?/rdbms/admin/sql.bsq' near line 4587
    ORA-00604: error occurred at recursive SQL level 2
    ORA-00942: table or view does not exist
    Error 1519 happened during db open, shutting down database
    USER: terminating instance due to error 1519
    Thu Apr 16 17:58:57 2009
    Instance terminated by USER, pid = 10954
    ORA-1092 signalled during: CREATE DATABASE saidb
    USER SYS IDENTIFIED BY *USER SYSTEM IDENTIFIED BY *LOGFILE GROUP 1 ('/u01/oradat
    a/saidb/redo01.log') SIZE 10M,
    GROUP 2 ('/u01/oradata/saidb/redo02.log') SIZE 10M,
    GROUP 3 ('/u01/oradata/saidb/redo03.log') SIZE 10M


    The actual trace file:

    Dump file /u01/app/oracle/admin/saidb/udump/saidb_ora_10954.trc
    Oracle Database 10g Release 10.2.0.4.0 - Production
    ORACLE_HOME = /u01/app/oracle/product/10.2.0
    System name: SunOS
    Node name: sitetest6
    Release: 5.10
    Version: Generic_138889-05
    Machine: i86pc
    Instance name: saidb
    Redo thread mounted by this instance: 0
    Oracle process number: 13
    Unix process pid: 10954, image: oracle@sitetest6 (TNS V1-V3)

    *** 2009-04-16 17:58:43.504
    *** ACTION NAME:() 2009-04-16 17:58:43.504
    *** MODULE NAME:(sqlplus@sitetest6 (TNS V1-V3)) 2009-04-16 17:58:43.504
    *** SERVICE NAME:() 2009-04-16 17:58:43.503
    *** SESSION ID:(434.1) 2009-04-16 17:58:43.503
    Control file created with size 416 blocks
    *** 2009-04-16 17:58:57.351
    ORA-00604: error occurred at recursive SQL level 2
    ORA-00942: table or view does not exist
    Offending statement at line 4587
    create table user_astatus_map
    ( status# number not null,
    status varchar2(32) not null)
    ORA-01501: CREATE DATABASE failed
    ORA-01519: error while processing file '?/rdbms/admin/sql.bsq' near line 4587
    ORA-00604: error occurred at recursive SQL level 2
    ORA-00942: table or view does not exist
    ~

  2. #2
    Join Date
    Nov 2005
    Location
    USA
    Posts
    32
    If nothing hurts retry after taking out the following statements:

    USER SYS IDENTIFIED BY sai_sys
    USER SYSTEM IDENTIFIED BY sai_system

  3. #3
    Join Date
    Apr 2009
    Posts
    6
    Thanks Sunil.

    For some reason this create statement worked - I think the initial command was running into space issues.

    create database "saidb"
    maxdatafiles 1022
    maxinstances 8
    maxlogfiles 36
    maxlogmembers 3
    maxloghistory 1
    character set UTF8
    national character set UTF8
    datafile '/u01/oradata/saidb/system01.dbf' size 500M
    extent management local
    sysaux datafile '/u01/oradata/saidb/sysaux01.dbf' size 500M
    logfile group 1 '/u03/oradata/saidb/redo01.log' size 10M,
    group 2 '/u03/oradata/saidb/redo02.log' size 10M,
    group 3 '/u03/oradata/saidb/redo03.log' size 10M
    undo tablespace undo_ts
    datafile '/u02/oradata/saidb/undo01.dbf' size 200M
    default temporary tablespace temp
    tempfile '/u01/oradata/saidb/temp01.dbf' size 100M
    extent management local uniform size 1M;

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