Re: Cannot add data file!?

On Tue, 31 Aug 1999 07:46:47 -0400, Jack Zhu <jackzhu_at_monmouth.com> wrote:

>Linux 8.0.5 on Red Hat Linux 6.0.
>
>When I try to add a datafile in 'svrmgrl', I issue:
>
>alter tablespace <tablespace name> add datafile '<file name>';
>
>The error message is:
>
>ORA-01119: error in creating database file '<file name>'
>ORA-27037: unable to obtain file status
>Linux error: 2 No such file or directory
>Additional information: 3
>

--- snip

Hi Jack,

check the directory persmissions. The owner of the oracle binaries or the group must have permission to create a file in this directory and there must be enough space. If one of the conditions is false, you will receive the error message above.

You can check it when you login as owner of the software and touch the file.
Assume the filename is '/u01/oradata/SID/tblsp003.dbf' and your software is installed as swowner, try
# su - swowner
# touch /u01/oradata/SID/tblsp003.dbf
the errormessage from linux might be:
touch: /u01/oradata/SID/tblsp003.dbf: Permission denied and with
# df /u01/oradata/SID/
you can check the available space.

if you don't receive an error message and the space is enough # svrmgrl <<!
  connect internal
  alter tablespace tblsp
    add datafile '/u01/oradata/SID/tblsp003.dbf' size 123M;   exit
!
should work correctly.

if the file already exists try "add datafile ... 123M reuse;"

__
Fred Stojentin Received on Wed Sep 01 1999 - 03:18:58 CDT