My Oracle Support Banner

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

Last updated on MARCH 01, 2019

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 P1 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 ****';


  
end loop;
end;
/

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



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

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

To view full details, sign in with your My Oracle Support account.

Don't have a My Oracle Support account? Click to get started!


In this Document
Symptoms
Cause
Solution
References


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