Skip to Main Content

Oracle Database Discussions

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!

MS SQL 2000 to Oracle 9R2

397706Jun 26 2003
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.
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Jul 24 2003
Added on Jun 26 2003
0 comments
323 views