Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Re: ORA-01092: ORACLE instance terminated. Disconnection forced

Re: ORA-01092: ORACLE instance terminated. Disconnection forced

From: Peter van Rijn <p.vanrijnREMOVE_at_THISzhew.nl>
Date: Fri, 13 Dec 2002 07:51:43 +0100
Message-ID: <uvj0sbm3rfcpe3@corp.supernews.com>


Any additional error messages in the alert.log?

Peter

"Shravana Kumar" <kumar.shravana_at_blr.spcnl.co.in> schreef in bericht news:3DF965D9.57D09E74_at_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 Fri Dec 13 2002 - 00:51:43 CST

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US