Wednesday, April 2, 2008


SQL> alter database datafile ' /xxx16/xxxdata/xx1p/apws1p_coredata3s_03.dbf ' resize 4700m;

alter database datafile ' /xxx16/xxxdata/xx1p/apws1p_coredata3s_03.dbf ' resize 4700m


ERROR at line 1:

ORA-01237: cannot extend datafile 69

ORA-01110: data file 69: ' /xxx16/xxxdata/xx1p/apws1p_coredata3s_03.dbf '

The ORA-1110 displays the physical datafile in which Oracle is having a problem accessing.
The ORA-1110 is followed by one or more messages. These messages may be Oracle specific messages or be related to the operating system.

See Metalink :

Doc ID: Note:434013.1

ORA-27059: skgfrsz: could not reduce file size <<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<

HPUX-ia64 Error: 28: No space left on device

Additional information: 2

ORA-19502: write error on file

"' /xxx16/xxxdata/xx1p/apws1p_coredata3s_03.dbf '


ORA-27072: skgfdisp: I/O error

HPUX-ia64 Error: 2: No such file or directory

Additional information: 525825

SQL> ! df -k /xx16/xxdata

/pwssreg16 (/dev/vgpwss1/reg16 ) : 112795648 total allocated Kb

0 free allocated Kb

112795648 used allocated Kb

100 % allocation used



=>ulimit -a
time(seconds)        unlimited
file(blocks)         unlimited
data(kbytes)         1048576
stack(kbytes)        392192
memory(kbytes)       unlimited
coredump(blocks)     4194303

what are the files size limit?

This  should be file(blocks) unlimited.

Probably system re-boot needed.

No comments:

Post a Comment