[Ocfs2-users] OCFS2 and util_file
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 Information Technology The State University of New York State University Plaza - Albany, New York 12246 Tel: 518.320.1213 Fax: 518.320.1550 eMail: nancy.m...@suny.edu Be a part of Generation SUNY: Facebook http://www.facebook.com/generationsuny - Twitter http://www.twitter.com/generationsuny - YouTube http://www.youtube.com/generationsuny image001.gif___ Ocfs2-users mailing list Ocfs2-users@oss.oracle.com https://oss.oracle.com/mailman/listinfo/ocfs2-users
Re: [Ocfs2-users] OCFS2 and util_file
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 wrote: 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 ** ** [image: circle] http://www.suny.edu/** *Nancy Maki* *Manager of Database Services* Office of Information Technology The State University of New York State University Plaza - Albany, New York 12246 Tel: 518.320.1213 Fax: 518.320.1550 eMail: nancy.m...@suny.edu *Be a part of Generation SUNY: **Facebook*http://www.facebook.com/generationsuny * - **Twitter* http://www.twitter.com/generationsuny* - **YouTube*http://www.youtube.com/generationsuny ** ** ** ** ___ Ocfs2-users mailing list Ocfs2-users@oss.oracle.com https://oss.oracle.com/mailman/listinfo/ocfs2-users image001.gif___ Ocfs2-users mailing list Ocfs2-users@oss.oracle.com https://oss.oracle.com/mailman/listinfo/ocfs2-users
Re: [Ocfs2-users] OCFS2 and util_file
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 particular volume only and leave it on our database volumes? Thanks, Nancy From: Sunil Mushran [mailto:sunil.mush...@gmail.com] Sent: Thursday, August 23, 2012 1:22 PM To: Maki, Nancy Cc: ocfs2-users@oss.oracle.com Subject: Re: [Ocfs2-users] OCFS2 and util_file 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 wrote: 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 Information Technology The State University of New York State University Plaza - Albany, New York 12246 Tel: 518.320.1213 Fax: 518.320.1550 eMail: nancy.m...@suny.edu Be a part of Generation SUNY: Facebook http://www.facebook.com/generationsuny - Twitter http://www.twitter.com/generationsuny - YouTube http://www.youtube.com/generationsuny ___ Ocfs2-users mailing list Ocfs2-users@oss.oracle.com https://oss.oracle.com/mailman/listinfo/ocfs2-users image001.gif___ Ocfs2-users mailing list Ocfs2-users@oss.oracle.com https://oss.oracle.com/mailman/listinfo/ocfs2-users
Re: [Ocfs2-users] OCFS2 and util_file
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 files. Would it be appropriate to remove the datavolume mount option from this particular volume only and leave it on our database volumes? Yes. datavolume was only meant for db volumes. Other volumes have never needed it. ___ Ocfs2-users mailing list Ocfs2-users@oss.oracle.com https://oss.oracle.com/mailman/listinfo/ocfs2-users