[Solved Issue] DBMS_PDB.CHECK_PLUG_COMPATIBILIT ORA-7445[__intel_ssse3_rep_memcpy()+6429]

Administration, Multitenant / 14/07/2022

Ao tentar realizar a verificação de compatibilidade de um novo PDB ao CDB, a seguinte mensagem era apresentada:

[oracle@oel8 ~]$ sqlplus / as sysdba
 
SQL*Plus: Release 18.0.0.0.0 - Production on Thu Mar 18 04:51:10 2021
Version 18.3.0.0.0
 
Copyright (c) 1982, 2018, Oracle.  All rights reserved.
 
 
Connected to:
Oracle Database 18c Enterprise Edition Release 18.0.0.0.0 - Production
Version 18.3.0.0.0
 
SQL> set serveroutput on
DECLARE
        compatible BOOLEAN := FALSE;
BEGIN
        compatible := DBMS_PDB.CHECK_PLUG_COMPATIBILITY( PDB_DESCR_FILE => '/home/oracle/HIPOFISE2.xml');
        if compatible then
                DBMS_OUTPUT.PUT_LINE('It is compatible');
        else
        DBMS_OUTPUT.PUT_LINE('It is NOT compatible');
        end if;
END;
/SQL>   2    3    4    5    6    7    8    9   10   11
ERROR:
ORA-03114: not connected to ORACLE
 
 
DECLARE
*
ERROR at line 1:
ORA-03113: end-of-file on communication channel
Process ID: 7890
Session ID: 96 Serial number: 57426

No alert, é possível ver a seguinte mensagem:

2021-03-18 04:51:12.232000 -03:00
Exception [type: SIGSEGV, Address not mapped to object] [ADDR:0xFFFFFFFFFFFFFFEF] [PC:0x6E2FDA6, __intel_ssse3_rep_memcpy()+6710] [flags: 0x0, count: 1]
Errors in file /oracle/18.0.0/base/diag/rdbms/talamo/TALAMO/trace/TALAMO_ora_7890.trc  (incident=29209) (PDBNAME=CDB$ROOT):
ORA-07445: exception encountered: core dump [__intel_ssse3_rep_memcpy()+6710] [SIGSEGV] [ADDR:0xFFFFFFFFFFFFFFEF] [PC:0x6E2FDA6] [Address not mapped to object] []
Incident details in: /oracle/18.0.0/base/diag/rdbms/talamo/TALAMO/incident/incdir_29209/TALAMO_ora_7890_i29209.trc
Use ADRCI or Support Workbench to package the incident.
See Note 411.1 at My Oracle Support for error and packaging details.
Dumping diagnostic data in directory=[cdmp_20210318045113], requested by (instance=1, osid=7890), summary=[incident=29209].

Encontrado no MOS uma nota referenciando o fenômeno como um BUG (28502403). Note: “DBMS_PDB.CHECK_PLUG_COMPATIBILITY = ORA-3113 / ORA-7445[__intel_ssse3_rep_memcpy()+6429] (Doc ID 2446450.1)“. Há 2 soluções: migrar o ambiente de 18C para 19.1, ou aplicar um patch (caso tenha disponível para a sua versão):

Realizando download:

Após download e cópia do arquivo para a máquina virtual, realizando o unzip:

[oracle@oel8 ~]$ unzip -q p28502403_183000DBRU_Linux-x86-64.zip
[oracle@oel8 ~]$

[oracle@oel8 28502403]$ ll
total 8
drwxr-x---. 3 oracle oinstall   20 Aug 22  2018 etc
drwxr-x---. 3 oracle oinstall   17 Aug 22  2018 files
-rw-rw-r--. 1 oracle oinstall 6116 Aug 22  2018 README.txt
[oracle@oel8 28502403]$ pwd
/home/oracle/28502403

Garantindo que a versão do OPatch é a mínima exigida através da leitura do readme:

