access to timesten via oracle gateway
729213Feb 1 2012 — edited Feb 3 2012Hi.
How to set up acces to timsten via oracle gateway.
inittt.ora
#
# HS init parameters
#
HS_FDS_CONNECT_INFO = tt_1122
HS_FDS_TRACE_LEVEL = 4
HS_FDS_SHAREABLE_NAME = /u01/app/TimesTen/tt1122/lib/libtten.so
#
# ODBC specific environment variables
#
set ODBCINI=/u01/app/TimesTen/tt1122/info/sys.odbc.ini
#
# Environment variables required for the non-Oracle system
#
set LD_LIBRARY_PATH="/u01/app/oracle/product/11.1.0_gateway/lib:/u01/app/TimesTen/tt1122/lib"
listener.ora
LISTENER =
(ADDRESS_LIST=
(ADDRESS=(PROTOCOL=tcp)(HOST=oel)(PORT=1521))
)
SID_LIST_LISTENER=
(SID_LIST=
(SID_DESC=
(SID_NAME=tt)
(ORACLE_HOME="/u01/app/oracle/product/11.2.0_gateway")
(PROGRAM=dg4odbc)
(ENVS=LD_LIBRARY_PATH="/usr/lib:/u01/app/oracle/product/11.2.0_gateway/lib:/u01/app/TimesTen/tt1122/lib")
)
(SID_DESC=
(SID_NAME=ttcs)
(ORACLE_HOME="/u01/app/oracle/product/11.2.0_gateway")
(PROGRAM=dg4odbc)
(ENVS=LD_LIBRARY_PATH="/u01/app/oracle/product/11.2.0_gateway/lib:/u01/app/TimesTen/tt1122/lib")
)
)
tnsnames.ora
tt=(DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=oel)(PORT=1521))(CONNECT_DATA=(SID=TT))(HS=OK))
ttcs=(DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=oel)(PORT=1521))(CONNECT_DATA=(SID=TTCS))(HS=OK))
the problem is with driver.
Following error i have got from trace.
pice of log file
Exiting hgosdip, rc=0
ORACLE_SID is "tt"
Product-Info:
Port Rls/Upd:2/0 PrdStat:0
Agent:Oracle Database Gateway for ODBC
Facility:hsa
Class:ODBC, ClassVsn:11.2.0.2.0_0008, Instance:tt
Exiting hgogprd, rc=0
Entered hgoinit
HOCXU_COMP_CSET=1
HOCXU_DRV_CSET=178
HOCXU_DRV_NCHAR=873
HOCXU_DB_CSET=178
HS_LANGUAGE not specified
LANG=en_US.UTF-8
HOCXU_SEM_VER=112000
Entered hgolofn at 2012/02/01-11:25:26
HOSGIP for "HS_FDS_SHAREABLE_NAME" returned "/u01/app/TimesTen/tt1122/lib/libtten.so"
Entered hgolofns at 2012/02/01-11:25:26
libname=/u01/app/TimesTen/tt1122/lib/libtten.so, funcname=SQLAllocHandle
peflerr=6521, libname=/u01/app/TimesTen/tt1122/lib/libtten.so, funcname=SQLAllocHandle
hoaerr:28500
Exiting hgolofns at 2012/02/01-11:25:26
Failed to load ODBC library symbol: /u01/app/TimesTen/tt1122/lib/libtten.so(SQLAllocHandle)+
Exiting hgolofn, rc=28500 at 2012/02/01-11:25:26
Exiting hgoinit, rc=28500 with error ptr FILE:hgoinit.c LINE:417 FUNCTION:hgoinit() ID:Loading ODBC aray of function ptrs
Entered hgoexit
HS Gateway: NULL connection context at exit
Exiting hgoexit, rc=0 with error ptr FILE:hgoexit.c LINE:110 FUNCTION:hgoexit() ID:Connection context
Is there some additional odbc driver that i need ?
DataDirect doesn't has any drivers for timesten. Maybe there is some workaround ?