Stay at Home!! Be Safe!! Take Care!!

Thanks all my viewers for your support, I am an Oracle Ace now. For Any queries, please mail us at support@funoracleapps.com

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

No comments

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


When running SQL loader concurrent request, we are seeing below error.

Error:

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

SQL*Loader: Release 10.1.0.5.0 - Production on Wed Jun 24 14:08:27 2020

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

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


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


Cause:

Service Manager logfile (for all managers started by FNDSM). This causes FNDSM log to grow to enormous size 2 GB

$ du -sh FNDSM2342760.mgr
2.1G    FNDSM2342760.mgr


Workaround:

Workaround 1: Restart Concurrent Managers

Workaround 2: Take backup of the file and nullify the file to reduce the size.

$ >FNDSM2342760.mgr


Also you can refer below Oracle Doc for more details and other solution

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)



No comments :

Post a Comment