Durham Oracle: February 2019

See earlier post for details on where to pull the latest Oracle patches.

"Download Reference for Oracle Database / GI Update, Revision, PSU, SPU(CPU), Bundle Patches, Patchsets and Base Releases ( Doc ID 2118136.2 )"

This is the patching info for a standalone grid server with rdbms 12c.

As we are using grid - downloaded the latest grid patch 28828733.

Applied the latest Opatch patch to both homes, applied the patch on both homes and ran datapatch verbose on the rdbms side to apply the patch updates to the database.

As always please try on test environment first!!!

https://dba12c.wordpress.com/2015/05/19/12c-new-pathcing-feature-datapatch-2/

Latest OPatch :

https://updates.oracle.com/download/6880880.html

If you hit this issue when running Opatch after unzipping the patch :

Error: This Java instance does not support a 64-bit JVM.
Please install the desired version.

From the OPatch/jre/bin directory link Java back to the Home Java.

[oracle@usnyssmtaoem01 bin]$ pwd

/u01/app/12.2.0/grid/OPatch/jre/bin

Keep the original java.

[oracle@usnyssmtaoem01 bin]$ mv java java_orig

[oracle@usnyssmtaoem01 bin]$ ln -s /u01/app/12.2.0/grid/jdk/bin/java java

[oracle@usnyssmtaoem01 bin]$ ./java -version

java version "1.8.0_91"

Java(TM) SE Runtime Environment (build 1.8.0_91-b14)

Java HotSpot(TM) 64-Bit Server VM (build 25.91-b14, mixed mode)

This is for the database home but also ran against the Grid Home.

root@oradw01 OPatch]# ./opatchauto apply /u99/media/software/28828733 -oh /u01/app/oracle/product/dbhome

OPatchauto session is initiated at Tue Feb 5 04:02:28 2019

System initialization log file is /u01/app/oracle/product/dbhome/cfgtoollogs/opatchautodb/systemconfig2019-02-05_04-02-32AM.log.

Session log file is /u01/app/oracle/product/dbhome/cfgtoollogs/opatchauto/opatchauto2019-02-05_04-02-37AM.log

The id for this session is V583

Executing OPatch prereq operations to verify patch applicability on home /u01/app/oracle/product/dbhome

Patch applicability verified successfully on home /u01/app/oracle/product/dbhome

Verifying SQL patch applicability on home /u01/app/oracle/product/dbhome

SQL patch applicability verified successfully on home /u01/app/oracle/product/dbhome

Preparing to bring down database service on home /u01/app/oracle/product/dbhome

Successfully prepared home /u01/app/oracle/product/dbhome to bring down database service

Bringing down database service on home /u01/app/oracle/product/dbhome

Following database has been stopped and will be restarted later during the session: adwdata

Database service successfully brought down on home /u01/app/oracle/product/dbhome

Start applying binary patch on home /u01/app/oracle/product/dbhome

Binary patch applied successfully on home /u01/app/oracle/product/dbhome

Starting database service on home /u01/app/oracle/product/dbhome

Database service successfully started on home /u01/app/oracle/product/dbhome

Preparing home /u01/app/oracle/product/dbhome after database service restarted

No step execution required.........

Trying to apply SQL patch on home /u01/app/oracle/product/dbhome

SQL patch applied successfully on home /u01/app/oracle/product/dbhome

OPatchAuto successful.

-------------------------------Summary--------------------------------

Patching is completed successfully. Please find the summary as follows:

Host:oradw01

SIDB Home:/u01/app/oracle/product/dbhome

Version:12.2.0.1.0

Summary:

==Following patches were SKIPPED:

Patch: /u99/media/software/28828733/28864846

Reason: This patch is not applicable to this specified target type - "oracle_database"

Patch: /u99/media/software/28828733/26839277

Reason: This patch is not applicable to this specified target type - "oracle_database"

Patch: /u99/media/software/28828733/28566910

Reason: This patch is not applicable to this specified target type - "oracle_database"

==Following patches were SUCCESSFULLY applied:

Patch: /u99/media/software/28828733/28822515

Log: /u01/app/oracle/product/dbhome/cfgtoollogs/opatchauto/core/opatch/opatch2019-02-05_04-03-53AM_1.log

Patch: /u99/media/software/28828733/28870605

Log: /u01/app/oracle/product/dbhome/cfgtoollogs/opatchauto/core/opatch/opatch2019-02-05_04-03-53AM_1.log

OPatchauto session completed at Tue Feb 5 04:06:35 2019

Time taken to complete the session 4 minutes, 7 seconds

[root@oradw01 OPatch]# exit

[oracle@oradw01 OPatch]$ pwd

/u01/app/oracle/product/dbhome/OPatch

[oracle@oradw01 OPatch]$ ./datapatch -verbose

SQL Patching tool version 12.2.0.1.0 Production on Tue Feb 5 04:08:51 2019

Copyright (c) 2012, 2018, Oracle. All rights reserved.

Log file for this invocation: /u01/app/12.2.0/cfgtoollogs/sqlpatch/sqlpatch_63892_2019_02_05_04_08_51/sqlpatch_invocation.log

Connecting to database...OK

Bootstrapping registry and package to current versions...done

Determining current state...done

Current state of SQL patches:

Bundle series DBRU:

ID 190115 in the binary registry and ID 190115 in the SQL registry

Adding patches to installation queue and performing prereq checks...

Installation queue:

Nothing to roll back

Nothing to apply

SQL Patching tool complete on Tue Feb 5 04:08:58 2019

[oracle@oradw01 OPatch]$ sqlplus / as sysdba

SQL*Plus: Release 12.2.0.1.0 Production on Tue Feb 5 04:09:31 2019

Copyright (c) 1982, 2016, Oracle. All rights reserved.

Connected to:

Oracle Database 12c Enterprise Edition Release 12.2.0.1.0 - 64bit Production

SQL> select patch_id, status, description from dba_registry_sqlpatch

SQL> /

PATCH_ID STATUS DESCRIPTION
--------- ------------------------- ------------------------------------------------------------
28822515 SUCCESS DATABASE JAN 2019 RELEASE UPDATE 12.2.0.1.190115

Durham Oracle

ASM compatibility

Two column match in Excel

Oracle Patching quick notes..