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.