DBAsupport.com Forums - Powered by vBulletin
Results 1 to 2 of 2
  1. #1
    Join Date
    Jul 2001

    SQL*Loader Error

    I can login properly using sql*plus, but when I invoke sql*loader I get this below error.How to resolve this issue. (I am not dba)

    SQL*Loader: Release - Production on Thu Jun 05 15:49:39 2003

    Copyright (c) Oracle Corporation 1979, 1996. All rights reserved.

    SQL*Loader-925: Error while logging on to ORACLE (ulmconnect)
    ORA-12154: TNS:could not resolve service name

    Run began on Thu Jun 05 15:49:39 2003
    Run ended on Thu Jun 05 15:49:40 2003

    Elapsed time was: 00:00:00.50
    CPU time was: 00:00:00.00 (May not include ORACLE CPU time)

  2. #2
    Join Date
    Feb 2000
    Do you have multiple Oracle Home or Multiple tnsnames.ora on the machine you are runnind SQL*Loader ?
    Sanjay G.
    Oracle Certified Professional 8i, 9i.

    "The degree of normality in a database is inversely proportional to that of its DBA"

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Click Here to Expand Forum to Full Width

We have made updates to our Privacy Policy to reflect the implementation of the General Data Protection Regulation.