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?
>
> 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!!

To reinforce what Howard said ... don't do it.

And do keep in mind you connect to the instance ... not the database.

-- 
Daniel A. Morgan
University of Washington
damorgan_at_x.washington.edu
(replace 'x' with 'u' to respond)