Posts

Oracle Database 19c performance Issue Post Migration -- What to Consider

Image
  Common Misunderstanding :  1)  Compatible Parameter  Control  Optimizer Behavior 2)  A) Thing to Compare in source  and Target :   1)   Compare Database Parameter with source and Target  Specially Non default parameters and Optimizer Parameters  Under Score Parameters / Events 2)  Compare  Database  Hidden parameters  In source and  Target  3) Compare Database Optimizer parameters in source and target  https://abdul-hafeez-kalsekar.blogspot.com/2022/06/oracle-database-parameters-influencing.html 4)  Compare Database Sql profiles  and Baselines  in source and Target  5) Compare Database Sql patches in source and  Target  6)   Compare database maintenance window in source and  Target  and verify  automatic  statistics collection 7)    Compare dba_profiles   and password verification function for  comparin...
Post a Comment
Read more

Copy Grid home from one node to another

  BUG 26126676 - CLUSTER DOWN ON DENS13ADM02 SERVER AFTER ONEOFF PATCH ROLLBACK     *** PBRYS  philippe.brys 05/23/17 02:52 am ***  Since the software installation are identical on all nodes  it is possible to copy over the whole software from one of the correct node  to the bad third node    a. tar as root the whole software tree on e.g. node1  e.g. for the GRID_HOME  cd $GRID_HOME  cd ..  tar cvf grid.tar ./grid    b. untar it as root in the same recreated directory on the failed node    cd $GRID_HOME  cd ..  mv grid grid.old  /* preserve the bad grid home  tar xvf grid.tar    c. set back the configuration    rm -Rf grid/log/*  rm -Rf grid/crf/*  rm -Rf grid/cdata/*  rm -Rf grid/gpnp/*  rm -Rf grid/ccr/hosts/*  rm -Rf grid/dbs/*  rm -Rf grid/network/admin/*    mv grid.old/log/* grid/log  mv grid.old/crf/* grid/cr...
Post a Comment
Read more

Rac check script rac_status.sh -a

https://github.com/freddenis/oracle-scripts/blob/master/rac-status.sh  #!/bin/bash # Fred Denis -- Jan 2016 -- fred.denis3@gmail.com -- http://unknowndba.blogspot.com # rac-status.sh - an overview of your Oracle RAC / GI 11g, 12c, 18c ,19c, 21c+ resources in a glimpse  # Copyright (C) 2021 Fred Denis # # This program is free software: you can redistribute it and/or modify # it under the terms of the GNU General Public License as published by # the Free Software Foundation, either version 3 of the License, or # (at your option) any later version. # # This program is distributed in the hope that it will be useful, # but WITHOUT ANY WARRANTY; without even the implied warranty of # MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE.  See the # GNU General Public License for more details. # # You should have received a copy of the GNU General Public License # along with this program.  If not, see <https://www.gnu.org/licenses/>. # # # More info and git repo: https:...
Post a Comment
Read more