Problem with dblinks generated from Oracle Warehouse Builder
Hi,
I am using Oracle Warehouse Builder 9i to implement my data warehouse.
Normally, it generates dblinks containing a TNS reference:
create database link <hostname>@<connector>
connect to <user>
identified by <password>
using '<hostname>';
But sometimes it generates dblinks containing a TNS *definition* instead:
create database link <hostname>@<connector>
connect to <user>
identified by <password>
using '(DESCRIPTION=(ADDRESS_LIST=(ADDRESS=(PROTOCOL=TCP)
(HOST=<hostname>)(PORT=<port>)))
(CONNECT_DATA=(SERVICE_NAME=<service>))
)';
There are problems with the latter definition, but I have trouble finding how to avoid generating it. Oracle Support has so far not come up with a solution.
Has anyone else had this problem?
Regards,
Kai Quale
University of Oslo
Software/Hardware used:
Software/Hardware used:
ASKED:
May 12, 2004 11:19 AM
UPDATED:
May 14, 2004 6:07 AM
Answer Wiki:
But what is the actual problem ?
I use this form for my database links to be not dependent on tnsnames.ora stuff (we have several UNIX hosts with several Oracle instances and dummy DBAs who never keeps Oracle networking files in sync)
To see all answers submitted to the Answer Wiki: View Answer History.
There have been problems with SELECTs joining local and remote tables across these dblinks.
We are hoping the problems will be solved by a coming upgrade to OWB 9.2.0.4…
Rgds,
Kai