{"id":2000,"date":"2020-09-28T07:00:00","date_gmt":"2020-09-28T04:00:00","guid":{"rendered":"https:\/\/www.dataplatform.gr\/?p=2000"},"modified":"2025-04-30T13:30:36","modified_gmt":"2025-04-30T10:30:36","slug":"pos-efarmozoyme-to-teleytaio-patch-psu-se-vas","status":"publish","type":"post","link":"https:\/\/www.dataplatform.gr\/en\/pos-efarmozoyme-to-teleytaio-patch-psu-se-vas\/","title":{"rendered":"How do we apply the latest patch (PSU) to an Oracle database"},"content":{"rendered":"

In the article we will analyze its process patch set update (PSU)<\/strong> in Oracle Database<\/strong>. The process is done through the two Oracle tools OPatch <\/strong>and Datapatch<\/strong>. The OPatch <\/strong>is a tool that allows applying and uninstalling patches to software (binaries)<\/strong> of Oracle. On the other hand Datapatch<\/strong> applies these updates to the database and which specifically to data dictionary<\/strong> (system views and tables).<\/p>\n\n\n\n

How to download the patch set update<\/h2>\n\n\n\n

Through the Oracle support portal, we connect to the link below.<\/p>\n\n\n\n

*We need to have an account that has the right to download PSU (paid), if the version has been released in Extended Support e.g. 12.1 has a special cost.<\/em><\/p>\n\n\n\n

https://support.oracle.com\/portal\/<\/code><\/pre>\n\n\n\n
We select Patches & Updates, Advanced, Product Oracle Database Enterprise and the Release we have.<\/p>\n\n\n\n
\"\"<\/figure>\n\n\n\n
There it will load a list, we order it with the updated column and look for the latest patch set update for the operating system we have.<\/p>\n\n\n\n
\"\"<\/figure>\n\n\n\n
On the next screen we can find information about the patch which contains cumulative and all previous ones.<\/p>\n\n\n\n
We choose it functional <\/strong>and Download<\/strong>:<\/p>\n\n\n\n
\"\"<\/figure>\n\n\n\n
We can either download it and ftp it to the server or use wget.sh which will download it directly to the server using ssh.<\/p>\n\n\n\n
\"\"<\/figure>\n\n\n\n
The preparation<\/h2>\n\n\n\n
We have downloaded the PSU in the \u201cDownloads\u201d folder:<\/p>\n\n\n\n
[oracle@dp-gr Downloads]$ ls -ltr<\/code><\/pre>\n\n\n\n
total 2155088\ndrwxrwxr-x+ 7 oracle oracle       4096 Jul  7  2014 database\n-rw-rw-r--. 1 oracle oracle 2206794758 Jul  8 15:14 p31113348_121020_Linux-x86-64.zip\n-rwxrwxr-x. 1 opc    opc          1949 Sep 21  2020 wget.sh<\/code><\/pre>\n\n\n\n
We check what version the OPatch tool has, it is not possible to apply patches with an old version:<\/p>\n\n\n\n
[oracle@dp-gr Downloads]$ $ORACLE_HOME\/OPatch\/opatch version<\/code><\/pre>\n\n\n\n
OPatch Version: 12.1.0.1.3<\/code><\/pre>\n\n\n\n
We see that it is old so we will delete its folder and download the latest.<\/p>\n\n\n\n
Move the PSU .zip to ORACLE_HOME and unzip it.<\/p>\n\n\n\n
At the same time, we also delete the OPatch folder located in ORACLE_HOME since it will be replaced:<\/p>\n\n\n\n
[oracle@dp-gr Downloads]$ cp p31* $ORACLE_HOME\/\n[oracle@dp-gr Downloads]$ cd $ORACLE_HOME\n[oracle@dp-gr db_1]$ rm -rf OPatch\n[oracle@dp-gr db_1]$ unzip p31113348_121020_Linux-x86-64.zip<\/code><\/pre>\n\n\n\n
How to install the latest OPatch<\/h2>\n\n\n\n
We connect to the link below:<\/p>\n\n\n\n
https://updates.oracle.com\/download\/6880880.html<\/code><\/pre>\n\n\n\n
We choose the correct release and operating system (careful with 32 and 64bit):<\/p>\n\n\n\n
\"\"<\/figure>\n\n\n\n
After it is downloaded, copy it to ORACLE_HOME and unzip it:<\/p>\n\n\n\n
[oracle@dp-gr Downloads]$ cp p688* $ORACLE_HOME\/\n[oracle@dp-gr Downloads]$ cd $ORACLE_HOME\n[oracle@dp-gr db_1]$ unzip p6880880_121010_LINUX.zip<\/code><\/pre>\n\n\n\n
Delete the zips we no longer need:<\/p>\n\n\n\n
[oracle@dp-gr db_1]$ rm -rf *.zip<\/code><\/pre>\n\n\n\n
Now we will see that we have the new version of OPatch:<\/p>\n\n\n\n
[oracle@dp-gr db_1]$ $ORACLE_HOME\/OPatch\/opatch version<\/code><\/pre>\n\n\n\n
OPatch Version: 12.2.0.1.21\n\nOPatch succeeded<\/code><\/pre>\n\n\n\n
The process<\/h2>\n\n\n\n
Go to the folder with the PSU id located in ORACLE_HOME:<\/p>\n\n\n\n
[oracle@dp-gr db_1]$ cd 31113348<\/code><\/pre>\n\n\n\n
We check if there is any conflict with other patches:<\/p>\n\n\n\n
[oracle@dp-gr 31113348]$ $ORACLE_HOME\/OPatch\/opatch prereq CheckConflictAgainstOHWithDetail -ph .\/<\/code><\/pre>\n\n\n\n
\nOracle Interim Patch Installer version 12.2.0.1.21\nCopyright (c) 2020, Oracle Corporation.  All rights reserved.\n\nPREREQ session\n\nOracle Home       : \/home\/oracle\/oracle\/app\/oracle\/product\/12.1.0.2\/db_1\nCentral Inventory : \/home\/oracle\/oracle\/app\/oraInventory\n   from           : \/home\/oracle\/oracle\/app\/oracle\/product\/12.1.0.2\/db_1\/oraInst.loc\nOPatch version    : 12.2.0.1.21\nOUI version       : 12.1.0.2.0\nLog file location : \/home\/oracle\/oracle\/app\/oracle\/product\/12.1.0.2\/db_1\/cfgtoollogs\/opatch\/opatch2020-09-21_13-27-13PM_1.log\n\nInvoking prereq \"checkconflictagainstohwithdetail\"\n\nPrereq \"checkConflictAgainstOHWithDetail\" passed.\n\nOPatch succeeded.<\/code><\/pre>\n\n\n\n
It's time to stop him listener <\/strong>so that no other external user can connect and then to let's close<\/strong> the base:<\/p>\n\n\n\n
[oracle@dp-gr 31113348]$ lsnrctl stop<\/code><\/pre>\n\n\n\n
\nLSNRCTL for Linux: Version 12.1.0.2.0 - Production on 21-SEP-2020 13:29:22\n\nCopyright (c) 1991, 2014, Oracle.  All rights reserved.\n\nConnecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=dp-gr)(PORT=1521)))\nThe command completed successfully<\/code><\/pre>\n\n\n\n
[oracle@dp-gr 31113348]$ sqlplus \/ as sysdba\n\nSQL> shutdown immediate;<\/code><\/pre>\n\n\n\n
We do one last check on the files:<\/p>\n\n\n\n
** If it fails with \/sbin\/fuser<\/strong> and the name of the file we find which process uses it and we do it kill<\/strong>.<\/em><\/p>\n\n\n\n
[oracle@dp-gr 31113348]$ $ORACLE_HOME\/OPatch\/opatch prereq CheckActiveFilesAndExecutables -ph .\/<\/code><\/pre>\n\n\n\n
\nOracle Interim Patch Installer version 12.2.0.1.21\nCopyright (c) 2020, Oracle Corporation.  All rights reserved.\n\nPREREQ session\n\nOracle Home       : \/home\/oracle\/oracle\/app\/oracle\/product\/12.1.0.2\/db_1\nCentral Inventory : \/home\/oracle\/oracle\/app\/oraInventory\n   from           : \/home\/oracle\/oracle\/app\/oracle\/product\/12.1.0.2\/db_1\/oraInst.loc\nOPatch version    : 12.2.0.1.21\nOUI version       : 12.1.0.2.0\nLog file location : \/home\/oracle\/oracle\/app\/oracle\/product\/12.1.0.2\/db_1\/cfgtoollogs\/opatch\/opatch2020-09-21_13-32-03PM_1.log\n\nInvoking prereq \"checkactivefilesandexecutables\"\n\nPrereq \"checkActiveFilesAndExecutables\" for patch 20299023 passed.\n\n.\n.\n.\nPrereq \"checkActiveFilesAndExecutables\" for patch 31113348 passed.\n\nOPatch succeeded.<\/code><\/pre>\n\n\n\n
By command opatch apply<\/strong> patching finally begins:<\/p>\n\n\n\n
[oracle@dp-gr 31113348]$ $ORACLE_HOME\/OPatch\/opatch apply<\/code><\/pre>\n\n\n\n
Oracle Interim Patch Installer version 12.2.0.1.21\nCopyright (c) 2020, Oracle Corporation.  All rights reserved.\n\n\nOracle Home       : \/home\/oracle\/oracle\/app\/oracle\/product\/12.1.0.2\/db_1\nCentral Inventory : \/home\/oracle\/oracle\/app\/oraInventory\n   from           : \/home\/oracle\/oracle\/app\/oracle\/product\/12.1.0.2\/db_1\/oraInst.loc\nOPatch version    : 12.2.0.1.21\nOUI version       : 12.1.0.2.0\nLog file location : \/home\/oracle\/oracle\/app\/oracle\/product\/12.1.0.2\/db_1\/cfgtoollogs\/opatch\/opatch2020-09-21_13-41-15PM_1.log\n\nVerifying environment and performing prerequisite checks...\nOPatch continues with these patches:   19769480  20299023  20831110  21359755  21948354  22291127  23054246  24006101  24732082  25171037  25755742  26609783  26713565  26925311  27338041  27547329  28259833  28729169  29141015  29494060  29918340  30340202  30700212  31113348\n\nDo you want to proceed? [y|n]<\/code><\/pre>\n\n\n\n
Composite patch 31113348 successfully applied.\nLog file location: \/home\/oracle\/oracle\/app\/oracle\/product\/12.1.0.2\/db_1\/cfgtoollogs\/opatch\/opatch2020-09-21_13-41-15PM_1.log\n\nOPatch succeeded.<\/code><\/pre>\n\n\n\n
To see which patches were applied:<\/p>\n\n\n\n
[oracle@dp-gr 31113348]$ $ORACLE_HOME\/OPatch\/opatch lsinventory<\/code><\/pre>\n\n\n\n
\nOracle Interim Patch Installer version 12.2.0.1.21\nCopyright (c) 2020, Oracle Corporation.  All rights reserved.\n\n\nOracle Home       : \/home\/oracle\/oracle\/app\/oracle\/product\/12.1.0.2\/db_1\nCentral Inventory : \/home\/oracle\/oracle\/app\/oraInventory\n   from           : \/home\/oracle\/oracle\/app\/oracle\/product\/12.1.0.2\/db_1\/oraInst.loc\nOPatch version    : 12.2.0.1.21\nOUI version       : 12.1.0.2.0\nLog file location : \/home\/oracle\/oracle\/app\/oracle\/product\/12.1.0.2\/db_1\/cfgtoollogs\/opatch\/opatch2020-09-21_15-03-14PM_1.log\n\nLsinventory Output file location : \/home\/oracle\/oracle\/app\/oracle\/product\/12.1.0.2\/db_1\/cfgtoollogs\/opatch\/lsinv\/lsinventory2020-09-21_15-03-14PM.txt\n--------------------------------------------------------------------------------\nLocal Machine Information::\nHostname: dp-gr.subnet.vcn.oraclevcn.com\nARU platform id: 226\nARU platform description:: Linux x86-64\n\nInstalled Top-level Products (1):\n\nOracle Database 12c                                                  12.1.0.2.0\nThere are 1 products installed in this Oracle Home.\n\n\nInterim patches (1) :\n\nPatch  31113348     : applied on Mon Sep 21 14:44:47 GMT 2020\nUnique Patch ID:  23682224\nPatch description:  \"Database Patch Set Update : 12.1.0.2.200714 (31113348)\"\n   Created on 7 Jul 2020, 20:50:51 hrs PST8PDT<\/code><\/pre>\n\n\n\n
After the upgrade to the software binaries is complete, with the datapatch<\/strong> we will also update the database.<\/p>\n\n\n\n
But first, let's start with the basics:<\/p>\n\n\n\n
[oracle@dp-gr admin]$ sqlplus \/ as sysdba\n\nSQL> startup;\n\nSQL> exit;\n\n<\/code><\/pre>\n\n\n\n
And then we run it datapatch<\/strong>:<\/p>\n\n\n\n
[oracle@dp-gr admin]$ $ORACLE_HOME\/OPatch\/datapatch -verbose<\/code><\/pre>\n\n\n\n
\nSQL Patching tool version 12.1.0.2.0 Production on Mon Sep 21 15:09:55 2020\nCopyright (c) 2012, 2016, Oracle.  All rights reserved.\n\nLog file for this invocation: \/home\/oracle\/oracle\/app\/oracle\/cfgtoollogs\/sqlpatch\/sqlpatch_29130_2020_09_21_15_09_55\/sqlpatch_invocation.log\n\nConnecting to database...OK\nBootstrapping registry and package to current versions...done\nDetermining current state...done\n\nCurrent state of SQL patches:\nBundle series PSU:\n  ID 200714 in the binary registry and not installed in the SQL registry\n\nAdding patches to installation queue and performing prereq checks...\nInstallation queue:\n  Nothing to roll back\n  The following patches will be applied:\n    31113348 (DATABASE PATCH SET UPDATE 12.1.0.2.200714)\n\nInstalling patches...\nPatch installation complete.  Total patches installed: 1\n\nValidating logfiles...\nPatch 31113348 apply: SUCCESS<\/code><\/pre>\n\n\n\n
We can now bring up the listener again so that other users can connect:<\/p>\n\n\n\n
[oracle@dp-gr db_1]$ lsnrctl start<\/code><\/pre>\n\n\n\n
LSNRCTL for Linux: Version 12.1.0.2.0 - Production on 21-SEP-2020 18:21:03\n\nCopyright (c) 1991, 2014, Oracle.  All rights reserved.\n\nConnecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=dp-gr)(PORT=1521)))\nSTATUS of the LISTENER\n------------------------\nAlias                     LISTENER\nVersion                   TNSLSNR for Linux: Version 12.1.0.2.0 - Production\nStart Date                21-SEP-2020 18:10:08\nUptime                    0 days 0 hr. 10 min. 55 sec\nTrace Level               off\nSecurity                  ON: Local OS Authentication\nSNMP                      OFF\nListener Parameter File   \/home\/oracle\/oracle\/app\/oracle\/product\/12.1.0.2\/db_1\/network\/admin\/listener.ora\nListener Log File         \/home\/oracle\/oracle\/app\/oracle\/diag\/tnslsnr\/dp-gr\/listener\/alert\/log.xml\nListening Endpoints Summary...\n  (DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=dp-gr.subnet.vcn.oraclevcn.com)(PORT=1521)))\n  (DESCRIPTION=(ADDRESS=(PROTOCOL=ipc)(KEY=EXTPROC1521)))\n  (DESCRIPTION=(ADDRESS=(PROTOCOL=tcps)(HOST=dp-gr.subnet.vcn.oraclevcn.com)(PORT=5500))(Security=(my_wallet_directory=\/home\/oracle\/oracle\/app\/oracle\/admin\/orcl\/xdb_wallet))(Presentation=HTTP)(Session=RAW))\nServices Summary...<\/code><\/pre>\n\n\n\n
After the listener is up, we can also connect to an external application.<\/p>\n\n\n\n
With the following query we can see the PSU passed and when:<\/p>\n\n\n\n
select patch_id,status,action_time,description from dba_registry_sqlpatch order by action_time;<\/code><\/pre>\n\n\n\n
\"\"<\/figure>\n\n\n\n
To delete the garbage left from the installation, run it opatch cleanup<\/strong> (we will still be able to rollback the patches):<\/p>\n\n\n\n
[oracle@dp-gr db_1]$ $ORACLE_HOME\/OPatch\/opatch util cleanup<\/code><\/pre>\n\n\n\n
Oracle Interim Patch Installer version 12.2.0.1.21\nCopyright (c) 2020, Oracle Corporation.  All rights reserved.\n\n\nOracle Home       : \/home\/oracle\/oracle\/app\/oracle\/product\/12.1.0.2\/db_1\nCentral Inventory : \/home\/oracle\/oracle\/app\/oraInventory\n   from           : \/home\/oracle\/oracle\/app\/oracle\/product\/12.1.0.2\/db_1\/oraInst.loc\nOPatch version    : 12.2.0.1.21\nOUI version       : 12.1.0.2.0\nLog file location : \/home\/oracle\/oracle\/app\/oracle\/product\/12.1.0.2\/db_1\/cfgtoollogs\/opatch\/opatch2020-09-21_18-11-50PM_1.log\n\nInvoking utility \"cleanup\"\nOPatch will clean up 'restore.sh,make.txt' files and 'scratch,backup' directories.\nYou will be still able to rollback patches after this cleanup.\nDo you want to proceed? [y|n]\nY\nUser Responded with: Y\n\nBackup area for restore has been cleaned up. For a complete list of files\/directories\ndeleted, Please refer log file.\n\nOPatch succeeded.<\/code><\/pre>\n\n\n\n
<\/p>\n\n\n\n
If we want to rollback the patch...<\/h2>\n\n\n\n
In the event that we want to rollback the patch, we can, while we have downloaded the database, run the following command stating the patch id that we want to remove:<\/p>\n\n\n\n
[oracle@dp-gr db_1]$ $ORACLE_HOME\/OPatch\/opatch rollback -id 31113348<\/code><\/pre>\n\n\n\n
However, after the rollback to the Oracle binaries is completed, we should run datapatch again (with the database uploaded) so that the changes to the database tables will also be passed:<\/p>\n\n\n\n
[oracle@dp-gr db_1]$ $ORACLE_HOME\/OPatch\/datapatch -verbose<\/code><\/pre>\n\n\n\n
<\/p>\n\n\n\n
Sources:<\/h2>\n\n\n\n