Re: Oracle 9i/Solaris 8/NFS & >4GB datafiles

Der Ubergeek doodled thusly:

>I've installed Oracle 9i on a Sun E250 running solaris 8 (64 bit). It
>mounts via NFS to a Sun SS1000E running solaris 8 (32 bit). There are
>5 (u01..u05) 13GB file systems setup as Raid-5 on an RSM2000 disk
>array.

I'm confused right here. What is the relevance of NFS for this? Are you using NFS file systems (in the 32-bit 10K) in the 64-bit E250 to store your >4Gb data files? If so, are you surprised it doesn't work?

>
>So it seems that largefiles & NFS largefile support aren't the
>problem.

Nope, but IIRC ORACLE recommends strongly against creating its datafiles using NFS volumes. If nothing else, at least the NFS server should be 64-bit OS, no?

>Obviously, I could just change my structure to put a cap at 4095M on
>datafiles. Just as obviously, I could try out DB2 and see if I have
>more manageable problems (the tryout CD is in the mail...).
>

I think you should try out DB2. And make sure you are comparing apples and oranges, ie: make sure you install DB2 EXACTLY the same way you have installed O9i, with the same I/O distribution and same NFS file systems and OS mix. Who knows, it might work. Despite IBM also recommending against putting their datafiles in NFS volumns.

Cheers
Nuno Souto
nsouto_at_optushome.com.au.nospam Received on Sat Dec 08 2001 - 18:54:29 CST