">

Patch 30830887: DATABASE RELEASE UPDATE REVISION 18.8.2.0.0

Patch 30830887: DATABASE RELEASE UPDATE REVISION 18.8.2.0.0

Merhaba Arkadaşlar, 

 

30830887 numaralı patch i oracle 18c veri tabanına geçişin adımlarını takip edebilirsiniz.

 

installation dokümanınıda aşağıdaki linkten takip edebilirsiniz:

https://updates.oracle.com/Orion/Services/download?type=readme&aru=23449901

 

Patch'i aşağıdaki linkten indirebilirsiniz:

 

https://support.oracle.com/epmos/faces/PatchResultsNDetails?_adf.ctrl-state=107lasva90_4&releaseId=600000000071008&requestId=23449901&patchId=30830887&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=179574826383282

 

Unzip edip yetkiler verilir.

 

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

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

Cd /u01/app/oracle/product/18c/db/OPatch/30830887

 

Check edilir patch yüklenebilir mi diye?

 

[oracle@oracledb 30830887]$ .././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-18_09-57-52AM_1.log

 

Invoking prereq "checkconflictagainstohwithdetail"

 

Prereq "checkConflictAgainstOHWithDetail" passed.

 

OPatch succeeded.

 

[oracle@oracledb 30830887]$ sqlplus / as sysdba

 

SQL*Plus: Release 18.0.0.0.0 - Production on Tue Aug 18 09:59:12 2020

Version 18.3.0.0.0

 

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

 

 

Connected to:

Oracle Database 18c Enterprise Edition Release 18.0.0.0.0 - Production

Version 18.3.0.0.0

 

SQL> shu immediate

Database closed.

Database dismounted.

ORACLE instance shut down.

 

[oracle@oracledb ~]$ lsnrctl stop

 

LSNRCTL for Linux: Version 18.0.0.0.0 - Production on 18-AUG-2020 10:02:03

 

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)))

TNS-12541: TNS:no listener

 TNS-12560: TNS:protocol adapter error

  TNS-00511: No listener

   Linux Error: 2: No such file or directory

 

[oracle@oracledb ~]$ crsctl stop has

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

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

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

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

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

CRS-2677: Stop of 'ora.FRA.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

CRS-2793: Shutdown of Oracle High Availability Services-managed resources on 'oracledb' has completed

CRS-4133: Oracle High Availability Services has been stopped.

 

Burada çok uun olduğu için ve diskalanı yetersizliğinden dolayı çok uzun bir log olması sebebi ile sadece komutu yazdım ve başarılı bir şekilde bittiğini yazdım.

 

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

…..

User Responded with: Y

Patch 30830887 successfully applied.

 

[oracle@oracledb ~]$ crsctl start has

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

 

 

kontrol ettiğimizde versiyonun 18.8.2.0.0 olduğunu görebilirsiniz. koyu renk ilede boyadım.

 

[oracle@oracledb 30830887]$ sqlplus / as sysdba

 

SQL*Plus: Release 18.0.0.0.0 - Production on Tue Aug 18 10:25:25 2020

Version 18.8.2.0.0

 

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

 

 

Connected to:

Oracle Database 18c Enterprise Edition Release 18.0.0.0.0 - Production

Version 18.3.0.0.0

 

 

Burda da göreceğiniz üzere 30830887 numaralı patch i lsinventory ile baktığınızda görebilirsiniz.

 

[oracle@oracledb OPatch]$ ./opatch lsinventory

Oracle Interim Patch Installer version 12.2.0.1.21

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

 

 

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-18_10-25-52AM_1.log

 

Lsinventory Output file location : /u01/app/oracle/product/19c/db/cfgtoollogs/opatch/lsinv/lsinventory2020-08-18_10-25-52AM.txt

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

Local Machine Information::

Hostname: oracledb

ARU platform id: 226

ARU platform description:: Linux x86-64

 

Installed Top-level Products (1): 

 

Oracle Database 18c                                                  18.0.0.0.0

There are 1 products installed in this Oracle Home.

 

 

Interim patches (3) :

 

Patch  30830887     : applied on Tue Aug 18 10:18:27 EET 2020

Unique Patch ID:  23449901

Patch description:  "Database Release Update Revision : 18.8.2.0.200414 (30830887)"

   Created on 20 Mar 2020, 01:31:56 hrs PST8PDT

   Bugs fixed:

     8932139, 9062315, 13554903, 14221306, 20436508, 21095391, 21223848

     21374587, 21547051, 21744603, 21766220, 21806121, 21935698, 23003564

     23061453, 23310101, 23761724, 24489904, 24687075, 24689376, 24737581

     24841671, 24844841, 24903291, 24925863, 24971597, 25035594, 25035599

     25060506, 25287072, 25293659, 25303284, 25309116, 25348956, 25405687

     25487146, 25591292, 25607397, 25634405, 25644811, 25663488, 25686739

     25696520, 25726981, 25736428, 25743479, 25756945, 25824236, 25882883

     25890002, 25908728, 25911069, 25929650, 25943740, 25958554, 25986062

     25997810, 26083489, 26115103, 26164661, 26226953, 26237338, 26281476

     26284722, 26297826, 26336101, 26362155, 26399691, 26422277, 26423085

     26427905, 26440169, 26450454, 26476244, 26521043, 26536320, 26595088

     26598422, 26615291, 26617804, 26646549, 26654411, 26694735, 26724511

     26731697, 26745002, 26785169, 26790514, 26792891, 26798411, 26818960

     26822620, 26843558, 26843664, 26846077, 26871815, 26883456, 26894737

     26895149, 26898279, 26910716, 26927998, 26928317, 26933599, 26943004

     26956033, 26960097, 26961415, 26966120, 26966916, 26970175, 26976568

     26985002, 26986173, 26992964, 27000158, 27005278, 27006120, 27006664

     27016033, 27026401, 27028251, 27030974, 27033520, 27034688, 27035653

     27036408, 27037839, 27038986, 27041253, 27044575, 27047831, 27053044

     27054231, 27058530, 27060167, 27060859, 27061736, 27066451, 27066519

     27072923, 27073066, 27075854, 27080874, 27086821, 27090765, 27093423

     27101105, 27101527, 27101652, 27105900, 27106301, 27110878, 27111780

     27112686, 27115422, 27119621, 27122162, 27125872, 27126666, 27128580

    ………….

 

Umarım Faydalı olmuştur.

 

 

Yorumlar

Henüz yorum yapılmadı.

Yorum Yapın