Return-Path: X-Original-To: oracle-l@orafaq.com Delivered-To: oracle-l@orafaq.com Received: from smtp-aa.freelists.org (smtp-aa.freelists.org [23.23.80.81]) by malta2546.startdedicated.com (Postfix) with ESMTPS id DDBC210031C85A for ; Fri, 3 Dec 2021 13:32:56 +0100 (CET) Received: from turing.freelists.org (ip-10-0-0-164.ec2.internal [10.0.0.164]) (using TLSv1.3 with cipher TLS_AES_256_GCM_SHA384 (256/256 bits) key-exchange X25519 server-signature RSA-PSS (2048 bits)) (No client certificate requested) by smtp-aa.freelists.org (Avenir Technologies Mail Multiplex) with ESMTPS id 6519742837; Fri, 3 Dec 2021 12:32:55 +0000 (UTC) Received: from localhost (localhost [127.0.0.1]) by turing.freelists.org (Postfix) with ESMTP id 50F4E40089; Fri, 3 Dec 2021 12:32:55 +0000 (UTC) DKIM-Signature: v=1; a=rsa-sha256; c=simple/simple; d=freelists.org; s=turing; t=1638534775; bh=+xHTmpvs310xK5EzjnIfd7yunqT8PnCUyOn/p8ooce8=; h=From:Sender:Sender:From; b=gEqDp1F02dFgIDhAfZxvnbKOg+Tq346bLPi0msrbGjPJqKLe5pC2fSaY+fRHKyc9z 7j/aHexrmra+rqMGvXpLjzGn/qRQjlFkR7l1gz2N2jk20ecD0zuh8utcQJ3x4hi/2v 5k1p60WMEYwyH1Lm2fTXFoeQh9lUhCpIZ1/tDfbI= X-Virus-Scanned: by FreeLists at turing.freelists.org Received: from turing.freelists.org ([127.0.0.1]) by localhost (turing.freelists.org [127.0.0.1]) (amavisd-new, port 10024) with ESMTP id F7MD7iY_a1nt; Fri, 3 Dec 2021 12:32:55 +0000 (UTC) Received: from turing.freelists.org (localhost [127.0.0.1]) by turing.freelists.org (Postfix) with ESMTP id 49B5A4008B; Fri, 3 Dec 2021 12:32:52 +0000 (UTC) DKIM-Signature: v=1; a=rsa-sha256; c=simple/simple; d=freelists.org; s=turing; t=1638534773; bh=+xHTmpvs310xK5EzjnIfd7yunqT8PnCUyOn/p8ooce8=; h=From:Sender:Sender:From; b=LMrzGsa+mb2Eq/agGFRw0vUeOiaZ6i0CAeskk7VnOyWr+Sqr9MBAoR2t1NxalaIlV p6hmCYJb7HotVLxH1VK+dv1zM1EVqBDfakjx/ESlQ2kCw89/RHnLcRxV5AwgB4Rsjv 1lKioEhkO4WmgnO3mEXwSNzF26IXJtL4h9HmoyeQ= Received: with ECARTIS (v1.0.0; list oracle-l); Fri, 03 Dec 2021 12:32:50 +0000 (UTC) Received: from localhost (localhost [127.0.0.1]) by turing.freelists.org (Postfix) with ESMTP id 5F72A40089 for ; Fri, 3 Dec 2021 12:32:50 +0000 (UTC) Authentication-Results: turing.freelists.org; dkim=pass (1024-bit key; unprotected) header.d=tgw-group.com header.i=@tgw-group.com header.a=rsa-sha256 header.s=selector1 header.b=IVFTSIL2; dkim-atps=neutral Received: from turing.freelists.org ([127.0.0.1]) by localhost (turing.freelists.org [127.0.0.1]) (amavisd-new, port 10024) with ESMTP id cgwT1MuMryNz for ; Fri, 3 Dec 2021 12:32:50 +0000 (UTC) Received: from EUR05-AM6-obe.outbound.protection.outlook.com (mail-am6eur05on2125.outbound.protection.outlook.com [40.107.22.125]) (using TLSv1.2 with cipher ECDHE-RSA-AES256-GCM-SHA384 (256/256 bits)) (No client certificate requested) by turing.freelists.org (Postfix) with ESMTPS id 6A0E83FD0E for ; Fri, 3 Dec 2021 12:32:49 +0000 (UTC) ARC-Seal: i=1; a=rsa-sha256; s=arcselector9901; d=microsoft.com; cv=none; b=GvJdXjaDPLAxo0tww55jDPlSrUoaLIdJ9FP/MTYdxE7HztT2FaitrsXstVrBforEsQR64LVmnKigzExMTAhZjaby+S5sIvnrnFGv7lHOebtVgHa7zng+b1P9ALBmP/GAev1ZVMGTONkDLPpdBy6X7d3/Q/RMLLJtGBcrqG82h33s3vS3WgWWdPfcAUDqdiDfgMg25gLe+iODCNzGDlO+f+nBpiA+GiccJuCgdWgXpuuzcKGpJnh+4Y17C5aO5xL3hURi9WmQybt8rf/kVeoiSaCV4WBmbK0grrMazRVOr5CMSx6Ugo1n5RhBjS/NV11ZDpO+jIwihxvpOhpLwVhCyQ== ARC-Message-Signature: i=1; a=rsa-sha256; c=relaxed/relaxed; d=microsoft.com; s=arcselector9901; h=From:Date:Subject:Message-ID:Content-Type:MIME-Version:X-MS-Exchange-AntiSpam-MessageData-ChunkCount:X-MS-Exchange-AntiSpam-MessageData-0:X-MS-Exchange-AntiSpam-MessageData-1; bh=evUeUo9oIW9rYdxB0Fma+Fn9k0o5PjkJo5H+4i/rDJQ=; b=OFdLE/MbC3wI9vRm8HCk8YkG2vQIbFxU9dKmjkIU9pvzcExEEzEvVj7mxEwYjpv7Ai9SjPPYle29DR71/aLqdd7g3TlOfRsUeVFBDhi26DP6ZfBGL/cWbG1JR7CxB9s924KR6HJ1gYP2WyHvg2+9wfIPo5rL6AyOlAnfhPQvOmiEyd89zaqNKZrUKZQMBkJmk8AL9lWUE8w2Ow3k/XR74C6MXWprO2RxdGUWPnna4jV6OU1HQ5r3v4IjCLkkiUU8/TjGysfYb8gWq7j358VP6zRMKnEujs8M6XB1q6pjjePWkDZmAsfe0V7RwR3C3A4ytFOIEdALZVHgpNS3kOtRtA== ARC-Authentication-Results: i=1; mx.microsoft.com 1; spf=pass smtp.mailfrom=tgw-group.com; dmarc=pass action=none header.from=tgw-group.com; dkim=pass header.d=tgw-group.com; arc=none Authentication-Results: dkim=none (message not signed) header.d=none;dmarc=none action=none header.from=tgw-group.com; Received: from AS4P191MB2086.EURP191.PROD.OUTLOOK.COM (2603:10a6:20b:4b2::6) by AS4P191MB2039.EURP191.PROD.OUTLOOK.COM (2603:10a6:20b:4c3::16) with Microsoft SMTP Server (version=TLS1_2, cipher=TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384) id 15.20.4755.16; Fri, 3 Dec 2021 12:32:47 +0000 Received: from AS4P191MB2086.EURP191.PROD.OUTLOOK.COM ([fe80::95b8:a5e7:5d2c:1c7a]) by AS4P191MB2086.EURP191.PROD.OUTLOOK.COM ([fe80::95b8:a5e7:5d2c:1c7a%4]) with mapi id 15.20.4734.024; Fri, 3 Dec 2021 12:32:45 +0000 Date: Fri, 03 Dec 2021 13:32:44 +0100 From: "Manfred Pausch" ("manfred.pausch") To: Frank Gordon CC: Oracle Mailing List Subject: Re: [EXT] Re: Datapump export to ACFS with UEK6 User-Agent: K-9 Mail for Android In-Reply-To: References: Message-ID: Content-Type: multipart/alternative; boundary=----FN66T0Y8K8316JMB0M3MVHF8KQFUAQ Content-Transfer-Encoding: 7bit X-ClientProxiedBy: AM5PR0301CA0018.eurprd03.prod.outlook.com (2603:10a6:206:14::31) To AS4P191MB2086.EURP191.PROD.OUTLOOK.COM (2603:10a6:20b:4b2::6) MIME-Version: 1.0 Received: from [127.0.0.1] (79.253.119.123) by AM5PR0301CA0018.eurprd03.prod.outlook.com (2603:10a6:206:14::31) with Microsoft SMTP Server (version=TLS1_2, cipher=TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384) id 15.20.4755.17 via Frontend Transport; Fri, 3 Dec 2021 12:32:45 +0000 X-MS-PublicTrafficType: Email X-MS-Office365-Filtering-Correlation-Id: fd5cfd42-343b-4f6f-96c6-08d9b6590217 X-MS-TrafficTypeDiagnostic: AS4P191MB2039: X-Microsoft-Antispam-PRVS: X-MS-Oob-TLC-OOBClassifiers: OLM:8273; X-MS-Exchange-SenderADCheck: 1 X-MS-Exchange-AntiSpam-Relay: 0 X-Microsoft-Antispam: BCL:0; X-Microsoft-Antispam-Message-Info: sQhBi9F9LF6Gv4g/wwf7svUgb6VdFbOeUNy2IhLzmsYAVp0uVENAQ8PulUflyEpSgNar2/ptCbUqOX3lvDYidAYbzw5T/GJkDZBJbf/28Q0aiQdjqeK64EA79gTl96FOlr4bkt44ESJ0JVjK25Fh7QNAZUKE0Id2WlRsGUSNN2NzBsT5FuxJ8nSxnavWNCn1Nuh97Q6rC5khrfHpEvP286ltRtUZXg6e6z229I5ChkvfQ+n//jevPYTelnwCDBO4VwTCDvJOZDrlNIk8RFuHAXYBDw7e7SMTzy0jLduQJZ/Mt9iJ8VuwtVx2j+EzKm36ln0cMQC3QvNqivMF0tE/bOKmrV69aUQwYPKpLxIhOL8xuHehjPQPTud32JIqcBJyNeYTbMkd1nfK9qrP4yK+x+EGn+dTGEicYzl3Xz09dIGKnD3RtrGlzEc/oRbjLp1yEcFbTB4SxVWUnivppOes9boCUM75aigTX0bO38cY9KCr4nijM/TI87Z2IpoZ8SSPbqIjrzdNqCyr5yfGnvjLyPT7bllHF/DeMywH7ww0bVqoaChFQtTuWq5SR2eevvvUAIX3/lEgX7pE1H7Lo1wyd4sqfGCLCJCUeG6yRoCimkLCZbHNolnFuQ+CJTqmjWwGYEcZGoMfaHttqSjYbdERBKMOZghyai0YYLRmqGG3ao5tZd4WnjSWXxVgvg98ynsZAgkzg8r6v9AhBF+TkqNUFIZAnWoIC30tVplwnvhQ5iV4TdrNOhMqk4tf/J/H0tpoOPQ32n8ogzm9rymE0I252QJP27jFhCCJfU4TLfB1nn/d8fYqVz09wjC8z8kGideM X-Forefront-Antispam-Report: CIP:255.255.255.255;CTRY:;LANG:en;SCL:1;SRV:;IPV:NLI;SFV:NSPM;H:AS4P191MB2086.EURP191.PROD.OUTLOOK.COM;PTR:;CAT:NONE;SFS:(4636009)(366004)(956004)(7126003)(2616005)(52116002)(36756003)(508600001)(33656002)(4326008)(5660300002)(44832011)(66946007)(86362001)(53546011)(83380400001)(166002)(38350700002)(38100700002)(316002)(7246003)(8676002)(186003)(33964004)(66476007)(8936002)(6916009)(2906002)(6486002)(66556008)(16576012)(26005)(45980500001);DIR:OUT;SFP:1102; X-MS-Exchange-AntiSpam-MessageData-ChunkCount: 1 X-MS-Exchange-AntiSpam-MessageData-0: =?utf-8?B?amxzVVdZR2o4TFdCTDRFbS9nSy9aQ21LUkRVM0NaVnR6ZEZQd3M0ckk5SDUz?= =?utf-8?B?a3NKZVcwaTNqUmR0MTlzQ0RPejd1RUFMZFpadFFtZzZtZWVSZytkdFVVTFgv?= =?utf-8?B?OCtBUEMyRmNZOGhyMU9iZVEwZEFCSGVhUEw3MXhuQzVWVytqTzgxbTF2Vmhp?= =?utf-8?B?Q0RDQWo4YnlMVUpvWk9YRmp3QkovQis3NlNVWlVmVWY0cFBKWjNBSGJzSU9G?= =?utf-8?B?ZCtLTUsxU2V5YjJpRVF2ajhlM05CeE96d3RDM1B3WGQvZlc1Nk90NXROM1dB?= =?utf-8?B?dGdES1EyeW83bXJBdFJKUkxsaXB1VDlZVGxNOGc2eEZFZEVDanB6dWVXVmpM?= =?utf-8?B?RjNqU0NDeEJPUzIrbDNReGxWVU8wL2ljTFl1eVlUaGdvekp0R0dHb1hURkxv?= =?utf-8?B?VUM0dm1HK29KSU5OMU5lUDZkZkppVE1yRmxBbjRGY1FkK05kckE2OUdyRGV1?= =?utf-8?B?OXliWm1OckRTN1Nwak9jeG83bnBjVzgvVFNjUWY3NU1qQngzbHMxSnp3ZDlB?= =?utf-8?B?cUlvcEtDYzhaOVFocUNzeEtHVVRPTS9BSzlZNUdDbGFXWTYvU01hNXNBWmk3?= =?utf-8?B?ZG1tZ05INC9jcWozOWRhcC93eDFkSnlwUmFtQWYyN0RJMlcxdHJreC84MjRv?= =?utf-8?B?UERKMUNmSWpOL0FTN1pTcHY5bHZSUFNuKzdTdXBLV3hweklLSW0vSG1OYnJQ?= =?utf-8?B?c0IxVjE4VEhKQ2J1SFJKTExlUEZwRWxLejc1bWNlOGkwUnpxZUF3R253bjY2?= =?utf-8?B?KzEwRU5OejlvM2tHK2RTdEJINDhJdEw2aElOY3VnWkdmOE9jaUJOMkhYNWZD?= =?utf-8?B?RXpYZ3VRdVlyNGxhTFlMWDYrcWdQVWc0TjdjeVppb1VtNms2VFFPWFRqeEJ0?= =?utf-8?B?UGNsQ3JMNU9VUHJOZTdJbzlJak96UERTUDNtS1I2L3hrT3FNaU9IbGlwYVdZ?= =?utf-8?B?SVlTRmc0QjVlTnozMm1uR2xxdDY0MDRQR0NNMmVMTk8vQk9KdmxkZ3dTaDZF?= =?utf-8?B?cFJFM1RMMDl0TnpPQkloSWJJNmR3YXlXais2UWFsK3M4UlRseTJBU1lqZHNn?= =?utf-8?B?bGVIUlFSMjVNeXpLUTN4MDhCWkE1c0VSOWZEdU1OK1I0Sklpd0NBa0RoQ21Z?= =?utf-8?B?elJSTVIyM2dUQTVqaE9KdFY2cng1QWZTOEphN21hcGg3UE9RbTlCaTZrdXl1?= =?utf-8?B?cWNpSXdEbmx1S25TM1VwNjZLQ0huV3F4VmJrcWNrV0U1aHVVVHo0SUdzc2ky?= =?utf-8?B?eEtYNGhhSWx2STN4Z0dibXgxWlJ1L0pyQkovU1lSeEVwem1tOTk5RlU3RE4w?= =?utf-8?B?Vlo2UE9Jd0o5c2s3czlpaWpiajZyUlZVTDZjQyt0ekFuRzl5clZwNXpwak4y?= =?utf-8?B?TFdPbENCWFRLZEY1c0F0OEorUnZmaGVEMUdXSXVEUFBnemhUOVNNNWhSV3RJ?= =?utf-8?B?NU0xR0MvVWxvQUFob2Jjb3laRUJFaE5uWEVzL3ZLTnJtWnFFWVR2MExRM3Bu?= =?utf-8?B?M1F6Tm1BVWp6M3FCLzlRdFNwZ2NmRjZ3Rkl5bytyRFBTcGd0dEpLZEVqaVlZ?= =?utf-8?B?TnliMkFCb0Z5ZkZWMExobDhKZDlITStCeDl0WlBYTDYvREY1am16endaTEhP?= =?utf-8?B?YXQxU0NXSXBYcWl4QVRQVnZpV3RKWCtKd3ZoTXlZNEg0Y01pNmgwNzZZTWQ0?= =?utf-8?B?bjhRYjY4cVRreEdEN3l6T0g2R2hkTXZBdXNBZzJKaWszUDg3SUdld3JNazNH?= =?utf-8?B?MzRQYTRhOC9aQXhvanU4RXNYdkhhT2V1cHh0L3hTQWF6ZmxqbEZqcEo0bnFB?= =?utf-8?B?TURTNVZCd1ZyalZQMGV1T1Z4N0VCVWlqZmRJK1p5SVBxL0VHalVjV21lM0pq?= =?utf-8?B?dTNDRlJTSDFIRFN5bHltaWYvZkhWc08zaURiZnN6T1dDUVk2OVkrWDFqNmdn?= =?utf-8?B?Q3NrN2xMbXM4SU16VHQ3SWlBZERNY09QQXl4MHhrVUgyMTY4NmhNUFlXTXVZ?= =?utf-8?B?SmNzUFN3Vk1RRnpCMjlIdmllVkJDT0pONE1RV3BmSzNCVGR5cjAvZzVDZzBp?= =?utf-8?B?SGhYb1BCc2lOaER6cTFzTE1lWTUvVldJMXhlQkwrNC94UHZDenNMZ2lIZStQ?= =?utf-8?B?VGw3S3BadUJKd1p3N3BLMEdVMUZSdTdEbjBSN1hCZVNPMUc1dmFpdGd0SkRO?= =?utf-8?Q?KQVvHmoLbQEQ0VoUkWJidkY=3D?= X-OriginatorOrg: tgw-group.com X-MS-Exchange-CrossTenant-Network-Message-Id: fd5cfd42-343b-4f6f-96c6-08d9b6590217 X-MS-Exchange-CrossTenant-AuthSource: AS4P191MB2086.EURP191.PROD.OUTLOOK.COM X-MS-Exchange-CrossTenant-AuthAs: Internal X-MS-Exchange-CrossTenant-OriginalArrivalTime: 03 Dec 2021 12:32:45.4245 (UTC) X-MS-Exchange-CrossTenant-FromEntityHeader: Hosted X-MS-Exchange-CrossTenant-Id: 409598cf-67ac-44d8-bad5-877b05415cdc X-MS-Exchange-CrossTenant-MailboxType: HOSTED X-MS-Exchange-CrossTenant-UserPrincipalName: QxBWmOnnFztnjx1xVbxZOn7D4KRiCvgzgUFUFArQH6HguXH8q2Htd4mOevqoHlCZz5G5Vgu11/1zdHNVmaY1rg== X-MS-Exchange-Transport-CrossTenantHeadersStamped: AS4P191MB2039 X-FreeLists-DMARC-Sender: manfred.pausch@tgw-group.com X-archive-position: 81518 X-ecartis-version: Ecartis v1.0.0 Sender: oracle-l-bounce@freelists.org Errors-to: oracle-l-bounce@freelists.org X-original-sender: manfred.pausch@tgw-group.com Precedence: normal Reply-To: manfred.pausch@tgw-group.com List-Help: List-Unsubscribe: List-software: Ecartis version 1.0.0 List-Id: oracle-l X-List-ID: oracle-l List-Subscribe: List-Owner: List-post: List-Archive: X-list: oracle-l ------FN66T0Y8K8316JMB0M3MVHF8KQFUAQ Content-Type: text/plain; charset=utf-8 Content-Transfer-Encoding: quoted-printable Hi, not manually=2E I can remember that there was depmod running quite some ti= me after the first reboot with UEK6=2E And I was able to mount ACFS with UEK6=2E According to docs, ACFS drivers get updated automatically=2E=2E=2E? (https= ://docs=2Eoracle=2Ecom/en/database/oracle/oracle-database/19/ostmg/oracle-p= atching-and-oracle-acfs=2Ehtml#GUID-E8C5D948-849B-4A7D-B5D7-29F9D792BDE0 ) So I assume that ACFS drivers got updated=2E Regards Manfred Am 3=2E Dezember 2021 13:18:47 MEZ schrieb Frank Gordon : >Hello, > >Did you update the ACFS linux drivers? > >Regards, >Frank > > >On Thu, Dec 2, 2021 at 4:12 PM Pausch Manfred >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=2E4=2E17-2136=2E301=2E1=2E3=2Eel7uek, and also older versi= ons of UEK6) I >> get the following output in my datapump logfile: >> >> >> >> Export: Release 19=2E0=2E0=2E0=2E0 - Production on Wed Dec 1 19:31:51 2= 021 >> >> Version 19=2E13=2E0=2E0=2E0 >> >> >> >> Copyright (c) 1982, 2019, Oracle and/or its affiliates=2E All rights >> reserved=2E >> >> ;;; >> >> Connected to: Oracle Database 19c Enterprise Edition Release 19=2E0=2E0= =2E0=2E0 - >> 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=2Edmp" >> >> ORA-06512: at "SYS=2EKUPF$FILE", line 4430 >> >> ORA-06512: at "SYS=2EKUPF$FILE", line 2676 >> >> ORA-19502: write error on file "/u02/datapump/expdp_acfstest=2Edmp", bl= ock >> number 1 (block size=3D4096) >> >> 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=2EKUPF$FILE_INT", line 80 >> >> ORA-06512: at "SYS=2EKUPF$FILE", line 2573 >> >> ORA-06512: at "SYS=2EKUPF$FILE", line 4410 >> >> >> >> >> >> Expdp parameter file is quite simple: >> >> DIRECTORY=3DDATA_PUMP_DIR <- DATA_PUMP_DIR is on ACFS >> >> DUMPFILE=3Dexpdp_acfstest=2Edmp >> >> LOGFILE=3Dexpdp_acfstest=2Elog >> >> FLASHBACK_TIME=3D"TO_TIMESTAMP(TO_CHAR(SYSDATE,'YYYY-MM-DD >> HH24:MI:SS'),'YYYY-MM-DD HH24:MI:SS')" >> >> SCHEMAS=3DMYSCHEMA >> >> EXCLUDE=3DSTATISTICS >> >> CLUSTER=3Dno >> >> PARALLEL=3D2 >> >> QUERY=3DMYSCHEMA=2ETABLE1:"WHERE 1=3D2", >> >> MYSCHEMA=2ETABLE2:"WHERE 1=3D2", >> >> MYSCHEMA=2ETAB3:"WHERE 1=3D2", >> >> MYSCHEMA=2ETAB4:"WHERE 1=3D2", >> >> MYSCHEMA=2ETAB5:"WHERE 1=3D2", >> >> MYSCHEMA=2ETAB6:"WHERE 1=3D2" >> >> >> >> >> >> When I boot the VM with UEK5 (4=2E14=2E35-2047=2E508=2E3=2E2=2Eel7uek a= nd also older >> versions of UEK5 ) the same datapump export works without problems=2E >> >> >> >> Some futher information about my environment: >> >> >> >> OS: Oracle Linux 7=2E9 x86_64 >> >> >> >> Grid Infrastructure is on 19=2E13: >> >> $ opatch lspatches >> >> 33239955;TOMCAT RELEASE UPDATE 19=2E0=2E0=2E0=2E0 (33239955) >> >> 33208123;OCW RELEASE UPDATE 19=2E13=2E0=2E0=2E0 (33208123) >> >> 33208107;ACFS RELEASE UPDATE 19=2E13=2E0=2E0=2E0 (33208107) >> >> 33192793;Database Release Update : 19=2E13=2E0=2E0=2E211019 (33192793) >> >> 32585572;DBWLM RELEASE UPDATE 19=2E0=2E0=2E0=2E0 (32585572) >> >> >> >> Database also on 19=2E13: >> >> $ opatch lspatches >> >> 30978304;ORA-20000 DURING IMPDP WITH STATS AND THE UNIQUE INDEX FOR THE= PK >> IS NOT CREATED >> >> 33208123;OCW RELEASE UPDATE 19=2E13=2E0=2E0=2E0 (33208123) >> >> 33192793;Database Release Update : 19=2E13=2E0=2E0=2E211019 (33192793) >> >> >> >> >> >> Maybe anybody has the same issue? >> >> >> >> Thanks >> >> >> >> Manfred >> >> >> > > >--=20 >+353-86-0695383 ------FN66T0Y8K8316JMB0M3MVHF8KQFUAQ Content-Type: text/html; charset=utf-8 Content-Transfer-Encoding: quoted-printable Hi,

