Shulou(Shulou.com)05/31 Report--

This issue of the content of the editor will bring you about running the OGG Extrac database platform in the implementation of expdp UDE-31623 bug how to do, the article is rich in content and professional analysis and description for you, after reading this article, I hope you can get something.

The production system is RedHat 6Magic RAC 11.2.0.4 CPU Jul 2015. Using expdp, the following error occurred when ogg is required to initialize synchronization table data for export:

The database stream_pool_size memory occupied by UDE-31623: operation generated ORACLE error 31623 ORA-31623: a job is not attached to this session via the specified handle ORA-6512: at "SYS.DBMS_DATAPUMP", line 3326 ORA-6512: at "SYS.DBMS_DATAPUMP", line 4551 ORA-6512: at line 1expdp and ogg ext processes can be detected by the following methods: 1. Is it normal to set stream_pool_size and re-execute the expdp command? The idea is to detect whether the expdp can not run normally because ogg ext occupies memory. 2. Add the oracle internal tracking parameter TRACE=1ff0b00 in the expdp command to track the specific expdp error. 3. Stop the ogg ext process manually and re-execute the expdp command to see if it works properly. Detect if it is caused by bug 20393675. There is no solution for this patch yet. The temporary solution is to temporarily stop the ogg ext process and start the ogg ext extraction process after the expdp execution is complete. The above is the editor for you to share the implementation of the OGG Extrac database platform in the implementation of expdp UDE-31623 bug how to do, if you happen to have similar doubts, you might as well refer to the above analysis to understand. If you want to know more about it, you are welcome to follow the industry information channel.

Welcome to subscribe "Shulou Technology Information " to get latest news, interesting things and hot topics in the IT industry, and controls the hottest and latest Internet news, technology news and IT industry trends.