Home » RDBMS Server » Networking and Gateways » DB LINK USING INTERNET (Oracle Database 10g Enterprise Edition Release 10.2.0.3.0 - Prod, WINDOWS 2003)
DB LINK USING INTERNET [message #604597] Wed, 01 January 2014 16:16 Go to next message
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

Re: DB LINK USING INTERNET [message #604599 is a reply to message #604597] Wed, 01 January 2014 17:02 Go to previous messageGo to next message
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.
Re: DB LINK USING INTERNET [message #604759 is a reply to message #604599] Fri, 03 January 2014 17:45 Go to previous messageGo to next message
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
Re: DB LINK USING INTERNET [message #604823 is a reply to message #604759] Sat, 04 January 2014 05:50 Go to previous messageGo to next message
Littlefoot
Messages: 21806
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.
Re: DB LINK USING INTERNET [message #604845 is a reply to message #604823] Sat, 04 January 2014 10:12 Go to previous messageGo to next message
hissam78
Messages: 193
Registered: August 2011
Location: PAKISTAN
Senior Member
thanx a lot, littlefoot your technical guidance always very helpful.
Re: DB LINK USING INTERNET [message #604945 is a reply to message #604759] Mon, 06 January 2014 06:54 Go to previous message
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).
Previous Topic: Read SQL Server table from Oracle
Next Topic: Listener
Goto Forum:
  


Current Time: Thu Mar 28 07:08:37 CDT 2024