ORA-01092: ORACLE instance terminated. Disconnection forced

[zakriyamhd]

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.

[sambavan]

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

[zakriyamhd]

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