Home » RDBMS Server » Server Administration » ORA-01092: ORACLE instance terminated. Disconnection forced (oracle 10g)
ORA-01092: ORACLE instance terminated. Disconnection forced [message #422511] Thu, 17 September 2009 00:02 Go to next message
member.forums@gmail.com
Messages: 28
Registered: June 2009
Location: India
Junior Member
Hi
i try to create a new database in oracle using the following script

CREATE DATABASE CQWB
Maxinstances 1
Maxloghistory 1
Maxlogfiles 10
Maxlogmembers 3
Maxdatafiles 100
sysaux datafile '/db/cqwb/sysaux.dbf'
size 10M
autoextend on
next 10M
maxsize unlimited
Datafile '/db/cqwb/datafile_01.dbf'
size 300M reuse autoextend on next 15M maxsize unlimited
character set WE8MSWIN1252
national character set AL16UTF16
logfile group 1('/db/cqwb/redo_01.log') size 75M,
group 2('/db/cqwb/redo_02.log') size 75M,
group 3('/db/cqwb/redo_03.log') size 75M
default temporary tablespace TEMP
tempfile '/db/cqwb/temp_01.dbf'
extent management local uniform size 1M
undo tablespace UNDO_TS datafile '/db/cqwb/datafile_01.dbf'
size 125M reuse autoextend on next 15M maxsize unlimited;


now I get the error

ORA-01092: ORACLE instance terminated. Disconnection forced

Any help wold be highly appreciated

Sapan
Re: ORA-01092: ORACLE instance terminated. Disconnection forced [message #422515 is a reply to message #422511] Thu, 17 September 2009 00:42 Go to previous messageGo to next message
ayush_anand
Messages: 417
Registered: November 2008
Senior Member
Google man

ORA-01092: ORACLE instance terminated. Disconnection forced
Cause: The instance this process was connected to was terminated abnormally, probably via a shutdown abort. This process was forced to disconnect from the instance.

Action: Examine the alert log for more details. When the instance has been restarted, retry action.
Re: ORA-01092: ORACLE instance terminated. Disconnection forced [message #422517 is a reply to message #422511] Thu, 17 September 2009 01:11 Go to previous messageGo to next message
Michel Cadot
Messages: 68658
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
On CREATE DATABASE this error is most of the time caused by an erroneous parameter in init.ora or an invalid or not accessible directory.
Check alert.log to get the details.

Regards
Michel
Re: ORA-01092: ORACLE instance terminated. Disconnection forced [message #423370 is a reply to message #422511] Wed, 23 September 2009 14:01 Go to previous messageGo to next message
purple73
Messages: 7
Registered: August 2009
Junior Member
Datafile for system and undo tablespaces are same. Change the names as highlighted below and it might work Smile

member.forums@gmail.com wrote on Thu, 17 September 2009 01:02
Hi
i try to create a new database in oracle using the following script

CREATE DATABASE CQWB
Maxinstances 1
Maxloghistory 1
Maxlogfiles 10
Maxlogmembers 3
Maxdatafiles 100
sysaux datafile '/db/cqwb/sysaux.dbf'
size 10M
autoextend on
next 10M
maxsize unlimited
Datafile '/db/cqwb/SYSTEM_datafile_01.dbf'
size 300M reuse autoextend on next 15M maxsize unlimited
character set WE8MSWIN1252
national character set AL16UTF16
logfile group 1('/db/cqwb/redo_01.log') size 75M,
group 2('/db/cqwb/redo_02.log') size 75M,
group 3('/db/cqwb/redo_03.log') size 75M
default temporary tablespace TEMP
tempfile '/db/cqwb/temp_01.dbf'
extent management local uniform size 1M
undo tablespace UNDO_TS datafile '/db/cqwb/UNDO_datafile_01.dbf'
size 125M reuse autoextend on next 15M maxsize unlimited;


now I get the error

ORA-01092: ORACLE instance terminated. Disconnection forced

Any help wold be highly appreciated

Sapan

Re: ORA-01092: ORACLE instance terminated. Disconnection forced [message #423374 is a reply to message #423370] Wed, 23 September 2009 14:34 Go to previous message
Michel Cadot
Messages: 68658
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
Good eyes! Wink

Regards
Michel
Previous Topic: how to perform manual redo log switch
Next Topic: Session Identification
Goto Forum:
  


Current Time: Sun Jun 02 13:09:16 CDT 2024