Posts

Showing posts from September, 2020

Vertical and horizontal scaling in oracle EBS Application R12

Image
  Vertical scaling (Scaling up)  Adding more power CPU,RAM,DISK to your existing machine.   In EBS R12 perspective  Adding more managed Servers to existing Node.  1) Single Managed Server (oacore_server1) on OACORE_CUSTER_1       2) Add Additional OACORE Managed Server  ((oacore_server2) on OACORE_CUSTER_1) You can create Additional Manage Server using Tool adProvisionEBS.pl   Why Additional Managed Servers  Handling Load and User Concurrency Provide Redundancy Add Services to existing  Node  (accessgate for SSO) Horizontal scaling (scaling out) Adding more machines to your pool or Cluster. In EBS R12 perspective,  ADD Managed Server by adding  new Server to exiting Cluster .  Horizontal Scaling  OACORE_SERVER1 and OACORE_SERVER2 on OACORE_CLUSTER_1 but both managed Server deployed on  different Application Server   You can Add Secondary Node on EBS Application u...

OJVM PSU Patch in Oracle 12c RAC Database

OJVM  include critical fixes for the Oracle JavaVM component within the Oracle Database OJVM  are applicable to all database installations regardless of which patching model is used ( DB Update, GI Update, DB Revision, GI Revision, DB PSU, GI PSU, Security Patch Update (SPU), Windows Bundle Patch or Database Patch for Exadata ) require the database home to be patched to at least October 2014 DB PSU ( or equivalent ) include binary changes to be applied to each Database ORACLE_HOME, and "post install" steps to be execute on each database running from the ORACLE_HOME You may not need to apply OJVM patch bundles to a Grid Infrastructure home Steps to Apply OJVM PSU Patch in Oracle 12c RAC  Database 1) Run the following select in each database to check if it has Oracle JavaVM present (most databases will have JavaVM): SELECT version, status FROM d ba_registry WHERE co mp_id='JAVAVM'; If "STATUS" is "VALID" then it is recommended to install OJVM PSU/Upd...

Applying PSU patches on Oracle Database 12.1.0.2 RAC database

Image
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    Download respective PSU patch you need to apply from oracle meta link to Linux box  Unzip patch and check patch READ me file  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/s...