Current Position:Home > Database Link - What ports are used?

Database Link - What ports are used?

Update:11-30Source: network consolidation
Advertisement
I am attempting to create a database link from a very locked down server (Database A) to Database B which is on my internal network.
Can someone tell me what ports I need to open in the firewall for a database link to work correctly? My Database B instance is a XE instance running on the default port 1521.
Thanks,

The Best Answer

Advertisement
avalanche333 wrote:
I am attempting to create a database link from a very locked down server (Database A) to Database B which is on my internal network.
Can someone tell me what ports I need to open in the firewall for a database link to work correctly? My Database B instance is a XE instance running on the default port 1521.
Thanks,Hans and Devotee have given you the best info so far. I'd like to expand and clarify slightly on their comments.
There is really nothing special about a db-link. It is just another client process, being used by the 'client' database. It uses exactly the same networking pieces as does sqlplus on the same machine. All of the same considerations are there ... tnsnames.ora on the client machine matching up with the listener configuration on the target machine, listener ports, port redirection for establishing the actual server process, etc. I would start by getting a sqlplus connection working. When you have that, you know you have all of your network configuration issues resolved. At that point any issues you have with the dblink will be in the link definition itself.
And as Hans pointed out, databases don't run on port 1521. It is a conceptual mistake to think of the database as "running" on any port. By default the listener uses port 1521 to listen for connection requests. The database knows nothing about that. It is also very easy, and not that uncommon, to configure the listener to use another port instead of or in addition to 1521, so it is also a mistake to treat port 1521 as if it were some immutable value.
  • Database Link - What ports are used? Update:11-30

    I am attempting to create a database link from a very locked down server (Database A) to Database B which is on my internal network. Can someone tell me what ports I need to open in the firewall for a database link to work correctly? My Database B in

  • Database link TCP ports Update:11-30

    We installed database link between two Oracle databases. Does anybody know on whitch TCP port it communicate ? I know only about port 1521. Problem is that we have firewall between computers and we need to enable Oracle communication between them.ava

  • Using database-link in view to get around ORA-01031 error Update:10-11

    I have been granted select rights on a users table. I am therefore able to select from his table. If however I try create a view against his table I run into the ORA-01031 problem. I have worked around this problem by creating a database-link to myse

  • Not able to create a database link using the database gateway of oracle 11g Update:10-11

    HI, While trying to create a database link to SQL server from Oracle ,using the database gateway provided with 11g, i am getting the following error while making use of it in selecting columns from tables : Error starting at line 1 in command: select

  • Unable to access remote database object using database link Update:10-11

    Hi all, I have created a database link to a remote server SQL> create database link remote_link connect to lax_dba identified by lax_dba using 'abc.corp.com'; database link created when i am trying to access any table of lax_dba sql> select * from l

  • Failed to create Database Link in OWB 9.2 for remote SQL Server Update:10-11

    Hi, I have to create Database link for connecting to SQL server in a different machine.I am using OWB 9.2 and XP. Dataserver is the machine name which is running SQL Server I included follwing lines in TNSNAMES.ORA file hsodbc.world = (DESCRIPTION =

  • Timeout when using database link connecting to a remote database Update:10-11

    Hi, I have another strange problem. I have two computers A and B. Both have an Oracle database server instance. I manage the one in B (which is my local computer) but not the one in A (which is a computer where I have a user account and an Oracle acc

  • Problems in using database link Update:10-11

    Hi all, I have problems in using the following created database link: Name: fzanalyze User: fzanalyze PWD: xxx Host: fz.domain.com I get the following error message, if I try to start this select: select * from [email protected]; FEHLER in Zeile 1: ORA-1

  • How to Execute a Remote Procedure in Portal using Database Link Update:10-11

    Hi, I followed the instructions to create a Portal form for a remote procedure. But I am encountering the following error. Can someone advise what may be the cause? Failed to execute - Missing string(create_package_body) language(us) domain (wwv) sub

  • Database link from 11g to 10g Update:10-11

    I am trying to create a database link from the 11g database to the 10g database using: create database link ORCL10R2 connect to <username10g> identified by <password10g> using <db10g>; It Returns Database link created. select sysdate fro