Home » RDBMS Server » Server Administration » ORA-01092: ORACLE instance terminated. Disconnection forced
ORA-01092: ORACLE instance terminated. Disconnection forced [message #195765] Mon, 02 October 2006 04:34 Go to next message
jaydba
Messages: 86
Registered: September 2006
Location: UK
Member

Hi,

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
Re: ORA-01092: ORACLE instance terminated. Disconnection forced [message #195781 is a reply to message #195765] Mon, 02 October 2006 06:29 Go to previous messageGo to next message
Mahesh Rajendran
Messages: 10672
Registered: March 2002
Location: oracleDocoVille
Senior Member
Account Moderator
This might be your case.
http://www.orafaq.com/forum/m/190729/42800/?srch=DB_CREATE_FILE_DEST#msg_190729

Please search the forum before posting.
Re: ORA-01092: ORACLE instance terminated. Disconnection forced [message #196005 is a reply to message #195765] Tue, 03 October 2006 11:24 Go to previous message
jaydba
Messages: 86
Registered: September 2006
Location: UK
Member

Hi,

Thanks for your help. I've specified the datafile clause along with default tablepsace tablepsacename as mentioned by you. The issue is resolved.

Jayesh
Previous Topic: availability of oracle CPU patch for 3rd quarter 2006
Next Topic: when resizing SQL database i get error ORA-03113
Goto Forum:
  


Current Time: Sat Dec 10 22:25:17 CST 2016

Total time taken to generate the page: 0.21581 seconds