Re: what is error invalid file name ORA-02236 ?

From: spencer <spencerp_at_swbell.net>
Date: 2000/05/09
Message-ID: <P03S4.248$Rk6.37715@nnrp3.sbc.net>#1/1

remove the comma after the last logfile.

you've got an extra comma at the end of
the line with the fourth logfile. the next line is being interpreted as a datafile name for a fifth log file, which is not what you want.

sometimes it's the simple things...

"James Lee" <Jameslee_at_comsys.com> wrote in message news:39179726.ACBA062F_at_comsys.com...
> I tried to create a database, but got invalid file name error
 ORA-02236.
> Here is the log file:
>
> >ORACLE instance started.
> >Total System Global Area 11901612 bytes
> >Fixed Size 47788 bytes
> >Variable Size 10653696 bytes
> >Database Buffers 1126400 bytes
> >Redo Buffers 73728 bytes
> >datafile 'D:\orant\database\sys1mydb.ora' size 10M reuse
 autoextend on
> >*
> >ORA-02236: invalid file name
> >create tablespace user_data
> >*
> >ORA-01109: database not open
>
> and create_database script used as:
>

---

---

> startup nomount pfile=d:\Orant\DATABASE\initmydb.ora
> -- Create database
> create database mydb
> logfile 'D:\orant\database\log1mydb.ora' size 1M reuse,
> 'D:\orant\database\log2mydb.ora' size 1M reuse,
> 'D:\orant\database\log3mydb.ora' size 1M reuse,
> 'D:\orant\database\log4mydb.ora' size 1M reuse,
> datafile 'D:\orant\database\sys1mydb.ora' size 10M reuse
 autoextend on
> next 10M maxsize 200M character set WE8ISO8859P1;
>
> create tablespace user_data
> datafile 'D:\orant\database\usr1mydb.ora' size 3M reuse
 autoextend on
> next 5M maxsize 150M;
> create tablespace rollback_data
> datafile 'D:\orant\database\rbs1mydb.ora' size 5M reuse
 autoextend on
> next 5M maxsize 150M;
> create tablespace temporary_data
> datafile 'D:\orant\database\tmp1mydb.ora' size 2M reuse
 autoextend on
> next 5M maxsize 150M;
>
> create rollback segment rb_temp storage (initial 100 k next
 250 k); --
> Create additioanal tablespaces ...
> alter rollback segment rb_temp online;
>
> alter user system default tablespace user_data;
>
> create rollback segment rb1 storage(initial 50K next 50K)
> tablespace rollback_data;
> create rollback segment rb2 storage(initial 50K next 50K)
> tablespace rollback_data;
> create rollback segment rb3 storage(initial 50K next 50K)
> tablespace rollback_data;
> create rollback segment rb4 storage(initial 50K next 50K)
> tablespace rollback_data;
>
>

---

*
>
> Thanks for any help!
>
> James
>
>
Received on Tue May 09 2000 - 00:00:00 CDT