18c upgrade and ora-01017 invalid username/password

SQL_Warrior

Greetings All ,

i recently upgraded a database to 18c release with latest patches being applied. after the upgrade i am facing authentication issues with multiple accounts.

some accounts are not connecting to the database and the following error is thrown ?

ora-01017 invalid username/password

Emad Al-Mousa

what are the  PASSWORD_VERSIONS for these accounts ? you can check that from dba_users view . it seems these accounts are using old hashing algorithms. From 12cR2 and beyond oracle enforced higher authentication level !

in my opinion you have two options:

• reset the password of these accounts (password_versions) value should be updated, and make sure your application client is compatible with 18c !

• lower the authentication by setting the following parameter in sqlnet.ora file for example : SQLNET.ALLOWED_LOGON_VERSION=11

Emad Al-Mousa

what are the  PASSWORD_VERSIONS for these accounts ? you can check that from dba_users view . it seems these accounts are using old hashing algorithms. From 12cR2 and beyond oracle enforced higher authentication level !

in my opinion you have two options:

• reset the password of these accounts (password_versions) value should be updated, and make sure your application client is compatible with 18c !

• lower the authentication by setting the following parameter in sqlnet.ora file for example : SQLNET.ALLOWED_LOGON_VERSION=11

SQL_Warrior

first option (resetting the password) worked with me fine !  Thank You !