Discussion :

[lepierot]

Bonjour, suite a une erreur l'or d'un export vers un base 10G en utilisant EXPDP VERSION=10.2.0.5 j'ai l'erreur :

ORA-39126: Worker unexpected fatal error in KUPW$WORKER.FIXUP_MASTER_TABLE_EXPORT [TABLE_DATA:"SYS"."SYS_EXPORT_TABLE_03"]
ORA-12899: value too large for column "SYS"."KU$_DATAPUMP_MASTER_10_1"."PROCESSING_STATUS" (actual: 2, maximum: 1)
ORA-06512: at "SYS.DBMS_SYS_ERROR", line 95
ORA-06512: at "SYS.KUPW$WORKER", line 11259

En faisant des recherches j'ai cru comprendre que je devais appliquer le patch 22119791
p22119791_12102180417ProactiveBP_Generic

Mais en appliquant ce patch ca me demande de patcher Opatch avec le patch 6880880.
Enfin une fois opatch patché quand j'essai d'appliquer le 1er patch 22119791 ca me dit de patcher en 27338029. Or quand je recherche ce patch pour ma plateforme Windows 2016 je ne que des patch pour des platefforms Unix.

Quelqu'un aurait il une idee ?

Merci


Je vpous joint l'integralite des logs :

Microsoft Windows [Version 6.3.9600]
(c) 2013 Microsoft Corporation. All rights reserved.

C:\Windows\system32>cd c:\patchs

c:\patchs>cd p22119791_12102180417ProactiveBP_Generic

c:\patchs\p22119791_12102180417ProactiveBP_Generic>cd 22119791

c:\patchs\p22119791_12102180417ProactiveBP_Generic\22119791>C:\app\administrateu
r\product\12.1.0\dbhome_1\OPatch apply
'C:\app\administrateur\product\12.1.0\dbhome_1\OPatch' is not recognized as an i
nternal or external command,
operable program or batch file.

c:\patchs\p22119791_12102180417ProactiveBP_Generic\22119791>C:\app\administrateu
r\product\12.1.0\dbhome_1\OPatch\opatch apply

Programme d'installation des patches temporaires Oracle version 12.1.0.1.3
Copyright (c) 2019, Oracle Corporation. Tous droits rÚservÚs.


Oracle Home : C:\app\ADMINI~1\product\121~1.0\dbhome_1
Central Inventory : C:\Program Files\Oracle\Inventory
from : n/a
OPatch version : 12.1.0.1.3
OUI version : 12.1.0.2.0
Log file location : C:\app\ADMINI~1\product\121~1.0\dbhome_1\cfgtoollogs\opatch\
22119791_May_13_2019_12_56_07\apply2019-05-13_12-56-06PM_1.log

Applying interim patch '22119791' to OH 'C:\app\ADMINI~1\product\121~1.0\dbhome_
1'
Verifying environment and performing prerequisite checks...
Prerequisite check "CheckMinimumOPatchVersion" failed.
The details are:


The OPatch being used has version 12.1.0.1.3 while the following patch(es) requi
re higher versions:
Patch 22119791 requires OPatch version 12.1.0.1.4.
Please download latest OPatch from My Oracle Support.

Log file location: C:\app\ADMINI~1\product\121~1.0\dbhome_1\cfgtoollogs\opatch\2
2119791_May_13_2019_12_56_07\apply2019-05-13_12-56-06PM_1.log

Recommended actions: Please download latest OPatch from My Oracle Support by Pat
ch 6880880, release version (as appropriate) and appropriate platform.

OPatch failed with error code = 31

c:\patchs\p22119791_12102180417ProactiveBP_Generic\22119791>
c:\patchs\p22119791_12102180417ProactiveBP_Generic\22119791>C:\app\administrateu
r\product\12.1.0\dbhome_1\OPatch\opatch apply
Oracle Interim Patch Installer version 12.2.0.1.17
Copyright (c) 2019, Oracle Corporation. All rights reserved.


Oracle Home : C:\app\ADMINI~1\product\121~1.0\dbhome_1
Central Inventory : C:\Program Files\Oracle\Inventory
from :
OPatch version : 12.2.0.1.17
OUI version : 12.1.0.2.0
Log file location : C:\app\ADMINI~1\product\121~1.0\dbhome_1\cfgtoollogs\opatch\
opatch2019-05-13_13-03-11PM_1.log

Verifying environment and performing prerequisite checks...



UtilSession failed: Interim patch 22119791 requires prerequisite patch(es) [273
38029] which are not present in the Oracle Home.
Apply prerequisite patch(es) [27338029] before applying interim patch 22119791.
Log file location: C:\app\ADMINI~1\product\121~1.0\dbhome_1\cfgtoollogs\opatch\o
patch2019-05-13_13-03-11PM_1.log

OPatch failed with error code = 73

c:\patchs\p22119791_12102180417ProactiveBP_Generic\22119791>sqlplus

SQL*Plus: Release 12.1.0.2.0 Production on Lun. Mai 13 13:29:50 2019

Copyright (c) 1982, 2017, Oracle. All rights reserved.