Errors “Poster 12070 - OCITransCommit failed with ORA-12008” and “error in materialized view refresh path.ORA-00942 table or view does not exist” (4302327)

Tchater maintenant avec le support

Obtenir une aide instantanée
Terminer l’enregistrement

Se connecter

Demander les tarifs

Contacter le service des ventes

Retour

Commentaire envoyé

Cet article vous a-t-il à résoudre un problème ?

Sélectionner une évaluation

Titre

Errors “Poster 12070 - OCITransCommit failed with ORA-12008” and “error in materialized view refresh path.ORA-00942 table or view does not exist”
Description

The following errors are seen in target event_log when a materialized view exists on target where the underlying table may or may not be a part of replication:
Error    2016-01-21 22:27:03.638086 20880 1365956928 s:2 Poster: 12070 - OCITransCommit failed with ORA-12008. (posting from SID1, queue queue_name, to SID2) [module osp]
Error    2016-01-21 22:27:03.644732 20880 1365956928 s:2 Poster: failed to commit transaction session 2 in CommitFunc(): ORA-12008: error in materialized view refresh path.ORA-00942: table or view does not exist. Will exit Post.. (posting from SID1, queue queue_name, to SID2) [module opo]
Info     2016-01-21 22:27:03.665129 16418 3646488288 Poster exited with code=1, pid = 20880 (posting from SID1, queue queue_name, to SID2)
Cause

The refresh activities on materialized view on target are interfering with Post.
Résolution

Most common reason for seeing the ORA-12008 and ORA-00942 during materialized view refresh is that the underlying target table(s) have been dropped. Recreate those tables while ensuring that the materialized view owner has the requisite grant on these, and then drop and recreate the materialized view and materialized view logs on the target. Then restart Post. This will result in Post running normally. Shareplex do replicate from materialized view to a table and the materialized view can exist on target. But if it is interfering with Post, these steps will help resolve the error.
Another reason for seeing ORA-00942 is that though the underlying tables may exist, the owner of materialized view lacks the privileges on the tables that comprise the materialized view. So it results in ORA-00942. This usually happens when the underlying tables are dropped and recreated, the grants have not been run on the newly created tables. Grant the requisite privileges on the newly created tables forming part of materialized view and restart Post.
Informations supplémentaires

For privileges associated with materialized view, please refer to Oracle documentation as it is a wide subject and its treatment is beyond the scope of this article.

Commentaire envoyé

Cet article vous a-t-il à résoudre un problème ?

Sélectionner une évaluation

Demander un article de la base de connaissances

Contenu recommandé

Produit(s) :: SharePlex
7.6.3

Sujet(s) :: Troubleshooting

Historique de l’article :: Créé le : 1/21/2016
Dernière mise à jour le : 5/7/2023

Rechercher tous les articles

Veuillez sélectionner votre produit

Afin de mieux répondre à vos besoins, précisez l'objet du tchat:

Solutions recommandées pour votre problème

Errors “Poster 12070 - OCITransCommit failed with ORA-12008” and “error in materialized view refresh path.ORA-00942 table or view does not exist” (4302327)

Titre

Description

Cause

Résolution

Informations supplémentaires

Leave a Comment