Re: Create a new Table Space on a Linux Server causing errors (ORA-01119 , ORA-27037)

Home -> Community -> Usenet -> c.d.o.server -> Re: Create a new Table Space on a Linux Server causing errors (ORA-01119 , ORA-27037)

From: Anton Buijs <remove_aammbuijs_at_xs4all.nl>
Date: Sun, 27 Apr 2003 10:50:47 +0200
Message-ID: <3eab99ef$0$49107$e4fe514c@news.xs4all.nl>

LJA <lou.ascoli_at_attws.com> schreef in berichtnieuws 40a3ec87.0304261546.1560ee41_at_posting.google.com... | "Sybrand Bakker" <postbus_at_sybrandb.demon.nl> wrote in message news:<valhl9d1rspmc0_at_corp.supernews.com>...
| > "LJA" <lou.ascoli_at_attws.com> wrote in message
| > news:40a3ec87.0304260850.e18f814_at_posting.google.com...
| > > I am trying to create a new Tablespace (8i) , on a Linux server using
| > > Redhat , and I continue receive two errors. Any suggestion are
| > > welcomed. Thank you.
| > >
| > > SQL> create tablespace RTESVR
| > > 2 DATAFILE '/u01/app/oracle/oradata/SSDB/rtesvr01.dbf'
| > > 3 default storage(initial 1M NEXT 1M MINEXTENTS 1 MAXEXTENTS 100
| > > PCTINCREASE 1)
| > > 4 online
| > > 5 permanent
| > > 6 logging
| > > 7 ;
| > > create tablespace RTESVR
| > > *
| > > ERROR at line 1:
| > > ORA-01119: error in creating database file
| > > '/u01/app/oracle/oradata/SSDB/rtesvr01.dbf'
| > > ORA-27037: unable to obtain file status
| > > Linux Error: 2: No such file or directory
| > > Additional information: 3

| >
| >

| > Read the O/S error: No such file or directory.
| > Now check whether the directory exists.
| > Please try to avoid posting every individual error rightaway

|
|
| The directory does exist
|
| /u01/app/oracle/oradata/SSDB/

And does the oracle account has the proper permissions on the directory and files in it?
Do you use disk quotas that are not exceeded? Maybe you hit the limit of max open files (a kernel parameter)? Received on Sun Apr 27 2003 - 03:50:47 CDT