Problem
When a program is executed to connect to oracle the error ‘Oracle Error 01017 (username/passwd invalid).’ is shown.
The Oracle Database is Oracle V.12.1.0.2 and the parameters with username and password are correct. Yet the error indicates it is incorrect.
Resolution
In Oracle 12 the default option parameter TRIM_PASSWORD=YES.
Changing the PIC length for the field 'PASSWD' with the exact length (without trailing blanks) resolved this issue.
#MFDS
#EnterpriseDeveloper
