Sunday, February 3, 2019

WARNING OGG-01932 Datastore already exists.


After Server Reboot where OGG is running my goldengate manager is unable to start and getting below error

GGSCI (oradev.domain.com) 1> info all

Program     Status      Group       Lag at Chkpt  Time Since Chkpt

MANAGER     STOPPED
JAGENT      STOPPED
EXTRACT     RUNNING     EXTDEVQ1    00:00:02      00:00:07
EXTRACT     RUNNING     EXTDEVQ1    00:00:04      00:00:09
EXTRACT     RUNNING     EXTDEVQ1    00:00:01      00:00:09
EXTRACT     RUNNING     EXTDEVQ1    00:00:02      00:00:03
EXTRACT     RUNNING     PXTDEVQ1    00:00:00      00:00:08
EXTRACT     RUNNING     PXTDEVQ1    00:00:00      00:00:03
EXTRACT     RUNNING     PXTDEVQ1    00:00:00      00:00:05
EXTRACT     RUNNING     PXTDEVQ1    00:00:00      00:00:02


GGSCI (oradev.domain.com) 1> start mgr
Manager started.
2019-01-17 10:37:29  INFO    OGG-00987  Oracle GoldenGate Command Interpreter for Oracle:  GGSCI command (oracle): start mgr.
2019-01-17 10:37:29  WARNING OGG-01877  Oracle GoldenGate Manager for Oracle, mgr.prm:  Missing explicit accessrule for server collector.
2019-01-17 10:37:29  INFO    OGG-00960  Oracle GoldenGate Manager for Oracle, mgr.prm:  Access granted (rule #7).
2019-01-17 10:37:29  INFO    OGG-00983  Oracle GoldenGate Manager for Oracle, mgr.prm:  Manager started (port 7809).
2019-01-17 10:37:29  WARNING OGG-01934  Oracle GoldenGate Manager for Oracle, mgr.prm:  Datastore repair failed.
2019-01-17 10:37:29  WARNING OGG-06530  Oracle GoldenGate Manager for Oracle, mgr.prm:  Berkeley Database encountered a Critical error.
2019-01-17 10:37:29  WARNING OGG-00543  Oracle GoldenGate Manager for Oracle, mgr.prm:  Unexpected threading library failure. Error code 16 (Device or resource busy).


GGSCI (oradev.domain.com) 13> delete datastore
Are you sure you want to delete the datastore? y
BDB0118 shmat: id 1679097930: unable to attach to shared system memory region: Invalid argument
BDB0118 shmat: id 1679097930: unable to attach to shared system memory region: Invalid argument
2019-01-17T15:37:57Z  INFO    OGG-06492  Datastore deleted
GGSCI (oradev.domain.com) 14>

GGSCI (oradev.domain.com) 14> info datastore
2019-01-17T15:38:03Z  WARNING OGG-06307  Datastore does not exist.

GGSCI (oradev.domain.com) 15> Create datastore mmap
2019-01-17T15:38:13Z  WARNING OGG-01933  Datastore create failed.

GGSCI (oradev.domain.com) 18> Create datastore
2019-01-17T15:39:44Z  WARNING OGG-01933  Datastore XTeate failed.

oradev:NOTSET:/home/oracle $ cd /goldengate/home/
oradev:NOTSET:/goldengate/home $ cd dirbdb
-bash: cd: dirbdb: No such file or directory

Looks like 'dirdbd' Directory is missing or Lost

oradev:NOTSET:/goldengate/home $ mkdir dirbdb

GGSCI (oradev.domain.com) 1> info all

Program     Status      Group       Lag at Chkpt  Time Since Chkpt

MANAGER     STOPPED
JAGENT      STOPPED
EXTRACT     STOPPED     EXTDEVQ1    00:00:46      00:17:59
EXTRACT     STOPPED     EXTDEVQ1    00:00:43      00:17:59
EXTRACT     STOPPED     EXTDEVQ1    00:00:44      00:17:58
EXTRACT     ABENDED     EXTDEVQ1    00:00:02      00:18:39
EXTRACT     STOPPED     PXTDEVQ1    00:00:00      00:17:57
EXTRACT     STOPPED     PXTDEVQ1    00:00:00      00:17:56
EXTRACT     STOPPED     PXTDEVQ1    00:00:00      00:17:55
EXTRACT     STOPPED     PXTDEVQ1    00:00:00      00:17:55


GGSCI (oradev.domain.com) 2> Create datastore mmap
2019-01-17T15:55:06Z  WARNING OGG-01932  Datastore already exists.

GGSCI (oradev.domain.com) 3> info datastore
2019-01-17T15:55:14Z  INFO    OGG-06308  Datastore uses memory mapped (MMAP) environment files.

GGSCI (oradev.domain.com) 5> info all

Program     Status      Group       Lag at Chkpt  Time Since Chkpt

MANAGER     STOPPED
JAGENT      STOPPED
EXTRACT     STOPPED     EXTDEVQ1    00:00:46      00:18:40
EXTRACT     STOPPED     EXTDEVQ1    00:00:43      00:18:39
EXTRACT     STOPPED     EXTDEVQ1    00:00:44      00:18:39
EXTRACT     ABENDED     EXTDEVQ1    00:00:02      00:19:20
EXTRACT     STOPPED     PXTDEVQ1    00:00:00      00:18:38
EXTRACT     STOPPED     PXTDEVQ1    00:00:00      00:18:37
EXTRACT     STOPPED     PXTDEVQ1    00:00:00      00:18:36
EXTRACT     STOPPED     PXTDEVQ1    00:00:00      00:18:35

GGSCI (oradev.domain.com) 6> start mgr
Manager started.

GGSCI (oradev.domain.com) 7> info mgr

Manager is running (IP port oradev.domain.com.7809, Process ID 139824).



0 comments:

Post a Comment

Auto Scroll Stop Scroll