Re: Datapump export to ACFS with UEK6

Hello,

Did you update the ACFS linux drivers?

Regards,
Frank

On Thu, Dec 2, 2021 at 4:12 PM Pausch Manfred <dmarc-noreply_at_freelists.org> wrote:

> Hello all,
>
>
>
> anybody having 19c databases with a data_pump_dir on ACFS using UEK6?
>
> Can you successfully do a datapump export?
>
>
>
> With UEK6 (5.4.17-2136.301.1.3.el7uek, and also older versions of UEK6) I
> get the following output in my datapump logfile:
>
>
>
> Export: Release 19.0.0.0.0 - Production on Wed Dec 1 19:31:51 2021
>
> Version 19.13.0.0.0
>
>
>
> Copyright (c) 1982, 2019, Oracle and/or its affiliates. All rights
> reserved.
>
> ;;;
>
> Connected to: Oracle Database 19c Enterprise Edition Release 19.0.0.0.0 -
> Production
>
> ORA-39097: Data Pump job encountered unexpected error -31644
>
> ORA-39065: unexpected master process exception in FILE
>
> ORA-31644: unable to position to block number 2 in dump file
> "/u02/datapump/expdp_acfstest.dmp"
>
> ORA-06512: at "SYS.KUPF$FILE", line 4430
>
> ORA-06512: at "SYS.KUPF$FILE", line 2676
>
> ORA-19502: write error on file "/u02/datapump/expdp_acfstest.dmp", block
> number 1 (block size=4096)
>
> ORA-27061: waiting for async I/Os failed
>
> Linux-x86_64 Error: 22: Invalid argument
>
> Additional information: 4294967295
>
> Additional information: 4096
>
> ORA-06512: at "SYS.KUPF$FILE_INT", line 80
>
> ORA-06512: at "SYS.KUPF$FILE", line 2573
>
> ORA-06512: at "SYS.KUPF$FILE", line 4410
>
>
>
>
>
> Expdp parameter file is quite simple:
>
> DIRECTORY=DATA_PUMP_DIR <- DATA_PUMP_DIR is on ACFS
>
> DUMPFILE=expdp_acfstest.dmp
>
> LOGFILE=expdp_acfstest.log
>
> FLASHBACK_TIME="TO_TIMESTAMP(TO_CHAR(SYSDATE,'YYYY-MM-DD
> HH24:MI:SS'),'YYYY-MM-DD HH24:MI:SS')"
>
> SCHEMAS=MYSCHEMA
>
> EXCLUDE=STATISTICS
>
> CLUSTER=no
>
> PARALLEL=2
>
> QUERY=MYSCHEMA.TABLE1:"WHERE 1=2",
>
> MYSCHEMA.TABLE2:"WHERE 1=2",
>
> MYSCHEMA.TAB3:"WHERE 1=2",
>
> MYSCHEMA.TAB4:"WHERE 1=2",
>
> MYSCHEMA.TAB5:"WHERE 1=2",
>
> MYSCHEMA.TAB6:"WHERE 1=2"
>
>
>
>
>
> When I boot the VM with UEK5 (4.14.35-2047.508.3.2.el7uek and also older
> versions of UEK5 ) the same datapump export works without problems.
>
>
>
> Some futher information about my environment:
>
>
>
> OS: Oracle Linux 7.9 x86_64
>
>
>
> Grid Infrastructure is on 19.13:
>
> $ opatch lspatches
>
> 33239955;TOMCAT RELEASE UPDATE 19.0.0.0.0 (33239955)
>
> 33208123;OCW RELEASE UPDATE 19.13.0.0.0 (33208123)
>
> 33208107;ACFS RELEASE UPDATE 19.13.0.0.0 (33208107)
>
> 33192793;Database Release Update : 19.13.0.0.211019 (33192793)
>
> 32585572;DBWLM RELEASE UPDATE 19.0.0.0.0 (32585572)
>
>
>
> Database also on 19.13:
>
> $ opatch lspatches
>
> 30978304;ORA-20000 DURING IMPDP WITH STATS AND THE UNIQUE INDEX FOR THE PK
> IS NOT CREATED
>
> 33208123;OCW RELEASE UPDATE 19.13.0.0.0 (33208123)
>
> 33192793;Database Release Update : 19.13.0.0.211019 (33192793)
>
>
>
>
>
> Maybe anybody has the same issue?
>
>
>
> Thanks
>
>
>
> Manfred
>
>
>

-- 
+353-86-0695383

--
http://www.freelists.org/webpage/oracle-l