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

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

  1. #1
    Join Date
    Sep 2006
    Location
    London
    Posts
    58

    ORA-01092: ORACLE instance terminated. Disconnection forced

    ORA-01092: ORACLE instance terminated. Disconnection forced

    Hi,

    I will appreciate if you can send me the solution of below problem:


    I try manually to create a database in Oracle 10g on fedora Linux platform.
    And I got the following error message

    My oracle database version is 10.1.0.2.0 and
    kernel is Linux polo 2.6.11-1.1369_FC4smp #1 SMP Thu Jun 2 23:08:39 EDT 2005 i686 i686 i386 GNU/Linux

    I could find out the error messags from the alert_db1.log file as below

    **

    Wed Sep 27 15:12:42 2006
    CREATE UNDO TABLESPACE UNDOTBS2 DATAFILE '/u01/app/oracle/oradata/db1/undotbs2.dbf' SIZE 200M REUSE AUTOEXTEND ON NEXT 5120K MAXSIZE UNLIMITED
    Successfully onlined Undo Tablespace 1.
    Completed: CREATE UNDO TABLESPACE UNDOTBS2 DATAFILE '/u01/ap
    Wed Sep 27 15:12:47 2006
    create tablespace SYSAUX datafile '/u01/app/oracle/oradata/db1/sysaux01.dbf' size 500m reuse AUTOEXTEND ON NEXT 10240K MAXSIZE UNLIMITED
    EXTENT MANAGEMENT LOCAL SEGMENT SPACE MANAGEMENT AUTO online
    Wed Sep 27 15:12:59 2006
    Completed: create tablespace SYSAUX datafile '/u01/app/oracl
    Wed Sep 27 15:12:59 2006
    CREATE TEMPORARY TABLESPACE MKODOTEMP TEMPFILE '/u01/app/oracle/oradata/db1/mkodotemp.dbf' size 200m reuse
    Completed: CREATE TEMPORARY TABLESPACE MKODOTEMP TEMPFILE '/
    Wed Sep 27 15:12:59 2006
    ALTER DATABASE DEFAULT TEMPORARY TABLESPACE MKODOTEMP
    Completed: ALTER DATABASE DEFAULT TEMPORARY TABLESPACE MKODOT
    Wed Sep 27 15:12:59 2006
    Errors in file /u01/app/oracle/admin/db1/udump/db1_ora_13807.trc:
    ORA-00604: error occurred at recursive SQL level 1
    ORA-02236: invalid file name
    Wed Sep 27 15:12:59 2006
    Errors in file /u01/app/oracle/admin/db1/udump/db1_ora_13807.trc:
    ORA-01501: CREATE DATABASE failed
    ORA-01519: error while processing file '?/rdbms/admin/sql.bsq' near line 6183
    ORA-00604: error occurred at recursive SQL level 1
    ORA-02236: invalid file name
    Error 1519 happened during db open, shutting down database
    USER: terminating instance due to error 1519
    Instance terminated by USER, pid = 13807
    ORA-1092 signalled during: CREATE DATABASE db1
    USER SYS IDENTIFIED BY ***US...

    The error message from Trace file is as below


    Wed Sep 27 15:12:42 2006
    CREATE UNDO TABLESPACE UNDOTBS2 DATAFILE '/u01/app/oracle/oradata/db1/undotbs2.dbf' SIZE 200M REUSE AUTOEXTEND ON NEXT 5120K MAXSIZE UNLIMITED
    Successfully onlined Undo Tablespace 1.
    Completed: CREATE UNDO TABLESPACE UNDOTBS2 DATAFILE '/u01/ap
    Wed Sep 27 15:12:47 2006
    create tablespace SYSAUX datafile '/u01/app/oracle/oradata/db1/sysaux01.dbf' size 500m reuse AUTOEXTEND ON NEXT 10240K MAXSIZE UNLIMITED
    EXTENT MANAGEMENT LOCAL SEGMENT SPACE MANAGEMENT AUTO online
    Wed Sep 27 15:12:59 2006
    Completed: create tablespace SYSAUX datafile '/u01/app/oracl
    Wed Sep 27 15:12:59 2006
    CREATE TEMPORARY TABLESPACE MKODOTEMP TEMPFILE '/u01/app/oracle/oradata/db1/mkodotemp.dbf' size 200m reuse
    Completed: CREATE TEMPORARY TABLESPACE MKODOTEMP TEMPFILE '/
    Wed Sep 27 15:12:59 2006
    ALTER DATABASE DEFAULT TEMPORARY TABLESPACE MKODOTEMP
    Completed: ALTER DATABASE DEFAULT TEMPORARY TABLESPACE MKODOT
    Wed Sep 27 15:12:59 2006
    Errors in file /u01/app/oracle/admin/db1/udump/db1_ora_13807.trc:
    ORA-00604: error occurred at recursive SQL level 1
    ORA-02236: invalid file name
    Wed Sep 27 15:12:59 2006
    Errors in file /u01/app/oracle/admin/db1/udump/db1_ora_13807.trc:
    ORA-01501: CREATE DATABASE failed
    ORA-01519: error while processing file '?/rdbms/admin/sql.bsq' near line 6183
    ORA-00604: error occurred at recursive SQL level 1
    ORA-02236: invalid file name
    Error 1519 happened during db open, shutting down database
    USER: terminating instance due to error 1519
    Instance terminated by USER, pid = 13807
    ORA-1092 signalled during: CREATE DATABASE db1
    USER SYS IDENTIFIED BY ***US...

    Many thanks in advance. Awaiting your favorable and quick response.


    Jayesh

  2. #2
    Join Date
    Sep 2002
    Location
    England
    Posts
    7,334
    oerr ora 2236
    02236, 00000, "invalid file name"
    // *Cause: A character string literal was not used in the filename list
    // of a LOGFILE, DATAFILE, or RENAME clause.
    // *Action: Use correct syntax.

  3. #3
    Join Date
    Sep 2006
    Location
    London
    Posts
    58
    Hi,

    Thanks for your hint. I've specified the datafile clause along with default tablepsace tablepsacename. The issue is resolved.

    Jayesh

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