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

Note 203850.1 on Metalink describes this even more extensively.

Peter

"Peter van Rijn" <p.vanrijnREMOVE_at_THISzhew.nl> schreef in bericht news:uvj2sqlakubi4f_at_corp.supernews.com...
> Found the following quote in a thread on Oracle's Metalink from Helen
> Schoone of Oracle:
>
> <quote>
> Hi. The problem is the line:
>
> DEFAULT TEMPORARY TABLESPACE temp
>
> You have not specified a file specification for the tempfile and the
> DB_CREATE_FILE_DEST is not set. From Chapter 3 in the Oracle9i
> Administrators guide under the section titled: Creating Oracle-Managed
> Files -> Creating Tempfiles for Temporary Tablespaces:
>
> "When creating a temporary tablespace the TEMPFILE clause is optional. If
> you include the TEMPFILE clause, then the filename is optional. If the
> TEMPFILE clause or filename is not provided, then the following rules
apply:
>
> If the DB_CREATE_FILE_DEST initialization parameter is specified, then an
> Oracle-managed tempfile is created in the location specified by the
> parameter.
>
> If the DB_CREATE_FILE_DEST initialization parameter is not specified, then
> the statement creating the tempfile fails."
>
> I believe you are following the example in the SQL Reference Manual which
is
> not clear on the requirement for the need to have one of those init.ora
> parameters set in order to use that syntax.
>
> I hope this helps.
>
> Regards,
> Helen
> Oracle Support Services
> </quote>
>
> Hope this helps,
>
> Peter
>
>
> "Shravana Kumar" <kumar.shravana_at_blr.spcnl.co.in> schreef in bericht
> news:3DF98ACF.B3A62E47_at_blr.spcnl.co.in...
> > The following is taken from the alert log.
> >
> > Successfully onlined Undo Tablespace 1.
> > Completed: CREATE UNDO TABLESPACE UNDOTBS DATAFILE '/export/
> > Fri Dec 13 02:09:10 2002
> > Errors in file
> /export/home/oracle/admin/SAMPLE/udump/sample_ora_20412.trc:
> > ORA-00604: error occurred at recursive SQL level 1
> > ORA-02236: invalid file name
> > Fri Dec 13 02:09:10 2002
> > Errors in file
> /export/home/oracle/admin/SAMPLE/udump/sample_ora_20412.trc:
> > ORA-01501: CREATE DATABASE failed
> > ORA-01519: error while processing file '?/rdbms/admin/sql.bsq' near line
> 5298
> > ORA-00604: error occurred at recursive SQL level 1
> > ORA-02236: invalid file name
> > Error 1519 happened during db open, shutting down database
> > USER: terminating instance due to error 1519
> > Fri Dec 13 02:09:10 2002
> > Errors in file
> /export/home/oracle/admin/SAMPLE/bdump/sample_lgwr_20403.trc:
> > ORA-01519: error while processing file '' near line
> > Instance terminated by USER, pid = 20412
> > ORA-1092 signalled during: create database SAMPLE
> >
> > Thanks.
> >
> > Peter van Rijn wrote:
> >
> > > 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 - 01:37:39 CST