My Oracle Support Banner

Concurrent Requests fail with SQL*Loader-101: Invalid Argument for username/password (Due to FNDSM Log File Size Grows 2 GB ) (Doc ID 1542216.1)

Last updated on NOVEMBER 03, 2016

Applies to:

Oracle Concurrent Processing - Version 11.5.10.2 to 12.1.3 [Release 11.5 to 12.1]
Information in this document applies to any platform.

Symptoms

Concurrent Requests are failing with SQL*Loader-101. Restart of the Concurrent Manager is a workaround which helps for some time. It is observed that the FNDSM log filling up quickly and reach to 2 GB and then the programs starting to fail. This might also prevent you from doing certain control functions like start and stop from "Administer Screen".

CONCURRENT REQUEST LOG FILE

SQL*Loader-101: Invalid argument for username/password

SQL*Loader: Release 10.1.0.5.0 - Production on Thu Mar 21 14:43:27 2013

Copyright (c) 1982, 2005, Oracle. All rights reserved.

SQL*Loader-101: Invalid argument for username/password

Program exited with status 1
Concurrent Manager encountered an error while running SQL*Loader for your concurrent request 15551589.

Review your concurrent request log file for more detailed information. 

FNDSM Log 

FNDSM log filling up quickly and reach to 2 GB and then Concurrent programs starting to fail:

Commit point reached - logical record count 4520 
Commit point reached - logical record count 4536 
Commit point reached - logical record count 4552 
Commit point reached - logical record count 4568 
Commit point reached - logical record count 4584

Changes

 Concurrent programs of type SQL*Loader are being used.

Cause

To view full details, sign in with your My Oracle Support account.

Don't have a My Oracle Support account? Click to get started!


In this Document
Symptoms
Changes
Cause
Solution
References


My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.