Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: ORA-01092: ORACLE instance terminated. Disconnection forced
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