[oracle@oel8 OPatch]$ cd $ORACLE_HOME/
[oracle@oel8 product]$ cd $ORACLE_HOME/OPatch
[oracle@oel8 OPatch]$ ./opatch version
OPatch Version: 12.2.0.1.14
 
OPatch succeeded.

Garantindo que o PSU 28090523 esteja já aplicado:

[oracle@oel8 OPatch]$ ./opatch lsinventory | grep escript
ARU platform description:: Linux x86-64
Patch description:  "UPDATE 18.3 DATABASE CLIENT JDK IN ORACLE HOME TO JDK8U171"
Patch description:  "OJVM RELEASE UPDATE: 18.3.0.0.180717 (27923415)"
Patch description:  "OCW RELEASE UPDATE 18.3.0.0.0 (28090553)"
Patch description:  "Database Release Update : 18.3.0.0.180717 (28090523)"

Verificando se haverá algum tipo de incompatibilidade com o novo Patch:

[oracle@oel8 28502403]$ cd ~/28502403
[oracle@oel8 28502403]$ /oracle/18.0.0/product/OPatch/opatch prereq CheckConflictAgainstOHWithDetail -ph ./
Oracle Interim Patch Installer version 12.2.0.1.14
Copyright (c) 2021, Oracle Corporation.  All rights reserved.
 
PREREQ session
 
Oracle Home       : /oracle/18.0.0/product
Central Inventory : /oracle/18.0.0/oraInventory
   from           : /oracle/18.0.0/product/oraInst.loc
OPatch version    : 12.2.0.1.14
OUI version       : 12.2.0.4.0
Log file location : /oracle/18.0.0/product/cfgtoollogs/opatch/opatch2021-03-18_05-21-02AM_1.log
 
Invoking prereq "checkconflictagainstohwithdetail"
 
Prereq "checkConflictAgainstOHWithDetail" passed.
 
OPatch succeeded.
[oracle@oel8 28502403]$

Baixando o ambiente de banco de dados e listener:

[oracle@oel8 28502403]$ sqlplus / as sysdba
 
SQL*Plus: Release 18.0.0.0.0 - Production on Thu Mar 18 05:23:27 2021
Version 18.3.0.0.0
 
Copyright (c) 1982, 2018, Oracle.  All rights reserved.
 
 
Connected to:
Oracle Database 18c Enterprise Edition Release 18.0.0.0.0 - Production
Version 18.3.0.0.0
 
SQL> shu immediate;
Database closed.
Database dismounted.
ORACLE instance shut down.
SQL> exit
Disconnected from Oracle Database 18c Enterprise Edition Release 18.0.0.0.0 - Production
Version 18.3.0.0.0
[oracle@oel8 28502403]$ lsnrctl stop
 
LSNRCTL for Linux: Version 18.0.0.0.0 - Production on 18-MAR-2021 05:24:19
 
Copyright (c) 1991, 2018, Oracle.  All rights reserved.
 
Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=oel8.localdomain)(PORT=1521)))
The command completed successfully

Aplicando efetivamente o Patch:

[oracle@oel8 28502403]$ cd ~/28502403
[oracle@oel8 28502403]$ /oracle/18.0.0/product/OPatch/opatch apply
Oracle Interim Patch Installer version 12.2.0.1.14
Copyright (c) 2021, Oracle Corporation.  All rights reserved.
 
 
Oracle Home       : /oracle/18.0.0/product
Central Inventory : /oracle/18.0.0/oraInventory
   from           : /oracle/18.0.0/product/oraInst.loc
OPatch version    : 12.2.0.1.14
OUI version       : 12.2.0.4.0
Log file location : /oracle/18.0.0/product/cfgtoollogs/opatch/opatch2021-03-18_05-25-37AM_1.log
 
Verifying environment and performing prerequisite checks...
OPatch continues with these patches:   28502403
 
