Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Oracle SQL error when executing script on OCFS drive

Oracle SQL error when executing script on OCFS drive

From: Tony Barker <tbarker_at_doit.state.in.us>
Date: 6 Oct 2004 12:46:12 -0700
Message-ID: <86e87f9.0410061146.746c4e7d@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!! Received on Wed Oct 06 2004 - 14:46:12 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US