How to delete SYS.KUPC$ service after kill datapump job

  • 2018/12/25
  • ORACLE 9i-23ai
  • 2,126 views
  • How to delete SYS.KUPC$ service after kill datapump job已关闭评论

本11.2.0.4 2-nodes RAC, 现象是service_name 参数出现了一些SYS.KUPC$ 的service, 监听上同样有，且停节点1 ，service会漂到节点2， 重启双实例后同样存在， 手动修改service_name可以临时解决，但是重启实例还是会存在，虽然是新增service, 监听上看着乱，其它没什么影响， 这类服务常见于datapump 自动增加的…

, ,

阅读全文

11.2 impdp ORA-31693 ORA-29913 ORA-27163 when the table has xmltype column

  • 2016/11/02
  • ORACLE 9i-23ai
  • 1,314 views
  • 11.2 impdp ORA-31693 ORA-29913 ORA-27163 when the table has xmltype column已关闭评论

ORA-31693: Failed to load / unload the data object table “ANBOB” “SDTEMPETL” object is ignored because of the error.:
ORA-29913: error in executing the call ODCIEXTTABLEFETCH
ORA-27163: insufficient memory(内存不足)

,

阅读全文