Do you want to proceed? [y|n]
y
User Responded with: Y
All checks passed.
 
Please shutdown Oracle instances running out of this ORACLE_HOME on the local system.
(Oracle Home = '/oracle/18.0.0/product')
 
 
Is the local system ready for patching? [y|n]
y
User Responded with: Y
Backing up files...
Applying interim patch '28502403' to OH '/oracle/18.0.0/product'
 
Patching component oracle.rdbms, 18.0.0.0.0...
Patch 28502403 successfully applied.
Log file location: /oracle/18.0.0/product/cfgtoollogs/opatch/opatch2021-03-18_05-25-37AM_1.log
 
OPatch succeeded.
[oracle@oel8 28502403]$

Validando no inventário a aplicação do Patch:

[oracle@oel8 28502403]$ /oracle/18.0.0/product/OPatch/opatch lsinventory
Oracle Interim Patch Installer version 12.2.0.1.14
Copyright (c) 2021, Oracle Corporation.  All rights reserved.
 
 
Oracle Home       : /oracle/18.0.0/product
Central Inventory : /oracle/18.0.0/oraInventory
   from           : /oracle/18.0.0/product/oraInst.loc
OPatch version    : 12.2.0.1.14
OUI version       : 12.2.0.4.0
Log file location : /oracle/18.0.0/product/cfgtoollogs/opatch/opatch2021-03-18_05-29-00AM_1.log
 
Lsinventory Output file location : /oracle/18.0.0/product/cfgtoollogs/opatch/lsinv/lsinventory2021-03-18_05-29-00AM.txt
 
--------------------------------------------------------------------------------
Local Machine Information::
Hostname: oel8.localdomain
ARU platform id: 226
ARU platform description:: Linux x86-64
 
Installed Top-level Products (1):
 
Oracle Database 18c                                                  18.0.0.0.0
There are 1 products installed in this Oracle Home.
 
 
Interim patches (5) :
 
Patch  28502403     : applied on Thu Mar 18 05:25:58 BRT 2021
Unique Patch ID:  22401662
Patch description:  "ORACLE 18.3.0 MULTITENANT  COMPATIBILITY CHECK DOES NOT WORK"
   Created on 22 Aug 2018, 22:33:32 hrs PST8PDT
   Bugs fixed:
     28502403
   This patch overlays patches:
     28090523
   This patch needs patches:
     28090523
   as prerequisites
 
Patch  27908644     : applied on Wed Jul 18 14:44:11 BRT 2018
Unique Patch ID:  22153180
Patch description:  "UPDATE 18.3 DATABASE CLIENT JDK IN ORACLE HOME TO JDK8U171"
   Created on 4 May 2018, 01:21:02 hrs PST8PDT
   Bugs fixed:
     27908644
 
Patch  27923415     : applied on Wed Jul 18 14:41:38 BRT 2018
Unique Patch ID:  22239273
Patch description:  "OJVM RELEASE UPDATE: 18.3.0.0.180717 (27923415)"
   Created on 15 Jul 2018, 10:33:22 hrs PST8PDT
   Bugs fixed:
     27304131, 27539876, 27952586, 27642235, 27636900, 27461740
 
