ITPub博客

首页 > 数据库 > Oracle > ORA-31687: error creating worker process with worker id 1

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

Oracle 作者:数据与人 时间:2021-04-07 09:40:01 0 删除 编辑

Datapump导入数据的时候报错:

Connected to: Oracle Database 11g Enterprise Edition Release 11.2.0.1.0 - 64bit Production
With the Partitioning, OLAP, Data Mining and Real Application Testing options
ORA-31626: job does not exist
ORA-31687: error creating worker process with worker id 1
ORA-31687: error creating worker process with worker id 1
ORA-31688: Worker process failed during startup.

 

 

在MOS上找到官方解释:

Changes
In the first situation AQ_TM_PROCESSES=0

For the second situation AQ_TM_PROCESSES should not be 0.
Cause
For the first situation, AQ_TM_PROCESSES init.ora parameter was set to zero (AQ_TM_PROCESSES=0)

Once removed this parameter from the init.ora file, and bounced the database the problem was resolved


For the second situation, there is likely a lack of memory for the streams_pool_size.
Solution
For the first situation:
o  Remove AQ_TM_PROCESSES init.ora parameter (AQ_TM_PROCESSES=0) from the init.ora.


For the second situation:

o  Allocate between 50-100MB for the STREAMS_POOL_SIZE in order for datapump to function since it is dependent on streams processing.

 

还是mos权威,特此记录,以帮助更多的人快速高效解决问题~


来自 “ ITPUB博客 ” ,链接:http://blog.itpub.net/69997824/viewspace-2766781/,如需转载,请注明出处,否则将追究法律责任。

请登录后发表评论 登录
全部评论
聚焦技术与人文,分享干货,共同成长!公号:数据与人(shujuyr)

注册时间:2021-04-06

  • 博文量
    22
  • 访问量
    5657