Results 1 to 3 of 3

Thread: SQL Loader

  1. #1
    Join Date
    Dec 2002
    Posts
    3

    Question Unanswered: SQL Loader

    Hello,

    I am currently using ORACLE7 on my NT workstation.

    I need to use SQL Loader, in this case sqlldr73, to load CSV file to the database.
    I've encounter with login problems;

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

    From the sqlnet log file:
    Fatal OSN connect error 12154, connecting to:
    {aliasname}/{password}

    VERSION INFORMATION:
    TNS for 32-bit Windows: Version 2.3.3.0.0 - Production
    Time: 18-DEC-02 10:26:30
    Tracing not turned on.

    TNSNAMES.ORA should be working fine as connections made with SQLPLUS is alright.

    Please help. Thanks
    Last edited by WorkDB; 12-18-02 at 02:23.

  2. #2
    Join Date
    Dec 2002
    Location
    Indonesia
    Posts
    6

    Post

    Check your TNSNAMES.ora, INIT.ora.

  3. #3
    Join Date
    Dec 2002
    Posts
    3

    Smile

    Hi there,

    I've found out the mistake.
    I've successfully run the loader w/o any problems.

    Thanks for your help!

Posting Permissions

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