Patch  28090553     : applied on Wed Jul 18 14:40:01 BRT 2018
Unique Patch ID:  22256940
Patch description:  "OCW RELEASE UPDATE 18.3.0.0.0 (28090553)"
   Created on 11 Jul 2018, 19:20:31 hrs PST8PDT
   Bugs fixed:
     12816839, 18701017, 22734786, 23698980, 23840305, 25709124, 25724089
     26299684, 26313403, 26433972, 26527054, 26586174, 26587652, 26647619
     26827699, 26860285, 26882126, 26882316, 26943660, 26996813, 27012915
     27018734, 27032726, 27034318, 27040560, 27080748, 27086406, 27092991
     27098733, 27106915, 27114112, 27121566, 27133637, 27144533, 27153755
     27166715, 27174938, 27174948, 27177551, 27177852, 27182006, 27182064
     27184253, 27204476, 27212837, 27213140, 27220610, 27222423, 27222938
     27238077, 27238258, 27249544, 27252023, 27257509, 27263677, 27265816
     27267992, 27271876, 27274143, 27285557, 27299455, 27300007, 27302415
     27309182, 27314512, 27315159, 27320985, 27334353, 27338838, 27346984
     27358232, 27362190, 27370933, 27377219, 27378959, 27379846, 27379956
     27393421, 27398223, 27399499, 27399762, 27399985, 27401618, 27403244
     27404599, 27426277, 27428790, 27430219, 27430254, 27433163, 27452897
     27458829, 27465480, 27475272, 27481406, 27481765, 27492916, 27496806
     27503318, 27503413, 27508936, 27508984, 27513114, 27519708, 27526362
     27528204, 27532009, 27534289, 27560562, 27560735, 27573154, 27573408
     27574335, 27577122, 27579969, 27581484, 27593587, 27595801, 27600706
     27609819, 27625010, 27625050, 27627992, 27654039, 27657467, 27657920
     27668379, 27682288, 27691717, 27702244, 27703242, 27708711, 27714373
     27725967, 27731346, 27734470, 27735534, 27739957, 27740854, 27747407
     27748321, 27757979, 27766679, 27768034, 27778433, 27782464, 27783059
     27786669, 27786699, 27801774, 27811439, 27839732, 27850736, 27862636
     27864737, 27865439, 27889841, 27896388, 27897639, 27906509, 27931506
     27935826, 27941514, 27957892, 27978668, 27984314, 27993298, 28023410
     28025398, 28032758, 28039471, 28039953, 28045209, 28099592, 28109698
     28174926, 28182503, 28204423, 28240153
 
