dblink port info
DBAsupport.com Forums - Powered by vBulletin
Results 1 to 5 of 5

Thread: dblink port info

  1. #1
    Join Date
    May 2002
    Location
    USA
    Posts
    462

    dblink port info

    Hi friends ,

    i want to create dblink to one of our database, which is used to store web application data .

    for some reason security/firewall setting i am not able to connect using dblink or connect scting ..

    1) which port numbers do i need to enable to make connection ?
    2) is it a single port all the time or does it pick up randomly ?
    3) what problems can we encounter by opening ports ..

    appreciate your help regarding this ..

  2. #2
    Join Date
    Aug 2002
    Location
    Atlanta
    Posts
    1,187

    Re: dblink port info

    Originally posted by prakashs43
    Hi friends ,

    i want to create dblink to one of our database, which is used to store web application data .

    for some reason security/firewall setting i am not able to connect using dblink or connect scting ..

    1) which port numbers do i need to enable to make connection ?
    2) is it a single port all the time or does it pick up randomly ?
    3) what problems can we encounter by opening ports ..

    appreciate your help regarding this ..
    what platform? what kind of firewall?

    you can always set a net trace to see if any port redirection is happening under the covers of the OS. Port redirecton is expected behavior on windooze although some firewalls can accomidate thie
    I'm stmontgo and I approve of this message

  3. #3
    Join Date
    Nov 2000
    Location
    greenwich.ct.us
    Posts
    9,095
    DB Link work from tnsnames.ora. If you can use sqlplus to connect, you can use dblink. You will probably need to setup a connection manager or sqlnet proxy on your firewall to connect. More details would be helpful.
    Jeff Hunter
    marist89@yahoo.com
    http://marist89.blogspot.com/
    Get Firefox!
    "I pledge to stop eating sharks fin soup and will not do so under any circumstances."

  4. #4
    Join Date
    May 2002
    Location
    USA
    Posts
    462
    This is solaris Operating system

    i am not able to do sqlplus using connect string to remote database .
    I am sure it is fro security reasons/ and firewall settings that i am not able to do sqlplus using connect string ..

    if i have to approach network guys to enable port ..

    what port should i have to tell them to enable . in order to make dblink work ...

    this is an 8.1.6.3 database .
    Hi marist do i need to install is connection manager seperately or does it already installed with database ...

    thanks for your advice

  5. #5
    Join Date
    Nov 2000
    Location
    greenwich.ct.us
    Posts
    9,095
    Connection manager does not sit on the database host, therefore it doesn't matter if it is installed or not.

    Basically the way connection manager works is:
    1. your firewall guys open up a port and forward it to a host:port. That host:port is the host:port of your connection manager. It doesn't matter what port they open up on the firewall as long as it is forwarded to your connection manager.

    2. Your connection manager redirects your connection request to the database host.

    3. Database receives the connect request and sets up a connection with the connection manager host on your behalf.

    4. connection manager shoves your data back through the firewall on the port you specify.

    You have to setup connection manager behind the firewall and you have to tweak with your tnsnames.ora on the "client" (in this case your other db host) in order to get this to work. If you can connect through sqlplus from the "client", then you can connect through dblink.
    Jeff Hunter
    marist89@yahoo.com
    http://marist89.blogspot.com/
    Get Firefox!
    "I pledge to stop eating sharks fin soup and will not do so under any circumstances."

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  



Click Here to Expand Forum to Full Width