Action: Check and make sure the file name is valid.... 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 batch file from my java program which I tried to use my old username and password before upgrade, it didn't work!
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 As I said in my answer, it looks like the working directory from when the JVM launched; maybe you have a shortcut to launch NetBeans that sets that working area, or Reload to refresh your session. Sp2-0310: Unable To Open File: Sql Developer 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.
Could any one help? Sp2 0310 Unable To Open File In Shell Script However we receive the error SP2-0310: unable to open file "/apps/prod/sql/xxxx.sql " . WaappuJune 8th, 2010, 07:13 AMHi, Apex is inside database. have a peek here You need to specify the correct directory, either hard-coded into the script, or passed as another parameter.
If I do copy and pate the same script on command prompt it works, problem occurs only from Script. Change Directory In Sqlplus To start viewing messages, select the forum that you want to visit from the selection below. You signed in with another tab or window. Advanced Search Forum Oracle Forums Oracle Database Administration SP2-0310 Unable to open file If this is your first visit, be sure to check out the FAQ by clicking the link above.
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 http://www.unix.com/unix-for-dummies-questions-and-answers/39240-sp2-0310-unable-open-file.html Naushad. Unable To Open Sql File In Sqlplus Where should a galactic capital be? Sp2 0310 Unable To Open File Sql In Unix Workaround: [[email protected] /]# chown -R oracle /u01/app/oracle Environment: SUSE Linux Enterprise Server 12 SP1 Docker version 1.10.3, build 9e83765 Other Notes After step3, the database wouldn't start up - I had
more stack exchange communities company blog Stack Exchange Inbox Reputation and Badges sign up log in tour help Tour Start here for a quick overview of the site Help Center Detailed Check This Out standard workspace is "internal" 2. You may change it to somewhere else in your convenience. Cheers:D! Sp2 0310 Unable To Open File Sql In Windows
Mark Wyatt wingkitfMarch 23rd, 2009, 01:37 AMHi Mark, Thanks for the instruction! PLEASE HELP! TIP: when you find such kind of issue please look at the error message properly as it will tell you where the script is looking when it got failed, so just Source That will either be whatever the working directory was when your JVM launched, or your home directory, I think - not quite sure.
I still have a problem, what is the "workspace,username & password"? Sp2-0310 Windows Joseph R.P. Cheers:D!
SQL> @/u01/app/oracle./scripts/myfile.sql Else, go to the directory where the file exists and then invoke sqlplus. and after that running the script apxxepwd.sql with a parameter telling the password for the admin account everything now works very well! Feel free to ask questions on our Oracle forum. 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?
Personal Open source Business Explore Sign up Sign in Pricing Blog Support Search GitHub This repository Watch 23 Star 111 Fork 81 wscherphof/oracle-12c Code Issues 16 Pull requests 0 Projects 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 Edited by: Sunny kichloo on Apr 21, 2011 1:04 AM Like Show 0 Likes(0) Actions 2. http://crudlet.org/unable-to/ubuntu-warning-unable-to-locate-open-x-configuration-file.html 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,
The time now is 07:33 AM.