Database Administration (MOSC)

MOSC Banner

Getting ora-01017 invalid username after a brand new installation of Oracle 19.21

Hello,

Just installed a a brand new installation of Oracle 19.21 on windows server 2019 and I am getting ora-01017 invalid username after any new created username.

The init parameter sec_case_sensitive_logon = FALSE.

The command is simple:

SQL> CREATE USER u1 IDENTIFIED BY u1 HTTP DIGEST DISABLE;

User created.

SQL>

SQL> GRANT "CONNECT" TO u1;

Grant succeeded.

SQL> GRANT "RESOURCE" TO u1;

Grant succeeded.

SQL> ALTER USER u1 DEFAULT ROLE ALL;

User altered.

SQL> exit

Disconnected from Oracle Database 19c Enterprise Edition Release 19.0.0.0.0 - Production

Version 19.21.0.0.0


Z:\>sqlplus u1/u1

SQL*Plus: Release 19.0.0.0.0 - Production on Sun Dec 3 18:59:29 2023

Version 19.21.0.0.0

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

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center