MÔ TẢ:-
Trong bài viết này tôi sẽ hướng dẫn các bạn apply PSU patch phát hành vào 18/07 trên môi trườngr Oracle One Node RAC
- Kiểm tra phiên bản OPatch hiện tại
- Nâng cấp tiện ích Opatch
- Chuẩn bị Patch
- Apply Patch
- Kiểm tra sau khi Patch
Kiểm tra phiên bản OPatch hiện tại:
Bước 1:-
$ export PATH=$ORACLE_HOME/OPatch:$PATH $ $ORACLE_HOME/OPatch/opatch version OPatch Version: 12.1.0.1.3 OPatch succeeded.
Phiên bản Opatch hiện tại là 12.1.0.1.3. Nhưng khi đọc README OPatch tối thiểu phải từ 12.2.0.1.12 để có thể apply patch, bạn có thể down từ My Oracle Support patch 6880880 và lựa chọn phiên bản 12.2.0.1.0
Nâng cấp tiện ích Opatch:-
Bước 2:- Backup thư mục Opatch cũ
Backup thư mục OPatch bằng user root trong thư mục GRID_HOME và bằng user oracle trong thư mục ORACLE_HOME(Database) trên cả 2 node của cluster.
GRID_HOME: $ su - root $ cd /oradb/app/12.1.0.2/grid/ $ mv OPatch/ OPatch_bkp $ unzip <PATH_TO_PATCH>/p6880880_122010_Linux-x86-64.zip -d . $ chown -R oracle:oinstall OPatch $ chmod -R 755 OPatch ORACLE_HOME: $ su - oracle $ cd /oradb/app/oracle/product/12.1.0.2/db_1 $ mv OPatch/ OPatch_bkp $ unzip <PATH_TO_PATCH>/p6880880_122010_Linux-x86-64.zip -d . $ chmod -R 755 OPatch
Bây giờ, login bằng user oracle để kiểm tra phiên bản OPatch
GRID_HOME:-(Cả 2 Node)
$ export ORACLE_HOME=/oradb/app/12.1.0.2/grid $ export PATH=$ORACLE_HOME/OPatch:$PATH $ opatch version OPatch Version: 12.2.0.1.14 OPatch succeeded.
ORACLE_HOME:-(Cả 2 Node)
$ export ORACLE_HOME=/oradb/app/oracle/product/12.1.0.2/db_1 $ export PATH=$ORACLE_HOME/OPatch:$PATH $ opatch version OPatch Version: 12.2.0.1.14 OPatch succeeded.
Chuẩn bị Patch:-
Bước 3:- Chuẩn bị Node 1 để apply PSU Patch
Bây giờ, login bằng root và thiết lập biến môi trường
Apply Patch:-
Bước 4:- Vào thư mục chứa bản patch và thực hiện các bước sau để apply patch.
$ cd <PATH_TO_PATCH> $ unzip p27967747_121020_Linux-x86-64.zip $ cd 27967747 $ $ORACLE_HOME/OPatch/opatchauto apply ./ OPatchauto session is initiated at Wed Sep 26 02:39:52 2018 System initialization log file is /oradb/app/12.1.0.2/grid/cfgtoollogs/opatchautodb/systemconfig2018-09-26_02-40-10AM.log. Session log file is /oradb/app/12.1.0.2/grid/cfgtoollogs/opatchauto/opatchauto2018-09-26_02-41-29AM.log The id for this session is WYWB Executing OPatch prereq operations to verify patch applicability on home /oradb/app/12.1.0.2/grid Executing OPatch prereq operations to verify patch applicability on home /oradb/app/oracle/product/12.1.0.2/db_1 Patch applicability verified successfully on home /oradb/app/oracle/product/12.1.0.2/db_1 Patch applicability verified successfully on home /oradb/app/12.1.0.2/grid Verifying SQL patch applicability on home /oradb/app/oracle/product/12.1.0.2/db_1 SQL patch applicability verified successfully on home /oradb/app/oracle/product/12.1.0.2/db_1 Preparing to bring down database service on home /oradb/app/oracle/product/12.1.0.2/db_1 WARNING: The service ORCL.oracledbwr.com configured on orcl will not be switched as it is not configured to run on any other node(s). Successfully prepared home /oradb/app/oracle/product/12.1.0.2/db_1 to bring down database service Relocating RACOne home before patching on home /oradb/app/oracle/product/12.1.0.2/db_1 Relocated RACOne home before patching on home /oradb/app/oracle/product/12.1.0.2/db_1 Bringing down CRS service on home /oradb/app/12.1.0.2/grid Prepatch operation log file location: /oradb/app/12.1.0.2/grid/cfgtoollogs/crsconfig/crspatch_prodrac101_2018-09-26_02-49-04AM.log CRS service brought down successfully on home /oradb/app/12.1.0.2/grid Performing prepatch operation on home /oradb/app/oracle/product/12.1.0.2/db_1 Perpatch operation completed successfully on home /oradb/app/oracle/product/12.1.0.2/db_1 Start applying binary patch on home /oradb/app/oracle/product/12.1.0.2/db_1 Binary patch applied successfully on home /oradb/app/oracle/product/12.1.0.2/db_1 Performing postpatch operation on home /oradb/app/oracle/product/12.1.0.2/db_1 Postpatch operation completed successfully on home /oradb/app/oracle/product/12.1.0.2/db_1 Start applying binary patch on home /oradb/app/12.1.0.2/grid Binary patch applied successfully on home /oradb/app/12.1.0.2/grid Starting CRS service on home /oradb/app/12.1.0.2/grid Postpatch operation log file location: /oradb/app/12.1.0.2/grid/cfgtoollogs/crsconfig/crspatch_prodrac101_2018-09-26_03-42-46AM.log CRS service started successfully on home /oradb/app/12.1.0.2/grid Relocating back RACOne to home /oradb/app/oracle/product/12.1.0.2/db_1 Relocated back RACOne home successfully to home /oradb/app/oracle/product/12.1.0.2/db_1 Preparing home /oradb/app/oracle/product/12.1.0.2/db_1 after database service restarted No step execution required......... Trying to apply SQL patch on home /oradb/app/oracle/product/12.1.0.2/db_1 SQL patch applied successfully on home /oradb/app/oracle/product/12.1.0.2/db_1 OPatchAuto successful. --------------------------------Summary-------------------------------- Patching is completed successfully. Please find the summary as follows: Host:prodrac101 RAC Home:/oradb/app/oracle/product/12.1.0.2/db_1 Version:12.1.0.2.0 Summary: ==Following patches were SKIPPED: Patch: /mnt/hgfs/shared/soft/12102/July18_PSU/27967747/26983807 Reason: This patch is not applicable to this specified target type - "rac_database" Patch: /mnt/hgfs/shared/soft/12102/July18_PSU/27967747/27762277 Reason: This patch is not applicable to this specified target type - "rac_database" ==Following patches were SUCCESSFULLY applied: Patch: /mnt/hgfs/shared/soft/12102/July18_PSU/27967747/27547329 Log: /oradb/app/oracle/product/12.1.0.2/db_1/cfgtoollogs/opatchauto/core/opatch/opatch2018-09-26_02-55-50AM_1.log Patch: /mnt/hgfs/shared/soft/12102/July18_PSU/27967747/27762253 Log: /oradb/app/oracle/product/12.1.0.2/db_1/cfgtoollogs/opatchauto/core/opatch/opatch2018-09-26_02-55-50AM_1.log Host:prodrac101 CRS Home:/oradb/app/12.1.0.2/grid Version:12.1.0.2.0 Summary: ==Following patches were SUCCESSFULLY applied: Patch: /mnt/hgfs/shared/soft/12102/July18_PSU/27967747/26983807 Log: /oradb/app/12.1.0.2/grid/cfgtoollogs/opatchauto/core/opatch/opatch2018-09-26_03-08-36AM_1.log Patch: /mnt/hgfs/shared/soft/12102/July18_PSU/27967747/27547329 Log: /oradb/app/12.1.0.2/grid/cfgtoollogs/opatchauto/core/opatch/opatch2018-09-26_03-08-36AM_1.log Patch: /mnt/hgfs/shared/soft/12102/July18_PSU/27967747/27762253 Log: /oradb/app/12.1.0.2/grid/cfgtoollogs/opatchauto/core/opatch/opatch2018-09-26_03-08-36AM_1.log Patch: /mnt/hgfs/shared/soft/12102/July18_PSU/27967747/27762277 Log: /oradb/app/12.1.0.2/grid/cfgtoollogs/opatchauto/core/opatch/opatch2018-09-26_03-08-36AM_1.log OPatchauto session completed at Wed Sep 26 04:03:09 2018 Time taken to complete the session 83 minutes, 17 seconds
Kiểm tra sau khi Patch:-
Bước 5:- Mỗi khi patch được apply thành công, kiểm tra database:
$ sqlplus / as sysdba SQL> set serveroutput on SQL> exec dbms_qopatch.get_sqlpatch_status; Patch Id : 27547329 Action : APPLY Action Time : 26-SEP-2018 04:03:06 Description : DATABASE PATCH SET UPDATE 12.1.0.2.180717 Logfile : /oradb/app/oracle/cfgtoollogs/sqlpatch/27547329/22280349/27547329_apply_ORCL_201 8Sep26_04_00_51.log Status : SUCCESS PL/SQL procedure successfully completed.
Tương tự như vậy thực hiện trên Node 2.
Hy vọng hữu ích cho bạn.
* KHOÁ HỌC ORACLE DATABASE A-Z ENTERPRISE trực tiếp từ tôi giúp bạn bước đầu trở thành những chuyên gia DBA, đủ kinh nghiệm đi thi chứng chỉ OA/OCP, đặc biệt là rất nhiều kinh nghiệm, bí kíp thực chiến trên các hệ thống Core tại VN chỉ sau 1 khoá học.
* CÁCH ĐĂNG KÝ: Gõ (.) hoặc để lại số điện thoại hoặc inbox https://m.me/tranvanbinh.vn hoặc Hotline/Zalo 090.29.12.888
* Chi tiết tham khảo:
https://bit.ly/oaz_w
=============================
KẾT NỐI VỚI CHUYÊN GIA TRẦN VĂN BÌNH:
📧 Mail: binhoracle@gmail.com
☎️ Mobile: 0902912888
⚡️ Skype: tranbinh48ca
👨 Facebook: https://www.facebook.com/BinhOracleMaster
👨 Inbox Messenger: https://m.me/101036604657441 (profile)
👨 Fanpage: https://www.facebook.com/tranvanbinh.vn
👨 Inbox Fanpage: https://m.me/tranvanbinh.vn
👨👩 Group FB: https://www.facebook.com/groups/DBAVietNam
👨 Website: https://www.tranvanbinh.vn
👨 Blogger: https://tranvanbinhmaster.blogspot.com
🎬 Youtube: http://bit.ly/ytb_binhoraclemaster
👨 Tiktok: https://www.tiktok.com/@binhoraclemaster?lang=vi
👨 Linkin: https://www.linkedin.com/in/binhoracle
👨 Twitter: https://twitter.com/binhoracle
👨 Địa chỉ: Tòa nhà Sun Square - 21 Lê Đức Thọ - Phường Mỹ Đình 1 - Quận Nam Từ Liêm - TP.Hà Nội
=============================
học oracle database, Tự học Oracle, Tài liệu Oracle 12c tiếng Việt, Hướng dẫn sử dụng Oracle Database, Oracle SQL cơ bản, Oracle SQL là gì, Khóa học Oracle Hà Nội, Học chứng chỉ Oracle ở đầu, Khóa học Oracle online,khóa học pl/sql, học dba, học dba ở việt nam, khóa học dba, khóa học dba sql, tài liệu học dba oracle, Khóa học Oracle online, học oracle sql, học oracle ở đâu tphcm, học oracle bắt đầu từ đâu, học oracle ở hà nội, oracle database tutorial, oracle database 12c, oracle database là gì, oracle database 11g, oracle download, oracle database 19c, oracle dba tutorial, oracle tunning, sql tunning , oracle 12c, oracle multitenant, Container Databases (CDB), Pluggable Databases (PDB), oracle cloud, oracle security, oracle fga, audit_trail, oracle dataguard, oracle goldengate, mview, oracle exadata, oracle weblogic, middleware, hoc solaris, hoc linux, hoc aix, unix, oracle oca, oracle ocp, oracle ocm
