Migrating Password Using AFPASSWD Fails With Error: "Users with Invalid passwords" (Doc ID 2194846.1)

Last updated on FEBRUARY 22, 2023

Applies to:

Symptoms

Customer tried to migrate password to Advanced Hashing AFPASSWD -c apps -m SHA512 FULL. Resulting in the following Error:

+----------------------------------------------------------------------------+
Application Object Library - AFPASSWD
+----------------------------------------------------------------------------+
Copyright (c) 2006, Oracle. All rights reserved.
+----------------------------------------------------------------------------+
Current system time is 12-SEP-16 07:58:17

+----------------------------------------------------------------------------+
Working...
Users migrated successfully : 0
Users with External passwords : 1
Users with Invalid passwords : 14820
Users not migrated : 3 of 14824
AFPASSWD completed with errors.
+----------------------------------------------------------------------------+

Changes

Customer is using SHARED_SERVER parameter on the Database Instance to enhance performance of APEX.

A shared server process allows a single server process to service several clients, based on the premise that usually in an OLTP environment, a user is more often than not, reading and editing data on the screen than actually executing a DML. This is a Database INIT.ORA parameter

Check the parameter value with:

SHOW PARAMETER SHARED_Servers

Cause

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.