OGG-00542 Unexpected threading library failure. Error code 11 (Resource temporarily unavailable) OGG-01668 PROCESS ABENDING.

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/

About Mehmet Salih Deveci

I am Founder of SysDBASoft IT and IT Tutorial and Certified Expert about Oracle & SQL Server database, Goldengate, Exadata Machine, Oracle Database Appliance administrator with 10+years experience.I have OCA, OCP, OCE RAC Expert Certificates I have worked 100+ Banking, Insurance, Finance, Telco and etc. clients as a Consultant, Insource or Outsource.I have done 200+ Operations in this clients such as Exadata Installation & PoC & Migration & Upgrade, Oracle & SQL Server Database Upgrade, Oracle RAC Installation, SQL Server AlwaysOn Installation, Database Migration, Disaster Recovery, Backup Restore, Performance Tuning, Periodic Healthchecks.I have done 2000+ Table replication with Goldengate or SQL Server Replication tool for DWH Databases in many clients.If you need Oracle DBA, SQL Server DBA, APPS DBA,  Exadata, Goldengate, EBS Consultancy and Training you can send my email adress [email protected].-                                                                                                                                                                                                                                                 -Oracle DBA, SQL Server DBA, APPS DBA,  Exadata, Goldengate, EBS ve linux Danışmanlık ve Eğitim için  [email protected] a mail atabilirsiniz.

Leave a Reply

Your email address will not be published. Required fields are marked *