Cleaning up SIB Messaging Engine Tables

The error seen in SystemOut.log is

 [8/24/14 6:22:10:484 SGT] 00000024 SibMessage    I   [BPC.dmgrCell............AppTarget.000-BPC.dmgrCell.Bus] CWSIS1538I: The messaging engine, ME_UUID=0F85DAE9B3AAA0D9, INC_UUID=0943692F04ECD95C, is attempting to obtain an exclusive lock on the data store.

[8/24/14 6:22:10:484 SGT] 00000027 SibMessage    I   [SCA.APPLICATION.dmgrCell.Bus:...........AppTarget.000-SCA.APPLICATION.dmgrCell.Bus] CWSIS1538I: The messaging engine, ME_UUID=68C818AD75633803, INC_UUID=0943692F04ECD95C, is attempting to obtain an exclusive lock on the data store.

[8/24/14 6:22:15:481 SGT] 00000026 SibMessage    I   [SCA.SYSTEM.dmgrCell.Bus:...................AppTarget.000-SCA.SYSTEM.dmgrCell.Bus] CWSIS1593I: The messaging engine, ME_UUID=2D0F4AEB9596F3A5, INC_UUID=0943692F04ECD95C, has failed to gain an initial lock on the data store.

 

Login to Deployment Manager Console and Stop the application servers

Execute the SQLs as described.

Connect to SIB ME Schema  using the user id/password 

sqlplus /@ORACLE_SID

 

Run the below sql commands in sql developer .

delete from .SIB000;

delete from .SIBOWNER;

delete from .SIB001;

delete from .SIBKEYS;

delete from .SIBXACTS;

delete from .SIBCLASSMAP;

delete from .SIBOWNERO;

delete from .SIBLISTING;

delete from .SIB002;

commit;

 

Either you can use truncate sql query  where you don't have to do final commit;

The same set of query has to be run for all the messaging engines .

For example,  if you have 2 servers and 4 buses , then you will have 8 messaging engines.

In case of Process server ,  4 buses are  BPC , CEI, SCA Application and SCA System.

 

Login to Deployment Manager Console and Start the application servers