-
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
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
Click Here to Expand Forum to Full Width
|