Problem Note 64584: The message "ERROR: General error ORA-01017: invalid username/password; logon denied" occurs when you use a caslib to connect to Oracle
When using a caslib to connect to Oracle with the SAS® Data Connector to Oracle, you might receive the following error:
ERROR: General error ORA-01017: invalid username/password; logon denied
This issue happens when RADIUS is configured to connect to the Oracle database. SAS Data Connector to Oracle passes double quotation marks around the password to RADIUS. Due to the quotation marks, RADIUS does not see the password as valid and generates the error.
Click the Hot Fix tab in this note for a link to instructions about accessing and applying the software update.
Operating System and Release Information
SAS System | SAS Data Connector to Oracle | Linux for x64 | V.03.03 | V.03.05 | Viya | Viya |
*
For software releases that are not yet generally available, the Fixed
Release is the software release in which the problem is planned to be
fixed.
Type: | Problem Note |
Priority: | high |
Date Modified: | 2019-11-01 09:35:08 |
Date Created: | 2019-08-08 11:30:30 |