not manually. I can remember that there was depmod ru= nning quite some time after the first reboot with UEK6.
And I was able t= o mount ACFS with UEK6.

According to docs, ACFS drivers get updated = automatically...? (https://docs.oracle.com/en/database/oracle/orac= le-database/19/ostmg/oracle-patching-and-oracle-acfs.html#GUID-E8C5D948-849= B-4A7D-B5D7-29F9D792BDE0 )

So I assume that ACFS drivers got upd= ated.

Regards
Manfred


Am 3.= Dezember 2021 13:18:47 MEZ schrieb Frank Gordon <frankagordon@gmail.com= >:
Hello,

Did you update the ACFS linux drivers?

Re= gards,
Frank


On Thu, Dec 2, 2021 at 4:12 PM Pausch Manfred <= dmarc-noreply@freelists.org<= /a>> 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 olde= r versions of UEK6) I get the following output in my datapump logfile:

 

Export: Release 19.0.0.0.0 - Production on We= d Dec 1 19:31:51 2021

Version 19.13.0.0.0

 

Copyright (c) 1982, 2019, Oracle and/or its a= ffiliates.  All rights reserved.

;;;

Connected to: Oracle Database 19c Enterprise = Edition Release 19.0.0.0.0 - Production

ORA-39097: Data Pump job encountered unexpect= ed error -31644

