执行expdp导出后，alert.log中报服务名修改

系统在执行expdp导出后，alert.log中报服务名修改信息，具体如下：

Wed Sep 05 02:09:29 2012
ALTER SYSTEM SET service_names="SYS$SYS.KUPC$C_1_20120905020929.ZZBRAC3" SCOPE=MEMORY SID="zzbrac31";
ALTER SYSTEM SET service_names="SYS$SYS.KUPC$C_1_20120905020929.ZZBRAC3","SYS$SYS.KUPC$S_1_20120905020929.ZZBRAC3" SCOPE=MEMORY SID="zzbrac31";
Wed Sep 05 02:09:30 2012
DM00 started with pid=69, OS id=29489, job DNIS.SYS_EXPORT_SCHEMA_01
Wed Sep 05 02:09:31 2012
DW01 started with pid=49, OS id=29503, wid=1, job DNIS.SYS_EXPORT_SCHEMA_01
Wed Sep 05 02:10:04 2012
ALTER SYSTEM SET service_names="SYS$SYS.KUPC$S_1_20120905020929.ZZBRAC3" SCOPE=MEMORY SID="zzbrac31";
ALTER SYSTEM SET service_names="" SCOPE=MEMORY SID="zzbrac31";

MOS给出的解决信息[ID 1269319.1]

On RAC, expdp Removes the Service Name [ID 1269319.1]
--------------------------------------------------------------------------------
修改时间:2012-2-4类型:PROBLEM状态:MODERATED优先级:3
注释（0）
In this Document
   Symptoms
   Cause
   Solution
   References

--------------------------------------------------------------------------------
This document is being delivered to you via Oracle Support"s Rapid Visibility （RaV） process and therefore has not been subject to an independent technical review.
Applies to:
Oracle Server - Enterprise Edition - Version: 10.2.0.2 to 11.2.0.1 - Release: 10.2 to 11.2
Information in this document applies to any platform.
Symptoms
On RAC, before run of expdp, you have the following services:

select name from dba_services;
SYS$BACKGROUND
SYS$USERS
alphaXDB
alpha
beta
beta2

Calling expdp causes the following type of entries to be written to the alert.log:

Mon Nov 15 11:06:07 2010
ALTER SYSTEM SET service_names="SYS$SYS.KUPC$C_1_20101115110600.ALPHA" SCOPE=MEMORY SID="alpha1";
Mon Nov 15 11:06:07 2010
ALTER SYSTEM SET service_names="SYS$SYS.KUPC$C_1_20101115110600.OMEGA","SYS$SYS.KUPC$S_1_20101115110600.ALPHA" SCOPE=MEMORY SID="alpha1";
kupprdp: master process DM00 started with pid=52, OS id=421934
to execute - SYS.KUPM$MCP.MAIN（"SYS_EXPORT_SCHEMA_01", "SYS", "KUPC$C_1_20101115110600", "KUPC$S_1_20101115110600", 0）;
kupprdp: worker process DW01 started with worker id=1, pid=68, OS id=766178
to execute - SYS.KUPW$WORKER.MAIN（"SYS_EXPORT_SCHEMA_01", "SYS"）;
kupprdp: worker process DW02 started with worker id=2, pid=70, OS id=397824
to execute - SYS.KUPW$WORKER.MAIN（"SYS_EXPORT_SCHEMA_01", "SYS"）;
kupprdp: worker process DW03 started with worker id=3, pid=244, OS id=827494
to execute - SYS.KUPW$WORKER.MAIN（"SYS_EXPORT_SCHEMA_01", "SYS"）;
kupprdp: worker process DW04 started with worker id=4, pid=245, OS id=348810
to execute - SYS.KUPW$WORKER.MAIN（"SYS_EXPORT_SCHEMA_01", "SYS"）;
Mon Nov 15 11:10:07 2010
ALTER SYSTEM SET service_names="SYS$SYS.KUPC$S_1_20101115110600.ALPHA","SYS$SYS.KUPC$C_1_20101115110600.ALPHA","alpha" SCOPE=MEMORY SID="alpha1";
Mon Nov 15 11:12:55 2010
ALTER SYSTEM SET service_names="SYS$SYS.KUPC$S_1_20101115110600.ALPHA","alpha" SCOPE=MEMORY SID="alpha1";
Mon Nov 15 11:12:56 2010
ALTER SYSTEM SET service_names="alpha" SCOPE=MEMORY SID="alpha1";

and all new services are broken.

Cause
This is Bug:8513146 THE SERVICE_NAMES VALUE IS SET TO NULL AFTER RUNNING EXPDP IN RAC ENVIRONMENT.

Solution

Depending on the version of your database, Patch:8513146 may exist.
As of Feb. 3rd 2012, this patch exists for:
- 10.2.0.4 / IBM AIX on POWER Systems （64-bit）
- 10.2.0.4.3 / Linux x86-64
- 10.2.0.5 / Linux x86, Linux x86-64 and IBM AIX on POWER Systems （64-bit）
If this fix does not exist on top of the latest available patchset for your platform, please log a new Service Request, provide evidences that you are encountering this issue and request for an interim patch for your platform.

References
BUG:8513146 - THE SERVICE_NAMES VALUE IS SET TO NULL AFTER RUNNING EXPDP IN RAC ENVIRONMENT.
相关内容
产品
？Oracle Database Products > Oracle Database > Oracle Database > Oracle Server - Enterprise Edition > RDBMS > Data Pump Export
关键字
RAC;SERVICE_NAMES从RAC恢复到单实例数据库操作步骤expdp时出错：ORA-39070的解决方法相关资讯 expdp

Oracle 11g版本expdp的COMPRESSION （今 07:43）
expdp与impdp参数用法（08月03日）
Oracle通过expdp的remap_data实现（03月29日）

exp和expdp 导出性能比较（08月03日）
利用Oracle自带的impdp和expdp进行（05月18日）
expdp导出报ORA-39181处理方法（12/15/2015 21:17:38）

本文评论查看全部评论（0）