https://community.hpe.com/t5/operating-system-hp-ux/sqlplus-cant-open-spool-file/m-p/2991361#M923916 Well, I figured it out myself (too bad I can't get any points...)<BR />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.<BR /><BR />Thanks Fri, 06 Jun 2003 20:59:24 GMT Dave Chamberlin 2003-06-06T20:59:24Z https://community.hpe.com/t5/operating-system-hp-ux/sqlplus-cant-open-spool-file/m-p/2991360#M923915 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? Fri, 06 Jun 2003 18:25:21 GMT https://community.hpe.com/t5/operating-system-hp-ux/sqlplus-cant-open-spool-file/m-p/2991360#M923915 Dave Chamberlin 2003-06-06T18:25:21Z https://community.hpe.com/t5/operating-system-hp-ux/sqlplus-cant-open-spool-file/m-p/2991361#M923916 Well, I figured it out myself (too bad I can't get any points...)<BR />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.<BR /><BR />Thanks Fri, 06 Jun 2003 20:59:24 GMT https://community.hpe.com/t5/operating-system-hp-ux/sqlplus-cant-open-spool-file/m-p/2991361#M923916 Dave Chamberlin 2003-06-06T20:59:24Z https://community.hpe.com/t5/operating-system-hp-ux/sqlplus-cant-open-spool-file/m-p/2991362#M923917 Well, I figured it out myself (too bad I can't get any points...)<BR />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.<BR /><BR />Thanks Fri, 06 Jun 2003 20:59:43 GMT https://community.hpe.com/t5/operating-system-hp-ux/sqlplus-cant-open-spool-file/m-p/2991362#M923917 Dave Chamberlin 2003-06-06T20:59:43Z