Wednesday, 25 November 2009

Oracle Database Gateways 11g (11.1.0.6.0) - Part 2 of the series Informix to Oracle Connectivity by using the Oracle Gateway 11g for ODBC"

Introduction:
This is the 2nd of the article of the series "Informix to Oracle Connectivity by using the Oracle Gateway 11g for ODBC"
In this post we will do the installation of Oracle Database Gateways 11g for ODBC and will configure the listener so it could talk to ODBC, which we had configured in the previous article.

Also we have to patch this Oracle Database Gateways 11g 11.1.0.6.0 to 11.1.0.7. We need to download the patch 6890831.
Cookbook:
Installation of Oracle Database Gateways 11g (11.1.0.6):
Following are the images of install screen.



You need to select the option "Oralce Database Gateways for ODBC", I selected the option, but that is hidden in the following screen :)









After this installation, we need to apply the patch 6890831, and the version of Oracle Database Gateways 11g would be 11.1.0.7.0.
Configuration:
Now after the installtion and patching, we have to configure the Oracle Database Gateways 11g for ODBC, the metalink document "How to Setup DG4ODBC on 64bit Unix OS (Linux, Solaris, AIX, HP-UX) [ID 561033.1]" can be followed to do this configuration.
Following is the configuration details.
1- Environment variables:
Following are the environment variables which was set with respect to Oracle Database Gateways 11g for ODBC.
ORACLE_HOME=/u04/oragateway/gateway
PATH=/usr/openwin/bin/xauth:/usr/bin:/usr/ucb:/etc:/usr/local/bin:/usr/X/bin:/u04/oragateway/gateway/bin:.
2- edit the file "initdg4odbc.ora" at the path $ORACLE_HOME/hs/admin, also after the change copy the file to $ORACLE_HOME
following is my initdg4odbc.ora
HS_FDS_CONNECT_INFO = Informix HS_FDS_TRACE_LEVEL = DEBUG HS_FDS_SHAREABLE_NAME = /export/home/odbc1/odbc/Connect64forODBC60/lib/libodbc.so
## ODBC specific environment variables#set ODBCINI= /export/home/odbc1/odbc/Connect64forODBC60/odbc.ini
3- configure the listener for Oracle Database Gateways 11g. Following is the configurtaion of the listener.ora at the path $ORACLE_HOME/network/admin
LISTENER =
(DESCRIPTION_LIST =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC1522))
(ADDRESS = (PROTOCOL = TCP)(HOST = tabsmt04.mtcvb.com)(PORT = 1522))
)
)

SID_LIST_LISTENER =
(SID_LIST =
(SID_DESC =
(SID_NAME=DG4ODBC)
(ORACLE_HOME=/u04/oragateway/gateway)
(ENVS=LD_LIBRARY_PATH=/export/home/odbc1/odbc/Connect64forODBC60/lib:/u04/oragateway/gateway/hs/lib:/u04/oragateway/gateway/hs/lib32:/u04/oragateway/gateway/lib)
(PROGRAM=dg4odbc)
)
)
4- configure the tnsnames.ora file, following is the confiugration details.
DG4ODBC =
(DESCRIPTION=
(ADDRESS=(PROTOCOL=tcp)(HOST=tabsmt04)(PORT=1522))
(CONNECT_DATA=(SID=DG4ODBC))
(HS=OK)
)
5- verify the listener with the tnspin command.

bash-2.05$ tnsping dg4odbc

TNS Ping Utility for Solaris: Version 11.1.0.7.0 - Production on 25-NOV-2009 16:06:38

Copyright (c) 1997, 2008, Oracle. All rights reserved.

Used parameter files:
/u04/oragateway/gateway/network/admin/sqlnet.ora


Used TNSNAMES adapter to resolve the alias
Attempting to contact (DESCRIPTION= (ADDRESS=(PROTOCOL=tcp)(HOST=tabsmt04)(PORT=1522)) (CONNECT_DATA=(SID=DG4ODBC)) (HS=OK))
OK (10 msec)
Used parameter files:
/u04/oragateway/gateway/network/admin/sqlnet.ora


Used TNSNAMES adapter to resolve the alias
Attempting to contact (DESCRIPTION= (ADDRESS=(PROTOCOL=tcp)(HOST=tabsmt04)(PORT=1522)) (CONNECT_DATA=(SID=DG4ODBC)) (HS=OK))
This shows the successfull connection, in the next article we will see to install and patch the Oracle 10g R2 database and will configure the Oracle 10g R2 database so we could fetch the data from Infomix database.

1 comment:

Anonymous said...

you have a nice site. thanks for sharing this valuable resources. keep it up. anyway, various kinds of ebooks are available here

http://feboook.blogspot.com