Error Sp2-0310 Unable To Open File
Contents |
here for a quick overview of the site Help Center Detailed answers to any questions you might have Meta sp2-0310 unable to open file sqlplus Discuss the workings and policies of this site About Us Learn sp2-0310 unable to open file in oracle more about Stack Overflow the company Business Learn more about hiring developers or posting ads with us Stack sqlplus unable to open file error Overflow Questions Jobs Documentation Tags Users Badges Ask Question x Dismiss Join the Stack Overflow Community Stack Overflow is a community of 4.7 million programmers, just like you,
Sql Sp2-0310 Unable To Open File
helping each other. Join them; it only takes a minute: Sign up SP2-0310: unable to open file “dba_files_all.sql” up vote 0 down vote favorite Please advise , @dba_files_all --- SP2-0310: unable to open file "dba_files_all.sql"-- is not working sqlplus share|improve this question asked Jul 26 '15 at 8:27 Jaad 1015 add a comment| 3 Answers 3 active sp2-310 unable to open file oldest votes up vote 0 down vote 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 file exists and then invoke sqlplus. share|improve this answer answered Jul 26 '15 at 8:31 Itz Raghu 199214 not working as well SP2-0310: unable to open file "/u01/app/oracle./scripts/myfile.sql" –Jaad Jul 26 '15 at 8:40 if the file does not exist in current directory or permissions are not correct, then you'll get this error –Itz Raghu Jul 26 '15 at 8:44 How can I over come this issue? I need to view all files after migrating from File system to ASM. –Jaad Jul 29 '15 at 8:38 This is a verbatim copy-pasta from dba-oracle.com/t_sp2_0310_unable_to_open_file.htm –Rondo Sep 28 at 23:04 add a comment| Did you find this question interesting? Try our newsletter Sign up for our newsletter and get our top new questions delive
here for a quick overview of the site Help Center Detailed answers to any questions you might have Meta Discuss the workings and policies of this site About Us Learn more about Stack sp-0310 unable to open file Overflow the company Business Learn more about hiring developers or posting ads with us
Sp20310 Unable Open File
Stack Overflow Questions Jobs Documentation Tags Users Badges Ask Question x Dismiss Join the Stack Overflow Community Stack Overflow is a
Unable To Open Sql File In Sqlplus
community of 4.7 million programmers, just like you, helping each other. Join them; it only takes a minute: Sign up SP2-0310: unable to open file .sql up vote 0 down vote favorite I am calling http://stackoverflow.com/questions/31635032/sp2-0310-unable-to-open-file-dba-files-all-sql batch file from my java program which in result execute some .sql files. the batch script is below: set part1= CREATE OR REPLACE DIRECTORY REPORT AS ' set total=%part1%%4'; echo %total% > DIR_REPORT.sql echo exit; >>DIR_REPORT.sql sqlplus %1/%2@%3 @./DIR_REPORT.sql sqlplus %1/%2@%3 @./PACKAGE_SCRIPTv2.sql and my java code is : Runtime run = Runtime.getRuntime(); System.out.println("Start Running the batch file"); Process p = run.exec(new String[]{"cmd.exe","/c", "start", "C:/Users/sony/Documents/NetBeansProjects/CodeReview/src/codereview/install.bat",i,j,m,l}); System.out.println("Completed"); it is giving error :SP2-0310: unable http://stackoverflow.com/questions/20375222/sp2-0310-unable-to-open-file-sql to open file The first file generated using the batch (DIR_REPORT) is being executed but my PACKAGE_SCRIPTv2.sql is not being executed and giving error, please help me what to do. although when a run batch file mannualy from cmd everything works fine... java oracle share|improve this question edited Dec 5 '13 at 12:18 Maurice Perry 24.2k74474 asked Dec 4 '13 at 12:20 user3065757 2615 Do you have permissions to access the file? –Ben Dec 4 '13 at 13:31 Yes I have, but how can i Check that ? –user3065757 Dec 4 '13 at 13:44 If you're on windows right-click on the file then click properties. –Ben Dec 4 '13 at 13:49 I have all the permission, I verified... –user3065757 Dec 4 '13 at 13:52 add a comment| 2 Answers 2 active oldest votes up vote 0 down vote The first script is being created and executed in the current working directory, so it will always exist (assuming you have permission to create there). The second is expected to be in the current working directory as well. The question is, then, what is the current working directory? It looks like you're expecting it to be C:/Users/sony/Documents/NetBeansProjects/CodeReview/src/codereview/, and if you run the .bat manuall
#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 have tried giving the http://www.orafaq.com/forum/t/101689/ full path & with @ but to no avail???? thanx in advance Report message to http://www.ibm.com/support/docview.wss?uid=swg21131726 a moderator Re: SP2-0310 error [message #317498 is a reply to message #317497] Thu, 01 May 2008 12:35 joy_division Messages: 4620Registered: 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 [message #317499 is a reply to message #317497] unable to Thu, 01 May 2008 12:36 Michel Cadot Messages: 63875Registered: 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 #317497] Thu, 01 May 2008 12:39 Michel Cadot Messages: 63875Registered: March unable to open 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: 24942Registered: 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.0 - 64bit Production With the Partitioning, OLAP and Data Mining options SQL> select sysdate from dual; SYSDATE --------------- 01-MAY-08 SQL> @time Session a
in SQL*PLUS sp2-0310; unable to open file; oracle; short file name; script; 8.3; long name; short name; sql*plus; sql; file name; create_reqpro.sql; script; configure; database; 1131726 Technote (troubleshooting) Problem(Abstract) This technote identifies a possible solution to the error, SP2-0310, which might occur when running the IBM Rational RequisitePro configuration scripts for Oracle. Cause When running the Oracle configuration scripts for RequisitePro for the following error occurs when using SQL*PLUS to specify the path to the create_reqpro.sql file:
SQL> @C:\Documents and Settings\user\Desktop\Oracle scripts\create_reqpro.sql
The user receives the following error message:
SP2-0310: unable to open file "C:\Documents.sql"
This error is caused by the spaces contained in the path to the create_reqpro.sql script. Resolving the problem To resolve this issue you need to specify the path to the create_reqpro.sql using the 8.3 DOS Naming convention: Converting the path to the script to match the 8.3 Naming Convention. For example:
C:\Documents and Settings\user\Desktop\Oracle scripts\create_reqpro.sql
8.3 Naming Convention:
C:\Docume~1\user\desktop\Oracle~1\create_reqpro.sql
Once you have converted the path to the 8.3 Naming Convention you will be able to rerun the create_reqpro.sql script in SQL*PLUS successfully. Historical Number 151035317 Document information More support for: Rational RequisitePro Database: Oracle Software version: 7.0, 7.0.1, 2002.05.00, 2002.05.20, 2003.06.00, 2003.06.01, 2003.06.10, 2003.06.12, 2003.06.13, 2003.06.14, 2003.06.15 Operating system(s): Windows Reference #: 1131726 Modified date: 2010-10-27 Site availability Site assistance Contact and feedback Need support? Submit feedback to IBM Support 1-800-IBM-7378 (USA) Directory of worldwide contacts Contact Privacy Terms of use Accessibility