{"id":2907,"date":"2021-03-20T13:49:29","date_gmt":"2021-03-20T13:49:29","guid":{"rendered":"https:\/\/swiv.com.br\/how-to-apply-psu-patch-on-oracle-database-18c\/"},"modified":"2026-05-27T20:02:50","modified_gmt":"2026-05-27T19:02:50","slug":"how-to-apply-psu-patch-on-oracle-database-18c","status":"publish","type":"post","link":"https:\/\/swiv.com.br\/index.php\/2021\/03\/20\/how-to-apply-psu-patch-on-oracle-database-18c\/","title":{"rendered":"How to apply PSU patch on Oracle Database 18C"},"content":{"rendered":"\n

Fiz a instala\u00e7\u00e3o de um Oracle Database 18C h\u00e1 um bom tempo, e ainda n\u00e3o havia aplicado PSU nele (apenas alguns patches espec\u00edficos devido bug). Desse modo, para n\u00e3o ficar recebendo erro de gra\u00e7a durante meus laborat\u00f3rios, pretendo aplicar o \u00faltimo PSU dispon\u00edvel (JAN21). Ao acessar o Oracle Note “Database 18 Proactive Patch Information (Doc ID 2369376.1)<\/strong>” consigo acessar a parte de download:<\/p>\n\n\n\n

\"\"<\/figure>\n\n\n\n

Como meu ambiente n\u00e3o possui o GRID instalado, me atento apenas ao sistema operacional e seleciona o Database Release Patch:<\/p>\n\n\n\n

\"\"<\/figure>\n\n\n\n

Realizando o download:<\/p>\n\n\n\n

\"\"<\/figure>\n\n\n\n
\"\"<\/figure>\n\n\n\n

Enquanto o arquivo passa pelo download, podemos ver no Readme que \u00e9 necess\u00e1rio uma vers\u00e3o de OPatch m\u00ednima 12.2.0.1.23. Validando a vers\u00e3o que eu possuo:<\/p>\n\n\n

\n[oracle@oel8 OPatch]$ cd $ORACLE_HOME\/OPatch\n[oracle@oel8 OPatch]$ .\/opatch version\nOPatch Version: 12.2.0.1.14\n \nOPatch succeeded.\n<\/pre><\/div>\n\n\n
Como constatado, minha vers\u00e3o \u00e9 inferior, e o pr\u00f3prio readme possui um link para que possamos baixar o Opatch:<\/p>\n\n\n\n
\"\"<\/figure>\n\n\n\n
Seleciono minha release e S.O:<\/p>\n\n\n\n
\"\"<\/figure>\n\n\n\n
Movendo meu atual OPatch para uma pasta backup:<\/p>\n\n\n
\n[oracle@oel8 OPatch]$ cd ..\n[oracle@oel8 product]$ mv OPatch\/ OPatch_OLD\n<\/pre><\/div>\n\n\n
Download do OPatch conclu\u00eddo. Podemos realizar o unzip para o DB_HOME:<\/p>\n\n\n
\n[oracle@oel8 ~]$ unzip -d \/oracle\/18.0.0\/product\/ p6880880_180000_Linux-x86-64.zip\nArchive:  p6880880_180000_Linux-x86-64.zip\n   creating: \/oracle\/18.0.0\/product\/OPatch\/\n  inflating: \/oracle\/18.0.0\/product\/OPatch\/emdpatch.pl\n \n...\n \n  inflating: \/oracle\/18.0.0\/product\/OPatch\/operr\n  inflating: \/oracle\/18.0.0\/product\/OPatch\/opatchauto.cmd\n[oracle@oel8 ~]$\n<\/pre><\/div>\n\n\n
Validado com sucesso:<\/p>\n\n\n
\n[oracle@oel8 OPatch]$ cd $ORACLE_HOME\/OPatch\n[oracle@oel8 OPatch]$ .\/opatch version\nOPatch Version: 12.2.0.1.24\n \nOPatch succeeded.\n<\/pre><\/div>\n\n\n
Obviamente, no readme tamb\u00e9m \u00e9 mencionado a sugest\u00e3o de termos um backup dos bin\u00e1rios e invent\u00e1rio do Oracle. Como este meu ambiente \u00e9 apenas um lab, fiz simplesmente um snapshot da minha VM pelo VirtualBox.<\/p>\n\n\n\n
Agora posso descompactar o arquivo do PSU em si:<\/p>\n\n\n
\n[oracle@oel8 ~]$ unzip p32204699_180000_Linux-x86-64.zip\nArchive:  p32204699_180000_Linux-x86-64.zip\n   creating: 32204699\/\n   creating: 32204699\/etc\/\n   creating: 32204699\/etc\/config\/\n \n...\n \n  inflating: 32204699\/custom\/scripts\/init\n  inflating: 32204699\/README.html\n extracting: 32204699\/README.txt\nreplace PatchSearch.xml? [y]es, [n]o, [A]ll, [N]one, [r]ename: A\n  inflating: PatchSearch.xml\n<\/pre><\/div>\n\n\n
Entrando na pasta que foi criada:<\/p>\n\n\n
\n[oracle@oel8 ~]$ cd 32204699\n[oracle@oel8 32204699]$ ll\ntotal 84\ndrwxr-x---.  3 oracle oinstall    21 Jan 12 16:02 custom\ndrwxr-x---.  3 oracle oinstall    20 Jan 12 15:59 etc\ndrwxr-x---. 30 oracle oinstall  4096 Jan 12 15:59 files\n-rw-r--r--.  1 oracle oinstall 73836 Jan 12 16:02 README.html\n-rw-r--r--.  1 oracle oinstall    21 Jan 12 16:02 README.txt\n<\/pre><\/div>\n\n\n
Verificando se o PSU possui algum conflito com algum patch que j\u00e1 tenha sido aplicado no ambiente:<\/p>\n\n\n
\n[oracle@oel8 32204699]$ \/oracle\/18.0.0\/product\/OPatch\/opatch prereq CheckConflictAgainstOHWithDetail -ph .\/\nOracle Interim Patch Installer version 12.2.0.1.24\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.24\nOUI version       : 12.2.0.4.0\nLog file location : \/oracle\/18.0.0\/product\/cfgtoollogs\/opatch\/opatch2021-03-20_10-38-24AM_1.log\n \nInvoking prereq "checkconflictagainstohwithdetail"\n \nPrereq "checkConflictAgainstOHWithDetail" passed.\n \nOPatch succeeded.\n[oracle@oel8 32204699]$\n<\/pre><\/div>\n\n\n
J\u00e1 que n\u00e3o foi reportada nenhum incompatibilidade, podemos aplicar o PSU. Antes disso, vou baixar o Oracle Database e o listener:<\/p>\n\n\n
\n[oracle@oel8 32204699]$ sqlplus \/ as sysdba\n \nSQL*Plus: Release 18.0.0.0.0 - Production on Sat Mar 20 10:39:30 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 32204699]$ lsnrctl stop\n \nLSNRCTL for Linux: Version 18.0.0.0.0 - Production on 20-MAR-2021 10:40:16\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 o PSU (com sucesso):<\/p>\n\n\n
\n[oracle@oel8 32204699]$ \/oracle\/18.0.0\/product\/OPatch\/opatch apply\nOracle Interim Patch Installer version 12.2.0.1.24\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.24\nOUI version       : 12.2.0.4.0\nLog file location : \/oracle\/18.0.0\/product\/cfgtoollogs\/opatch\/opatch2021-03-20_10-41-03AM_1.log\n \nVerifying environment and performing prerequisite checks...\n \n--------------------------------------------------------------------------------\nStart OOP by Prereq process.\nLaunch OOP...\n \nOracle Interim Patch Installer version 12.2.0.1.24\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.24\nOUI version       : 12.2.0.4.0\nLog file location : \/oracle\/18.0.0\/product\/cfgtoollogs\/opatch\/opatch2021-03-20_10-41-22AM_1.log\n \nVerifying environment and performing prerequisite checks...\nOPatch continues with these patches:   32204699\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 '32204699' to OH '\/oracle\/18.0.0\/product'\nApplySession: Optional component(s) [ oracle.assistants.server.oui, 18.0.0.0.0 ] , [ oracle.has.crs, 18.0.0.0.0 ] , [ oracle.network.gsm, 18.0.0.0.0 ] , [ oracle.tfa, 18.0.0.0.0 ] , [ oracle.oid.client, 18.0.0.0.0 ] , [ oracle.network.cman, 18.0.0.0.0 ] , [ oracle.assistants.asm, 18.0.0.0.0 ] , [ oracle.options.olap, 18.0.0.0.0 ] , [ oracle.rdbms.tg4tera, 18.0.0.0.0 ] , [ oracle.rdbms.tg4db2, 18.0.0.0.0 ] , [ oracle.rdbms.tg4sybs, 18.0.0.0.0 ] , [ oracle.rdbms.tg4msql, 18.0.0.0.0 ] , [ oracle.assistants.usm, 18.0.0.0.0 ] , [ oracle.ons.daemon, 18.0.0.0.0 ] , [ oracle.net.cman, 18.0.0.0.0 ] , [ oracle.crs, 18.0.0.0.0 ] , [ oracle.rdbms.tg4ifmx, 18.0.0.0.0 ] , [ oracle.jdk, 1.8.0.171.00 ]  not present in the Oracle Home or a higher version is found.\n \nPatching component oracle.rdbms.util, 18.0.0.0.0...\n \nPatching component oracle.rdbms, 18.0.0.0.0...\n \nPatching component oracle.rdbms.rsf, 18.0.0.0.0...\n \nPatching component oracle.assistants.acf, 18.0.0.0.0...\n \nPatching component oracle.assistants.server, 18.0.0.0.0...\n \nPatching component oracle.ctx, 18.0.0.0.0...\n \nPatching component oracle.dbdev, 18.0.0.0.0...\n \nPatching component oracle.dbjava.ic, 18.0.0.0.0...\n \nPatching component oracle.dbjava.jdbc, 18.0.0.0.0...\n \nPatching component oracle.dbjava.ucp, 18.0.0.0.0...\n \nPatching component oracle.dbtoolslistener, 18.0.0.0.0...\n \nPatching component oracle.javavm.client, 18.0.0.0.0...\n \nPatching component oracle.ldap.owm, 18.0.0.0.0...\n \nPatching component oracle.ldap.rsf, 18.0.0.0.0...\n \nPatching component oracle.ldap.security.osdt, 18.0.0.0.0...\n \nPatching component oracle.network.rsf, 18.0.0.0.0...\n \nPatching component oracle.oracore.rsf, 18.0.0.0.0...\n \nPatching component oracle.rdbms.dbscripts, 18.0.0.0.0...\n \nPatching component oracle.rdbms.deconfig, 18.0.0.0.0...\n \nPatching component oracle.rdbms.install.common, 18.0.0.0.0...\n \nPatching component oracle.rdbms.install.plugins, 18.0.0.0.0...\n \nPatching component oracle.rdbms.oci, 18.0.0.0.0...\n \nPatching component oracle.sdo, 18.0.0.0.0...\n \nPatching component oracle.sdo.locator.jrf, 18.0.0.0.0...\n \nPatching component oracle.sqlplus, 18.0.0.0.0...\n \nPatching component oracle.swd.opatchautodb, 12.2.0.1.5...\n \nPatching component oracle.precomp.rsf, 18.0.0.0.0...\n \nPatching component oracle.ons, 18.0.0.0.0...\n \nPatching component oracle.oraolap.dbscripts, 18.0.0.0.0...\n \nPatching component oracle.duma, 18.0.0.0.0...\n \nPatching component oracle.ldap.client, 18.0.0.0.0...\n \nPatching component oracle.nlsrtl.rsf.core, 18.0.0.0.0...\n \nPatching component oracle.rdbms.crs, 18.0.0.0.0...\n \nPatching component oracle.rdbms.lbac, 18.0.0.0.0...\n \nPatching component oracle.rdbms.hsodbc, 18.0.0.0.0...\n \nPatching component oracle.oraolap, 18.0.0.0.0...\n \nPatching component oracle.xdk.parser.java, 18.0.0.0.0...\n \nPatching component oracle.xdk, 18.0.0.0.0...\n \nPatching component oracle.ldap.ssl, 18.0.0.0.0...\n \nPatching component oracle.assistants.deconfig, 18.0.0.0.0...\n \nPatching component oracle.server, 18.0.0.0.0...\n \nPatching component oracle.ctx.atg, 18.0.0.0.0...\n \nPatching component oracle.sqlplus.ic, 18.0.0.0.0...\n \nPatching component oracle.sdo.locator, 18.0.0.0.0...\n \nPatching component oracle.xdk.rsf, 18.0.0.0.0...\n \nPatching component oracle.rdbms.dv, 18.0.0.0.0...\n \nPatching component oracle.ctx.rsf, 18.0.0.0.0...\n \nPatching component oracle.network.client, 18.0.0.0.0...\n \nPatching component oracle.ldap.rsf.ic, 18.0.0.0.0...\n \nPatching component oracle.network.listener, 18.0.0.0.0...\n \nPatching component oracle.odbc, 18.0.0.0.0...\n \nPatching component oracle.rdbms.drdaas, 18.0.0.0.0...\n \nPatching component oracle.rdbms.rman, 18.0.0.0.0...\n \nPatching component oracle.nlsrtl.rsf, 18.0.0.0.0...\n \nPatching component oracle.install.deinstalltool, 18.0.0.0.0...\n \nPatching component oracle.rdbms.rsf.ic, 18.0.0.0.0...\n \nPatching component oracle.precomp.common, 18.0.0.0.0...\n \nPatching component oracle.precomp.lang, 18.0.0.0.0...\n \nPatching component oracle.jdk, 1.8.0.152.0...\nPatch 32204699 successfully applied.\nSub-set patch [28502403] has become inactive due to the application of a super-set patch [32204699].\nSub-set patch [27908644] has become inactive due to the application of a super-set patch [32204699].\nSub-set patch [28090523] has become inactive due to the application of a super-set patch [32204699].\nPlease refer to Doc ID 2161861.1 for any possible further required actions.\nLog file location: \/oracle\/18.0.0\/product\/cfgtoollogs\/opatch\/opatch2021-03-20_10-41-22AM_1.log\n \nOPatch succeeded.\n[oracle@oel8 32204699]$\n<\/pre><\/div>\n\n\n
Validando:<\/p>\n\n\n
\n[oracle@oel8 32204699]$ cd $ORACLE_HOME\/OPatch\n[oracle@oel8 OPatch]$ .\/opatch lsinventory | grep escript\nARU platform description:: Linux x86-64\nPatch description:  "Database Release Update : 18.13.0.0.210119 (32204699)"\nPatch description:  "OJVM RELEASE UPDATE: 18.3.0.0.180717 (27923415)"\nPatch description:  "OCW RELEASE UPDATE 18.3.0.0.0 (28090553)"\n[oracle@oel8 OPatch]$\n<\/pre><\/div>\n\n\n
Banco de dados operacional:<\/p>\n\n\n
\n[oracle@oel8 OPatch]$ sqlplus \/ as sysdba\n \nSQL*Plus: Release 18.0.0.0.0 - Production on Sat Mar 20 10:47:57 2021\nVersion 18.13.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> SELECT INSTANCE_NAME,STATUS FROM V$INSTANCE;\n \nINSTANCE_NAME    STATUS\n---------------- ------------\nTALAMO           OPEN\n<\/pre><\/div>","protected":false},"excerpt":{"rendered":"
Fiz a instala\u00e7\u00e3o de um Oracle Database 18C h\u00e1 um bom tempo, e ainda n\u00e3o havia aplicado PSU nele (apenas alguns patches espec\u00edficos devido bug). Desse modo, para n\u00e3o ficar recebendo erro de gra\u00e7a durante meus laborat\u00f3rios, pretendo aplicar o \u00faltimo PSU dispon\u00edvel (JAN21). Ao acessar o Oracle Note “Database 18 Proactive Patch Information (Doc […]<\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"closed","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[2],"tags":[],"class_list":["post-2907","post","type-post","status-publish","format-standard","hentry","category-administration"],"_links":{"self":[{"href":"https:\/\/swiv.com.br\/index.php\/wp-json\/wp\/v2\/posts\/2907","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=2907"}],"version-history":[{"count":1,"href":"https:\/\/swiv.com.br\/index.php\/wp-json\/wp\/v2\/posts\/2907\/revisions"}],"predecessor-version":[{"id":9216,"href":"https:\/\/swiv.com.br\/index.php\/wp-json\/wp\/v2\/posts\/2907\/revisions\/9216"}],"wp:attachment":[{"href":"https:\/\/swiv.com.br\/index.php\/wp-json\/wp\/v2\/media?parent=2907"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/swiv.com.br\/index.php\/wp-json\/wp\/v2\/categories?post=2907"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/swiv.com.br\/index.php\/wp-json\/wp\/v2\/tags?post=2907"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}