Home » RDBMS Server » Networking and Gateways » Heterogeneous services
Heterogeneous services [message #498855] Fri, 11 March 2011 11:14 Go to next message
infinitenumbers
Messages: 33
Registered: November 2010
Member
Hi Guys,

I was trying to connect to SQL server from Oracle using Oracle heterogeneous services (HS).

But I found that I do not have HS installed on my system. It was mentioned in Oracle website that we need to run 'caths.sql' script under the path $ORACLE_HOME/rdbms/admin.

But I do not have any such folder(rdbms) in my $ORACLE_HOME.

What does it mean? And how can I install HS alone on my system(Since I already have oracle)


Please help me with it.

Thank you very much for your time.
Re: Heterogeneous services [message #498856 is a reply to message #498855] Fri, 11 March 2011 11:19 Go to previous messageGo to next message
Michel Cadot
Messages: 67464
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
Which version and edition of Oracle have you?

Regards
Michel
Re: Heterogeneous services [message #498858 is a reply to message #498856] Fri, 11 March 2011 11:23 Go to previous messageGo to next message
infinitenumbers
Messages: 33
Registered: November 2010
Member
I have Oracle 10G (10.2.0)

[Updated on: Fri, 11 March 2011 11:31]

Report message to a moderator

Re: Heterogeneous services [message #498859 is a reply to message #498858] Fri, 11 March 2011 11:37 Go to previous messageGo to next message
Michel Cadot
Messages: 67464
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
which edition?
Post result of
select * from v$version;

Regards
Michel
Re: Heterogeneous services [message #498863 is a reply to message #498859] Fri, 11 March 2011 12:19 Go to previous message
infinitenumbers
Messages: 33
Registered: November 2010
Member
Hi Michel,

This is the result:


BANNER
----------------------------------------------------------------
Oracle Database 10g Enterprise Edition Release 10.2.0.4.0 - 64bi
PL/SQL Release 10.2.0.4.0 - Production
CORE 10.2.0.4.0 Production
TNS for HPUX: Version 10.2.0.4.0 - Production
NLSRTL Version 10.2.0.4.0 - Production
Previous Topic: Database Link Failing with ORA-28500
Next Topic: TNSPING HOSTNAME gives error
Goto Forum:
  


Current Time: Sun Oct 25 11:50:43 CDT 2020