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

Thread: manual create 9i database problem

Threaded View

  1. #1
    Join Date
    Aug 2003
    Posts
    54

    manual create 9i database problem

    Hi all,

    I am on 9.2.0.4 running Linux Rehat Advance Server 2.1 and I tried to create 9i database manually and I have some problem, below is the error I got:

    Created Undo Segment _SYSSMU10$
    ORA-30012 signalled during: CREATE UNDO TABLESPACE UNDOTBS DATAFILE '/u01/ora...
    Tue Sep 16 09:09:49 2003
    Errors in file /home/oracle/admin/test/udump/test_ora_17792.trc:
    ORA-00604: error occurred at recursive SQL level 1
    ORA-30012: undo tablespace 'UNDOTBS1' does not exist or of wrong type
    Tue Sep 16 09:09:49 2003
    Errors in file /home/oracle/admin/test/udump/test_ora_17792.trc:
    ORA-01501: CREATE DATABASE failed
    ORA-01519: error while processing file '?/rdbms/admin/sql.bsq' near line 5166
    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 = 17792
    ORA-1092 signalled during: create database test
    controlfile reuse


    When I looked into ORA-01519, It said "Try the system installation procedure again or contact customer support", Does it mean my o/s and Oracle software is messed up????

    Everything went successful during my installation. DBCA ran successull to create the database

    any thoughts???
    Last edited by candyman; 09-16-2003 at 10:27 AM.

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