CODEWITHSUNDEEP
oracle-databaseoracle11goracle10gdblink
Morteza
Morteza

Reputation: 55

Connect to an oracle instance from another oracle instance on different servers

How to create a DB link between two Oracle instances on different servers with different IPs. let say A (10g with e.g. 192.168.1.1) and B (11g with e.g. 192.168.1.2) are two instances. I want to access the data in instance A from the instance B.

Upvotes: 1

Views: 1775

Answers (1)

Littlefoot
Littlefoot

Reputation: 142710

People usually edit TNSNAMES.ORA and include database B alias in there, and then

create database link dblink
  connect to username_on_B
  identified by password_on_B
  using 'database_B_tnsnames_ora_alias';

Or, without TNSNAMES.ORA, something like this:

create database link dblink
 connect to username_on_B
 identified by password_on_B
 using '192.168.1.2:1521/dbB_service_name';
                    ----
                    port

Upvotes: 1

Related Questions