Applying PSU patches on Oracle Database 12.1.0.2 RAC database

-

PSU patches are  quarterly cumulative patches that contain security fixes as well as additional fixes 

Before starting Database  upgrades, update your new release Oracle Database to the latest Oracle bundle patch, patch set update (BP or PSU), or Release Update (Update), or Release Update Revision (Revision).

Before you start an upgrade or downgrade process, Oracle strongly recommends For Oracle Database 12c or earlier releases, update to the latest Oracle bundle patch, or patch set update (BP or PSU). 

Applying PSU patch on oracle RAC 

  1.  Download respective PSU patch you need to apply from oracle meta link to Linux box
  2.  Unzip patch and check patch READ me file
  3.  Install recommended OPatch on both nodes (Patch number: 6880880 )
Below Steps Demonstrate how to Apply PSU patch on GRID HOME & DB HOME separately  

  • GRID_HOME =/u01/app/12.1.0/grid
  • DATABASE_HOME=/u01/app/oracle/product/12.1.0/dbhome_1
  • PSU_Patch_Directory=/u02/soft/soft/Grid/pre-patch/psu/cpujuly2019/29698592

1) Analyze Grid Home  as ROOT user 

Below command will not actually apply patch it will analyze patch is compatible,prerequisites and any conflict patches on Oracle Grid Home 

/u01/app/12.1.0/grid/opatchauto apply /u02/soft/soft/Grid/pre-patch/psu/cpujuly2019/29698592  -analyze -oh /u01/app/12.1.0/grid    


2) Apply patch on GI Home (Rolling Manner ) as ROOT user

Rolling Manner refer to applying patches on different databases or different instances of the same database participating on Same RAC Cluster one at a time, without stopping the database.(one-off patches and PSU patches is currently available for rolling patch)

it will shutdown local Node Services (Cluster and DB Services)  and apply patch and restart all the services on local Node 

/u01/app/12.1.0/grid/OPatch/opatchauto apply /u02/soft/soft/Grid/pre-patch/psu/cpujuly2019/29698592  -oh /u01/app/12.1.0/grid


3) Analyze Database Home as ROOT user

Below command will not actually apply patch it will analyze patch is compatible,prerequisites and any conflict patches on Oracle Database  Home 

/u01/app/oracle/product/12.1.0/dbhome_1/OPatch/opatchauto apply /u02/soft/soft/Grid/pre-patch/psu/cpujuly2019/29698592 -analyze -oh /u01/app/oracle/product/12.1.0/dbhome_1



4) Apply patch on Database Home (Rolling Manner ) as ROOT user

Rolling Manner refer to applying patches on different databases or different instances of the same database participating on Same RAC Cluster one at a time, without stopping the database.(one-off patches and PSU patches is currently available for rolling patch)

It will shutdown Database instance and all services related to respective Oracle Database Home and apply patches and restart Database instance and all services related to respective Oracle Database Home. 

OPatchAuto calls datapatch to complete post patch actions upon installation of the binary patch and restart of the database.



5) you need to do same steps on all the nodes it is participating on Same RAC Cluster 

6) Check Database registry for patch information 

select description, action, to_char(action_time,'DD/MM/RR HH24:MI:SS') action_date, ' ' version

from dba_registry_sqlpatch;


Comments

Post a Comment

Popular posts from this blog

Enabling TLS 1.2 with Backward Compatibility in Oracle E-Business Suite Release 12.2 using Elliptic Curve Cryptography (ECC) certificate

-
Image
  Introduction TLS  Transport Layer Security ( TLS) is the successor  protocol to  SSL .  TLS  is an improved version of  SSL . Elliptic Curve Cryptography (ECC) certificate   ECC offers equivalent security with smaller key sizes, which results in faster computations, lower power consumption, and memory and bandwidth savings. Oracle Fusion Middleware supports the use of an Elliptic Curve Cryptography (ECC) certificate if the entire chain is ECC and the server cert is signed using ecdsasha256. Oracle E-Business Suite connections fall into the following three categories: Inbound connections Inbound connections are from a client to the Oracle HTTP Server (OHS) delivered with the Oracle E-Business Suite applications technology stack Example :  User accesses Oracle E-Business Suite applications pages through the network using a browser User accesses Oracle E-Business Suite application through Oracle Forms when using Forms Servlet mode An XML Gatew...
Read more

Mask sensitive data in cloned (non-production) EBS 12.2 environments using EBS 12.2 Data Masking Template with EM 13C.

-
Image
Due to data dependencies, scrambling E-Business Suite data is very time consuming and difficult task, because application functionality should work after Data Mask .  Oracle Provides Pre defined Data Masking Pack ( EBSMaskingPack 2.0.7) it is   Certified     with EBS R12.2 , We can easily do Data Masking on Test environment   using OEM 13 C with  Pre defined Data Masking Pack.    Data Masking Template certified with EBS R12.2 does the following. De-identifies the data : Scrambles identifiers of individuals, also known as personally identifiable information (PII).  Examples include information such as name, account, and address. Masks sensitive data : Masks data that, if associated with PII, would cause privacy concerns.  Examples include compensation, health and employment information.   Maintains data validity : Provides a functional application. Below Steps Demonstrate How to Mask -Oracle E-Bu...
Read more

Enabling SSL in Oracle E-Business Suite Release 12.2

-
Image
Oracle E-Business Suite Release 12.2 uses the Oracle Fusion Middleware infrastructure to secure communication between components using SSL (Secure Sockets Layer). Oracle HTTP Server (web tier) is the web server component for Oracle Fusion Middleware  and enables strong cryptography using mod_ossl and mod_wl_ohs modules. Web tier certificates can still be managed by   1)    Oracle Wallet Manager (OWM) GUI Tool 2)   orapki command line interface (CLI) 3)   Oracle Enterprise Manager Fusion Middleware Control (Fusion Middleware Control) Components running under Java  1)   JKS-based keystores to store keys and certificates. Set Your Environment for SSL  1)  You need to Configure SSL on RUN file System, So you require Application down Time  2)    Apply the latest AD and TXK Delta Release Update Packs (Always Recommend) 3) If you are using clients (JRE 8, some modern browsers) or Oracle Database 12c, you must ...
Read more