ORA-7443 When Changing Password For A Local User With Common Profile

(Doc ID 2381052.1)

Last updated on APRIL 03, 2018

Applies to:

Oracle Database - Enterprise Edition - Version 12.1.0.2 and later
Information in this document applies to any platform.

Goal

ORA-7443 when changing password for a local user with common profile.

ORA-7443: function for password verification not found

 
Given the following circumstances:
-The default profile in CDB$ROOT has a password verify function set
-There is a common profile in CDB$ROOT that has the the password verify function set to DEFAULT
-A local user in a PDB has that common profile

Any attempt to change the password for that user results in an ORA-7443 error.
 

Solution

Sign In with your My Oracle Support account

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

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms