File creation error - insufficient system resources

[Yuan Burns]

We are running Oracle Database on Windows 2000 Advanced
Server SP4. I scheduled an OS job via Schedule Tasks GUI
to backup the database (offline backup) weekly. However,
the task was never completed fully for the last 3 weeks.

To diagnose the problem, I kicked off the job manually.
I sat there and watch the process to xcopy 30 datafiles
each of them is about 2GB in size ).
After completing about 15 datafiles, the following error
occurred:

File creation error - insufficient system resources exist
for the requested serives.

The script was aborted as soon as the error occurred. I
checked the disk spaces, temp folder, and everything. I
could not find anything suspecious.

The server has 8 CPUs and 12 GB memory. I don't understand
why the system resource is an issue.

If you have an answer for me, please send me an email to
the two email addresses below:

(e-mail address removed)
(e-mail address removed)

Thanks a lot!

 

[Mark Beauchamp]

I've run into a very similar issue. In this case, copying
a 115GB file from a remote server to a local 7.5TB
filesystem. The copy fails at approximately 86GB with the
error "Insufficient system resources exist to complete
the requested service". 1.6TB is available on the
destination filesytem. Additional system info is
included below.

System Summary:
Item Value
OS Name Microsoft Windows 2000 Advanced Server
Version 5.0.2195 Service Pack 4 Build 2195
OS Manufacturer Microsoft Corporation
System Name MSSMDS00
System Manufacturer HP
System Model ProLiant DL380 G3
System Type X86-based PC
Processor x86 Family 15 Model 2 Stepping 9
GenuineIntel ~2382 Mhz
Processor x86 Family 15 Model 2 Stepping 9
GenuineIntel ~2382 Mhz
Processor x86 Family 15 Model 2 Stepping 9
GenuineIntel ~2382 Mhz
Processor x86 Family 15 Model 2 Stepping 9
GenuineIntel ~2382 Mhz
BIOS Version 07/25/03
Windows Directory C:\WINNT
System Directory C:\WINNT\system32
Boot Device \Device\Harddisk0\Partition1
Locale United States
User Name MSSMDS00\markbeau
Time Zone Pacific Standard Time
Total Physical Memory 1,572,372 KB
Available Physical Memory 846,516 KB
Total Virtual Memory 4,039,568 KB
Available Virtual Memory 2,993,416 KB
Page File Space 2,467,196 KB
Page File C:\pagefile.sys

Any pointers appreciated.

Thanks,

-Mark Beauchamp