Re: Oracle 6 tablespace problem

The directory is owned by oracle, and has rw for both owner and group.

Guy.

On Fri, 27 Sep 2002 23:58:41 +0100, "David Sharples" <david.sharples3_at_ntlworld.com> wrote:

>does that directory have group write on that directory (as opposed to just
>owner write)
><gquesnel_at_magma.ca> wrote in message news:3d94d12a.450217_at_news.magma.ca...
>> I am hopping that someone who encounterred this problem, a long time
>> ago would remember how they went about fixing it ...
>>
>> Unix version : SunOS scotty 4.1.4 3 sun4c
>> Oracle version : ORACLE RDBMS V6.0.33.1.1 - Production
>>
>> I am trying to create a tablespace but encountering privilege problems
>> I have an osuser who belongs to dba group in the unix environment.
>> ... using sqldba.
>>
>> SQLDBA> connect internal
>> Connected.
>> SQLDBA> create tablespace guy datafile '/b/ora/dbs/guy.dbf' size 1M;
>> ORA-00604: error occurred at recursive SQL level 1
>> ORA-01116: error in opening database file
>> '/b/ora/dbs/E70_emul_space_20.dat'
>> ORA-07368: sfofi: open error, unable to open database file.
>> SunOS Error: 13: Permission denied
>>
>>
>> If the osuser is oracle , it works fine. -
>>
>> Also if we open up the security on the directory (777),
>> the tablespace will get created, but the owner (and privileges) will
>> be those of the OSUSER who called up SQLDBA (vs oracle).
>>
>> Is there a flag in Oracle 6, or does this sound like a program
>> corruption ?
>>
>> I'd appreciate any hints or clues.
>> Tia
>> Guy Quesnel
>
>
Received on Fri Sep 27 2002 - 18:23:53 CDT