Oracle Error Sp2-0310
Contents |
here for a quick overview of the site Help Center Detailed answers to any questions you might have Meta Discuss the workings and policies
Sp2-0310 Unable To Open File Windows
of this site About Us Learn more about Stack Overflow the company Business sp2 0310 unable to open file in shell script Learn more about hiring developers or posting ads with us Stack Overflow Questions Jobs Documentation Tags Users Badges sp2-0310: unable to open file: sql developer Ask Question x Dismiss Join the Stack Overflow Community Stack Overflow is a community of 6.2 million programmers, just like you, helping each other. Join them; it only takes a minute:
Sp2 0310 Unable To Open File Sql In Windows
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 oldest votes up vote 0 down vote The SP2-0310 error occurs when you have not fully-qualified
Sp2 0310 Unable To Open File Sql In Unix
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| up vote 0 down vote 1. use absolutely path like: /u01/app/oaracle/test.sql 2. check if the path if the script exists ls -l /u01/app/oaracle/test.sql share|improve this answer answered Jul 25 at 10:09 tzJacky 11 add a comment| up vote 0 down vote All the answers so far imply that absolute paths are require
CommunityOracle User Group CommunityTopliners CommunityOTN Speaker BureauJava CommunityError: You don't have JavaScript enabled. This tool uses JavaScript and much of it will not work correctly without it enabled. Please turn JavaScript back on and reload this page. Please enter a title. You can not post change directory in sqlplus a blank message. Please type your message and try again. More discussions in
How To Run Sql Script In Sqlplus
Recovery Manager (RMAN) All PlacesDatabasePerformance & AvailabilityRecovery Manager (RMAN) This discussion is archived 2 Replies Latest reply on Apr 21, sp2-0640 not connected 2011 8:53 AM by 855496 SP2-0310: unable to open file "transport.sql" 855496 Apr 21, 2011 6:53 AM Hello all, I am planning to migrate my db from Windows to Linux, hence I followed http://stackoverflow.com/questions/31635032/sp2-0310-unable-to-open-file-dba-files-all-sql this guide here: http://blogs.oracle.com/AlejandroVargas/Database-Migration-Windows-Linux-with-RMAN.pdf After doing all the necessary steps, I finally arrived at the step to execute the transport script (refer to page 21 of linked pdf). However, when I executed @transport, I got the following error: SP2-0310: unable to open file "transport.sql" Does anyone have any idea where I may have gone wrong? I have the same question Show 0 Likes(0) 785Views Tags: none (add) https://community.oracle.com/thread/2213122 migrationContent tagged with migration, rmanContent tagged with rman, sp2-0310Content tagged with sp2-0310, windows_to_linuxContent tagged with windows_to_linux This content has been marked as final. Show 2 replies 1. Re: SP2-0310: unable to open file "transport.sql" Sunny kichloo Apr 21, 2011 8:05 AM (in response to 855496) By default it search for script in $ORACLE_HOME/rdbms/admin If you know the path of the script run it by following command SQL>@{path}{file} For eg:-- SQL> @/u01/app/oracle./scripts/myfile.sql Else, go to the directory where the file exists and then invoke sqlplus. Edited by: Sunny kichloo on Apr 21, 2011 1:04 AM Like Show 0 Likes(0) Actions 2. Re: SP2-0310: unable to open file "transport.sql" 855496 Apr 21, 2011 8:53 AM (in response to Sunny kichloo) Hi there, Thank you for your reply. Based on the RMAN migration manual which I followed (refer to my first post), I had generated a transport script called TRANSPORTSCRIPT which does not have an extension however. Nevertheless, I still tried to call the file using the path of the file but still encountered the same error message. Like Show 0 Likes(0) Actions Go to original post Actions About Oracle Technology Network (OTN)My Oracle Support Community (MOSC)MOS Support PortalAboutModern Marketing BlogRSS F
#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 http://www.orafaq.com/forum/t/101689/ giving the full path & with @ but to no avail???? thanx in advance Report message to a moderator Re: SP2-0310 error [message #317498 is a reply to message #317497] 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 [message #317499 is a unable to 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 #317497] Thu, 01 May 2008 unable to open 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.0 - 64bit Production With the Partitioning, OLAP and Data M