Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Oracle SQL error when executing script on OCFS drive
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!! Received on Wed Oct 06 2004 - 14:46:12 CDT