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

>>>>> "LJA" == LJA <lou.ascoli_at_attws.com> writes:

 LJA> "Sybrand Bakker" <postbus_at_sybrandb.demon.nl> wrote in message  LJA> 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 autoextend on > 4
>> default storage(initial 10240 next 10240 minextents 1 maxextents >
>> 2147483645 pctincrease 50) > 5 online > 6 permanent > 7 logging >
>> 8 ; > 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
>> >
>> >
>> > Alternate size settings
>> >
>> >
>> >
>> > 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

 LJA> The directory does exist

 LJA> /u01/app/oracle/oradata/SSDB/

What are the permissions on the directory? Can Oracle read/write to it?

-- 
Tim Cross
The e-mail address on this message is FALSE (obviously!). My real e-mail is
to a company in Australia called rapttech and my login is tcross - if you 
really need to send mail, you should be able to work it out!