+ Reply to Thread
Results 1 to 6 of 6

Undo tablespace error while creating a database

  1. Undo tablespace error while creating a database

    I got this error while creating the database. The Part from alert log
    file is given.


    Errors in file /disk1/test/smoradata/udump/smalldb_ora_6080.trc:

    ORA-00604: error occurred at recursive SQL level 1

    ORA-30012: undo tablespace 'UNDOTSSMDB' does not exist or of wrong
    type

    Mon Jul 16 16:23:33 2007

    Errors in file /disk1/test/smoradata/udump/smalldb_ora_6080.trc:

    ORA-01501: CREATE DATABASE failed

    ORA-01519: error while processing file '?/rdbms/admin/sql.bsq' near
    line 5792

    ORA-00604: error occurred at recursive SQL level 1

    ORA-30012: undo tablespace 'UNDOTSSMDB' does not exist or of wrong
    type

    Error 1519 happened during db open, shutting down database

    USER: terminating instance due to error 1519

    Mon Jul 16 16:23:34 2007

    Instance terminated by USER, pid = 6080

    ORA-1092 signalled during: create database smalldb

    default temporary tablespace TEMPSMDB...


  2. Re: Undo tablespace error while creating a database

    muzu1232005@gmail.com wrote:
    > I got this error while creating the database. The Part from alert log
    > file is given.
    >
    >
    > Errors in file /disk1/test/smoradata/udump/smalldb_ora_6080.trc:
    >
    > ORA-00604: error occurred at recursive SQL level 1
    >
    > ORA-30012: undo tablespace 'UNDOTSSMDB' does not exist or of wrong
    > type
    >
    > Mon Jul 16 16:23:33 2007
    >
    > Errors in file /disk1/test/smoradata/udump/smalldb_ora_6080.trc:
    >
    > ORA-01501: CREATE DATABASE failed
    >
    > ORA-01519: error while processing file '?/rdbms/admin/sql.bsq' near
    > line 5792
    >
    > ORA-00604: error occurred at recursive SQL level 1
    >
    > ORA-30012: undo tablespace 'UNDOTSSMDB' does not exist or of wrong
    > type
    >
    > Error 1519 happened during db open, shutting down database
    >
    > USER: terminating instance due to error 1519
    >
    > Mon Jul 16 16:23:34 2007
    >
    > Instance terminated by USER, pid = 6080
    >
    > ORA-1092 signalled during: create database smalldb
    >
    > default temporary tablespace TEMPSMDB...
    >


    How are you creating your database? With DBCA or manually?

    It looks like the CREATE DATABASE statement, with all of its options, is
    not defined correctly. Without seeing the actual statement, it could be
    difficult to diagnose the problem.

    HTH,
    Brian

    --
    ===================================================================

    Brian Peasland
    dba@nospam.peasland.net
    http://www.peasland.net

    Remove the "nospam." from the email address to email me.


    "I can give it to you cheap, quick, and good.
    Now pick two out of the three" - Unknown

    --
    Posted via a free Usenet account from http://www.teranews.com


  3. Re: Undo tablespace error while creating a database


    a écrit dans le message de news: 1184661488.240532.317060@e9g2000prf.googlegroups.com...
    |I got this error while creating the database. The Part from alert log
    | file is given.
    |
    |
    | Errors in file /disk1/test/smoradata/udump/smalldb_ora_6080.trc:
    |
    | ORA-00604: error occurred at recursive SQL level 1
    |
    | ORA-30012: undo tablespace 'UNDOTSSMDB' does not exist or of wrong
    | type
    |
    | Mon Jul 16 16:23:33 2007
    |
    | Errors in file /disk1/test/smoradata/udump/smalldb_ora_6080.trc:
    |
    | ORA-01501: CREATE DATABASE failed
    |
    | ORA-01519: error while processing file '?/rdbms/admin/sql.bsq' near
    | line 5792
    |
    | ORA-00604: error occurred at recursive SQL level 1
    |
    | ORA-30012: undo tablespace 'UNDOTSSMDB' does not exist or of wrong
    | type
    |
    | Error 1519 happened during db open, shutting down database
    |
    | USER: terminating instance due to error 1519
    |
    | Mon Jul 16 16:23:34 2007
    |
    | Instance terminated by USER, pid = 6080
    |
    | ORA-1092 signalled during: create database smalldb
    |
    | default temporary tablespace TEMPSMDB...
    |

    The tablespace you gave in the "undo_tablespace" parameter
    of your configuration file is not the undo tablespace you gave
    in the "create database" statement.

    Regards
    Michel Cadot



  4. Re: Undo tablespace error while creating a database

    On Jul 17, 10:38 am, muzu1232...@gmail.com wrote:
    > I got this error while creating the database. The Part from alert log
    > file is given.
    >
    > Errors in file /disk1/test/smoradata/udump/smalldb_ora_6080.trc:
    >
    > ORA-00604: error occurred at recursive SQL level 1
    >
    > ORA-30012: undo tablespace 'UNDOTSSMDB' does not exist or of wrong
    > type
    >
    > Mon Jul 16 16:23:33 2007
    >
    > Errors in file /disk1/test/smoradata/udump/smalldb_ora_6080.trc:
    >
    > ORA-01501: CREATE DATABASE failed
    >
    > ORA-01519: error while processing file '?/rdbms/admin/sql.bsq' near
    > line 5792
    >
    > ORA-00604: error occurred at recursive SQL level 1
    >
    > ORA-30012: undo tablespace 'UNDOTSSMDB' does not exist or of wrong
    > type
    >
    > Error 1519 happened during db open, shutting down database
    >
    > USER: terminating instance due to error 1519
    >
    > Mon Jul 16 16:23:34 2007
    >
    > Instance terminated by USER, pid = 6080
    >
    > ORA-1092 signalled during: create database smalldb
    >
    > default temporary tablespace TEMPSMDB...


    I don't see any database version, and, more importantly, I don't see
    the CREATE DATABASE statement (which should be in the alert log).
    Likely, the undo tablespace clause of your create database is
    incorrect, but as you jumped to this group without even looking, no
    one here can see it either.

    --
    Sybrand Bakker
    Senior Oracle DBA


  5. Re: Undo tablespace error while creating a database

    muzu1232005@gmail.com wrote:
    > I got this error while creating the database. The Part from alert log
    > file is given.
    >
    >
    > Errors in file /disk1/test/smoradata/udump/smalldb_ora_6080.trc:
    >
    > ORA-00604: error occurred at recursive SQL level 1
    >
    > ORA-30012: undo tablespace 'UNDOTSSMDB' does not exist or of wrong
    > type
    >
    > Mon Jul 16 16:23:33 2007
    >
    > Errors in file /disk1/test/smoradata/udump/smalldb_ora_6080.trc:
    >
    > ORA-01501: CREATE DATABASE failed
    >
    > ORA-01519: error while processing file '?/rdbms/admin/sql.bsq' near
    > line 5792
    >
    > ORA-00604: error occurred at recursive SQL level 1
    >
    > ORA-30012: undo tablespace 'UNDOTSSMDB' does not exist or of wrong
    > type
    >
    > Error 1519 happened during db open, shutting down database
    >
    > USER: terminating instance due to error 1519
    >
    > Mon Jul 16 16:23:34 2007
    >
    > Instance terminated by USER, pid = 6080
    >
    > ORA-1092 signalled during: create database smalldb
    >
    > default temporary tablespace TEMPSMDB...


    Where did "UNDOTSSMDB" come from? Certainly not from Oracle.
    --
    Daniel A. Morgan
    University of Washington
    damorgan@x.washington.edu (replace x with u to respond)
    Puget Sound Oracle Users Group
    www.psoug.org

  6. Re: Undo tablespace error while creating a database

    On Jul 17, 4:38 am, muzu1232...@gmail.com wrote:
    > I got this error while creating the database. The Part from alert log
    > file is given.
    >
    > Errors in file /disk1/test/smoradata/udump/smalldb_ora_6080.trc:
    >
    > ORA-00604: error occurred at recursive SQL level 1
    >
    > ORA-30012: undo tablespace 'UNDOTSSMDB' does not exist or of wrong
    > type
    >
    > Mon Jul 16 16:23:33 2007
    >
    > Errors in file /disk1/test/smoradata/udump/smalldb_ora_6080.trc:
    >
    > ORA-01501: CREATE DATABASE failed
    >
    > ORA-01519: error while processing file '?/rdbms/admin/sql.bsq' near
    > line 5792
    >
    > ORA-00604: error occurred at recursive SQL level 1
    >
    > ORA-30012: undo tablespace 'UNDOTSSMDB' does not exist or of wrong
    > type
    >
    > Error 1519 happened during db open, shutting down database
    >
    > USER: terminating instance due to error 1519
    >
    > Mon Jul 16 16:23:34 2007
    >
    > Instance terminated by USER, pid = 6080
    >
    > ORA-1092 signalled during: create database smalldb
    >
    > default temporary tablespace TEMPSMDB..


    post your init.ora settings and create database script.


+ Reply to Thread