Re: 19g SQL*Loader difficulties

"Ian" <ian_stephenson(@)hotmail.com> wrote:

>Please disregard this request for assistance. Apart from elevating 10g to
>19g, I found the answer to my query on http://www.orafaq.com/, which is a
>resource I had not known about before. The resolution to the problem was
>simple - 2 tnsnames.ora files on the server which had differing entries. I
>updated both files with similar entries and the problem is now resolved.
>
>Regards,
>Ian
>
>"Ian" <ian_stephenson(@)hotmail.com> wrote in message
>news:41214299_at_derwent.nt.tas.gov.au...
>> Hallo,
>>
>> Environment: 10g database server + 9i database on notebook.
>>
>> Task: Uploading csv file to Oracle database table using sqlldr.exe
>utility.
>> This is my first attempt at doing this task however I am using the Orielly
>> text "Oracle SQL*Loader - The Definitive Guide".
>>
>> Problem: On the 10g database server when running sqlldr with the ctl file
>> containing all of the various paremeters the following error is reported:
>>
>> SQL*Loader: Release 10.1.0.2.0 - Production on Tue Aug 17 09:21:38 2004
>>
>> Copyright (c) 1982, 2004, Oracle. All rights reserved.
>>
>> SQL*Loader-704: Internal error: ulconnect: OCIServerAttach [0]
>> ORA-12560: TNS:protocol adapter error
>>
>> Comment: Please note that exactly the same script running on the notebook
>> with 9i works. Also, and this is where I am getting lost, I can run
>exactly
>> the same script on the notebook but set to update the tables on the 10g
>> server and it works without an errors. As noted above, if the script is
>run
>> on the 10g server then the above error is returned. All of the logon
>> permissions are exactly the same on both databases.
>>
>> Many thanks for your assistance.
>>
>> Regards,
>> Ian
>>
>>
>>
>>
>

To help avoid this in the future create an environment variable called TNS_ADMIN and set it to the path to your preferred tnsnames.ora file like:
 TNS_ADMIN = 'c:\oracle\oracle10\network\admin'

This way all Oracle products on that machine will look in that directory for the tnsnames.ora file so it is the only one that needs to be correct ( you can delete the others)

hth Received on Tue Aug 17 2004 - 08:48:14 CDT