Results 1 to 3 of 3
  1. #1
    Join Date
    Jun 2005
    Posts
    3

    Unanswered: Accessing Oracle Database behing Firewall via DB-link

    I have an application running on a webserver outside a firewall (accessible from the internet).
    This application connects to Oracle database (DB-A) that is within the firewall. This connection works ok and able to fetch data from it after modifying the firewall to allow comunication btw the servers.

    However, from within the database DB-A, there are Synonyms that are linked to a second database (DB-B) on another server within the firewall.
    This is where the problem is. When the web application tries to fetch data from these Linked Synonyms, it fails!

    Please what could be the problem? Methink the firewall should not block the data from this 3rd server since the request should be coming from the DB-A server!

    Any help please?

  2. #2
    Join Date
    Aug 2003
    Location
    Where the Surf Meets the Turf @Del Mar, CA
    Posts
    7,776
    Provided Answers: 1
    >When the web application tries to fetch data from these Linked Synonyms, it fails!
    >since the request should be coming from the DB-A server!
    Make you your mind.
    From which system does the query REALLY originate?
    You can lead some folks to knowledge, but you can not make them think.
    The average person thinks he's above average!
    For most folks, they don't know, what they don't know.
    Good judgement comes from experience. Experience comes from bad judgement.

  3. #3
    Join Date
    Jun 2005
    Posts
    3
    Server WS-1 is the Webserver
    Server DB-A is the application database server
    Server DB-B is a data warehouse

    There are remote Synonyms in DB-A that points to objects in DB-B via a database link.

    The WS-1 connects directly to the DB-A database and send the queries. When WS-1 queries local objects in DB-A, all works well. But when WS-1 queries the remote Synonyms in DB-A, it fails to fetch records.

    This same setup works perfectly when we moved the WS-1 within the firewall.

Posting Permissions

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