Re: Oracle SQL error when executing script on OCFS drive

"Tony Barker" <tbarker_at_doit.state.in.us> wrote in message news:86e87f9.0410061146.746c4e7d_at_posting.google.com...
> 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?
>
> 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!!
>

Ditto, clustered file systems are not for things which do not need a resource lock manager
involved. SQL scripts should be in your oracle software homes, which would not be part of
a clustered file system. If you need the script shared, then as the other two said NFS is good. Received on Sat Oct 09 2004 - 12:00:40 CDT