OCI DB SYSTEM:ORA-01017-sqlplus connection from windows client to OCI database
(Doc ID 2706728.1)
Last updated on OCTOBER 12, 2020
Applies to:Oracle Database - Enterprise Edition - Version 126.96.36.199 and later
Oracle Cloud Infrastructure - Database Service - Version N/A and later
Information in this document applies to any platform.
--- Connection from windows client to database is failing
SQL*Plus: Release 10.2.0.1.0 - Production on Wed Aug 26 12:53:22 2020
Copyright (c) 1982, 2005, Oracle. All rights reserved.
ORA-01017: invalid username/password; logon denied
--- Local sqlplus connection is working fine
$ sqlplus <username>/<password>@<Connect_string>
SQL*Plus: Release 188.8.131.52.0 - Production on Wed Aug 26 12:57:00 2020
Copyright (c) 1982, 2020, Oracle. All rights reserved.
Last Successful login time: Wed Aug 26 2020 12:21:48 +01:00
Oracle Database 19c Enterprise Edition Release 184.108.40.206.0 - Production
SQL> show user;
USER is "<USERNAME>"
---Issue with only one user and other database users able to connect both locally and remotely using service name
To view full details, sign in with your My Oracle Support account.
Don't have a My Oracle Support account? Click to get started!
In this Document