ORA-01092: ORACLE instance terminated. Disconnection forced

From: Shravana Kumar <kumar.shravana_at_blr.spcnl.co.in>
Date: Fri, 13 Dec 2002 10:15:13 +0530
Message-ID: <3DF965D9.57D09E74@blr.spcnl.co.in>

Hello All,

I am trying to create a sample database and I get the following error. Can any one shed light on this problem?

we are using oracle 9.0.1 on solaris 8.

SQL> /
create database SAMPLE
*
ERROR at line 1:
ORA-01092: ORACLE instance terminated. Disconnection forced

The create database statement goes like this...........

create database SAMPLE
MAXINSTANCES 1
MAXLOGHISTORY 1
MAXLOGFILES 5
MAXLOGMEMBERS 5
MAXDATAFILES 100
DATAFILE '/export/home/oracle/dev/SAMPLE/system01.dbf' SIZE 325M REUSE UNDO TABLESPACE undotbs DATAFILE
'/export/home/oracle/dev/SAMPLE/undotbs01.dbf' SIZE 200M REUSE AUTOEXTEND ON NEXT 5120K MAXSIZE UNLIMITED DEFAULT TEMPORARY TABLESPACE tabts1
CHARACTER SET US7ASCII
LOGFILE GROUP 1 ('/export/home/oracle/dev/SAMPLE/redo01.log') SIZE 100M,

GROUP 2 ('/export/home/oracle/dev/SAMPLE/redo02.log') SIZE 100M, GROUP 3 ('/export/home/oracle/dev/SAMPLE/redo03.log') SIZE 100M

Note : The REMOTE_LOGIN_PASSWORD is commented in initSAMPLE.ora file as followins.

# Distributed, Replication and Snapshot
DB_DOMAIN=hlri.oracle.com
#REMOTE_LOGIN_PASSWORDFILE=NONE Thanks a lot,

Best Regards,
ShravanaKumar. Received on Thu Dec 12 2002 - 22:45:13 CST