My Oracle Support Banner

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

Last updated on NOVEMBER 08, 2023

Applies to:

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


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

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

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

The error message received for unlocking the admin_client:

SQL> exec actlogin_unlockservice.Proc_Unlock_Service('/service/admin_client', 'root.');
BEGIN actlogin_unlockservice.Proc_Unlock_Service('/service/admin_client', 'root.'); 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 line 1


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


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

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