MS SQL 2000 to Oracle 9R2
Hi all!
I'm try to connect from Oracle to MS SQL 2000 (all in WIN NT4)
but get
ORA-28508: invalid value OSTRA-KIEV.OFFICE for Heterogeneous Services initialization parameter HS_DB_DOMAIN
My config files:
listener.ora:
LISTENER =
(DESCRIPTION_LIST =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = TCP)(HOST = Yazenok)(PORT = 1521))
)
)
SID_LIST_LISTENER =
(SID_LIST =
(SID_DESC =
(ORACLE_HOME = D:\Oracle)
(SID_NAME = zmey)
)
(SID_DESC =
(PROGRAM = tg4msql)
(SID_NAME = tg4msql)
(ORACLE_HOME = d:\oracle)
)
)
tnsnames.ora:
ZMEY.OSTRA-KIEV.OFFICE =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = Yazenok)(PORT = 1521))
)
(CONNECT_DATA =
(SID = zmey)
(GLOBAL_NAME = ZMEY)
)
)
TG4MSQL.OSTRA-KIEV.OFFICE =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = Yazenok)(PORT = 1521))
)
(CONNECT_DATA =
(SID = tg4msql)
(GLOBAL_NAME = tg4msql)
)
(HS = OK)
)
INSUR.OSTRA-KIEV.OFFICE =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = solaris)(PORT = 1521))
)
(CONNECT_DATA =
(SID = INSUR)
(SERVER = SHARED)
(GLOBAL_NAME = insur)
)
)
inittg4msql.ora:
HS_FDS_CONNECT_INFO="SERVER=ZMEY;DATABASE=insurance"
HS_FDS_TRACE_LEVEL = DEBUG
HS_FDS_RECOVERY_ACCOUNT=insur
HS_FDS_RECOVERY_PWD=insur
HS_DB_NAME=TG4MSQL
HS_DB_DOMAIN="OSTRA-KIEV.OFFICE"
Could anybody tell me what I'm doing wrong on this?
Thanks.