ORA-39065: unexpected master process exceptio= n in FILE

ORA-31644: unable to position to block number= 2 in dump file "/u02/datapump/expdp_acfstest.dmp"<= /span>

ORA-06512: at "SYS.KUPF$FILE", line= 4430

ORA-06512: at "SYS.KUPF$FILE", line= 2676

ORA-19502: write error on file "/u02/dat= apump/expdp_acfstest.dmp", block number 1 (block size=3D4096)

ORA-27061: waiting for async I/Os failed

Linux-x86_64 Error: 22: Invalid argument

Additional information: 4294967295<= /u>

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:<= /span>

DIRECTORY=3DDATA_PUMP_DIR   &n= bsp;  <- DATA_PUMP_DIR is on ACFS

DUMPFILE=3Dexpdp_acfstest.dmp

LOGFILE=3Dexpdp_acfstest.log

FLASHBACK_TIME=3D"TO_TIMESTAMP(TO_CHAR(S= YSDATE,'YYYY-MM-DD HH24:MI:SS'),'YYYY-MM-DD HH24:MI:SS')"

SCHEMAS=3DMYSCHEMA

EXCLUDE=3DSTATISTICS

CLUSTER=3Dno

PARALLEL=3D2

QUERY=3DMYSCHEMA.TABLE1:"WHERE 1=3D2&quo= t;,

