Simpler Navigation for Servers and Operating Systems - Please Update Your Bookmarks
Completed: a much simpler Servers and Operating Systems section of the Community. We combined many of the older boards, so you won't have to click through so many levels to get at the information you need. Check the consolidated boards here as many sub-forums are now single boards.
If you have bookmarked forums or discussion boards in Servers and Operating Systems, we suggest you check and update them as needed.
cancel
Showing results for 
Search instead for 
Did you mean: 

sqlplus cant open spool file

Dave Chamberlin
Trusted Contributor

sqlplus cant open spool file

Our oracle apps (10.7)have a number of concurrent requests that use sqlplus - all of which are failing with .."cant open spool file". This is our DEV box and I have not made any recent system changes to the system. It may be a permission or path issue but I don't know where it wants to open a spool file. Any ideas?
2 REPLIES
Dave Chamberlin
Trusted Contributor

Re: sqlplus cant open spool file

Well, I figured it out myself (too bad I can't get any points...)
As it turns out I could create spool files but not edit them! This led to the discovery that the spool files were owned by the oracle user and not the apps user. The sqlplus executable had permissions modified to set user id on execute! I reset this back to normal and all works now....I would sure like to find out how it was changed though.

Thanks
Dave Chamberlin
Trusted Contributor

Re: sqlplus cant open spool file

Well, I figured it out myself (too bad I can't get any points...)
As it turns out I could create spool files but not edit them! This led to the discovery that the spool files were owned by the oracle user and not the apps user. The sqlplus executable had permissions modified to set user id on execute! I reset this back to normal and all works now....I would sure like to find out how it was changed though.

Thanks