ORA-01092: ORACLE instance terminated. Disconnection forced
DBAsupport.com Forums - Powered by vBulletin
Results 1 to 3 of 3

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

  1. #1
    Join Date
    Jun 2005
    Location
    USA
    Posts
    57

    ORA-01092: ORACLE instance terminated. Disconnection forced

    Hi,


    database : 10.1.0.4
    os AIX 5.2

    SQL> @createdb.sql
    CREATE DATABASE ftpser
    *
    ERROR at line 1:
    ORA-01092: ORACLE instance terminated. Disconnection forced


    errors in ALERTlog file;

    create rollback segment SYSTEM tablespace SYSTEM
    storage (initial 50K next 50K)
    Completed: create rollback segment SYSTEM tablespace SYSTEM

    Wed Dec 21 18:53:42 2005
    CREATE UNDO TABLESPACE UNDOTBS DATAFILE '/u05/oradata/ftpser/undotbs01.dbf' size 2000m
    ORA-30012 signalled during: CREATE UNDO TABLESPACE UNDOTBS DATAFILE '/u05/ora...
    Wed Dec 21 18:55:30 2005
    Errors in file /apps/oracle/admin/ftpser/udump/ftpser_ora_33772.trc:
    ORA-00604: error occurred at recursive SQL level 1
    ORA-30012: undo tablespace 'UNDOTBS1' does not exist or of wrong type
    Wed Dec 21 18:55:30 2005
    Errors in file /apps/oracle/admin/ftpser/udump/ftpser_ora_33772.trc:
    ORA-01501: CREATE DATABASE failed
    ORA-01519: error while processing file '?/rdbms/admin/sql.bsq' near line 5645
    ORA-00604: error occurred at recursive SQL level 1
    ORA-30012: undo tablespace 'UNDOTBS1' does not exist or of wrong type
    Error 1519 happened during db open, shutting down database
    USER: terminating instance due to error 1519
    Instance terminated by USER, pid = 33772
    ORA-1092 signalled during: CREATE DATABASE ftpser
    -- SET STANDBY TO MAXIMIZE...
    Wed Dec 21 19:29:19 2005

    my init.ora file


    undo_management='AUTO'
    undo_retention=10800
    #undo_tablespace='UNDOTBS1'
    utl_file_dir=/u06/wsa/stage
    user_dump_dest='/apps/oracle/admin/ftpser/udump'
    sessions=1200

    I have mistakenly given the undotablespace name diffirent in init file and in the create db script,
    i can able to mount the database but i cannot mount it

    SQL> alter database mount;
    alter database mount
    *
    ERROR at line 1:
    ORA-01079: ORACLE database was not properly created, operation aborted

    /u05/oradata/ftpser>ls -l
    total 4096256
    -rw-r----- 1 oracle dba 2097160192 Dec 21 18:55 undotbs01.dbf

    it has created the undotbs datafile ,

    but it has not created the sysaux tablespace ( since there was no datafile created in the location and there is no clue mentioned in the alert log reg the sysaux )

    now how to come out of this situation,

    how to change the settings now? Any ideas?


    i commented the undo tablespace entry in pfile but it still throws me error cannot mount the database

    please help me in this.
    People with goals know where they are going

  2. #2
    Join Date
    Oct 2000
    Location
    Saskatoon, SK, Canada
    Posts
    3,925
    since this was a fresh install, I'll say start from the scratch. Use the database configuration assistant. Then you won't miss anything

    Sam
    Thanx
    Sam



    Life is a journey, not a destination!


  3. #3
    Join Date
    Jun 2005
    Location
    USA
    Posts
    57
    I removed the created files at the OS level and made the changes in the pfile and ran the create db script it went fine.

    it created the db.

    Thank you so much
    People with goals know where they are going

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