CODEWITHSUNDEEP
oracle-databaseauthenticationora-01017
Marcell
Marcell

Reputation: 949

Oracle denies login for newly created users

I came across this issue setting up new users for a German Oracle 18c Enterprise database. All of a sudden the logon is denied for any newly created user. See below:

connect updatest/1234567@orcl18c;

Fehler beim Start in Zeile: 3 in Befehl -
  connect ...
Fehlerbericht -
Verbindung konnte nicht hergestellt werden
  USER          = updatest
  URL           = jdbc:oracle:thin:@(DESCRIPTION =    (ADDRESS = (PROTOCOL = TCP)(HOST = QM-DB.GERADLINIG.com)(PORT = 1521))    (ADDRESS = (PROTOCOL = TCP)(HOST = ***.com)(PORT = 15218))    (CONNECT_DATA =      (SERVER = DEDICATED)      (SERVICE_NAME = orcl18c.***)    )  )
  Fehlermeldung = ORA-01017: Benutzername/Kennwort ungültig; Anmeldung abgelehnt
Commit

select * from dba_sys_privs where grantee='updatest';

enter image description here

Whereas I can login with a similar user that was created some weeks earlier. See here:

connect qm_ta_12.1/1234567@orcl18c;

Angemeldet.
Mit CONNECT-Skriptbefehl erstellte Verbindung beendet

They have the same system privileges! I ran out of ideas what could be the problem as the password is 100% correct.

Upvotes: 1

Views: 526

Answers (2)

Marcell
Marcell

Reputation: 949

The username was converted to uppercase by Oracle internally without any signs of it. I guess I will stick to using only uppercase letters for usernames in Oracle to avoid running in this dilemma again.

Upvotes: 0

Littlefoot
Littlefoot

Reputation: 142720

At the first sight, looks pretty obvious:

Fehlermeldung = ORA-01017

ORA-01017 means invalid username/password.

Upvotes: 2

Related Questions