<color><param>0100,0100,0100</param>Opps . . . .

I think I resent my origional message to the list by accident when I

was trying to form this reply. If I did, sorry.

I did a bunch of testing and found that I could resize a db files

up to a maximum size of 1582940k. Up to that point I can resize the db file with no problem. Any attempt to resize a file past this point resulted in the error. Oracle 7.3 has a 2gb file limit so this didn't seem to be an oracle error. By just coping files I was able to create a file over 4gb in size, so the problem didn't seem to be a netapp/nfs problem.

I decided to change some mount options. THe first things I tried was running nfs over tcp (I had been using udp). IT WORKED! After making the change I was able to resize the db file right up to Oracle's 2gb limit.

I don't know what's different between nfs over tcp and over udp, but it's working now!

Rick

</color>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

<color><param>0100,0100,0100</param>

<nofill> ---------------------------------------------------------------------- Richard L. Rhodes e: rhodesr@firstenergycorp.com Ohio Edison Co. p: 330-384-4904 f: 330-384-2514