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

From: RogerB <rogbak_er_at_yahoo.com>
Date: 7 Mar 2003 08:35:48 -0800
Message-ID: <b0defa1d.0303070835.41b761ba@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 - 10:35:48 CST