After the system executes expdp export, alert. log reports the service name modification information, as follows:
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_20905020929.zzbrac3 ', 'sys $ SYS. KUPC $ s_1_20905020929.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_20905020929.zzbrac3 'SCOPE = memory sid = 'zzbrac31 ';
Alter system set service_names = ''SCOPE = memory sid = 'zzbrac31 ';
Resolution information provided by MOS [ID 1269319.1]
On RAC, expdp Removes the Service Name [ID 1269319.1]
--------------------------------------------------------------------------------
Modification time: 2012-2-4 type: PROBLEM status: MODERATED Priority: 3
Note (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:
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_000020101115110600.alpha 'SCOPE = memory sid = 'alpha1 ';
Mon Nov 15 11:06:07 2010
Alter system set service_names = 'sys $ SYS. KUPC $ c_000020101115110600.omega ', 'sys $ SYS. KUPC $ s_000020101115110600.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_000020101115110600 ', 'kupc $ s_000020101115110600', 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_000020101115110600.alpha ', 'sys $ SYS. KUPC $ c_000020101115110600.alpha', 'alpha' SCOPE = memory sid = 'alpha1 ';
Mon Nov 15 11:12:55 2010
Alter system set service_names = 'sys $ SYS. KUPC $ s_000020101115110600.alpha ', 'alpha' SCOPE = memory sid = 'alph1 ';
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:
-10.2.0.4/ibm aix on POWER Systems (64-bit)
-10.2.0.4.3/x86-64 for Linux
-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.
Related content
Product
? Oracle Database Products> Oracle Database> Oracle Server-Enterprise Edition> RDBMS> Data Pump Export
Keywords
RAC; SERVICE_NAMES