CODEWITHSUNDEEP
oracle-databaseauthenticationpasswordsoracle19c
SuperUser
SuperUser

Reputation: 1

ORA-28040: No matching authentication protocol exception with orcale19c

I am facing this issue in oracle19c. I have added the following to sqlnet.ora

SQLNET.ALLOWED_LOGON_VERSION_CLIENT = 8
SQLNET.ALLOWED_LOGON_VERSION_SERVER = 8

as well as

SQLNET.AUTHENTICATION_SERVICES = (NONE)

But I am getting:

ORA-01017: invalid username/password: logon denied

I read all over stackoverflow to re-create the password. I have even tried creating password file as well as changing the password of the user by alter command.

Can any one help me out with the exact steps to re-create password.

Upvotes: 0

Views: 572

Answers (1)

Popeye
Popeye

Reputation: 35920

You can create a password file using orapwd utility.

Users are added to the password file when they are granted the SYSDBA, SYSOPER, SYSASM, SYSKM, SYSDG or SYSBACKUP privilege.

By default, SYS is the only user that has SYSDBA and SYSOPER privileges. Creating a password file via orapwd enables the remote users to connect with admin privileges.

The basic command to create the password file is

orapwd file=<Password file name> entries=<nnumber of entries allowed> force=<y/n>

There should be no space around =.

Here, You should use force=y to permits overwriting an existing password file.

Cheers!!

Upvotes: 0

Related Questions