{"id":2834,"date":"2021-03-18T09:37:18","date_gmt":"2021-03-18T09:37:18","guid":{"rendered":"https:\/\/swiv.com.br\/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\/"},"modified":"2026-05-27T20:02:50","modified_gmt":"2026-05-27T19:02:50","slug":"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","status":"publish","type":"post","link":"https:\/\/swiv.com.br\/index.php\/2021\/03\/18\/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\/","title":{"rendered":"[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"},"content":{"rendered":"

Ap\u00f3s aplicar um Patch descrito NESTE<\/a> artigo, foi reportado na view PDB_PLUG_IN_VIOLATIONS as seguintes mensagens (ap\u00f3s checar a compatibilidade de um PDB no CDB):<\/p>\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>\n\n
\nSQL> SELECT * FROM PDB_PLUG_IN_VIOLATIONS WHERE NAME='HIPOFISE2';\n \nTIME\n---------------------------------------------------------------------------\nNAME\n--------------------------------------------------------------------------------\nCAUSE                                                            TYPE\n---------------------------------------------------------------- ---------\nERROR_NUMBER       LINE\n------------ ----------\nMESSAGE\n--------------------------------------------------------------------------------\nSTATUS\n---------\nACTION\n--------------------------------------------------------------------------------\n    CON_ID\n----------\n18-MAR-21 05.42.22.509718 AM\n \nTIME\n---------------------------------------------------------------------------\nNAME\n--------------------------------------------------------------------------------\nCAUSE                                                            TYPE\n---------------------------------------------------------------- ---------\nERROR_NUMBER       LINE\n------------ ----------\nMESSAGE\n--------------------------------------------------------------------------------\nSTATUS\n---------\nACTION\n--------------------------------------------------------------------------------\n    CON_ID\n----------\nHIPOFISE2\n \nTIME\n---------------------------------------------------------------------------\nNAME\n--------------------------------------------------------------------------------\nCAUSE                                                            TYPE\n---------------------------------------------------------------- ---------\nERROR_NUMBER       LINE\n------------ ----------\nMESSAGE\n--------------------------------------------------------------------------------\nSTATUS\n---------\nACTION\n--------------------------------------------------------------------------------\n    CON_ID\n----------\nSQL Patch                                                        ERROR\n \nTIME\n---------------------------------------------------------------------------\nNAME\n--------------------------------------------------------------------------------\nCAUSE                                                            TYPE\n---------------------------------------------------------------- ---------\nERROR_NUMBER       LINE\n------------ ----------\nMESSAGE\n--------------------------------------------------------------------------------\nSTATUS\n---------\nACTION\n--------------------------------------------------------------------------------\n    CON_ID\n----------\n           0          1\n \nTIME\n---------------------------------------------------------------------------\nNAME\n--------------------------------------------------------------------------------\nCAUSE                                                            TYPE\n---------------------------------------------------------------- ---------\nERROR_NUMBER       LINE\n------------ ----------\nMESSAGE\n--------------------------------------------------------------------------------\nSTATUS\n---------\nACTION\n--------------------------------------------------------------------------------\n    CON_ID\n----------\n'18.3.0.0.0 Release_Update 1806280943' is installed in the CDB but '18.3.0.0.0 R\n \nTIME\n---------------------------------------------------------------------------\nNAME\n--------------------------------------------------------------------------------\nCAUSE                                                            TYPE\n---------------------------------------------------------------- ---------\nERROR_NUMBER       LINE\n------------ ----------\nMESSAGE\n--------------------------------------------------------------------------------\nSTATUS\n---------\nACTION\n--------------------------------------------------------------------------------\n    CON_ID\n----------\nelease_Update 180628094' is installed in the PDB\n \nTIME\n---------------------------------------------------------------------------\nNAME\n--------------------------------------------------------------------------------\nCAUSE                                                            TYPE\n---------------------------------------------------------------- ---------\nERROR_NUMBER       LINE\n------------ ----------\nMESSAGE\n--------------------------------------------------------------------------------\nSTATUS\n---------\nACTION\n--------------------------------------------------------------------------------\n    CON_ID\n----------\nPENDING\n \nTIME\n---------------------------------------------------------------------------\nNAME\n--------------------------------------------------------------------------------\nCAUSE                                                            TYPE\n---------------------------------------------------------------- ---------\nERROR_NUMBER       LINE\n------------ ----------\nMESSAGE\n--------------------------------------------------------------------------------\nSTATUS\n---------\nACTION\n--------------------------------------------------------------------------------\n    CON_ID\n----------\nCall datapatch to install in the PDB or the CDB\n \nTIME\n---------------------------------------------------------------------------\nNAME\n--------------------------------------------------------------------------------\nCAUSE                                                            TYPE\n---------------------------------------------------------------- ---------\nERROR_NUMBER       LINE\n------------ ----------\nMESSAGE\n--------------------------------------------------------------------------------\nSTATUS\n---------\nACTION\n--------------------------------------------------------------------------------\n    CON_ID\n----------\n         1\n \nTIME\n---------------------------------------------------------------------------\nNAME\n--------------------------------------------------------------------------------\nCAUSE                                                            TYPE\n---------------------------------------------------------------- ---------\nERROR_NUMBER       LINE\n------------ ----------\nMESSAGE\n--------------------------------------------------------------------------------\nSTATUS\n---------\nACTION\n--------------------------------------------------------------------------------\n    CON_ID\n----------\n<\/pre><\/div>\n\n\n
Ao tentar seguir o Oracle Note “Datapatch precheck failed : Release update is BEING installed to PDB but is not installed in CDB$ROOT.This will cause a patch mismatch between this PDB and CDB$ROOT (Doc ID 2604940.1)<\/strong>“, realizei o datapatch no CDB:<\/p>\n\n\n
\n[oracle@oel8 OPatch]$ cd $ORACLE_HOME\/OPatch\n[oracle@oel8 OPatch]$ .\/datapatch -verbose -pdbs CDB\\$ROOT\nSQL Patching tool version 18.0.0.0.0 Production on Thu Mar 18 06:18:44 2021\nCopyright (c) 2012, 2018, Oracle.  All rights reserved.\n \nLog file for this invocation: \/oracle\/18.0.0\/base\/cfgtoollogs\/sqlpatch\/sqlpatch_32394_2021_03_18_06_18_44\/sqlpatch_invocation.log\n \nConnecting to database...OK\nGathering database info...done\n \nNote:  Datapatch will only apply or rollback SQL fixes for PDBs\n       that are in an open state, no patches will be applied to closed PDBs.\n       Please refer to Note: Datapatch: Database 12c Post Patch SQL Automation\n       (Doc ID 1585822.1)\n \nBootstrapping registry and package to current versions...done\nDetermining current state...done\n \nCurrent state of interim SQL patches:\nInterim patch 27923415 (OJVM RELEASE UPDATE: 18.3.0.0.180717 (27923415)):\n  Binary registry: Installed\n  PDB CDB$ROOT: Applied successfully on 02-MAR-21 06.35.31.589073 AM\n \nCurrent state of release update SQL patches:\n  Binary registry:\n    18.3.0.0.0 Release_Update 1806280943: Installed\n  PDB CDB$ROOT:\n    Applied 18.3.0.0.0 Release_Update 1806280943 successfully on 02-MAR-21 06.35.31.581343 AM\n \nAdding patches to installation queue and performing prereq checks...done\nInstallation queue:\n  For the following PDBs: CDB$ROOT\n    No interim patches need to be rolled back\n    No release update patches need to be installed\n    No interim patches need to be applied\n \nSQL Patching tool complete on Thu Mar 18 06:18:52 2021\n[oracle@oel8 OPatch]$\n<\/pre><\/div>\n\n\n
Aplicando nos PDBs e notamos que, por termos dropado o PDB HIPOFISE2, n\u00e3o ser\u00e1 poss\u00edvel o seu datapatch:<\/p>\n\n\n
\n[oracle@oel8 OPatch]$ .\/datapatch -verbose -pdbs HIPOFISE1,HIPOFISE2\nSQL Patching tool version 18.0.0.0.0 Production on Thu Mar 18 06:20:53 2021\nCopyright (c) 2012, 2018, Oracle.  All rights reserved.\n \nLog file for this invocation: \/oracle\/18.0.0\/base\/cfgtoollogs\/sqlpatch\/sqlpatch_1163_2021_03_18_06_20_53\/sqlpatch_invocation.log\n \nConnecting to database...OK\nGathering database info...Error: prereq checks failed!\nSome of the -pdbs containers were not found in the database. Bad containers: HIPOFISE2\n \nPlease refer to MOS Note 1609718.1 and\/or the invocation log\n\/oracle\/18.0.0\/base\/cfgtoollogs\/sqlpatch\/sqlpatch_1163_2021_03_18_06_20_53\/sqlpatch_invocation.log\nfor information on how to resolve the above errors.\n \nSQL Patching tool complete on Thu Mar 18 06:20:54 2021\n<\/pre><\/div>\n\n\n
Tentando gerar uma solu\u00e7\u00e3o de contorno: plugar este PDB no CDB, para ent\u00e3o realizar o datapatch posteriormente:<\/p>\n\n\n
\n[oracle@oel8 OPatch]$ sqlplus \/ as sysdba\n \nSQL*Plus: Release 18.0.0.0.0 - Production on Thu Mar 18 06:25:39 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> CREATE PLUGGABLE DATABASE HIPOFISE2 USING '\/home\/oracle\/HIPOFISE2.xml' NOCOPY TEMPFILE REUSE;\n \nPluggable database created.\n<\/pre><\/div>\n\n\n
Abrindo o PDB:<\/p>\n\n\n
\nSQL> ALTER PLUGGABLE DATABASE HIPOFISE2 OPEN;\n \nPluggable database altered.\n<\/pre><\/div>\n\n\n
Realizando datapatch novamente:<\/p>\n\n\n
\n[oracle@oel8 OPatch]$ .\/datapatch -verbose -pdbs HIPOFISE1,HIPOFISE2\nSQL Patching tool version 18.0.0.0.0 Production on Thu Mar 18 06:31:21 2021\nCopyright (c) 2012, 2018, Oracle.  All rights reserved.\n \nLog file for this invocation: \/oracle\/18.0.0\/base\/cfgtoollogs\/sqlpatch\/sqlpatch_4269_2021_03_18_06_31_21\/sqlpatch_invocation.log\n \nConnecting to database...OK\nGathering database info...done\n \nNote:  Datapatch will only apply or rollback SQL fixes for PDBs\n       that are in an open state, no patches will be applied to closed PDBs.\n       Please refer to Note: Datapatch: Database 12c Post Patch SQL Automation\n       (Doc ID 1585822.1)\n \nBootstrapping registry and package to current versions...done\nDetermining current state...done\n \nCurrent state of interim SQL patches:\nInterim patch 27923415 (OJVM RELEASE UPDATE: 18.3.0.0.180717 (27923415)):\n  Binary registry: Installed\n  PDB HIPOFISE1: Applied successfully on 02-MAR-21 06.44.54.948445 AM\n  PDB HIPOFISE2: Applied successfully on 02-MAR-21 06.44.54.948445 AM\n \nCurrent state of release update SQL patches:\n  Binary registry:\n    18.3.0.0.0 Release_Update 1806280943: Installed\n  PDB HIPOFISE1:\n    Applied 18.3.0.0.0 Release_Update 1806280943 successfully on 02-MAR-21 06.44.54.938616 AM\n  PDB HIPOFISE2:\n    Applied 18.3.0.0.0 Release_Update 1806280943 successfully on 02-MAR-21 06.44.54.938616 AM\n \nAdding patches to installation queue and performing prereq checks...done\nInstallation queue:\n  For the following PDBs: HIPOFISE1 HIPOFISE2\n    No interim patches need to be rolled back\n    No release update patches need to be installed\n    No interim patches need to be applied\n \nSQL Patching tool complete on Thu Mar 18 06:31:31 2021\n[oracle@oel8 OPatch]$\n<\/pre><\/div>\n\n\n
Gerando um novo arquivo XML:<\/p>\n\n\n
\n[oracle@oel8 ~]$ mv HIPOFISE2.xml HIPOFISE2.xml.OLD\n[oracle@oel8 ~]$ sqlplus \/ as sysdba\n \nSQL*Plus: Release 18.0.0.0.0 - Production on Thu Mar 18 06:32:41 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>ALTER PLUGGABLE DATABASE HIPOFISE2 CLOSE IMMEDIATE;\n \nPluggable database altered.\n \nSQL> ALTER PLUGGABLE DATABASE HIPOFISE2 UNPLUG INTO '\/home\/oracle\/HIPOFISE2.xml';\n \nPluggable database altered.\n<\/pre><\/div>\n\n\n
Dropando apenas a refer\u00eancia do banco:<\/p>\n\n\n
\nSQL> DROP PLUGGABLE DATABASE HIPOFISE2 KEEP DATAFILES;\n \nPluggable database dropped.\n<\/pre><\/div>\n\n\n
Realizando teste de compatibilidade e vendo que agora o PDB est\u00e1 apto a ser plugado no CDB:<\/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 compatible\n \nPL\/SQL procedure successfully completed.\n<\/pre><\/div>","protected":false},"excerpt":{"rendered":"
Ap\u00f3s aplicar um Patch descrito NESTE artigo, foi reportado na view PDB_PLUG_IN_VIOLATIONS as seguintes mensagens (ap\u00f3s checar a compatibilidade de um PDB no CDB): Ao tentar seguir o Oracle Note “Datapatch precheck failed : Release update is BEING installed to PDB but is not installed in CDB$ROOT.This will cause a patch mismatch between this PDB […]<\/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-2834","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\/2834","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=2834"}],"version-history":[{"count":1,"href":"https:\/\/swiv.com.br\/index.php\/wp-json\/wp\/v2\/posts\/2834\/revisions"}],"predecessor-version":[{"id":9221,"href":"https:\/\/swiv.com.br\/index.php\/wp-json\/wp\/v2\/posts\/2834\/revisions\/9221"}],"wp:attachment":[{"href":"https:\/\/swiv.com.br\/index.php\/wp-json\/wp\/v2\/media?parent=2834"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/swiv.com.br\/index.php\/wp-json\/wp\/v2\/categories?post=2834"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/swiv.com.br\/index.php\/wp-json\/wp\/v2\/tags?post=2834"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}