Pmsrvr receives SIGSEGV and crashes after recreating datastore.
we can see below error on ggserr.log
ERROR OGG-01117 Oracle GoldenGate Performance Metrics Server for Oracle: Received signal: Segmentation violation
Cause:
Empty dirbdb directory under GG_HOME existed when recreating datastore.
pmsrvr does not initialize the datastore completely if <GG_HOME>/dirbdb/ exists even if the directory is empty.
Solution:
stop jagent
stop *
stop manager
stop pmsrvr
GGSCI 14> info all
Program Status Group Lag at Chkpt Time Since Chkpt
MANAGER STOPPED
JAGENT STOPPED
PMSRVR STOPPED
EXTRACT STOPPED PUMP1 00:00:00 00:00:53
EXTRACT STOPPED EXT1 00:00:02 00:00:53
EXTRACT STOPPED EXT2 00:00:00 00:00:51
REPLICAT STOPPED REPLG1 00:00:00 00:00:46
remove or mv dirbdb with backup name
mv <GG_HOME>/dirbdb/ <GG_HOME>/dirbdb_org
Start GG Process:
GGSCI 15> start pmsrvr -initds
PMSRVR started
GGSCI 16> start manager
Manager started.
GGSCI 17> start *
Sending START request to MANAGER ...
EXTRACT PUMP1 starting
Sending START request to MANAGER ...
EXTRACT EXT1 starting
Sending START request to MANAGER ...
EXTRACT EXT2 starting
Sending START request to MANAGER ...
REPLICAT REPLG1 starting
GGSCI 18> start jagent
Sending START request to MANAGER ...
GGCMD JAGENT starting
GGSCI 1> info all
Program Status Group Lag at Chkpt Time Since Chkpt
MANAGER RUNNING
JAGENT RUNNING
PMSRVR RUNNING
EXTRACT RUNNING PUMP1 00:00:00 00:00:09
EXTRACT RUNNING EXT1 00:00:03 00:00:07
EXTRACT RUNNING EXT2 00:00:02 00:00:07
REPLICAT RUNNING REPLG1 00:00:03 00:00:00
Recreate datastore after delete old one helped to start PMSRVR without errors
No comments:
Post a Comment