| Accessing Oracle Database behing Firewall via DB-link [message #191241] |
Tue, 05 September 2006 05:40  |
biggy
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  |
kimant
Messages: 201
Registered: August 2006
Location: Denmark
|
Senior Member |
|
|
Hi
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?
Br
Kim
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
