Edit the Listener.Ora file and add information for each necessary gateway. For example:
(SID_LIST=
(SID_DESC=
(SID_NAME=dg4msql)
(ORACLE_HOME=C:\product\11.1.0\tg_1)
(PROGRAM=dg4msql)
)
)
Stop any existing Listeners on the Oracle Gateway server.
If you need to connect to other Oracle instances, you must configure the TNS Names in the directory where you installed the Gateway.
Start the Gateway Listener. The following Initialization parameters were set for the Gateway:
HS_RPC_FETCH_SIZE=1000000
HS_ROWID_CACHE_SIZE=10000
HS_FDS_ROW_SIZE=50000
For a dataset with similar statistics:
TASK - 6 million rows
TASKACTV - 15 million rows
TASKRSRC - 9 million rows
UDFVALUE - 3 million rows
RSRCHOUR - 50 million rows
PROJWBS - 2 million rows
When configuring the Gateway, set HS_LANGUAGE for the Oracle character set of your instance:
On the gateway machine, go to the gateway install directory (for example, C:\product\11.1.0\tg_2\dg4msql\admin)
Edit the initdg4msql.ora file and add the following parameter specific to your Oracle dataset. Depending on your character set, either add the following or adjust for UTF8: