OIP-04109: Error creating temporary file
Error occurred at application side when the application try to execute any sql query from its own session.
We checked the alert log file for temporary tablespace space issue and restart the oracle database.
We also check with oracle client on application server and make connectivity with oracle database server.
Try to execute the same sql query running from the application.
Then we find all its working fine at database level.
Then we open cmd ( command prompt with administrator privileges ), then go to application directory and run the application from command prompt.
Then application run fine for us.
Its is user privileges issue at windows level to temp folder location.
We also find one thread explaining about same issue:
Finally the temp directory.
needs the user to read/write permission to user at window level.