Re: What are the ports involved with DB Link

From: <ed.stevens_at_comcast.net>
Date: 20 Apr 2005 05:24:30 -0700
Message-ID: <1113999870.263264.153600@g14g2000cwa.googlegroups.com>

Given DB01 (on server01) with a db_link to DB02 (on server02) ...

You connect to DB01 with sql*plus or any other tool. (SQL*Plus itself is not the operative factor here) The initial call is made to the listener on server01, which then sets up the connection on a random port. You then issue a SQL statement that references the link to DB02. To service this request DB01 (NOT your SQL*Plus session) makes a call to the listener on server02, on port 1521. Listener02 then sets up the connection on a random port. Notice that the 'client' to DB02 is NOT your sql*plus session. DB01 itself is the client requesting a connection to DB02.

Does this help, or did I mis-understand your question? Received on Wed Apr 20 2005 - 07:24:30 CDT