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

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

[日期：2012-09-07]

来源：Linux社区

作者：DBAYONG

[字体：大 中 小]

系统在执行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