Solved

Oracle 11g Heterogeneous Services setup

Posted on 2012-03-20
2
1,029 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
2 Comments
 
LVL 16

Accepted Solution

by:
Wasim Akram Shaik earned 250 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:praveencpk
praveencpk earned 250 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

Gigs: Get Your Project Delivered by an Expert

Select from freelancers specializing in everything from database administration to programming, who have proven themselves as experts in their field. Hire the best, collaborate easily, pay securely and get projects done right.

Question has a verified solution.

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

Suggested Solutions

Title # Comments Views Activity
Wrap Oraccle SQL*Plus executable Command 4 83
Problems using Provider=OraOLEDB.Oracle via VBScript/Classic ASP 5 66
help on oracle query 5 43
Can't Access My Database 57 63
Working with Network Access Control Lists in Oracle 11g (part 2) Part 1: http://www.e-e.com/A_8429.html Previously, I introduced the basics of network ACL's including how to create, delete and modify entries to allow and deny access.  For many‚Ķ
Using SQL Scripts we can save all the SQL queries as files that we use very frequently on our database later point of time. This is one of the feature present under SQL Workshop in Oracle Application Express.
This video shows how to copy a database user from one database to another user DBMS_METADATA.  It also shows how to copy a user's permissions and discusses password hash differences between Oracle 10g and 11g.
This videos aims to give the viewer a basic demonstration of how a user can query current session information by using the SYS_CONTEXT function

786 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