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

Last updated on OCTOBER 25, 2016

Applies to:

Oracle Application Object Library - Version 12.1.3 and later
Information in this document applies to any platform.

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

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