This content has been marked as final. Show 3 replies
I don't have an Oracle XE installation to check... but you can verify if it is installed or not very easy. Just look at the ORACLE_HOME/bin directory if there's an executable called dg4odbc. If there's one it is installed by default. If not you need to download the gateway software from OTN: http://www.oracle.com/technetwork/database/enterprise-edition/downloads/112010-linx8664soft-100572.html1 person found this helpful
Then install the software into ist own Oracle_Home directory, different from the XE installation.
Please be aware that DG4ODBC would also require a 3rd party ODBC driver and a 3rd party ODBC Driver Manager.
Your response was very helpful. One clarification I need:
You mentioned installing the Gateway into its own Oracle home directory. Currently the Oracle XE database is in /u01/app/oracle/product/11.2.0/xe.
When you say 'install the gateway in its own Oracle home are you suggestion something on the order of /u01/app/oracle/product/11.2.0/hg? Or something more divergent (/u02/app/oracle/hg)?
In other words, is it sufficient just to install the gateway in a new subdirectory of the existing Oracle home directory tree or somewhere vastly different?
(I do already have the 3rd party ODBC drivers/driver mgr but thanks for mentioning that for future readers of this thread).
Thanks in advance.
The directory needs to be different from your xe durectory /u01/app/oracle/product/11.2.0/xe. Use a meaningful name like /u01/app/oracle/product/11.2.0/gtw - just another subtree is sufficient.