SP2-0310 unable to open file - UNIX for Dummies Questions & Answers

guru_2007 · #1 06-28-2007

Hi ,

We are running Oracle 8.1.7 on HP-UX B.11.00. Recently we have upgraded Oracle from 8.0.6. to 8.1.7. Almost all the shell script we use has the Sqlplus as sqlplus -s @/apps/prod/sql/xxxx.sql > /apps/prod/log/xxxx.out .

However we receive the error
SP2-0310: unable to open file "/apps/prod/sql/xxxx.sql " .

We dont have any problem with sqlplus.

I do not have much knowledge on Unix Shell Script. Could any one help?

jim mcnamara · #2 06-28-2007

SP2-310 is sqlplus complaining about not having permissions to open a file.

In this case, the user running the script has to have execute access to all the directories in the path, (apps prod sql ) and read+execute access to the .sql file

guru_2007 · #3 06-28-2007

Hi ,

Thanks for the reply,
I have given all the permission but still the problem exists. If I do copy and pate the same script on command prompt it works, problem occurs only from Script. Could you suggest some solution to this problem.

Thanks .
Guru.

More UNIX and Linux Forum Topics You Might Find Helpful
Thread	Thread Starter	Forum	Replies	Last Post
Probably an easy SMIT question- "Unable to open temp file"	jeffpas	AIX	6	02-29-2008 03:06 PM
unable to open a .log(4MB) file in vi	venkatramana	SUN Solaris	18	11-29-2007 06:45 AM
Unable to open .sql file	Ananth.p	UNIX for Dummies Questions & Answers	2	10-23-2007 12:56 AM
Unable to open thread	dangral	Post Here to Contact Site Administrators and Moderators	2	04-07-2005 08:31 AM
PCC-F-NOERRFILE, unable to open error message file, facility PR2	asutoshch	UNIX for Advanced & Expert Users	1	03-11-2005 10:59 AM

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode