ORA-2330 ora-01403:no Data found

The following error was caused by the abnormal shutdown of the production library simulation test on Qhmes. Solution: Single-organ machine sequence shutdown immediate lsnrctl stop boot sequence lsnrctl start startup
RAC environment: < IBID. >

Sql> SELECT apply_name,apply_captured,status from dba_apply;
Apply_name APP STATUS-------------------------------------------apply_mes_qh YES ENABLED apply_mes_qbj YES aborted
Sql> select Propagation_name,source_queue_name,queue_to_queue,error_message from Dba_propagation;
Propagation_name source_queue_name QUEUE----------------------------------------------------------------- Error_message--------------------------------------------------------------------------------mes_to_qbjmes Mes_ QUEUE_QBJ FALSE

Mes_to_qhmes MES_QUEUE_QH FALSE ora-12541:tns:no listener Ora-12541:tns:no Listener


Question One
APPLY_MES_QBJ MES_QUEUE_QBJ aborted Ora-26714:user error encountered while applying

Sql> select Propagation_name,source_queue_name,queue_to_queue,error_message from Dba_propagation;
Propagation_name source_queue_name QUEUE----------------------------------------------------------------- Error_message--------------------------------------------------------------------------------mes_to_qbjmes Mes_ QUEUE_QBJ FALSE

Mes_to_qhmes MES_QUEUE_QH FALSE ora-12541:tns:no listener Ora-12541:tns:no Listener
Solution: Qhmes on Lsnrctl start OK
This two error is caused by my drop table when it is not synchronized at first, and when the database is restarted it is best to start checking the status of the deleted
Qhmes on sql> select Apply_name,queue_name,error_message,source_commit_scn from Dba_apply_error;
Apply_name queue_name------------------------------------------------------------error_message Source_commi T_SCN---------------------------------------------------------------------apply_qhmes_qh qhmes_queue_qh ORA-2330 8:object Qhmes. AA does not exist or is Inva 3865113 lid
APPLY_QHMES_QH QHMES_QUEUE_QH ora-23308:object qhmes. AA does not exist or is Inva 3864848 lid
Resolution: Select Apply_name,local_transaction_id, Source_transaction_id,error_message from Dba_apply_error;
Sql>
BEGIN Dbms_apply_adm. Execute_error (local_transaction_id => ' 9.15.663 ', <------local_transaction_id Execute_as_user FALSE); End; /

The following error was caused by the abnormal shutdown of the production library simulation test on Qhmes. Solution: Single-organ machine sequence shutdown immediate lsnrctl stop boot sequence lsnrctl start startup
RAC environment: < IBID. >

Sql> SELECT apply_name,apply_captured,status from dba_apply;
Apply_name APP STATUS-------------------------------------------apply_mes_qh YES ENABLED apply_mes_qbj YES aborted
Sql> select Propagation_name,source_queue_name,queue_to_queue,error_message from Dba_propagation;
Propagation_name source_queue_name QUEUE----------------------------------------------------------------- Error_message--------------------------------------------------------------------------------mes_to_qbjmes Mes_ QUEUE_QBJ FALSE

Mes_to_qhmes MES_QUEUE_QH FALSE ora-12541:tns:no listener Ora-12541:tns:no Listener


Problem one APPLY_MES_QBJ MES_QUEUE_QBJ aborted Ora-26714:user error encountered while applying

Sql> select Propagation_name,source_queue_name,queue_to_queue,error_message from Dba_propagation;
Propagation_name source_queue_name QUEUE----------------------------------------------------------------- Error_message--------------------------------------------------------------------------------mes_to_qbjmes Mes_ QUEUE_QBJ FALSE

Mes_to_qhmes MES_QUEUE_QH FALSE Ora-12541:tns:no listener ora-