ORA-01092: ORACLE instance terminated. Disconnection forced
536473Oct 2 2006 — edited Oct 2 2006Hi,
I will appreciate if you can send me the solution of below problem:
I try manually to create a database in Oracle 10g on fedora Linux platform.
And I got the following error message
My oracle database version is 10.1.0.2.0 and
kernel is Linux polo 2.6.11-1.1369_FC4smp #1 SMP Thu Jun 2 23:08:39 EDT 2005 i686 i686 i386 GNU/Linux
I could find out the error messags from the alert_db1.log file as below
**
Wed Sep 27 15:12:42 2006
CREATE UNDO TABLESPACE UNDOTBS2 DATAFILE '/u01/app/oracle/oradata/db1/undotbs2.dbf' SIZE 200M REUSE AUTOEXTEND ON NEXT 5120K MAXSIZE UNLIMITED
Successfully onlined Undo Tablespace 1.
Completed: CREATE UNDO TABLESPACE UNDOTBS2 DATAFILE '/u01/ap
Wed Sep 27 15:12:47 2006
create tablespace SYSAUX datafile '/u01/app/oracle/oradata/db1/sysaux01.dbf' size 500m reuse AUTOEXTEND ON NEXT 10240K MAXSIZE UNLIMITED
EXTENT MANAGEMENT LOCAL SEGMENT SPACE MANAGEMENT AUTO online
Wed Sep 27 15:12:59 2006
Completed: create tablespace SYSAUX datafile '/u01/app/oracl
Wed Sep 27 15:12:59 2006
CREATE TEMPORARY TABLESPACE MKODOTEMP TEMPFILE '/u01/app/oracle/oradata/db1/mkodotemp.dbf' size 200m reuse
Completed: CREATE TEMPORARY TABLESPACE MKODOTEMP TEMPFILE '/
Wed Sep 27 15:12:59 2006
ALTER DATABASE DEFAULT TEMPORARY TABLESPACE MKODOTEMP
Completed: ALTER DATABASE DEFAULT TEMPORARY TABLESPACE MKODOT
Wed Sep 27 15:12:59 2006
Errors in file /u01/app/oracle/admin/db1/udump/db1_ora_13807.trc:
ORA-00604: error occurred at recursive SQL level 1
ORA-02236: invalid file name
Wed Sep 27 15:12:59 2006
Errors in file /u01/app/oracle/admin/db1/udump/db1_ora_13807.trc:
ORA-01501: CREATE DATABASE failed
ORA-01519: error while processing file '?/rdbms/admin/sql.bsq' near line 6183
ORA-00604: error occurred at recursive SQL level 1
ORA-02236: invalid file name
Error 1519 happened during db open, shutting down database
USER: terminating instance due to error 1519
Instance terminated by USER, pid = 13807
ORA-1092 signalled during: CREATE DATABASE db1
USER SYS IDENTIFIED BY ***US...
The error message from Trace file is as below
Wed Sep 27 15:12:42 2006
CREATE UNDO TABLESPACE UNDOTBS2 DATAFILE '/u01/app/oracle/oradata/db1/undotbs2.dbf' SIZE 200M REUSE AUTOEXTEND ON NEXT 5120K MAXSIZE UNLIMITED
Successfully onlined Undo Tablespace 1.
Completed: CREATE UNDO TABLESPACE UNDOTBS2 DATAFILE '/u01/ap
Wed Sep 27 15:12:47 2006
create tablespace SYSAUX datafile '/u01/app/oracle/oradata/db1/sysaux01.dbf' size 500m reuse AUTOEXTEND ON NEXT 10240K MAXSIZE UNLIMITED
EXTENT MANAGEMENT LOCAL SEGMENT SPACE MANAGEMENT AUTO online
Wed Sep 27 15:12:59 2006
Completed: create tablespace SYSAUX datafile '/u01/app/oracl
Wed Sep 27 15:12:59 2006
CREATE TEMPORARY TABLESPACE MKODOTEMP TEMPFILE '/u01/app/oracle/oradata/db1/mkodotemp.dbf' size 200m reuse
Completed: CREATE TEMPORARY TABLESPACE MKODOTEMP TEMPFILE '/
Wed Sep 27 15:12:59 2006
ALTER DATABASE DEFAULT TEMPORARY TABLESPACE MKODOTEMP
Completed: ALTER DATABASE DEFAULT TEMPORARY TABLESPACE MKODOT
Wed Sep 27 15:12:59 2006
Errors in file /u01/app/oracle/admin/db1/udump/db1_ora_13807.trc:
ORA-00604: error occurred at recursive SQL level 1
ORA-02236: invalid file name
Wed Sep 27 15:12:59 2006
Errors in file /u01/app/oracle/admin/db1/udump/db1_ora_13807.trc:
ORA-01501: CREATE DATABASE failed
ORA-01519: error while processing file '?/rdbms/admin/sql.bsq' near line 6183
ORA-00604: error occurred at recursive SQL level 1
ORA-02236: invalid file name
Error 1519 happened during db open, shutting down database
USER: terminating instance due to error 1519
Instance terminated by USER, pid = 13807
ORA-1092 signalled during: CREATE DATABASE db1
USER SYS IDENTIFIED BY ***US...
Many thanks in advance. Awaiting your favorable and quick response.
Jayesh