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?

[Product update] Infrastructure Analysis Tool is now available with Business Accounts.Learn More

x
I wear a lot of hats...

"The solutions and answers provided on Experts Exchange have been extremely helpful to me over the last few years. I wear a lot of hats - Developer, Database Administrator, Help Desk, etc., so I know a lot of things but not a lot about one thing. Experts Exchange gives me answers from people who do know a lot about one thing, in a easy to use platform." -Todd S.

Wasim Akram ShaikCommented:
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

Experts Exchange Solution brought to you by

Your issues matter to us.

Facing a tech roadblock? Get the help and guidance you need from experienced professionals who care. Ask your question anytime, anywhere, with no hassle.

Start your 7-day free trial
Praveen Kumar ChandrashekatrDatabase 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
It's more than this solution.Get answers and train to solve all your tech problems - anytime, anywhere.Try it for free Edge Out The Competitionfor your dream job with proven skills and certifications.Get started today Stand Outas the employee with proven skills.Start learning today for free Move Your Career Forwardwith certification training in the latest technologies.Start your trial today
Oracle Database

From novice to tech pro — start learning today.