Skip to Main Content

Oracle Database Discussions

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

ORA-01017: invalid username/password in Oracle 12.2

Frank KulashAug 15 2017 — edited Aug 15 2017

Hi.

In Oracle 12.2.0.1.0, I can CONNECT / AS SYSDBA in SQL*Plus and say

ALTER USERĀ  FOO IDENTIFIED BY FUBAR;

and it tells me "user altered", but when I try

CONN FOO/FUBAR

i get the error message "ORA-01017: invalid username/password; logon denied".

I used all capital letters in all the commands, and I've done

ALTER SYSTEM SET SEC_CASE_SENSITIVE_LOGIN=FALSE SCOPE=BOTH

anyway.

I get the same problem with other users (including newly created users), longer and more complicated passwords, and whether or not I explicitly use @SID.

What am I doing wrong?

This post has been answered by Vlad Visan-Oracle on Aug 15 2017
Jump to Answer
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Sep 12 2017
Added on Aug 15 2017
14 comments
3,825 views