Hello,
I have an Oracle19c database with 2 pdbs inside.
There is a request to set a password complexity for both SYS and SYSTEM accounts. So I tried to create a profile with a custom password function.
I did both of them in cdbroot , by creating a C##profile and adding a function in catpvf.sql (I tried to run it manually too). I change the profile to system user by setting a complex password and on the first logon as normal on both cdb and pdb all works fine.
Although, and here is the problem. I cannot logon as system (as SYSSBA) anymore, It says that the credentials are wrong!
I revert all changes (delete the profile, function etc…) but still cannot logon using system (as SYSDBA) could you please assist?