ORA-01092: ORACLE instance terminated. Disconnection forced [message #422511] |
Thu, 17 September 2009 00:02 |
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 |
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.
|
|
|
|
|
|