">

Patch 31219909 - Oracle JavaVM Component Release Update 18.11.0.0.200714

Patch 31219909 - Oracle JavaVM Component Release Update 18.11.0.0.200714

 Merhaba Arkadaşlar,

 

Oracle 18c Veritabanı için 31219909 numaralı patch geçme işlemi

Aşağıdaki linkden patch indirilebilir.

 

https://support.oracle.com/epmos/faces/PatchResultsNDetails?_adf.ctrl-state=y79kztol2_106&releaseId=600000000071008&requestId=23606348&patchId=31219909&languageId=0&platformId=226&searchdata=%3Ccontext+type%3D%22ADVANCED%22+search%3D%22%26lt%3BSearch%26gt%3B%26lt%3BFilter+name%3D%26quot%3Bproduct%26quot%3B+op%3D%26quot%3Bis%26quot%3B+value%3D%26quot%3B1-97NVP%26quot%3B%2F%26gt%3B%26lt%3BFilter+name%3D%26quot%3Bproduct_family%26quot%3B+op%3D%26quot%3Bis%26quot%3B+value%3D%26quot%3Bfalse%26quot%3B%2F%26gt%3B%26lt%3BFilter+name%3D%26quot%3Brelease%26quot%3B+op%3D%26quot%3Bis%26quot%3B+value%3D%26quot%3B60000000007100180717211%26quot%3B%2F%26gt%3B%26lt%3BFilter+name%3D%26quot%3Bplatform%26quot%3B+op%3D%26quot%3Bis%26quot%3B+value%3D%26quot%3B226%26quot%3B%2F%26gt%3B%26lt%3BFilter+name%3D%26quot%3Blife_cycle%26quot%3B+op%3D%26quot%3Bis%26quot%3B+value%3D%26quot%3Btrue%26quot%3B%2F%26gt%3B%26lt%3BFilter+name%3D%26quot%3Bexclude_superseded%26quot%3B+op%3D%26quot%3Bis%26quot%3B+value%3D%26quot%3Bfalse%26quot%3B%2F%26gt%3B%26lt%3B%2FSearch%26gt%3B%22%2F%3E&_afrLoop=118872521921495

 

 

Sonrasında tmp dizinine atılan patch dosyasında aşağıdaki işlemler yapılır ;

 

Cd /tmp

[root@oracledb tmp]# chown oracle.oinstall p31219909_180000_Linux-x86-64.zip 

[oracle@oracledb tmp]$ unzip -d $ORACLE_HOME/OPatch p31219909_180000_Linux-x86-64.zip 

 

[oracle@oracledb tmp]$ cd $ORACLE_HOME

[oracle@oracledb db]$ cd OPatch/

 

[oracle@oracledb 31219909]$ .././opatch prereq CheckConflictAgainstOHWithDetail -ph ./

 

Oracle Interim Patch Installer version 12.2.0.1.21

Copyright (c) 2020, Oracle Corporation.  All rights reserved.

 

PREREQ session

 

Oracle Home       : /u01/app/oracle/product/19c/db

Central Inventory : /u01/app/oraInventory

   from           : /u01/app/oracle/product/19c/db/oraInst.loc

OPatch version    : 12.2.0.1.21

OUI version       : 12.2.0.4.0

Log file location : /u01/app/oracle/product/19c/db/cfgtoollogs/opatch/opatch2020-08-17_16-53-12PM_1.log

 

Invoking prereq "checkconflictagainstohwithdetail"

 

Prereq "checkConflictAgainstOHWithDetail" passed.

 

OPatch succeeded.

 

[oracle@oracledb 31219909]$ sqlplus / as sysdba                                      

SQL> shu immediate

Database closed.

Database dismounted.

ORACLE instance shut down.

 

[oracle@oracledb 31219909]$ cd 

[oracle@oracledb ~]$ . .grid 

 

[oracle@oracledb ~]$ lsnrctl stop

 

LSNRCTL for Linux: Version 18.0.0.0.0 - Production on 17-AUG-2020 16:55:52

 

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

 

Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=oracledb)(PORT=1521)))

TNS-12543: TNS:destination host unreachable

 TNS-12560: TNS:protocol adapter error

  TNS-00513: Destination host unreachable

   Linux Error: 113: No route to host

Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=IPC)(KEY=EXTPROC1521)))

The command completed successfully

You have new mail in /var/spool/mail/oracle

 

 

[oracle@oracledb ~]$ crsctl stop has

CRS-2791: Starting shutdown of Oracle High Availability Services-managed resources on 'oracledb'

CRS-2673: Attempting to stop 'ora.evmd' on 'oracledb'

CRS-2673: Attempting to stop 'ora.DATA.dg' on 'oracledb'

CRS-2673: Attempting to stop 'ora.FRA.dg' on 'oracledb'

CRS-2677: Stop of 'ora.FRA.dg' on 'oracledb' succeeded

CRS-2677: Stop of 'ora.DATA.dg' on 'oracledb' succeeded

CRS-2673: Attempting to stop 'ora.asm' on 'oracledb'

CRS-2677: Stop of 'ora.evmd' on 'oracledb' succeeded

CRS-2677: Stop of 'ora.asm' on 'oracledb' succeeded