MYSCHEMA.TABLE2:"WHERE 1=3D2",

MYSCHEMA.TAB3:"WHERE 1=3D2",=

MYSCHEMA.TAB4:"WHERE 1=3D2",=

MYSCHEMA.TAB5:"WHERE 1=3D2",=

MYSCHEMA.TAB6:"WHERE 1=3D2"<= u>

 

 

When I boot the VM with UEK5 (4.14.35-2047.508.3.2.e= l7uek and also older versions of UEK5 )  the same datapump export work= s 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 (33= 239955)

33208123;OCW RELEASE UPDATE 19.13.0.0.0 (3320= 8123)

33208107;ACFS RELEASE UPDATE 19.13.0.0.0 (332= 08107)

33192793;Database Release Update : 19.13.0.0.= 211019 (33192793)

32585572;DBWLM RELEASE UPDATE 19.0.0.0.0 (325= 85572)

 

Database also on 19.13:

$ opatch lspatches

30978304;ORA-20000 DURING IMPDP WITH STATS AN= D THE UNIQUE INDEX FOR THE PK IS NOT CREATED

33208123;OCW RELEASE UPDATE 19.13.0.0.0 (3320= 8123)

33192793;Database Release Update : 19.13.0.0.= 211019 (33192793)

 

 

Maybe anybody has the same issue?

 

Thanks

 

Manfred

 



--
+353-86-0695383
=
= ------FN66T0Y8K8316JMB0M3MVHF8KQFUAQ-- -- http://www.freelists.org/webpage/oracle-l