SP2-0310: unable to open file 'nomount.sql' SQL startup nomount; ORACLE instance started. Total System Global Area 422670336 bytes Fixed Size 1300352 bytes Variable Size 293603456 bytes Database Buffers 121634816 bytes Redo Buffers.
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 manually there it works OK (from what you've said); so when you call it from Java it must be somewhere else. That will either be whatever the working directory was when your JVM launched, or your home directory, I think - not quite sure.You need to specify the correct directory, either hard-coded into the script, or passed as another parameter. You may then want to cd to that in your script so the DIRREPORT.sql is created in the same, known, place; otherwise you can use it create the full path to PACKAGESCRIPTv2.sql.
Yeah the problem is path defined in statement contains all the files but while execution the script is going only till:'C:/Users/sony/Documents/NetBeansProjects/CodeReview'This is what was displayed in cmd, so I have placed the file into this directory and it started working.don't know the reason.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 place the file at that location and will work.Enjoy m/.
We have recently migrated from 9i to 10g. The new operating system is HP-UX 11.We have couple of shell scripts which execute sql files as below example.Some of them are executed without any errors but few of them throws SP2-0310: unable to open file dataload.sql.The shell scripts and sql files are located in $HOME/bin. But for some reason it is not executing.I am not sure how to address this issue. Can u please help.Thankssqlplus / @loaddata.sql $SCHEMA $PASSWD tee -a $PROCLOGSelect all.
Comments are closed.
|
AuthorWrite something about yourself. No need to be fancy, just an overview. Archives
March 2023
Categories |