Saturday, January 31, 2015

ERROR 0GG-01031

PROBLEM:  Pump abended with ERROR OGG-01031

GGSCI > view report POGG9

 ERROR   OGG-01031  There is a problem in network communication, a remote file problem, encryption keys for target and source do not match (if using ENCRYPT) or an unknown error. (Reply received is Unable to open file "/opt/app/ggs/trails/ap000029" (error 13, Permission denied)).

ERROR   OGG-01668  PROCESS ABENDING.

Cause: Stale  replicat process on target is holding the lock on the remote file. 

Resolution: 
  • Go to the target server
  • Stop all the REPLICATS that are running on target server.
  • Start abended pump
  • start all replicat's, Recreate the replicats if they don’t  start  or abended without any error, using the process


Querys to monitor RAC

following few  Query's will help to find out culprits-  Query to check long running transaction from last 8 hours  Col Sid Fo...