?
Solved

Oracle 11g Heterogeneous Services setup

Posted on 2012-03-20
2
Medium Priority
?
1,035 Views
Last Modified: 2012-04-15
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
0
Comment
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
2 Comments
 
LVL 16

Accepted Solution

by:
Wasim Akram Shaik earned 750 total points
ID: 37745878
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
 
LVL 12

Assisted Solution

by:Praveen Kumar Chandrashekatr
Praveen Kumar Chandrashekatr earned 750 total points
ID: 37759871
you can also refer the below doc on heterogeneous Services

http://www.in-oracle.com/Oracle-DBA/architecture/oracle-heterogeneous-services.php
0

Featured Post

What does it mean to be "Always On"?

Is your cloud always on? With an Always On cloud you won't have to worry about downtime for maintenance or software application code updates, ensuring that your bottom line isn't affected.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Introduction A previously published article on Experts Exchange ("Joins in Oracle", http://www.experts-exchange.com/Database/Oracle/A_8249-Joins-in-Oracle.html) makes a statement about "Oracle proprietary" joins and mixes the join syntax with gen…
This post first appeared at Oracleinaction  (http://oracleinaction.com/undo-and-redo-in-oracle/)by Anju Garg (Myself). I  will demonstrate that undo for DML’s is stored both in undo tablespace and online redo logs. Then, we will analyze the reaso…
This video explains at a high level with the mandatory Oracle Memory processes are as well as touching on some of the more common optional ones.
This video shows how to configure and send email from and Oracle database using both UTL_SMTP and UTL_MAIL, as well as comparing UTL_SMTP to a manual SMTP conversation with a mail server.
Suggested Courses

777 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question