IT Tutorial IT Tutorial | Oracle DBA | SQL Server, Goldengate, Exadata, Big Data, Data ScienceTutorial
Hi,
You can get frequently ” OGG-00542 Unexpected threading library failure. Error code 11 (Resource temporarily unavailable) OGG-01668 PROCESS ABENDING. ” error from Goldengate extract process.
Goldengate extract is abended with ” OGG-00542 Unexpected threading library failure. Error code 11 (Resource temporarily unavailable) OGG-01668 PROCESS ABENDING. ” error like below.
: [/ggatea01/goldengate/product/19.1.0.0.4/extract(ggs::gglib::MultiThreading::MainThread::Run(int, char**))]
: [/ggatea01/goldengate/product/19.1.0.0.4/extract(main)]
: [/lib64/libc.so.6(__libc_start_main)]
: [/ggatea01/goldengate/product/19.1.0.0.4/extract()]
2020-04-22 12:36:40 ERROR OGG-00542 Unexpected threading library failure. Error code 11 (Resource temporarily unavailable).
2020-04-22 12:36:40 ERROR OGG-01668 PROCESS ABENDING.
The ulimit nproc(max number of active processes) value is too low as follows.
> ulimit -a
address space limit (kbytes) (-M) unlimited
core file size (blocks) (-c) 0
cpu time (seconds) (-t) unlimited
data size (kbytes) (-d) unlimited
file size (blocks) (-f) unlimited
locks (-L) unlimited
locked address space (kbytes) (-l) 32
nice (-e) 0
nofile (-n) 8192
nproc (-u) 1024 <================= this is the max process setting
pipe buffer size (bytes) (-p) 4096
resident set size (kbytes) (-m) unlimited
rtprio (-r) 0
socket buffer size (bytes) (-b) 4096
stack size (kbytes) (-s) 10240
threads (-T) not supported
process size (kbytes) (-v) unlimited
You can temporarily increase the setting as follows.
ulimit -u ##### – substitute number for ####
ulimit -n 10024
Extract process has started successfully.
Do you want to learn Oracle Goldengate from scratch, then read the following Goldengate Tutorial articles.
https://ittutorial.org/goldengate-tutorials-oracle-for-beginners/
