Re: SQLLoader + OWB + different OraHomes

After you have gotten the database working with TNS, after installing OWB in a different home, copy tnsnames.ora dn sqlnet.ora from the database $TNS_ADMIN to OWB TNS_ADMIN.

Then you must fully qualify your connection script on the OWB side. Yakub

VirVit wrote:
> Hello!
>
> I have troubles with Oracle Warehouse Builder (OWB). First was installed
> database in one "home", than OWB in another. Both separatelly and together
> works cool, but when I try to run mapping wich loads simple data from plain
> file to simple table I've got an error. SQLLoader return error code 3. It
> means fail. When I run sqlldr from OWB home it say
>
> c:\> sqlldr test/test_at_virvitdb control=PRICE_MAP
>
> SQL*Loader: Release 9.0.1.3.1 - Production on ˆ?Ü „ÔÕ 19 20:02:14 2003
> (c) Copyright 2001 Oracle Corporation. All rights reserved.
> SQL*Loader-704: Internal error: ulconnect: OCIServerAttach [0]
> ORA-12154: TNS:could not resolve service name
>
> Doing the same but in Database home succeeded!!!
>
> I think that troubles in Listener of OWB but I've already Database listener
> running perfectly.
>
> Sorry for english :-(
>
>
Received on Fri Sep 05 2003 - 23:32:07 CDT