Re: Oracle SQL error when executing script on OCFS drive

Tony Barker wrote:

> We currently have Oracle RAC running with 3 Dell 6650 servers in a
> Linux Red Hat ES (3.2.3-26) using OCFS version 1.0.11 for its
> clustering software. I seem to be running into a peculiar problem
> when trying to run a script that resides on one of the OCFS mount
> points. When trying to execute a file that contains SQL, (@filename)
> I get the following error "Error 45 initializing SQL*Plus". Now when
> I move the file to a non-OCFS mount and call it from SQLPlus it works
> fine. Is there anything I need to consider when executing scripts
> from OCFS mount points?

You mean apart from the fact that Oracle says 'don't store ordinary files (such as text files which act as SQL scripts) on an OCFS volume?'.

> I thought it may be a Linux security thing, but I have modified the
> security of the files to allow all access and that does not take care
> of the issue. I created some files that just contain one simple SQL
> statement and still get the error. I am also able to run the contents
> of the scripts with SQLPlus with no issues. I would like to keep some
> highly-used, common scripts on the OCFS directories so we can run the
> scripts from any of our clustered machines.
>
> Thanks in advance for your input!!

Don't do it. OCFS is a moving target, so I might be out of date, but the last time I looked, Oracle explicitly sais, we certify/support OCFS for the storage of Control Files, Data Files, Redo Logs and the Oracle installation binaries alone. Not ordinary files which belong elsewhere on a "proper" file system.

Move to using NFS for your SQL Scripts.

Regards
HJR Received on Tue Oct 05 2004 - 14:56:30 CDT