SQLLoader + OWB + different OraHomes

From: VirVit <virvit_at_udm.ru>
Date: Tue, 19 Aug 2003 20:04:35 +0400
Message-ID: <bhtece$1a8u$1@hq.mark-itt.ru>

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 Tue Aug 19 2003 - 11:04:35 CDT