Oracle Database Discussions

Hi

I recently made a connection from oracle9i (solrais 10) to sql server 2000(V 8.0).
I'm encountering following issue, if someone could help me that would really great.

SQL Error: ORA-28536: error in processing Heterogeneous Services initialization parameters
ORA-28508: invalid value TITANSTAGE for Heterogeneous Services initialization parameter HS_DB_NAME
ORA-02063: preceding 2 lines from TITANSTAGE
28536. 00000 - "error in processing Heterogeneous Services initialization parameters"
*Cause: An error described by a subsequent error message
prevented successful processing of Heterogeneous Services
initialization parameters from the ORACLE server data dictionary.
*Action: Check server data dictionary views HS_CLASS_INIT, HS_INST_INIT, and
HS_ALL_INITS. Look for conditions which could produce
the error identified in the error message immediately
following this one.


Below is the listener.ora

LISTENER =
(DESCRIPTION_LIST =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = TCP)(HOST = shark)(PORT = 1521))
)
(DESCRIPTION =
(ADDRESS = (PROTOCOL = TCP)(HOST = shark)(PORT = 1523))
)
)
SID_LIST_LISTENER =
(SID_LIST =
(SID_DESC =
(SID_NAME = hsmsql)
(ORACLE_HOME = /z01/app/oracle/product/9.2.0.7)
(PROGRAM = hsodbc)
)
(SID_DESC =
(PROGRAM = hsodbc)
(ORACLE_HOME = /z01/app/oracle/product/9.2.0.7)
(SID_NAME = ititanstage)
)
)

Tnsnames.ora


hstitanstage=
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS =
(PROTOCOL = TCP)
(HOST = 135.63.14.54)
(PORT = 1521)
)
)
(CONNECT_DATA =
(SID =ititanstage)
)
(HS=)
)

Value from initititanstage.ora


# This is a sample agent init file that contains the HS parameters that are
# needed for an ODBC Agent.
#
# HS init parameters
#
HS_FDS_CONNECT_INFO = titan
HS_DB_NAME = TITANSTAGE
#HS_DB_DOMAIN= 10.32.130.52
#HS_FDS_TRACE_LEVEL = 4
HS_FDS_SHAREABLE_NAME=/usr/openlink/lib/libiodbc.so
HS_FDS_TRACE_FILE_NAME = /tmp/HSODBC/iniths9i.trc
#HS_OPEN_CURSORS=2
#
# ODBC specific environment variables
set ODBCINSTINI=/usr/openlink/bin/odbcinst.ini
set ODBCINI=/usr/openlink/bin/odbc.ini
#
# Environment variables required for the non-Oracle system
#
#set <envvar>=<value>
set OPENLINKINI=/usr/openlink/bin/openlink.ini
set FREETDSCONF=/usr/openlink/bin/freetds.conf
set OPL_LICENSE_DIR=/usr/openlink/bin
set LD_LIBRARY_PATH=$LD_LIBRARY_PATH:/usr/openlink/lib
set PATH=$PATH:/usr/openlink/bin


odbc.ini

[titan]
Driver = /usr/openlink/lib/sql_mt_lt.so
ServerType = SQLServer 2000
Username = reader
Password = reader
Database = titanstage
Options = -H 135.63.14.153 -P 1433 -V 8.0
FetchBufferSize = 99
ReadOnly = no
DeferLongFetch = no
JetFix = no
Description = Titanstage SQLServer 2000 Lite Connection