CRS-2673: Attempting to stop 'ora.cssd' on 'oracledb'

CRS-2677: Stop of 'ora.cssd' on 'oracledb' succeeded

 

[oracle@oracledb 31219909]$ .././opatch apply

Oracle Interim Patch Installer version 12.2.0.1.21

Copyright (c) 2020, Oracle Corporation.  All rights reserved.

 

 

Oracle Home       : /u01/app/19c/grid

Central Inventory : /u01/app/oraInventory

   from           : /u01/app/19c/grid/oraInst.loc

OPatch version    : 12.2.0.1.21

OUI version       : 12.2.0.4.0

Log file location : /u01/app/19c/grid/cfgtoollogs/opatch/opatch2020-08-17_17-01-03PM_1.log

 

Verifying environment and performing prerequisite checks...

OPatch continues with these patches:   31219909  

 

Do you want to proceed? [y|n]

y

User Responded with: Y

All checks passed.

 

Please shutdown Oracle instances running out of this ORACLE_HOME on the local system.

(Oracle Home = '/u01/app/19c/grid')

 

 

Is the local system ready for patching? [y|n]

y

User Responded with: Y

Backing up files...

Applying interim patch '31219909' to OH '/u01/app/19c/grid'

 

Patching component oracle.javavm.server, 18.0.0.0.0...

 

Patching component oracle.javavm.server.core, 18.0.0.0.0...

 

Patching component oracle.rdbms.dbscripts, 18.0.0.0.0...

 

Patching component oracle.rdbms, 18.0.0.0.0...

 

Patching component oracle.javavm.client, 18.0.0.0.0...

Patch 31219909 successfully applied.

Sub-set patch [27923415] has become inactive due to the application of a super-set patch [31219909].

Please refer to Doc ID 2161861.1 for any possible further required actions.

Log file location: /u01/app/19c/grid/cfgtoollogs/opatch/opatch2020-08-17_17-01-03PM_1.log

 

OPatch succeeded.

 

[oracle@oracledb ~]$ crsctl start has

CRS-6706: Oracle Clusterware Release patch level ('1733558083') does not match Software patch level ('70732493'). Oracle Clusterware cannot be started.

CRS-4000: Command Start failed, or completed with errors.

 

 

Yukardaki hatanın çözümü olarak aşağıdaki işlemler yapılır;

 

 

[oracle@oracledb ~]$ . .grid 

 

[oracle@oracledb ~]$ /u01/app/19c/grid/bin/kfod op=patches

---------------

List of Patches

===============

27908644

28090523

28090553

28090557

28090564

28256701

31219909

[oracle@oracledb ~]$ /u01/app/19c/grid/bin/kfod op=patchlvl

-------------------

Current Patch level

===================

1733558083

 

 

[root@oracledb tmp]# /u01/app/19c/grid/crs/install/roothas.sh -unlock 

Using configuration parameter file: /u01/app/19c/grid/crs/install/crsconfig_params

The log of current session can be found at:

  /u01/app/oracle/crsdata/oracledb/crsconfig/haunlock__2020-08-17_05-06-31PM.log

2020/08/17 17:06:42 CLSRSC-347: Successfully unlock /u01/app/19c/grid

[root@oracledb tmp]# /u01/app/19c/grid/crs/install/roothas.sh -postpatch

Using configuration parameter file: /u01/app/19c/grid/crs/install/crsconfig_params

The log of current session can be found at:

  /u01/app/oracle/crsdata/oracledb/crsconfig/hapatch_2020-08-17_05-07-26PM.log

2020/08/17 17:07:27 CLSRSC-329: Replacing Clusterware entries in file 'oracle-ohasd.service'

2020/08/17 17:08:12 CLSRSC-672: Post-patch steps for patching GI home successfully completed.

[root@oracledb tmp]# /u01/app/19c/grid/crs/install/roothas.sh -lock

Using configuration parameter file: /u01/app/19c/grid/crs/install/crsconfig_params

The log of current session can be found at:

  /u01/app/oracle/crsdata/oracledb/crsconfig/halock__2020-08-17_05-09-16PM.log

2020/08/17 17:09:17 CLSRSC-329: Replacing Clusterware entries in file 'oracle-ohasd.service'

 

 

Sonrasında tekrar açmayı deneriz;

 

[oracle@oracledb ~]$ crsctl start has  

CRS-4123: Oracle High Availability Services has been started.

 

[root@oracledb tmp]# su - oracle

Last login: Mon Aug 17 17:09:43 +03 2020

 

[oracle@oracledb ~]$ sqlplus / as sysdba     

 

SQL*Plus: Release 18.0.0.0.0 - Production on Mon Aug 17 17:12:07 2020

Version 18.3.0.0.0

 

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

 

Connected to an idle instance.

 

SQL> startup

ORACLE instance started.

 

Total System Global Area 1207957680 bytes

Fixed Size                  8657072 bytes

Variable Size             939524096 bytes

Database Buffers          251658240 bytes

Redo Buffers                8118272 bytes

Database mounted.

Database opened.

SQL> 

 

Umarım faydalı olmuştur.

Yorumlar

Henüz yorum yapılmadı.

Yorum Yapın