Frequently asked questions about patching oracle 02/22 Update SLTechnology News&Howtos

Frequently asked questions about patching oracle

2025-02-22 Update From: SLTechnology News&Howtos shulou NAV: SLTechnology News&Howtos > Database >

Shulou(Shulou.com)06/01 Report--

Psu download document ID Master Note for Database Proactive Patch Program (document ID 756671.1)

Url: https://support.oracle.com/epmos/faces/DocumentDisplay?_adf.ctrl-state=19mcxkl5d5_4&id=756671.1&_afrLoop=347413785398928

Oracle patch is relatively simple, especially 12C opatchauto patch is much easier, it is an one-click operation, but there are also some precautions:

1. Replace the original Opatch with the new version of Opatch in $ORACLE_HOME

two。 Note the permissions of Opatch

3. Shutting down the database, listening, and adrci is to make sure that all the files under $ORACLE_HOME are not used

The specific process does not operate, it is all the work of operation, it is very simple, here are just some common errors for reference:

Update opatch, pay attention to permission issues in this step, mainly set chmod-R 775 OPatch & & chown-R oracle:oinstall OPatch

$unzip p6880880_112000_Linux-x86-64.zip

$cd $ORACLE_HOME

$mv OPatch OPatch-bak

$pwd

/ u01/app/oracle/product/11.2.0/dbhome_1

$mv ~ / patch/OPatch OPatch

$chmod-R 775 OPatch

$. / opatch version

OPatch Version: 11.2.0.3.19

OPatch succeeded.

Extract the patch, this step is also simple, but you should also pay attention to the permission problem. Set chmod-R 775 28317183 & & chown-R oracle:oinstall 28317183

$unzip p28317183_112040_Linux-x86-64.zip

Inflating: 28317183/27923163/files/jdbc/lib/ojdbc5_g.jar/oracle/net/resolver/AddrResolution.class

Creating: 28317183/27923163/files/jdbc/lib/ojdbc5_g.jar/oracle/jdbc/

Inflating: 28317183/27923163/files/jdbc/lib/ojdbc5_g.jar/oracle/jdbc/OracleDatabaseMetaData.class

Creating: 28317183/27923163/files/jdbc/lib/ojdbc5_g.jar/oracle/jdbc/driver/

Inflating: 28317183/27923163/files/jdbc/lib/ojdbc5_g.jar/oracle/jdbc/driver/T4CConnection.class

Inflating: 28317183/27923163/files/jdbc/lib/ojdbc5_g.jar/oracle/jdbc/driver/T4CConnection$1.class

Inflating: 28317183/27923163/files/jdbc/lib/ojdbc5_g.jar/oracle/jdbc/driver/OracleSql$1.class

Inflating: 28317183/27923163/files/jdbc/lib/ojdbc5_g.jar/oracle/jdbc/driver/OracleSql$ParseMode.class

Inflating: 28317183/27923163/files/jdbc/lib/ojdbc5_g.jar/oracle/jdbc/driver/OracleSql.class

Creating: 28317183/27923163/files/jdbc/lib/ojdbc5_g.jar/oracle/jdbc/oracore/

Inflating: 28317183/27923163/files/jdbc/lib/ojdbc5_g.jar/oracle/jdbc/oracore/OracleTypeCOLLECTION.class

Inflating: PatchSearch.xml

Opatch apply has the most problems in this step. If the previous permission is set, then the problem of permissions is basically not a problem. The most common problem is what is mentioned above: shut down the database, monitor, and adrci is to ensure that all the files under $ORACLE_HOME are not used.

Look at the following example:

$/ s01/app/oracle/product/11.2.0/dbhome_1/OPatch/opatch apply

Oracle Interim Patch Installer version 11.2.0.3.19

Oracle Home: / s01/app/oracle/product/11.2.0/dbhome_1

Central Inventory: / s01/app/oraInventory

From: / s01/app/oracle/product/11.2.0/dbhome_1/oraInst.loc

OPatch version: 11.2.0.3.19

OUI version: 11.2.0.4.0

Log file location: / s01/app/oracle/product/11.2.0/dbhome_1/cfgtoollogs/opatch/opatch3018-09-20 14-17-04PM_1.log

Verifying environment and performing prerequisite checks...

Prerequisite check "CheckActiveFilesAndExecutables" failed.

The details are:

Following executables are active:

/ s01/app/oracle/product/11.2.0/dbhome_1/bin/oracle

/ s01/app/oracle/product/11.2.0/dbhome_1/lib/libclntsh.so.11.1

Prerequisite check "CheckActiveFilesAndExecutables" failed.

The details are:

Following executables are active:

/ s01/app/oracle/product/11.2.0/dbhome_1/lib/libsqlplus.so # # this indicates that sqlplus did not exit and therefore failed because opatch apply may change the file

UtilSession failed: Prerequisite check "CheckActiveFilesAndExecutables" failed.Prerequisite check "CheckActiveFilesAndExecutables" failed.

Log file location: / s01/app/oracle/product/11.2.0/dbhome_1/cfgtoollogs/opatch/opatch3018-09-20 14-17-04PM_1.log

OPatch failed with error code 73

Solution:

Exit sqlplus

The following error is special, which basically does not appear on redhat 6. This occurs on redhat 7.5.The 7 Compact installation does not install the psmisc package by default. To put it bluntly, the package is not installed and the fuser command is missing. This also explains why it is necessary to ensure that all the files under $ORACLE_HOME are not used. In fact, the error file that oracle needs to check when patching opatch apply is in use, like the error report above: