Home » RDBMS Server » Networking and Gateways » Urgence,Issue about transparent gateway to MSSQLServer (windows xp,oracle 10.2.0.1,transparent gateway 10.2)
icon2.gif  Urgence,Issue about transparent gateway to MSSQLServer [message #404995] Tue, 26 May 2009 00:46 Go to next message
wqq_chen
Messages: 2
Registered: May 2009
Junior Member
Envirenment:windowsxp + oracle 10.2.0.1 + oracle gateways:192.168.1.44
sqlserver2000:192.168.1.215
I installed the TG4MSQL in my windows XP,and the configuration showed below:
listener.ora

(SID_DESC =
(SID_NAME = sql2000)
(ORACLE_HOME = d:\oracle\product\10.2.0\db_1)
(PROGRAM = tg4msql)
)

tnsnames.ora

sql2k =
(DESCRIPTION=
(ADDRESS=(PROTOCOL=tcp)(HOST=192.168.1.44)(PORT=1521))
(CONNECT_DATA=(sid=sql2000))
(HS=OK)
)

initsql2000.ora

HS_FDS_CONNECT_INFO="SERVER=192.168.1.215;DATABASE=sql2000"
HS_FDS_TRACE_LEVEL=OFF
HS_FDS_RECOVERY_ACCOUNT=RECOVER
HS_FDS_RECOVERY_PWD=RECOVER

There is no problem while reload listener,and tnsping is ok.And I do the below steps:
SQL>create database link sql2000 connect to "sa" identified by "123456" using 'sql2k';
database link created
SQL>select count(*) from dbo.sysobjects@sql2000;
when I run the count script,there is response,and it's always in the runing state.
But I got the below error message from alert_primary.ora:
HS: Unable to update ORACLE DD to upload Foreign Data Store info
HS: FDS class = 'MSSQL10.2.0.1.0_200', FDS instance = 'sql2000'
HS: Failure occurred on create_fds_class() or create_fds_inst()

Is there Anyone could give some suggestions about the running state and the alert message?
And how to solve?
Thanks,waiting online.
Re: Urgence,Issue about transparent gateway to MSSQLServer [message #405149 is a reply to message #404995] Tue, 26 May 2009 10:18 Go to previous messageGo to next message
babuknb
Messages: 1734
Registered: December 2005
Location: NJ
Senior Member

http://www.dba-oracle.com/t_heterogeneous_database_connections_sql_server.htm

Babu
Re: Urgence,Issue about transparent gateway to MSSQLServer [message #405150 is a reply to message #404995] Tue, 26 May 2009 10:29 Go to previous messageGo to next message
BlackSwan
Messages: 23186
Registered: January 2009
Senior Member
Perhaps user SA has only SELECT privs & can not do DML in the SQLServer DB.
Re: Urgence,Issue about transparent gateway to MSSQLServer [message #405215 is a reply to message #405149] Wed, 27 May 2009 01:04 Go to previous messageGo to next message
wqq_chen
Messages: 2
Registered: May 2009
Junior Member
gentlebabu wrote on Tue, 26 May 2009 10:18

www dba-oracle com/t_heterogeneous_database_connections_sql_server.htm

Babu


Hello,gentlebabu
Thanks a lot for your article ,The issue has been solved.But I'm doubt about the part of ODBC installation.I'm not sure whether installing ODBC is nessesary,because I didn't do this step in my case,and this is not a problem.
Thanks again.
Re: Urgence,Issue about transparent gateway to MSSQLServer [message #405396 is a reply to message #405215] Wed, 27 May 2009 09:39 Go to previous message
babuknb
Messages: 1734
Registered: December 2005
Location: NJ
Senior Member

Thanks for the feedback

Babu
Previous Topic: service_name AND net_service_name
Next Topic: ORA-12518: TNS:listener could not hand off client connection.
Goto Forum:
  


Current Time: Fri Dec 26 14:50:09 CST 2014

Total time taken to generate the page: 0.32482 seconds