Oracle 11g Heterogeneous Services setup

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
Ravi Kiran Reddy KatkuriAnalyst ProgrammerAsked:
Who is Participating?
 
Wasim Akram ShaikConnect With a Mentor Commented:
Refer to one of the articles sdstuber has written in EE, this will help you


http://www.experts-exchange.com/Database/Oracle/A_9850-Configuring-and-using-Oracle-Database-Gateway-for-ODBC.html
0
 
Praveen Kumar ChandrashekatrConnect With a Mentor Database Analysist Senior Commented:
you can also refer the below doc on heterogeneous Services

http://www.in-oracle.com/Oracle-DBA/architecture/oracle-heterogeneous-services.php
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.