This is probably not a python bug. But if you can demonstrate it without needing to install the Oracle software, we can take a look at it. You've also not explained how you're using multiprocessing. We need an complete, short, working example program to determine if it's a python bug.

I suggest you ask this question on Stack Overflow.

Also, I'd suggest subprocess.run instead of .communicate, if you can.