BRM Admin_client Unlock Procedure on DB Gives an Error (Doc ID 2193979.1)

Last updated on NOVEMBER 08, 2023

Applies to:

Goal

Some of the BRM client tools are not able to connect to BRM anymore. This is only for the root.0.0.0.1 user using the /service/admin_client.

User tried to unlock the account by:
Connect to your database using SQL*Plus:
@create_actlogin_unlockservice_procedures.plb
exec actlogin_unlockservice.Proc_Unlock_Service('/service/admin_client', 'root.0.0.0.1');

Unfortunately this gives an error. Unlocking the pcm client works fine:
exec actlogin_unlockservice.Proc_Unlock_Service('/service/pcm_client', 'root.0.0.0.1');

The error message received for unlocking the admin_client:


SQL> exec actlogin_unlockservice.Proc_Unlock_Service('/service/admin_client', 'root.0.0.0.1');
BEGIN actlogin_unlockservice.Proc_Unlock_Service('/service/admin_client', 'root.0.0.0.1'); END;

*
ERROR at line 1:
ORA-20110: Proc_Unlock_Service: error in Unlocking Service:
ORA-01427: single-row subquery returns more than one row
ORA-06512: at "PIN.ACTLOGIN_UNLOCKSERVICE", line 40
ORA-06512: at line 1

----------------------------------

How to:
a) avoid this error and
b) unlock the account?
 

Solution

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