Oracle Error 0310
Contents |
SQL TuningSecurityOracle UNIXOracle LinuxMonitoringRemote supportRemote plansRemote servicesApplication Server ApplicationsOracle FormsOracle PortalApp UpgradesSQL ServerOracle ConceptsSoftware SupportRemote Support Development Implementation Consulting StaffConsulting PricesHelp Wanted! Oracle PostersOracle Books Oracle Scripts Ion Excel-DB
Sp2-0310 Unable To Open File Windows
Don Burleson Blog
sp2 0310 unable to open file in shell script SP2-0310 unable to open file tips Oracle Database Tips by Burleson Consulting May 10, sp2-0310: unable to open file: sql developer 2015 Question: I am trying to execute a SQL*plus file, but I am getting the error: sp2-0310 : unable to open file @path /recreate.sqlAnswer: The docs note this on theSp2 0310 Unable To Open File Sql In Windows
SP2-0310 error: Oracle Error : SP2-0310 unable to open file Cause: Unable to open the specified file. Action: Check and make sure the file name is valid.... The SP2-0310 error occurs when you have not fully-qualified the PATH to the file. Rather than rely on a variable, specify the fully-qualified path. SQL> @/u01/app/oracle./scripts/myfile.sql Else, go to the directory where the
Sp2 0310 Unable To Open File Sql In Unix
file exists and then invoke sqlplus. Get the Complete Oracle SQL Tuning Information The landmark book "Advanced Oracle SQL Tuning The Definitive Reference" is filled with valuable information on Oracle SQL Tuning. This book includes scripts and tools to hypercharge Oracle 11g performance and you can buy it for 30% off directly from the publisher. Burleson is the American Team Note: This Oracle documentation was created as a support and Oracle training reference for use by our DBA performance tuning consulting professionals. Feel free to ask questions on our Oracle forum. Verify experience! Anyone considering using the services of an Oracle support expert should independently investigate their credentials and experience, and not rely on advertisements and self-proclaimed expertise. All legitimate Oracle experts publish their Oracle qualifications. Errata? Oracle technology is changing and we strive to update our BC Oracle support information. If you find an error or have a suggestion for improving our content, we would appreciate your feedback. Just e-mail: and include the URL for the page. Burleson Consulting T
#317497] Thu, 01 May 2008 12:18 y2raza Messages: 34Registered: March 2008 Member i have been trying to run the sql script but to no avail each time i try it gives me SP2-0310 error, please help i change directory in sqlplus have tried giving the full path & with @ but to no avail???? thanx
How To Run Sql Script In Sqlplus
in advance Report message to a moderator Re: SP2-0310 error [message #317498 is a reply to message #317497] sp2-0640 not connected Thu, 01 May 2008 12:35 joy_division Messages: 4621Registered: February 2005 Location: East Coast USA Senior Member filename are case sensitive in unix and linux. Report message to a moderator Re: SP2-0310 error http://www.dba-oracle.com/t_sp2_0310_unable_to_open_file.htm [message #317499 is a reply to message #317497] Thu, 01 May 2008 12:36 Michel Cadot Messages: 63911Registered: March 2007 Location: Nanterre, France, http://... Senior MemberAccount Moderator Why don't you tell us the full message? What is SP2-0310? Why don't you post what you tried to do when you got this error? Regards Michel Report message to a moderator Re: SP2-0310 error [message #317501 is a reply to message http://www.orafaq.com/forum/t/101689/ #317497] Thu, 01 May 2008 12:39 Michel Cadot Messages: 63911Registered: March 2007 Location: Nanterre, France, http://... Senior MemberAccount Moderator Found it: Quote:SP2-0310 unable to open file file_name Cause: Unable to open the specified file. Action: Check and make sure the file name is valid. Regards Michel Report message to a moderator Re: SP2-0310 error [message #317504 is a reply to message #317497] Thu, 01 May 2008 13:12 y2raza Messages: 34Registered: March 2008 Member SQL> start awrddrpt.sql SP2-0310: unable to open file "awrddrpt.sql" Report message to a moderator Re: SP2-0310 error [message #317505 is a reply to message #317497] Thu, 01 May 2008 13:25 BlackSwan Messages: 24958Registered: January 2009 Location: SoCal Senior Member SQL> start awrddrpt.sql SQL> ! ls -l awrddrpt.sql if the file does not exist in current directory or permissions are not correct, then you'll get this error. CUT & PASTE can be your friend, but only when you actually use them [oracle@amo01dn sql]$ ls -l time.sql -rw-r--r-- 1 oracle oinstall 59 Apr 14 17:53 time.sql [oracle@amo01dn sql]$ sqlplus SQL*Plus: Release 10.2.0.1.0 - Production on Thu May 1 11:27:39 2008 Copyright (c) 1982, 2005, Oracle. All rights reserved. Enter user-name: / as sysdba Connected to: Oracle Database 10g Enterprise Edition Release 10.2.0.1
Unable to open file If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start http://www.dbasupport.com/forums/showthread.php?14270-SP2-0310-Unable-to-open-file viewing messages, select the forum that you want to visit from the selection below. Results 1 to 4 of 4 Thread: SP2-0310 Unable to open file Tweet Thread Tools Show Printable Version Email this Page… Subscribe to http://www.unix.com/unix-for-dummies-questions-and-answers/39240-sp2-0310-unable-open-file.html this Thread… Display Linear Mode Switch to Hybrid Mode Switch to Threaded Mode 08-07-2001,04:16 PM #1 richardana View Profile View Forum Posts Junior Member Join Date Jul 2001 Posts 45 Hi all, I find a script that I unable to have copied and saved on the notepad as all files with extension .sql. (REPORT.sql) when running the script on the sqlplus, i was getting the following error. SQL> @report.sql SP2-0310: Unable to open file "report.sql" Can someone tell me what that error is about? and how to go by correcting it? Thanks Richard Reply With Quote 08-07-2001,04:20 PM #2 jrpm View Profile View Forum Posts Senior Member Join Date Apr 2001 Location Louisville KY Posts unable to open 295 You might check for a 'report.sql.txt'. I have had that happen a couple of times. Joseph R.P. Maloney, CSP,CDP,CCP 'The answer is 42' Reply With Quote 08-07-2001,04:43 PM #3 santoshym View Profile View Forum Posts Advisor Join Date Mar 2001 Posts 635 Hi Richard, Make sure you have save ur file in ORACLE_HOME/bin directory becuase by default it looks into this directory for the file you might have saved it in a differnt directory Regards, Santosh Reply With Quote 08-07-2001,05:02 PM #4 hemanr View Profile View Forum Posts Senior Member Join Date May 2001 Location Atlanta US Posts 262 Search for the location of the file. It may be in the Oracle Bin directory. Then c:> sta (full path)\report.sql or else copy the file to the c:> then C:> sta report.sql (or @report.sql) If you do not specify a path while saving it gets saved to the Oracle bin directory by default. Hemant Reply With Quote Quick Navigation Oracle Database Administration Top Site Areas Settings Private Messages Subscriptions Who's Online Search Forums Forums Home Forums Oracle Forums Oracle Database Administration Oracle Applications DBA Oracle Development Oracle Certification Oracle : How To Oracle Careers Oracle Positions Available Oracle Job Wanted Archives Forum Archives Other Feedback and Questions regarding the forums Obfuscation Unlimited « Previous Thread | Next Thread » Posting Permissions You may
& Answers This forum is closed for new posts. Please post beginner questions to learn unix and learn linux in this forum UNIX for Beginners Questions & Answers Search Forums Show Threads Show Posts Tag Search Advanced Search Unanswered Threads Find All Thanked Posts Go to Page... unix and linux operating commands SP2-0310 unable to open file UNIX for Dummies Questions & Answers Thread Tools Search this Thread Display Modes #1 06-28-2007 guru_2007 Registered User Join Date: Jun 2007 Last Activity: 27 June 2008, 1:13 AM EDT Posts: 2 Thanks: 0 Thanked 0 Times in 0 Posts SP2-0310 unable to open file 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? Remove advertisements Sponsored Links guru_2007 View Public Profile Find all posts by guru_2007 #2 06-28-2007 jim mcnamara ...@... Join Date: Feb 2004 Last Activity: 22 October 2016, 9:39 PM EDT Location: NM Posts: 10,839 Thanks: 451 Thanked 971 Times in 902 Posts 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 Remove advertisements Sponsored Links jim mcnamara View Public Profile Find all posts by jim mcnamara #3 06-29-2007 guru_2007 Registered User Join Date: Jun 2007 Last Activity: 27 June 2008, 1:13 AM EDT Posts: 2 Thanks: 0 Thanked 0 Times in 0 Posts 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. Remove advertisements Sponsored Links guru_2007 View Public Profile Find all posts by guru_2007 « Previous Thread | Next Thread » Thread Tools Show Printable Version Email this Page Subscribe to this Thread Display Modes Linear Mode Switch to Hybrid Mode Switch to Threaded Mode Search this Thread Advanced Search More UNIX and Linux Forum Topics You Might Find Helpful Thread Thread Starter Forum Replies Last Post Unable to open a file in perl srijith Shell Programming and Scripting 7 07-22-201