Home » RDBMS Server » Networking and Gateways » Accessing Oracle Database behing Firewall via DB-link
Accessing Oracle Database behing Firewall via DB-link [message #191241] Tue, 05 September 2006 05:40 Go to next message
Messages: 1
Registered: September 2006
Junior Member
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!

In summary,
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.

Any help please?
Re: Accessing Oracle Database behing Firewall via DB-link [message #191273 is a reply to message #191241] Tue, 05 September 2006 07:52 Go to previous message
Messages: 201
Registered: August 2006
Location: Denmark
Senior Member

If You log on DB-A with fx. SQL*Plus, can You then query the synonyms that point to DB-B?

If this works, there should be no difference for Your application server. It cannot tell that whether it queries a normal table on DB-A or a synonym that points to DB-B.
When it queries a synonym, DB-A does the querying, and serves the result to Your webserver.

What error messages etc. do You get?

Previous Topic: "ORA-12500 TNS:Listerner failed to start the dedicated server process"
Next Topic: Able to connect via SERVICE_NAME, but not SID
Goto Forum:

Current Time: Tue Oct 25 14:12:10 CDT 2016

Total time taken to generate the page: 0.29294 seconds