ابدأ بالتواصل مع الأشخاص وتبادل معارفك المهنية

أنشئ حسابًا أو سجّل الدخول للانضمام إلى مجتمعك المهني.

متابعة

What is patching in oracle?

user-image
تم إضافة السؤال من قبل Waqar Ali , Database Administrator (DBA) , Precise Tech
تاريخ النشر: 2016/02/23
Trang Nguyen
من قبل Trang Nguyen , Senior DBA , Profectus

Patching in oracle is a collecting of regular patches to apply to Oracle products for various purposes including fixing bugs, secure or upgrade. The normal patching workflow can be broken down into the following nice steps:

1. Identify Patches

2. Download Patched and the lastest OPatch utility to a local system

3. Backup to the Oracle Home

4. Identify target

5. Apply on test system

6. Optional create/ update script

7. Check any conflict--> fix it does

8. Test the patches

9. Apply to production

Sreejith Divakaran Nair
من قبل Sreejith Divakaran Nair , Oracle DBA Consultant , Australia and New Zealand Banking Group

Oracle regularly makes patches available to upgrade features, enhance security, or fix problems with supported software. The major types of patches are:

  • Interim patches - contain a single bug fix or a collection of bug fixes provided as required

  • Interim patches for security bug fixes - contain customer-specific security bug fixes

  • Diagnostic patches - intended to help diagnose or verify a fix or a collection of bug fixes

  • Bundle Patch Updates (BPUs) - a cumulative collection of fixes for a specific product or component

  • Patch Set Updates (PSUs) - a cumulative collection of high impact, low risk, and proven fixes for a specific product or component and Security Patch Updates

  • Security Patch Updates (SPU) - a cumulative collection of security bug fixes. SPUs were formerly known as Critical Patch Updates (CPU).

  • System Patch - contains several sub-patches in a format that can be used by OPatchauto.

  • Merge Label Request (MLR) - a merge of two or more fixes. MLR creation requires a label for the new set of merged code and a Patch Set Exception

velupula ajay
من قبل velupula ajay

Patching is a set of programs  to fix the problems in the oracle version

Fouad TOUMIAT
من قبل Fouad TOUMIAT , Oracle DBA Manager , Ooredoo Algeria

Oracle Patch is a program to fix a particular problem, enhance or add a particular feature in the product.

abdullah aldubai
من قبل abdullah aldubai , database administrator , Techzone Training Services Ltd

oracle like any software contain bugs which not detected during the testing,

when a bug is detected it is given a unique bug number. oracle fixes the file that is

responsible of the bug.

the new version of the files knows as patch

it is to fix bugs (internal errors) defeats in the s/w code/logic , improve security and add features. 

 

 

 

Wajid Islam
من قبل Wajid Islam , Data Assistant , World Health Organization

Patch is a piece of program to fix bugs, improve security or add some features.

Abdulrahman Alsoufi
من قبل Abdulrahman Alsoufi , Senior Oracle Apps DBA , AEC

Patching is the action of fixing issues or problems that were found by Oracle Corp. using patches issued by Oracle.

It's not always for Bugs, it can also be used for adding options like languages.

Rao Waqar Alam
من قبل Rao Waqar Alam , Manager IT/MIS , Sui Northern Gas Pipelines Limited

Patching is simply bug fixes according to demand of the business users.

مستخدم محذوف‎
من قبل مستخدم محذوف‎

PATCH IS PROGRAM (SET OF INSTRUCTIONS) TO FIX A PARTICULAR PROBLEM OR ENHANCE/ ADD A PARTICULAR FEATURE IN EXISTING PROGRAM/PRODUCT/SOFTWARE

Mohammed Irfan Hussain
من قبل Mohammed Irfan Hussain , Oracle DBA ( Database Administrator) , Ministry of environment water and agriculture, Saudi Arabia

Patching is nothing but a bugs fixes.

Any major bugs if you have experienced  in 11.2.0.3 then that would fixes in 11.2.0.4 . Therefore bugs fixes is called as Patching. There are two types of Patching interim patch (for minor bugs)  and patchset patch (for major bugs fixes).

هل تحتاج لمساعدة في كتابة سيرة ذاتية تحتوي على الكلمات الدلالية التي يبحث عنها أصحاب العمل؟