Problem Note 48751: Bulk-loading data from SASĀ® into Oracle fails and returns an "invalid username/password" error
The following error might occur when using SAS on a UNIX platform and bulk-loading data into Oracle:
SQL*Loader-128: unable to begin a session
ORA-01017: invalid username/password; logon denied
The error occurs if the Oracle user's password provided in the LIBNAME statement contains a dollar sign ($). The problem occurs because the user ID/password string used to call the Oracle SQL*Loader utility is not within quotation marks.
To work around the problem, do not use dollar signs in the Oracle user password.
Click the Hot Fix tab in this note to access the hot fix for this issue.
Operating System and Release Information
SAS System | SAS/ACCESS Interface to Oracle | Solaris for x64 | 9.3 TS1M2 | 9.4 TS1M0 |
Linux for x64 | 9.3 TS1M2 | 9.4 TS1M0 |
Linux | 9.3 TS1M2 | 9.4 TS1M0 |
HP-UX IPF | 9.3 TS1M2 | 9.4 TS1M0 |
64-bit Enabled Solaris | 9.3 TS1M2 | 9.4 TS1M0 |
64-bit Enabled HP-UX | 9.3 TS1M2 | 9.4 TS1M0 |
64-bit Enabled AIX | 9.3 TS1M2 | 9.4 TS1M0 |
*
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: | medium |
Date Modified: | 2014-03-03 09:07:28 |
Date Created: | 2012-12-19 09:27:07 |