Patch  28090523     : applied on Wed Jul 18 14:39:24 BRT 2018
Unique Patch ID:  22329768
Patch description:  "Database Release Update : 18.3.0.0.180717 (28090523)"
   Created on 14 Jul 2018, 00:03:50 hrs PST8PDT
   Bugs fixed:
     9062315, 13554903, 21547051, 21766220, 21806121, 23003564, 23310101
     24489904, 24689376, 24737581, 24925863, 25035594, 25035599, 25287072
     25348956, 25634405, 25726981, 25743479, 25824236, 25943740, 26226953
     26336101, 26423085, 26427905, 26450454, 26476244, 26598422, 26615291
     26646549, 26654411, 26731697, 26785169, 26792891, 26818960, 26822620
     26843558, 26843664, 26846077, 26894737, 26898279, 26928317, 26933599
     26956033, 26961415, 26966120, 26986173, 26992964, 27005278, 27026401
     27028251, 27030974, 27036408, 27038986, 27041253, 27044575, 27047831
     27053044, 27058530, 27060167, 27060859, 27061736, 27066451, 27066519
     27073066, 27086821, 27090765, 27101527, 27101652, 27110878, 27112686
     27119621, 27126666, 27128580, 27135647, 27143756, 27143882, 27147979
     27153641, 27155549, 27156355, 27163928, 27169796, 27181521, 27181537
     27189611, 27190851, 27193810, 27199245, 27208953, 27210038, 27210872
     27214085, 27215007, 27216224, 27221900, 27222121, 27222626, 27224987
     27226913, 27232983, 27233563, 27236052, 27236110, 27240246, 27240570
     27241221, 27241247, 27244337, 27244785, 27249215, 27250547, 27254851
     27258578, 27259386, 27259983, 27262650, 27262945, 27263276, 27263996
     27270197, 27274456, 27274536, 27275136, 27275776, 27282707, 27283029
     27283960, 27284499, 27285244, 27288230, 27292213, 27294480, 27301308
     27301568, 27302594, 27302681, 27302695, 27302711, 27302730, 27302777
     27302800, 27302960, 27304410, 27304936, 27305318, 27307868, 27310092
     27313687, 27314206, 27314390, 27318869, 27321179, 27321834, 27326204
     27329812, 27330158, 27330161, 27333658, 27333664, 27333693, 27334316
     27334648, 27335682, 27338912, 27338946, 27339115, 27339396, 27339483
     27339495, 27341036, 27345190, 27345231, 27345450, 27345498, 27346329
     27346644, 27346709, 27346949, 27347126, 27348081, 27348707, 27349393
     27352600, 27354783, 27356373, 27357773, 27358241, 27359178, 27359368
     27360126, 27364891, 27364916, 27364947, 27365139, 27365702, 27365993
     27367194, 27368850, 27372756, 27375260, 27375542, 27376871, 27378103
     27379233, 27381383, 27381656, 27384222, 27389352, 27392187, 27395404
     27395416, 27395794, 27396357, 27396365, 27396377, 27396624, 27396666
     27396672, 27396813, 27398080, 27398660, 27401637, 27405242, 27405696
     27410300, 27410595, 27412805, 27417186, 27420715, 27421101, 27422874
     27423251, 27425507, 27425622, 27426363, 27427805, 27430802, 27432338
     27432355, 27433870, 27434050, 27434193, 27434486, 27434974, 27435537
     27439835, 27441326, 27442041, 27444727, 27445330, 27445462, 27447452
     27447687, 27448162, 27450355, 27450400, 27450783, 27451049, 27451182
     27451187, 27451531, 27452760, 27453225, 27457666, 27457891, 27458164
     27459909, 27460675, 27467543, 27469329, 27471876, 27472969, 27473800
     27479358, 27483974, 27484556, 27486253, 27487795, 27489719, 27496224
     27496308, 27497950, 27498477, 27501327, 27501413, 27501465, 27502420
     27504190, 27505603, 27506774, 27508985, 27511196, 27512439, 27517818
     27518227, 27518310, 27520070, 27520900, 27522245, 27523368, 27523800
     27525909, 27532375, 27533819, 27534509, 27537472, 27544030, 27545630
     27547732, 27550341, 27551855, 27558557, 27558559, 27558861, 27560702
     27563629, 27563767, 27570318, 27577758, 27579353, 27580996, 27585755
     27585800, 27586810, 27586895, 27587672, 27591842, 27592466, 27593389
     27595973, 27599689, 27602091, 27602488, 27603841, 27604293, 27607805
     27608669, 27610269, 27613080, 27613247, 27615608, 27616657, 27617522
     27625274, 27625620, 27631506, 27634676, 27635508, 27644757, 27649707
     27652302, 27663370, 27664702, 27679488, 27679664, 27679806, 27679961
     27680162, 27680509, 27682151, 27688099, 27688692, 27690578, 27691809
     27692215, 27693713, 27697092, 27701795, 27705761, 27707544, 27709046
     27718914, 27719187, 27723002, 27726269, 27726780, 27732323, 27739006
     27740844, 27744211, 27745220, 27747869, 27748954, 27751006, 27753336
     27757567, 27772815, 27773602, 27774320, 27774539, 27779886, 27780562
     27782339, 27783289, 27786772, 27791223, 27797290, 27803665, 27807441
     27812560, 27812593, 27813267, 27815347, 27818871, 27832643, 27833369
     27834984, 27840386, 27847259, 27851757, 27861909, 27869339, 27873643
     27882176, 27892488, 27924147, 27926113, 27930478, 27934468, 27941896
     27945870, 27950708, 27952762, 27961746, 27964051, 27970265, 27971575
     27984028, 27989849, 27993289, 27994333, 27997875, 27999597, 28021205
     28022847, 28033429, 28057267, 28059199, 28072130, 28098865, 28106402
     28132287, 28169711, 28174827, 28184554, 28188330, 25929650, 28264172
 
 
 
