Atualizar o banco de dados e manter o nível de segurança do ambiente é sempre uma recomendação a qualquer DBA. No entanto, ás vezes, como todo DBA experiente sabe, encontramos problemas durante estas tarefas. O post de hoje será sobre o erro “The OPatch version being used (version) doesn’t meet the minimum version required by the patch(es). Please download latest OPatch from My Oracle Support.”, um erro que acontece simplesmente porque o utilitário do OPatch existente no ambiente possui a versão menor do que a requirida. É importante destacar que esse erro acontece comumemente após uma tentativa de aplicar o patch em um binário que foi instalado no modo Silent Mode.
Segue um exemplo do erro:
Invoking OPatch 11.2.0.1.7 Oracle Interim Patch Installer version 11.2.0.1.7 Copyright (c) 2011, Oracle Corporation. All rights reserved. Oracle Home : /opt/oracle/product/11203 Central Inventory : /opt/oracle/oraInventory from : /etc/oraInst.loc OPatch version : 11.2.0.1.7 OUI version : 11.2.0.3.0 Log file location : /opt/oracle/product/11203/cfgtoollogs/opatch/opatch2017-08-08_13-26-17PM.log Verifying environment and performing prerequisite checks... UtilSession failed: Patch 13696216 requires OPatch version 11.2.0.3.0. Patch 13923374 requires OPatch version 11.2.0.3.0. Patch 14275605 requires OPatch version 11.2.0.3.0. Patch 14727310 requires OPatch version 11.2.0.3.0. Patch 16056266 requires OPatch version 11.2.0.3.0. Patch 16619892 requires OPatch version 11.2.0.3.0. Patch 16902043 requires OPatch version 11.2.0.3.0. Patch 17540582 requires OPatch version 11.2.0.3.0. Patch 18031683 requires OPatch version 11.2.0.3.0. Patch 18522512 requires OPatch version 11.2.0.3.0. Patch 19121548 requires OPatch version 11.2.0.3.0. Patch 19769496 requires OPatch version 11.2.0.3.0. The OPatch version being used (11.2.0.1.7) doesn't meet the minimum version required by the patch(es). Please download latest OPatch from My Oracle Support.
Para resolver este problema é necessário efetuar os seguintes passos:
- Download do patch p6880880 (numero 6880880 ) no My Oracle Support para a versão e o sistema operacional ao qual você esteja aplicando o patch .
- Renomear a antiga pasta OPatch do seu $ORACLE_HOME:
oracle@techdatabasketserver:/opt/oracle/product/11203> mv OPatch OPatch_old oracle@techdatabasketserver:/opt/oracle/product/11203> ls -ltr OPatch_old total 94746 -rw-r--r-- 1 oracle oinstall 2576 May 6 2009 opatch.pl -rw-r--r-- 1 oracle oinstall 23695 Jul 18 2010 emdpatch.pl -rwx--x--- 1 oracle oinstall 12850 Feb 22 2011 opatch.bat -rwx--x--- 1 oracle oinstall 23495 Jun 30 2011 opatch drwxrwxr-x 15 oracle oinstall 1024 Dec 10 2014 19769496 -rw-rw-r-- 1 oracle oinstall 93056 Jan 20 2015 PatchSearch.xml drwxr-xr-x 2 oracle oinstall 96 Aug 8 11:48 docs drwxr-xr-x 2 oracle oinstall 96 Aug 8 11:48 ocm drwxr-xr-x 2 oracle oinstall 1024 Aug 8 11:48 jlib drwxr-xr-x 4 oracle oinstall 96 Aug 8 11:48 opatchprereqs drwxr-xr-x 2 oracle oinstall 1024 Aug 8 11:48 fmw -rw-r--r-- 1 oracle oinstall 49 Aug 8 11:48 opatch.ini -rw------- 1 oracle oinstall 96857392 Aug 8 13:19 p19769496_112030_Linux-x86-64.zip
- Descompactar o patch p6880880 em $ORACLE_HOME:
oracle@techdatabasketserver:/opt/oracle/product/11203> unzip p6880880_112000_Linux-x86-64.zip
- Testar o novo utilitário o OPatch com um patch qualquer:
oracle@techdatabasketserver:/opt/oracle/product/11203/OPatch/19769496> $ORACLE_HOME/OPatch/opatch prereq CheckConflictAgainstOHWithDetail -ph ./ Oracle Interim Patch Installer version 11.2.0.3.16 Copyright (c) 2017, Oracle Corporation. All rights reserved. PREREQ session Oracle Home : /opt/oracle/product/11203 Central Inventory : /opt/oracle/oraInventory from : /opt/oracle/product/11203/oraInst.loc OPatch version : 11.2.0.3.16 OUI version : 11.2.0.3.0 Log file location : /opt/oracle/product/11203/cfgtoollogs/opatch/opatch2017-08-12_15-58-30PM_1.log Invoking prereq "checkconflictagainstohwithdetail" Prereq "checkConflictAgainstOHWithDetail" passed. OPatch succeeded.
Agora é só seguir com a aplicacao de patch normal…
Hi! I am Bruno, a Brazilian born and bred. Former Oracle ACE, Computer Scientist, MSc in Data Science, over ten years of experience in companies such as IBM, Epico Tech, and Playtech based in three different countries (Brazil, Hungary, and Sweden) and joined projects remotely in many others. I am super excited to show you my interest in Databases, Cloud, Data Science, Data Engineering, Bigdata, AI, Programming, Software Engineering, and data in general.
(Continue reading)