<div>
<div class="content wysiwyg-content">
Hi Experts,<br />
<br />
I have Oracle Database 11g Enterprise Edition Release 11.1.0.6.0 - 64bit Production (Windows platform).<br />
&nbsp; &nbsp; Now I have to communicate to remote database via ODBC. I know we need to use Heterogeneous Services. I am a Java Developer not DBA. I need simple step by step process to do this. <br />
<br />
I know about the link<br />
<a href="http://docs.oracle.com/cd/B28359_01/gateways.111/b31042/configodbc.htm" rel="ugc">http://docs.oracle.com/cd/B28359_01/gateways.111/b31042/configodbc.htm</a><br />
<br />
But I even want simple steps.<br />
Like, open listener.ora file do some stuff, open tnsnames.ora do some stuff....like this.<br />
<br />
Thanks,<br />
Ravi
</div>
</div>


Hi Experts,

I have Oracle Database 11g Enterprise Edition Release 11.1.0.6.0 - 64bit Production (Windows platform).
    Now I have to communicate to remote database via ODBC. I know we need to use Heterogeneous Services. I am a Java Developer not DBA. I need simple step by step process to do this. 

I know about the link
http://docs.oracle.com/cd/B28359_01/gateways.111/b31042/configodbc.htm

But I even want simple steps.
Like, open listener.ora file do some stuff, open tnsnames.ora do some stuff....like this.

Thanks,
Ravi

Oracle 11g Heterogeneous Services setup

Oracle is an object-relational database management system. It supports a large number of languages and application development frameworks. Its primary languages are SQL, PL/SQL and Java, but it also includes support for C and C++. Oracle also has its own enterprise modules and application server software.