My Oracle Support Banner

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 11.2.0.4 and later
Oracle Cloud Infrastructure - Database Service - Version N/A and later
Information in this document applies to any platform.

Symptoms

--- Connection from windows client to database is failing

C:\ORACLE\product\10.2.0\client_1\BIN>sqlplus <username>/<password>@<Connect_string>

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.

ERROR:
ORA-01017: invalid username/password; logon denied

--- Local sqlplus connection is working fine

$ sqlplus <username>/<password>@<Connect_string>

SQL*Plus: Release 19.0.0.0.0 - Production on Wed Aug 26 12:57:00 2020
Version 19.7.0.0.0

Copyright (c) 1982, 2020, Oracle. All rights reserved.

Last Successful login time: Wed Aug 26 2020 12:21:48 +01:00

Connected to:
Oracle Database 19c Enterprise Edition Release 19.0.0.0.0 - Production
Version 19.7.0.0.0

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

Changes

 NA

Cause

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
Symptoms
Changes
Cause
Solution


My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.