OIP-04109: Error creating temporary file

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.

Solution:
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:

https://community.oracle.com/thread/528631

Finally the temp directory.

C:\Windows\ServiceProfiles\NetworkService\AppData\Local\Temp

needs the user to read/write permission to user at window level.

Leave a Reply