CODEWITHSUNDEEP
oracle-databasesecuritydatabase-connectionoracle19c
László Tóth
László Tóth

Reputation: 601

Oracle 19.3.0.0.0 Password authentication failed

I made a PDB and I can connect to this PDB by sys as sysdba, but I can't connect my own common or just local users.

The reason is ORA-01017: bad password.

After I set in sqlnet.ora:

SQLNET.ALLOWED_LOGON_VERSION_SERVER=11

And the password starts end ends with quation mark, then works.

Commands to create user and login user:

create user c##test identified by "test" container=all;
grant create session to c##test container=all;
alter pluggable database FTR_SHOWCASE open;
conn c##test/"test"@localhost:1521/FTR_SHOWCASE

Why? How can I upgrade SQLNET.ALLOWED_LOGON_VERSION_SERVER to 12. Can I password set without quotation mark?

Can it be encoding problem?

Upvotes: 0

Views: 1150

Answers (1)

Cyrille MODIANO
Cyrille MODIANO

Reputation: 2376

WHEN using EZCONNECT to connect to the database you need to provide a password for the user:

sqlplus user/pwd@hostname:port/service_name

or you need to declare an alias to your pdb in your tnsnames.ora and connect using:

sqlplus user@alias

In your first exemple it works because oracle use the os authentication to connect you.

TEST:

SQL> create pluggable database FTR_SHOWCASE from PDBINV;

Pluggable database created.

SQL> create user c##test identified by "test" container=all;

User created.

SQL> grant create session to c##test container=all;

Grant succeeded.

SQL> alter pluggable database FTR_SHOWCASE open;

Pluggable database altered.

SQL> conn c##test/"test"@localhost:1521/FTR_SHOWCASE
Connected.

It's worked after a db change.

A must set SQLNET.ALLOWED_LOGON_VERSION_SERVER=11 in sqlnet.ora Then it works! But why isn't good by default value?

And very weird, but "test" is good with quotation marks. Password without quot is 10170 bad password.

Upvotes: 1

Related Questions