SUPPORT / SAMPLES & SAS NOTES
 

Support

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

DetailsHotfixAboutRate It

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

Product FamilyProductSystemProduct ReleaseSAS Release
ReportedFixed*ReportedFixed*
SAS SystemSAS Data Connector to OracleLinux for x64V.03.03V.03.05ViyaViya
* 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.