| Oracle 12c Uppercase Username [message #640] |
Tue, 01 October 2019 21:14  |
JimLo
Messages: 1
Registered: October 2019
Location: PA USA
|
Junior Member |
|
|
Today i downloaded Datawarrior 5.0.0 and tried to connect to an oracle 12.2 database. Initially I got a ORA-28040: No matching authentication protocol error. Google suggested either an oracle server change to Sqlnet.ora adding SQLNET.ALLOWED_LOGON_VERSION_SERVER=8, or updating the ojdbcX.jar file on the client. Since I have DBA access to the server I did the former and the error disappeared.
It was then replaced by a ORA-1017 Invalid Username or Password error. probably caused by my username and password being upper case (Oracle became case-sensitive after v11). This is probably a bug. The only workaround I found was to create a new oracle user with lower case name and password and grant it permissions on the tables of interest.
JimLo
Arxspan
|
|
|
|
Search
Help
Members
Register
Login
Home
