[Ocfs2-users] OCFS2 and util_file

2012-08-23 Thread Maki, Nancy
We are getting an error ORA-29284 when using utl_file.get_line to read an OCFS2 file of larger than 3896 characters. Has anyone encountered this before? We are at OCFS2 2.6 running on OEL 5.6. Thanks, Nancy http://www.suny.edu/ Nancy Maki Manager of Database Services Office of

Re: [Ocfs2-users] OCFS2 and util_file

2012-08-23 Thread Sunil Mushran
You are probably mounting the volume with the datavolume option. Instead use the init.ora param, filesystemio_options for force odirect and mount the volume without the datavolume option. This is documented in the user's guide. On Thu, Aug 23, 2012 at 8:14 AM, Maki, Nancy nancy.m...@suny.edu

Re: [Ocfs2-users] OCFS2 and util_file

2012-08-23 Thread Maki, Nancy
By default we mount all our OCFS2 volumes with datavolume. To be more specific, the volume that we are having the issue with is not a database volume but a shared drive for developers to read and write other types of files. Would it be appropriate to remove the datavolume mount option from this

Re: [Ocfs2-users] OCFS2 and util_file

2012-08-23 Thread Sunil Mushran
On Thu, Aug 23, 2012 at 10:58 AM, Maki, Nancy nancy.m...@suny.edu wrote: By default we mount all our OCFS2 volumes with datavolume. To be more specific, the volume that we are having the issue with is not a database volume but a shared drive for developers to read and write other types of