![Cisco BTS 10200 Softswitch Скачать руководство пользователя страница 778](http://html.mh-extra.com/html/cisco/bts-10200-softswitch/bts-10200-softswitch_troubleshooting-manual_67550778.webp)
16-30
Cisco BTS 10200 Softswitch Troubleshooting Guide, Release 5.0.x
OL-8723-19
Chapter 16 Disaster Recovery Procedures
Recovering Shared Memory Data
Recovering Shared Memory
Perform the following procedure:
Step 1
Check the transaction queue. Use the following command:
show transaction-queue
Step 2
If you find any transaction in the queue, delete the queue by entering the following CLI command.
Note
There should be no provisioning activity on the system—if the
show transaction-queue
command does not return the message "Void of entries," assume that a transaction is in the
queue. If there is no transaction in the queue, proceed to
.
delete transaction-queue
target=
CAxxx;
transaction-id
=
<id>
The
transaction-id
parameter enables you to delete only one transaction at a time from the
transaction_queue table. Note that to delete an entry from the transaction-queue, you should login as
ciscouser
.
Examples:
delete transaction-queue
target=CAxxx;
transaction-id=
<id>
delete transaction-queue
target=FSPTCxxx;
transaction-id=
<id>
delete transaction-queue
target=FSAINxxx
transaction-id=
<id>
If there are thousands of entries stuck in the transaction queue, it is recommended to flush all the entries
from Oracle after logging in as
oamp
user.
Perform the following steps to login as
oamp
user and to flush all the entries from Oracle:
Step 1
<hostname>#
su - oracle
Step 2
<hostname>$
sqlplus oamp/oamp
Step 3
SQL>
delete from transaction_queue;
Step 4
SQL>
commit;
Step 5
SQL>
exit
Step 6
<hostname>$
exit
In the following example, 138327 transactions are stuck in the queue, and the display of the transactions
(using the
show
command) is limited to 2. This example shows that when many transactions are stuck
in the queue, deleting one transaction at a time takes huge amount of time. In such scenarios, it is
recommended to flush all the entries from Oracle.
CLI>
show transaction_queue limit
=2
TRANSACTION_ID=1242510999092
SEQUENCE_NUM=0
TARGET=CA101