Skip to Main Content

Database Software

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

access to timesten via oracle gateway

729213Feb 1 2012 — edited Feb 3 2012
Hi.
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 ?
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Mar 2 2012
Added on Feb 1 2012
10 comments
614 views