ORA-31687: error creating worker process with worker id 1
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/,如需轉載,請註明出處,否則將追究法律責任。
相關文章
- ORA-39126: Worker unexpected fatal error in KUPW$WORKER.POST_MT_INITError
- Web WorkerWeb
- Service Worker初探
- Web Worker 初探Web
- Master-Worker 模式AST模式
- 初識Web WorkerWeb
- web worker 小白攻略!!!Web
- Master-Worker模式AST模式
- Web Worker 使用教程Web
- Service Worker入門
- JavaScript 效能利器 —— Web WorkerJavaScriptWeb
- Angular 裡的 Service WorkerAngular
- Service Worker的應用
- 動態建立 Web WorkerWeb
- 修改 Nginx 程式最大可開啟檔案數(worker processes和worker connections)Nginx
- Master-Worker工具使用文件AST
- 使用Web Worker優化程式碼Web優化
- javascript中web worker是什麼JavaScriptWeb
- php-worker 無法啟動PHP
- Nginx實現原理master和workerNginxAST
- web worker的介紹和使用Web
- Oracle 的Lgwr Worker的工作原理Oracle
- 聊聊PowerJob Worker的ServerAddressServer
- 利用service worker破解防盜鏈
- 淺談HTML5 Web WorkerHTMLWeb
- Apache的prefork模式和worker模式Apache模式
- 剖析 Laravel 佇列系統--WorkerLaravel佇列
- HTML5 Web Worker的使用HTMLWeb
- HTTP/1.x 及 Service Worker 快取實踐小結HTTP快取
- [原始碼解析] 並行分散式框架 Celery 之 worker 啟動 (1)原始碼並行分散式框架
- 像Event Emitter一樣使用Web WorkerMITWeb
- Service Worker 從入門到出門
- .Net core Worker Service 擴充套件庫套件
- 謹慎處理 Service Worker 的更新
- celery筆記六之worker介紹筆記
- 梳理 Web Worker 及實戰場景Web
- Service Worker 在 PWA 中的應用
- nginx學習隨筆--worker_processesNginx