ORA-31687: error creating worker process with worker id 1

created at 09-01-2021 views: 15

Datapump reports an error when importing data:

Connect to: Oracle Database 11g Enterprise Edition 11.2.0.1.0-
64-bit production with partitioning, OLAP, data mining, and real application testing options
ORA-31626: job does not exist
ORA-31687: An error occurred while creating a worker process, the worker process ID is 1
ORA-31687: An error occurred while creating a worker process, the worker process ID is 1
ORA-31688: The worker process failed during startup.

solution

I checked a bunch of answers on the Internet but didn't solve the problem. Finally, I found that the process was set to 150 by default. Change it to 1000 and restart the database and then import it.

created at:09-01-2021
edited at: 09-01-2021: