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

Last updated on OCTOBER 28, 2016

Applies to:

Oracle Communications Billing and Revenue Management - Version 7.5.0.15.0 and later
Information in this document applies to any platform.

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

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