Re: Oracle 6 tablespace problem

and does group have permission do look at this file ... '/b/ora/dbs/E70_emul_space_20.dat' even though you are trying to create '/b/ora/dbs/guy.dbf'

Dave

<gquesnel_at_magma.ca> wrote in message news:3d94e7ff.6294721_at_news.magma.ca...
> 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:35:04 CDT