11 ECE System Administration Utilities

This chapter provides reference information for Oracle Communications Billing and Revenue Management Elastic Charging Engine (ECE) utilities that are used for system administration.

encrypt.sh

Use the encrypt.sh utility to encrypt passwords that ECE uses for connecting to Oracle Communications Billing and Revenue Management (BRM) and Pricing Design Center (PDC).

For more information, see "About Managing External Application Passwords".

Location

ECE_Home/oceceserver/bin

Syntax

encrypt.sh string storepassword

where:

  • string is the new password to be encrypted

  • storepassword is the password to the keystore

Parameters

-help

Displays the syntax for this utility.

Results

The encrypt utility returns a message containing the encrypted value for the new password.

When you run the script, information is logged in the ECE_Home/logs/encrypt.log file.

events_propagate_utility.pl

Use the events_propagate_utility.pl utility to propagate events on update requests from the suspense queue to the BRM Account Synchronization DM database queue.

For more information, see "Troubleshooting Failed Update Requests from BRM".

Location

ECE_Home/brm_utils/

Copy event_propagate.sql and events_propagate_utility.pl from the ECE installation directory (ECE_Home/brm_utils/) to your BRM machine (for example, BRM_Home/sys/test/).

Syntax Overview

The following actions are supported for events_propagate_utility:

Syntax for Moving Events from the Suspense Queue

Moves events from the suspense queue to the BRM Account Synchronization DM database queue.

perl events_propagate_utility.pl move

-s queue_name 
-d queue_name 
[-l user_id/password@oracle_sid] 
-n number_of_events

Parameters for Moving Events from the Suspense Queue

The following parameters are used to move events from the suspense queue to the BRM Account Synchronization DM database queue:

  • -s queue_name

    Specifies the suspense queue name.

  • -d queue_name

    Specifies the BRM Account Synchronization DM database queue name.

  • -l user_id/password@oracle_sid

    Specifies the user ID and password to connect to the database.

  • -n number_of_events

    Specifies the number of events being moved from the suspense queue.

Syntax for Listing All Queues

Lists all queues on a BRM machine.

perl events_propagate_utility.pl list

[-l user_id/password@oracle_sid]

Parameters for Listing All Queues

The following parameters are used to list all queues on a BRM machine:

  • -l user_id/password@oracle_sid

    Specifies the user ID and password to connect to the database.

Syntax for Loading Data into the Database

Loads data from a queue into the database.

perl events_propagate_utility.pl load

[-l user_id/password@oracle_sid]

Parameters for Loading Data into the Database

The following parameters are used to load data into the database:

  • -l user_id/password@oracle_sid

    Specifies the user ID and password to connect to the database.

Syntax for Purging Data from a Queue

Purges data from the suspense queue or the BRM Account Synchronization DM database queue.

perl events_propagate_utility.pl purge

[-l user_id/password@oracle_sid] 
-q queue_name

Parameters for Purging Data from Queues

The following parameters are used to purge data from the suspense queue and the BRM Account Synchronization DM database queue:

  • -l user_id/password@oracle_sid

    Specifies the user ID and password to connect to the database.

  • -q queue_name

    Specifies the queue name from which data is purged.

Syntax for Getting Help

Displays the syntax for the events_propagate_utility script.

perl events_propagate_utility.pl help

Results

The events_propagate_utility script notifies you when it runs successfully. Otherwise, look in the logs.

gridSync

Use the gridSync utility to start the federation service for replicating the ECE cache data to the participant sites asynchronously and also replicate the existing ECE cache data to the participant sites.

For more information, see "Replicating ECE Cache Data".

Location

ECE_Home/oceceserver/bin

Syntax

[-help] gridSync {start|stop|pause|replicate}[remoteClusterNames]

Parameters

help

Displays the syntax for the gridSync utility.

start

Starts the federation service to replicate the ECE cache data to the backup or remote production sites.

stop

Stops replicating ECE cache data to the backup or remote production sites.

pause

Pauses replication of ECE cache data to the backup or remote production sites.

replicate

Replicates all the existing ECE cache data to the backup or remote production sites.

remoteClusterNames

Specify the name of the Coherence cluster in the backup site.

Results

When you run the gridSync utility, information is logged in the ECE_Home/logs/encrypt.log file.