Ok, I'm stumpted!
I've brought an Oracle db (7.3.4.3) up on a RS/6k(aix432)/Netapp(534r2) system. The mounts are using nfs v3 and udp. All has gone really well except when I went to extend the size of some of the db files. When I do this I get the following messages:
SVRMGR> ALTER DATABASE DATAFILE '/oracledata/orac/dbfiles/orac_gis_1.dbf' RESIZE 1600M;
ORA-01237: cannot extend datafile 10 ORA-01110: data file 10: '/oracledata/orac/dbfiles/orac_gis_1.dbf' ORA-09967: sfsfs: unable to resize a file larger
The db runs correctly. Oracle has permissions to, and can, create/delete files in this directory. The netapp filesystem isn't out of space - I can (as oracle) create large files in this dir. Snapshots are not using the space. There's no AIX error message. There's no error message in the Netapp messages file.
In general . . . . I'm stumpted!
Does anyone have any idea of what might be causing this? I highly suspect user error (me) but right now I'm blind as to what I may be doing wrong.
THanks
Rick
---------------------------------------------------------------------- Richard L. Rhodes e: rhodesr@firstenergycorp.com Ohio Edison Co. p: 330-384-4904 f: 330-384-2514
On Sat, 12 Feb 2000, Richard L. Rhodes wrote:
SVRMGR> ALTER DATABASE DATAFILE '/oracledata/orac/dbfiles/orac_gis_1.dbf' RESIZE 1600M; ORA-01237: cannot extend datafile 10 ORA-01110: data file 10: '/oracledata/orac/dbfiles/orac_gis_1.dbf' ORA-09967: sfsfs: unable to resize a file larger
Shot in the dark here, since I'm not familiar with Oracle management functions... is the "1600M" the desired size of the database file, or how much you want to grow the file by? If the latter, would the new file now exceed 2GB?