SQL*Loader-128: unable to begin a session ORA-01017: invalid username/password; logon denied

Error:
Programs were erroring out with below error in concurrent program log


Arguments
————
/u01/prod/attach/1418160319478.txt
————
ORA-01017: invalid username/password; logon denied
SQL*Loader-704: Internal error: ulconnect: OCISessionBegin [-1]


SQL*Loader: Release 8.0.6.3.0 – Production on Tue Dec 9 22:59:13 2014


(c) Copyright 1999 Oracle Corporation.  All rights reserved.


ORA-01017: invalid username/password; logon denied
SQL*Loader-704: Internal error: ulconnect: OCISessionBegin [-1]


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


Review your concurrent request log file for more detailed information.




+—————————————————————————+
Executing request completion options…


Solution:


When we started trouble shooting we found below points.


– Parameter processes it has been changed from 1528 to 2000 in the init.ora file
– FNDSM log file is below the 2GB.
– The program hasn’t been scheduled by an ended user ( Bug 12896168 )
– Instance is using it’s own service name (Doc ID 1160553.1)
– Program executable permissions have been check
– Issue occurs in RAC and non RAC environments  


For our issue it was caused by the size of the FNDSM log which was over 2GB.
-rw-r–r–    1 appp14   oaa      2147483647 Dec  9 21:15 FNDSM257792.mgr


To fix the issue, we have truncated the file.
>   FNDSM257792.mgr


After that user ran the program and it got completed successfully.
  • April 19, 2016 | 19 views