Password Change With Warning After Migration To 11.2.0.4 SP2-0642 (Doc ID 1969677.1)

Last updated on NOVEMBER 10, 2016

Applies to:

Oracle Database - Enterprise Edition - Version 11.2.0.4 and later
Information in this document applies to any platform.

Symptoms

On : 11.2.0.4 version, Database Security

When attempting to change the User Password after a Migration from 11.2.0.2.0 to 11.2.0.4.0 with a Verification function
the following error occurs.

ERROR
-----------------------
SP2-0642: SQL*Plus internal error state 2087, context 43:0:0
 Unsafe to proceed


STEPS
-----------------------
The issue can be reproduced at will with the following steps:
1. Create RDBMS 11.2.0.2.0

create PROFILE PROF_MIG LIMIT
FAILED_LOGIN_ATTEMPTS 10
  PASSWORD_LIFE_TIME UNLIMITED
  PASSWORD_REUSE_TIME UNLIMITED
  PASSWORD_REUSE_MAX UNLIMITED
  PASSWORD_VERIFY_FUNCTION verify_function
  PASSWORD_LOCK_TIME UNLIMITED
  PASSWORD_GRACE_TIME UNLIMITED ;

declare
 var1 number;
 begin
  for i in 1..100 loop

EXECUTE IMMEDIATE 'create user test'||i||' identified by oracle';


  
end loop;
end;
/

declare
 var1 number;
 begin
  for i in 1..100 loop
EXECUTE IMMEDIATE 'alter user test'||i||' profile prof_mig';
  
end loop;
end;
/



SQL> alter user &me identified by "&newPWD" replace "&oldPWD"
  2 /
Enter value for me: test1
Enter value for newpwd: fiction5
Enter value for oldpwd: oracle
old 1: alter user &me identified by "&newPWD" replace "&oldPWD"
new 1: alter user test1 identified by "fiction5" replace "oracle"

User altered.


2) Migrate the DB from 11.2.0.2.0 to 11.2.0.4.0

3) Connect to the 11.2.0.4.0 DB
alter user &me identified by "&newPWD" replace "&oldPWD"

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