--------------------------------------------------------------------------------
 
OPatch succeeded.
[oracle@oel8 28502403]$

Subindo ambiente e testando novamente o processo:

[oracle@oel8 28502403]$ lsnrctl start
 
LSNRCTL for Linux: Version 18.0.0.0.0 - Production on 18-MAR-2021 05:30:50
 
Copyright (c) 1991, 2018, Oracle.  All rights reserved.
 
Starting /oracle/18.0.0/product/bin/tnslsnr: please wait...
 
TNSLSNR for Linux: Version 18.0.0.0.0 - Production
System parameter file is /oracle/18.0.0/product/network/admin/listener.ora
Log messages written to /oracle/18.0.0/base/diag/tnslsnr/oel8/listener/alert/log.xml
Listening on: (DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=oel8.localdomain)(PORT=1521)))
Listening on: (DESCRIPTION=(ADDRESS=(PROTOCOL=ipc)(KEY=EXTPROC1521)))
 
Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=oel8.localdomain)(PORT=1521)))
STATUS of the LISTENER
------------------------
Alias                     LISTENER
Version                   TNSLSNR for Linux: Version 18.0.0.0.0 - Production
Start Date                18-MAR-2021 05:30:50
Uptime                    0 days 0 hr. 0 min. 0 sec
Trace Level               off
Security                  ON: Local OS Authentication
SNMP                      OFF
Listener Parameter File   /oracle/18.0.0/product/network/admin/listener.ora
Listener Log File         /oracle/18.0.0/base/diag/tnslsnr/oel8/listener/alert/log.xml
Listening Endpoints Summary...
  (DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=oel8.localdomain)(PORT=1521)))
  (DESCRIPTION=(ADDRESS=(PROTOCOL=ipc)(KEY=EXTPROC1521)))
The listener supports no services
The command completed successfully
[oracle@oel8 28502403]$ sqlplus / as sysdba
 
SQL*Plus: Release 18.0.0.0.0 - Production on Thu Mar 18 05:30:55 2021
Version 18.3.0.0.0
 
Copyright (c) 1982, 2018, Oracle.  All rights reserved.
 
Connected to an idle instance.
 
SQL> startup;
ORACLE instance started.
 
Total System Global Area 2466249080 bytes
Fixed Size                  8898936 bytes
Variable Size             671088640 bytes
Database Buffers         1778384896 bytes
Redo Buffers                7876608 bytes
Database mounted.
Database opened.
SQL>

Sucesso:

SQL> set serveroutput on
DECLARE
        compatible BOOLEAN := FALSE;
BEGIN
        compatible := DBMS_PDB.CHECK_PLUG_COMPATIBILITY( PDB_DESCR_FILE => '/home/oracle/HIPOFISE2.xml');
        if compatible then
                DBMS_OUTPUT.PUT_LINE('It is compatible');
        else
        DBMS_OUTPUT.PUT_LINE('It is NOT compatible');
        end if;
END;
/SQL>   2    3    4    5    6    7    8    9   10   11
It is NOT compatible
 
PL/SQL procedure successfully completed.
 
SQL>

2 thoughts on “[Solved Issue] DBMS_PDB.CHECK_PLUG_COMPATIBILIT ORA-7445[__intel_ssse3_rep_memcpy()+6429]”

  1. Pingback: [Solved] Issue: ‘18.3.0.0.0 Release_Update 1806280943’ is installed in the CDB but ‘18.3.0.0.0 Release_Update 180628094’ is installed in the PDB – Bruno Santos da Silva

  2. Pingback: [Solved] Issue: ‘18.3.0.0.0 Release_Update 1806280943’ is installed in the CDB but ‘18.3.0.0.0 Release_Update 180628094’ is installed in the PDB – SWIV

Leave a Comment

Your email address will not be published.

pt Portuguese
en Englishpt Portuguesees Spanish