Path: news.easynews.com!newsfeed1.easynews.com!easynews.com!easynews!newsfeed.news2me.com!news2.euro.net!lnewspeer01.lnd.ops.eu.uu.net!emea.uu.net!newsfeed1.sbs.de!news.mch.sbs.de!not-for-mail
From: Shravana Kumar <kumar.shravana@blr.spcnl.co.in>
Newsgroups: comp.databases.oracle.server
Subject: ORA-01092: ORACLE instance terminated. Disconnection forced
Date: Fri, 13 Dec 2002 10:15:13 +0530
Organization: Siemens Business Services
Lines: 48
Message-ID: <3DF965D9.57D09E74@blr.spcnl.co.in>
NNTP-Posting-Host: 132.186.66.128
Mime-Version: 1.0
Content-Type: text/plain; charset=us-ascii
Content-Transfer-Encoding: 7bit
X-Trace: news.mch.sbs.de 1039753757 4133 132.186.66.128 (13 Dec 2002 04:29:17 GMT)
X-Complaints-To: abuse@siemens.de
NNTP-Posting-Date: Fri, 13 Dec 2002 04:29:17 +0000 (UTC)
X-Mailer: Mozilla 4.72 [en] (WinNT; I)
X-Accept-Language: en
Xref: newsfeed1.easynews.com comp.databases.oracle.server:169563
X-Received-Date: Thu, 12 Dec 2002 21:28:52 MST (news.easynews.com)

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.