Re: sqlldr error

From: Billy Verreynne <vslabs_at_onwe.co.za>
Date: Thu, 10 Feb 2000 08:50:15 +0200
Message-ID: <87tn3g$r6b$1@ctb-nnrp1.saix.net>

kevinator_ca_at_my-deja.com wrote in message <87srrg$59a$1_at_nnrp1.deja.com>...
> I'm getting an error "ora-3121 : no interface driver connected -
>function not performed" from a sqlldr-925 error. I'm running Oracle 8i
>on NT with an Oracle 8.0.5 client on Windows 98 . Any ideas why?

Yes, there's no interface driver. Like the error message says. :-)

Check the SQL*Net/Net80 installation on the client and make sure it is working. In addition to SQl8Net, you will need one of Oracle's "protocol transport" drivers. TCP/IP, IPX or whatever. I assume it will be TCP/IP in your case. Best way to check is to fire up the Oracle Installer on the client and see what products are installed.

Then you need to configure TNSNAMES.ORA on the client and define a TNS entry for the NT Oracle database. Then test this using TNSPING (or TNSPING80 for Oracle 8 I think) to test the networking components.

Then try SQL*Loader again.

Billy Received on Thu Feb 10 2000 - 00:50:15 CST