OraFAQ Forum: Networking and Gateways » DB LINK USING INTERNET

Home » RDBMS Server » Networking and Gateways » DB LINK USING INTERNET (Oracle Database 10g Enterprise Edition Release 10.2.0.3.0 - Prod, WINDOWS 2003)

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

DB LINK USING INTERNET [message #604597]

Wed, 01 January 2014 16:16

hissam78
Messages: 193
Registered: August 2011
Location: PAKISTAN

Senior Member

Dear All,
can we link two oracle database servers via internet because we don't have LAN network between both the servers, both the servers in different location at kilometers distance.

is there any way to link both the oracle database servers using dblink via internet.

thanx

Report message to a moderator

Re: DB LINK USING INTERNET [message #604599 is a reply to message #604597]

Wed, 01 January 2014 17:02

BlackSwan
Messages: 26766
Registered: January 2009
Location: SoCal

Senior Member

>is there any way to link both the oracle database servers using dblink via internet.
yes, DB Link can be used to access a remote database.
Realize that if YOU can access the target DB from over the Internet; then I or anyone can access this database, too.
It is not wise to expose any DB Server system to the whole world over the Internet.

Report message to a moderator

Re: DB LINK USING INTERNET [message #604759 is a reply to message #604599]

Fri, 03 January 2014 17:45

hissam78
Messages: 193
Registered: August 2011
Location: PAKISTAN

Senior Member

Thanx for Reply dear,
Can you please guide me, what i need to do for db link for linking two databases via internet.

regards

Report message to a moderator

Re: DB LINK USING INTERNET [message #604823 is a reply to message #604759]

Sat, 04 January 2014 05:50

Littlefoot
Messages: 21823
Registered: June 2005
Location: Croatia, Europe

Senior Member
Account Moderator

A database link is created as follows:

create database link dbl_hissam 
connect to user1
identified by password1
using 'db1'

DB1 is a database alias which is to be found in TNSNAMES.ORA on your database server. It looks like this:

DB1=
  (DESCRIPTION=
    (ADDRESS=
      (PROTOCOL=TCP)
      (HOST=xxx.yyy.zzz.www)          --> IP address OR host name, e.g. (HOST=db1_server)
      (PORT=1521)
    )
    (CONNECT_DATA=
      (SERVICE_NAME=db1)
    )
  )

It means that servers must see each other over the internet. As I'm not a DBA or network guy, I can't tell for sure whether IP addresses must be static or not; someone else might know that. But, if you can mutually PING servers and TNSPING those databases, I believe that you're good to go.

Report message to a moderator

Re: DB LINK USING INTERNET [message #604845 is a reply to message #604823]

Sat, 04 January 2014 10:12

hissam78
Messages: 193
Registered: August 2011
Location: PAKISTAN

Senior Member

thanx a lot, littlefoot your technical guidance always very helpful.

Report message to a moderator

Re: DB LINK USING INTERNET [message #604945 is a reply to message #604759]

Mon, 06 January 2014 06:54

EdStevens
Messages: 1376
Registered: September 2013

Senior Member

hissam78 wrote on Fri, 03 January 2014 17:45

Thanx for Reply dear,
Can you please guide me, what i need to do for db link for linking two databases via internet.

regards

to reiterate the response from BlackSwan, I'd say the very first thing you need to link two databases via the internet is a careless attitude toward database security. I truly hope you never get your hands on a database that handles my 401(k).

Report message to a moderator

Previous Topic:	Read SQL Server table from Oracle
Next Topic:	Listener

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Thu Feb 06 23:44:13 CST 2025