Ao tentar realizar a verifica\u00e7\u00e3o de compatibilidade de um novo PDB ao CDB, a seguinte mensagem era apresentada:<\/p>\n\n\n
\n[oracle@oel8 ~]$ sqlplus \/ as sysdba\n \nSQL*Plus: Release 18.0.0.0.0 - Production on Thu Mar 18 04:51:10 2021\nVersion 18.3.0.0.0\n \nCopyright (c) 1982, 2018, Oracle. All rights reserved.\n \n \nConnected to:\nOracle Database 18c Enterprise Edition Release 18.0.0.0.0 - Production\nVersion 18.3.0.0.0\n \nSQL> set serveroutput on\nDECLARE\n compatible BOOLEAN := FALSE;\nBEGIN\n compatible := DBMS_PDB.CHECK_PLUG_COMPATIBILITY( PDB_DESCR_FILE => '\/home\/oracle\/HIPOFISE2.xml');\n if compatible then\n DBMS_OUTPUT.PUT_LINE('It is compatible');\n else\n DBMS_OUTPUT.PUT_LINE('It is NOT compatible');\n end if;\nEND;\n\/SQL> 2 3 4 5 6 7 8 9 10 11\nERROR:\nORA-03114: not connected to ORACLE\n \n \nDECLARE\n*\nERROR at line 1:\nORA-03113: end-of-file on communication channel\nProcess ID: 7890\nSession ID: 96 Serial number: 57426\n<\/pre><\/div>\n\n\n
No alert, \u00e9 poss\u00edvel ver a seguinte mensagem:<\/p>\n\n\n
\n2021-03-18 04:51:12.232000 -03:00\nException [type: SIGSEGV, Address not mapped to object] [ADDR:0xFFFFFFFFFFFFFFEF] [PC:0x6E2FDA6, __intel_ssse3_rep_memcpy()+6710] [flags: 0x0, count: 1]\nErrors in file \/oracle\/18.0.0\/base\/diag\/rdbms\/talamo\/TALAMO\/trace\/TALAMO_ora_7890.trc (incident=29209) (PDBNAME=CDB$ROOT):\nORA-07445: exception encountered: core dump [__intel_ssse3_rep_memcpy()+6710] [SIGSEGV] [ADDR:0xFFFFFFFFFFFFFFEF] [PC:0x6E2FDA6] [Address not mapped to object] []\nIncident details in: \/oracle\/18.0.0\/base\/diag\/rdbms\/talamo\/TALAMO\/incident\/incdir_29209\/TALAMO_ora_7890_i29209.trc\nUse ADRCI or Support Workbench to package the incident.\nSee Note 411.1 at My Oracle Support for error and packaging details.\nDumping diagnostic data in directory=[cdmp_20210318045113], requested by (instance=1, osid=7890), summary=[incident=29209].\n<\/pre><\/div>\n\n
Encontrado no MOS uma nota referenciando o fen\u00f4meno como um BUG (28502403). Note: “DBMS_PDB.CHECK_PLUG_COMPATIBILITY = ORA-3113 \/ ORA-7445[__intel_ssse3_rep_memcpy()+6429] (Doc ID 2446450.1)<\/strong>“. H\u00e1 2 solu\u00e7\u00f5es: migrar o ambiente de 18C para 19.1, ou aplicar um patch (caso tenha dispon\u00edvel para a sua vers\u00e3o):<\/p>\n\n\n<\/figure>\n\n\n\n
Verificando se haver\u00e1 algum tipo de incompatibilidade com o novo Patch:<\/p>\n\n\n
\n[oracle@oel8 28502403]$ cd ~\/28502403\n[oracle@oel8 28502403]$ \/oracle\/18.0.0\/product\/OPatch\/opatch prereq CheckConflictAgainstOHWithDetail -ph .\/\nOracle Interim Patch Installer version 12.2.0.1.14\nCopyright (c) 2021, Oracle Corporation. All rights reserved.\n \nPREREQ session\n \nOracle Home : \/oracle\/18.0.0\/product\nCentral Inventory : \/oracle\/18.0.0\/oraInventory\n from : \/oracle\/18.0.0\/product\/oraInst.loc\nOPatch version : 12.2.0.1.14\nOUI version : 12.2.0.4.0\nLog file location : \/oracle\/18.0.0\/product\/cfgtoollogs\/opatch\/opatch2021-03-18_05-21-02AM_1.log\n \nInvoking prereq "checkconflictagainstohwithdetail"\n \nPrereq "checkConflictAgainstOHWithDetail" passed.\n \nOPatch succeeded.\n[oracle@oel8 28502403]$\n<\/pre><\/div>\n\n\n
Baixando o ambiente de banco de dados e listener:<\/p>\n\n\n
\n[oracle@oel8 28502403]$ sqlplus \/ as sysdba\n \nSQL*Plus: Release 18.0.0.0.0 - Production on Thu Mar 18 05:23:27 2021\nVersion 18.3.0.0.0\n \nCopyright (c) 1982, 2018, Oracle. All rights reserved.\n \n \nConnected to:\nOracle Database 18c Enterprise Edition Release 18.0.0.0.0 - Production\nVersion 18.3.0.0.0\n \nSQL> shu immediate;\nDatabase closed.\nDatabase dismounted.\nORACLE instance shut down.\nSQL> exit\nDisconnected from Oracle Database 18c Enterprise Edition Release 18.0.0.0.0 - Production\nVersion 18.3.0.0.0\n[oracle@oel8 28502403]$ lsnrctl stop\n \nLSNRCTL for Linux: Version 18.0.0.0.0 - Production on 18-MAR-2021 05:24:19\n \nCopyright (c) 1991, 2018, Oracle. All rights reserved.\n \nConnecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=oel8.localdomain)(PORT=1521)))\nThe command completed successfully\n<\/pre><\/div>\n\n\n
Aplicando efetivamente o Patch:<\/p>\n\n\n
\n[oracle@oel8 28502403]$ cd ~\/28502403\n[oracle@oel8 28502403]$ \/oracle\/18.0.0\/product\/OPatch\/opatch apply\nOracle Interim Patch Installer version 12.2.0.1.14\nCopyright (c) 2021, Oracle Corporation. All rights reserved.\n \n \nOracle Home : \/oracle\/18.0.0\/product\nCentral Inventory : \/oracle\/18.0.0\/oraInventory\n from : \/oracle\/18.0.0\/product\/oraInst.loc\nOPatch version : 12.2.0.1.14\nOUI version : 12.2.0.4.0\nLog file location : \/oracle\/18.0.0\/product\/cfgtoollogs\/opatch\/opatch2021-03-18_05-25-37AM_1.log\n \nVerifying environment and performing prerequisite checks...\nOPatch continues with these patches: 28502403\n \nDo you want to proceed? [y|n]\ny\nUser Responded with: Y\nAll checks passed.\n \nPlease shutdown Oracle instances running out of this ORACLE_HOME on the local system.\n(Oracle Home = '\/oracle\/18.0.0\/product')\n \n \nIs the local system ready for patching? [y|n]\ny\nUser Responded with: Y\nBacking up files...\nApplying interim patch '28502403' to OH '\/oracle\/18.0.0\/product'\n \nPatching component oracle.rdbms, 18.0.0.0.0...\nPatch 28502403 successfully applied.\nLog file location: \/oracle\/18.0.0\/product\/cfgtoollogs\/opatch\/opatch2021-03-18_05-25-37AM_1.log\n \nOPatch succeeded.\n[oracle@oel8 28502403]$\n<\/pre><\/div>\n\n\n
Validando no invent\u00e1rio a aplica\u00e7\u00e3o do Patch:<\/p>\n\n\n
Subindo ambiente e testando novamente o processo:<\/p>\n\n\n
\n[oracle@oel8 28502403]$ lsnrctl start\n \nLSNRCTL for Linux: Version 18.0.0.0.0 - Production on 18-MAR-2021 05:30:50\n \nCopyright (c) 1991, 2018, Oracle. All rights reserved.\n \nStarting \/oracle\/18.0.0\/product\/bin\/tnslsnr: please wait...\n \nTNSLSNR for Linux: Version 18.0.0.0.0 - Production\nSystem parameter file is \/oracle\/18.0.0\/product\/network\/admin\/listener.ora\nLog messages written to \/oracle\/18.0.0\/base\/diag\/tnslsnr\/oel8\/listener\/alert\/log.xml\nListening on: (DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=oel8.localdomain)(PORT=1521)))\nListening on: (DESCRIPTION=(ADDRESS=(PROTOCOL=ipc)(KEY=EXTPROC1521)))\n \nConnecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=oel8.localdomain)(PORT=1521)))\nSTATUS of the LISTENER\n------------------------\nAlias LISTENER\nVersion TNSLSNR for Linux: Version 18.0.0.0.0 - Production\nStart Date 18-MAR-2021 05:30:50\nUptime 0 days 0 hr. 0 min. 0 sec\nTrace Level off\nSecurity ON: Local OS Authentication\nSNMP OFF\nListener Parameter File \/oracle\/18.0.0\/product\/network\/admin\/listener.ora\nListener Log File \/oracle\/18.0.0\/base\/diag\/tnslsnr\/oel8\/listener\/alert\/log.xml\nListening Endpoints Summary...\n (DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=oel8.localdomain)(PORT=1521)))\n (DESCRIPTION=(ADDRESS=(PROTOCOL=ipc)(KEY=EXTPROC1521)))\nThe listener supports no services\nThe command completed successfully\n[oracle@oel8 28502403]$ sqlplus \/ as sysdba\n \nSQL*Plus: Release 18.0.0.0.0 - Production on Thu Mar 18 05:30:55 2021\nVersion 18.3.0.0.0\n \nCopyright (c) 1982, 2018, Oracle. All rights reserved.\n \nConnected to an idle instance.\n \nSQL> startup;\nORACLE instance started.\n \nTotal System Global Area 2466249080 bytes\nFixed Size 8898936 bytes\nVariable Size 671088640 bytes\nDatabase Buffers 1778384896 bytes\nRedo Buffers 7876608 bytes\nDatabase mounted.\nDatabase opened.\nSQL>\n<\/pre><\/div>\n\n\n
Sucesso:<\/p>\n\n\n
\nSQL> set serveroutput on\nDECLARE\n compatible BOOLEAN := FALSE;\nBEGIN\n compatible := DBMS_PDB.CHECK_PLUG_COMPATIBILITY( PDB_DESCR_FILE => '\/home\/oracle\/HIPOFISE2.xml');\n if compatible then\n DBMS_OUTPUT.PUT_LINE('It is compatible');\n else\n DBMS_OUTPUT.PUT_LINE('It is NOT compatible');\n end if;\nEND;\n\/SQL> 2 3 4 5 6 7 8 9 10 11\nIt is NOT compatible\n \nPL\/SQL procedure successfully completed.\n \nSQL>\n<\/pre><\/div>","protected":false},"excerpt":{"rendered":"
Ao tentar realizar a verifica\u00e7\u00e3o de compatibilidade de um novo PDB ao CDB, a seguinte mensagem era apresentada: No alert, \u00e9 poss\u00edvel ver a seguinte mensagem: Encontrado no MOS uma nota referenciando o fen\u00f4meno como um BUG (28502403). Note: “DBMS_PDB.CHECK_PLUG_COMPATIBILITY = ORA-3113 \/ ORA-7445[__intel_ssse3_rep_memcpy()+6429] (Doc ID 2446450.1)“. H\u00e1 2 solu\u00e7\u00f5es: migrar o ambiente de 18C […]<\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"closed","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[2,8],"tags":[],"class_list":["post-2814","post","type-post","status-publish","format-standard","hentry","category-administration","category-multitenant"],"_links":{"self":[{"href":"https:\/\/swiv.com.br\/index.php\/wp-json\/wp\/v2\/posts\/2814","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/swiv.com.br\/index.php\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/swiv.com.br\/index.php\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/swiv.com.br\/index.php\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/swiv.com.br\/index.php\/wp-json\/wp\/v2\/comments?post=2814"}],"version-history":[{"count":1,"href":"https:\/\/swiv.com.br\/index.php\/wp-json\/wp\/v2\/posts\/2814\/revisions"}],"predecessor-version":[{"id":9222,"href":"https:\/\/swiv.com.br\/index.php\/wp-json\/wp\/v2\/posts\/2814\/revisions\/9222"}],"wp:attachment":[{"href":"https:\/\/swiv.com.br\/index.php\/wp-json\/wp\/v2\/media?parent=2814"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/swiv.com.br\/index.php\/wp-json\/wp\/v2\/categories?post=2814"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/swiv.com.br\/index.php\/wp-json\/wp\/v2\/tags?post=2814"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}
![\"\"](\"https:\/\/swiv.com.br\/wp-content\/uploads\/2022\/07\/image-273.png\")
<\/figure>\n\n\n\n![\"\"](\"https:\/\/swiv.com.br\/wp-content\/uploads\/2022\/07\/image-274.png\")
<\/figure>\n\n\n\n