Database Install/Upgrade/Opatch (MOSC)

MOSC Banner

ORA-28003; password verification failed AFTER upgrade to 19c

Hi

We recently upgraded one of our databases from 12.2 to 19.8

One of the functions that uses to work just fine in 12c is now not working with the following error

In all our 12 c databases, it works fine but in 19c it errors out with this error

ORA-28003: password verification for the specified password failed

ORA-06550; line 1, column 106:

PLS-00905; object SYS.OURCOMPANY_VERIFY_FUNCTION is invalid

ORA-06550; line 1, column 98;

PL/SQL: statement ignored

Here is the DDL of the function

CREATE OR REPLACE FUNCTION SYS.ourcompany_verify_function

(username varchar2,

password varchar2,

old_password varchar2)

RETURN boolean IS

  differ integer;

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