Re: SQL*Loader-704 ORA-12500 TNS:listener failed to start a dedicated server process

First of all it is possible to specify the TRUNCATE option directly in the SQL*Loader control file, so, unless you have very special requirements, there is no need to truncate the table in a separate script. If data volumes are nearly constant over time, I strongly encourage you to use the truncate option instead of running two scripts.

Assuming you have such special requirements, the error you get may be caused by an authentication problem caused by the user specified in the task scheduler.
When you run the job in the morning, are you running it under the same account?

Bye,
Flavio

"RogerB" <rogbak_er_at_yahoo.com> wrote in message news:b0defa1d.0303070835.41b761ba_at_posting.google.com...
> I have a Oracle 8i database on a Windows 2000 server. I have 2 nightly
> processes that run, they are Windows Scheduled tasks that run batch
> files. The first one Truncates a table, and the second task uses SQL
> Loader to load data into the table from a text file. The schedule
> tasks and the batch files are on the same server as the database.
> About every other night, the SQL Loader task fails with the following
> error message:
> ---------------
> SQL*Loader: Release 8.1.7.0.0 - Production on Fri Mar 7 00:04:00 2003
>
> (c) Copyright 2000 Oracle Corporation. All rights reserved.
>
> SQL*Loader-704: Internal error: ulconnect: OCIServerAttach [0]
> ORA-12500: TNS:listener failed to start a dedicated server process
> --------------
> The Truncate process runs at midnight, and the SQL Loader process runs
> 4 minutes later. When I come in in the morning, and run the batch
> process myself, it has no problems loading the table.
>
> Do I need to add another listener? I have done some research and I
> think this is sometimes related to resources. I have 2G memory on that
> machine, and at the time of morning that it runs, the database should
> have minimal activity.
>
> Thanks in advance for any insight,
> Roger
Received on Fri Mar 07 2003 - 11:54:12 CST