Home > Unable To > Sqlplus Script Unable To Open File

Sqlplus Script Unable To Open File


Regards Michel [Updated on: Wed, 16 December 2009 07:59]Report message to a moderator Re: SP2-0310: unable to open file [message #435479 is a reply to message #435361] Wed, All Rights Reserved.SP2-0310: unable to open file "ora_scr_tmp.sql"================================================================================2011-11-22, 13:44:44 SAPINST ORACLE start logging for connect / as sysdba ;CONNECT / AS SYSDBASHUTDOWN [email protected] IMMEDIATESTARTUP MOUNTALTER DATABASE ARCHIVELOG;ALTER DATABASE OPEN;EXITexit;Output of SQL Join Now For immediate help use Live now! Thanks 0 LVL 40 Overall: Level 40 Unix OS 27 Oracle Database 6 Message Active 5 days ago Expert Comment by:omarfarid ID: 214802992008-05-01 In your posting, you have mentioned two have a peek at this web-site

Ask a question on this topic 9 replies Share & Follow Privacy Terms of Use Legal Disclosure Copyright Trademark Sitemap Newsletter MenuExperts Exchange Browse BackBrowse Topics Open Questions Open Projects Solutions However, managing this community does not come without cost! 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 Linked 1 Execute scripts by relative path in Oracle SQL Developer Related 1How can I create a batch file for SQLPlus?2Bat File and SQLPLUS1Error 6 initializing SQL*Plus in UNIX9SqlPlus SP2-0734: Error0Passing

Sp2 0310 Unable To Open File In Shell Script

You may have to register before you can post: click the register link above to proceed. Rather than rely on a variable, specify the fully-qualified path. Golf a Numerical Growing Braid What is the intuition behind the formula for the average? June 8, 2016 at 11am to December 30, 2016 at 4pm – Toronto New Batch On IBM Clarity Online Training at VirtualNuggets June 20, 2016 at 11am to March 20, 2017

You can not post a blank message. Some components may not be visible. Is there a non-medical name for the curve where index finger and thumb meet? Change Directory In Sqlplus Report message to a moderator Re: SP2-0310: unable to open file [message #435361 is a reply to message #435358] Tue, 15 December 2009 17:14 BlackSwan Messages: 25071Registered: January

Powered by vBulletinCopyright ©2000 - 2016, Jelsoft Enterprises Ltd.Forum Answers by - Gio~Logist - Vbulletin Solutions & Services Home Register New Posts Advertising Archive Privacy Statement Sitemap Top Hosting and Cloud Sp2 0310 Unable To Open File Sql In Unix June 8, 2016 at 8am to December 30, 2016 at 4pm – Canada Announcement of IBM Cognos BI Online Training. Please guide me. useful source Oracle Database Advertise Here 666 members asked questions and received personalized solutions in the past 7 days.

All Rights Reserved.Connected to an idle instance.SP2-0310: unable to open file "run_control.sql"DisconnectedSAPINST: End of output of SQL executing program /oracle/PBW/102_64/bin/sqlplus.SAPINST found errors.SAPINST The current process environment may be found in sapinst_ora_environment.log.2011-11-22, Sp2-0310 Windows Please enter a title. sqlplus / @load_data.sql 0 Message Author Comment by:basirana ID: 214803752008-05-01 I just gave a file name it not actual name. Subscribe to our monthly newsletter for tech news and trends Membership How it Works Gigs Live Careers Plans and Pricing For Business Become an Expert Resource Center About Us Who We

Sp2 0310 Unable To Open File Sql In Unix

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? useful reference The shell scripts and sql files are located in $HOME/bin. Sp2 0310 Unable To Open File In Shell Script Advertisement dBforums Brief Subscribe to dBforums Brief to receive special offers from dBforums partners and sponsors Top Helpers healdem - 59 mark.b - 55 Pat Phelan - 54 ranman256 - 24 Sp2 0310 Unable To Open File Sql In Windows SQL> @/u01/app/oracle./scripts/myfile.sql Else, go to the directory where the file exists and then invoke sqlplus.

All Rights Reserved. Check This Out Any advice? However we receive the error SP2-0310: unable to open file "/apps/prod/sql/xxxx.sql " . Remove advertisements Sponsored Links guru_2007 View Public Profile Find all posts by guru_2007 #2 06-28-2007 jim mcnamara ...@... Sp2-0310 Unable To Open File Sql Developer

Sorry for some security reason I can't give actual name. 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. We dont have any problem with sqlplus. Source Donate Bitcoins Oracle Blogosphere Oracle Week 2016: Introduction to Apache Spark (slides) A 12.2 treat for the festive season Adaptive Query Optimization: Backport of 12.2 Configuration in

If you are willing to donate to help pay for the monthly community fees and domain services I accept Bitcoin and PayPal donations. How To Run Sql Script In Sqlplus SQL> @report.sql SP2-0310: Unable to open file "report.sql" Can someone tell me what that error is about? I do not have much knowledge on Unix Shell Script.

It may be in the Oracle Bin directory.

To make SQLPATH contain multiple folders, delimit the folder names with a semicolon (and don't put any extra spaces at the beginning or end of the folder names). Covered by US Patent. SQL> @/u01/app/oracle./scripts/myfile.sql Else, go to the directory where the file exists and then invoke sqlplus. Error 45 Initializing Sql*plus Results 1 to 3 of 3 Thread: P2-0310: unable to open file in SQL Plus Tweet Thread Tools Show Printable Version Subscribe to this Thread… Search Thread Advanced Search Display

Relative paths in sql is pretty universal in sql tools. is this a typo? Some of them are executed without any errors but few of them throws SP2-0310: unable to open file data_load.sql. have a peek here 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 FeedPowered byOracle Technology NetworkOracle Communities DirectoryFAQAbout OracleOracle and

Or perhaps many businesses even go to the extent of believing that data entry task is easy and their existing workforce can perform the tasks in their free time. I have created 1 script file with extension ".sql" and am executing like "@ file.sql" at that time getting one error message that is SP2-0310 UNABLE TO OPEN FILE"                    I have the same question Show 0 Likes(0) 1019Views Tags: none (add) 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 You may have to register before you can post: click the register link above to proceed.

One way of ensuring it is through… Continue Posted by Alvaro Dee on December 5, 2016 at 9:19pm Add a Blog Post View All © 2016 Created by Steve Karam. However, the… Continue Posted by Alvaro Dee on December 6, 2016 at 8:32pm Add Value and Improve the Quality of Your Data with Data Enrichment Services Data from various sources such First position golf Output the sign Let's speed that file sentence searching program Can a mathematician review my t-shirt design? 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

In 4/4 time can I insert a half sized bar in the middle of the piece? and how to go by correcting it?