Oracle Database Gateway For SQL Server Writing To /tmp (Doc ID 2318917.1)

In this Document

APPLIES TO: 

GOAL

Oracle Database Gateway for SQL Server (DG4MSQL), in some cases, is writing to /tmp.
The file names, for example, are qexrRQeo.

How can we change it to write to "/global/dbfs/temp/" as the /tmp is extremely small mount point ?
 

SOLUTION

You will need to set the ENV argument variable QE_TMPDIR to the directory you want. This must be put into the environment one way or another.

Try either setting is in the gateway init file thus:

SET PRIVATE QE_TMPDIR=/var/tmp

Or place it into the listener.ora entry for the gateway using the ENV=
parameter. eg:

SID_LIST_LISTENER=
   (SID_LIST=
    (SID_DESC=
     (SID_NAME=<gateway_sid>)
     (ORACLE_HOME=<oracle_home_directory>)
     (ENV="QE_TMPDIR=/var/tmp")
     (PROGRAM=dg4msql)
    )
   ) 


http://docs.oracle.com/database/122/OTGIS/config-sqlserver-gateway.htm

https://knowledgebase.progress.com/articles/Article/000024815?q=%2Ftmp&l=en_US&c=Product_Group%3ADataDirect&type=Article__kav,Critical_Alert__kav,Product_Alert__kav,Support_Information__kav&fs=Search&pn=1