Monday, October 3, 2016

ORA-01917: user or role 'ODS' does not exist

Faced some issue while running OID 11.1.19 RCU.

Error:oracle.sysman.assistants.rcu.backend.action.AbstractAction::handleNonIgnorableError: Received Non-Ignorable Error: ORA-01917: user or role 'ODS' does not exist

This seems to be related to to password verify function.We did give complex passwords.

Cause :Password policy was set. PASSWORD_VERIFY_FUNCTION is not set to NULL which causes the user creation to fail.

Fix:     alter profile default limit PASSWORD_VERIFY_FUNCTION null;

It fixed the issue and was able to proceed with RCU.