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.

Advertisements

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out /  Change )

Google+ photo

You are commenting using your Google+ account. Log Out /  Change )

Twitter picture

You are commenting using your Twitter account. Log Out /  Change )

Facebook photo

You are commenting using your Facebook account. Log Out /  Change )

w

Connecting to %s

This site uses Akismet to reduce spam. Learn how your comment data is processed.