Oracle DBA Solution !!

Add new node in 11gR2 RAC Pre Requests: 1. Create users and groups groupadd -g 501 oinstall groupadd -g 502 dba groupadd -g 504 asmadmin groupadd -g 506 asmdba groupadd -g 507 asmoper useradd -u 501 -g oinstall -G asmadmin,asmdba,asmoper grid useradd -u 502 -g oinstall -G dba,asmdba,asmadmin,asmoper oracle passwd grid passwd oracle 2. /etc/hosts file so that it is similar to the all nodes following example: #eth0 Public 192.168.0.101 node1.clientit.com node1 192.168.0.102 node2.clientit.com node2 192.168.0.108 node3.clientit.com node3 #eth1 Private 192.168.0.103 node1-priv.ucliidt.com node1-priv 192.168.0.104 node2-priv.clientit.com node2-priv 192.168.0.109 node3-priv.clientit.com node3-priv #VIP IP 192.168.0.105 node1-vip.clientit.com node1-vip 192.168.0.106 node2-vip.clientit.com node2-vip 192.168.0.110 node3-vip.clientit.com node3-vip #SCAN IP 192.168.0.107 rac-scan.clientit.com rac-scan 3. Configuring Kernel Parameters i. As ...

PSU/CPU Patch Analysis for July 2018 for Production : ------------------------------------ Follow below sequence to apply patches. 1] Patch 27967747: GRID INFRASTRUCTURE PATCH SET UPDATE 12.1.0.2.180717  2] Patch 27923320: OJVM PATCH SET UPDATE 12.1.0.2.180717 3] Patch 27919943: WLS PATCH SET UPDATE 12.1.3.0.180717 Below are step to do anaylisys : Grid Patch:---------------------------------------------------------------------------------------------------------------- From Oracle Home as oracle user:-[Both Oracle Home] /db/app/oracle/product/12.1.0/dbhome_1/OPatch/opatch lsinventory -detail -oh /db/app/oracle/product/12.1.0/dbhome_1    //node1 /db/app/oracle/product/12.1.0/dbhome_1/OPatch/opatch lsinventory -detail -oh /db/app/oracle/product/12.1.0/dbhome_1    //node2 From Grid Home as grid user:- /db/app/12.1.0/grid_1/OPatch/opatch lsinventory -detail -oh /db/app/12.1.0/grid_1/            //node1 /db/app...

PSU and CPU April 2018 Patching 2 Node RAC Cluster.[Doc ID 2353306.1]  -------------------------------- Database Version: 12.1.0.2.0 Patches Patch 27475603: OJVM PATCH SET UPDATE 12.1.0.2.180417 Patch 27468957 GRID INFRASTRUCTURE PATCH SET UPDATE 12.1.0.2.180417 Steps Performed :  [Before patching activity] We have check & save the current list of active process before performing this activity  on Node1,Node2 1. p -eaf|grep tns 2. ps -eaf|grep smon 3. crs_stat -t -v 4.crsctl status resource 5. crsctl check crs 6. crsctl check cluster -all 7. srvctl status asm Brought down the edq from weblogic console (Edq 24). along with admin server. Brought down the obiie from weblogic console (Obiee 23server) along with admin server. Need to down Opmnctl service also Brough down the database Steps 1: [node1, Node2 ] Patch 27468957 GRID INFRASTRUCTURE PATCH SET UPDATE 12.1.0.2.180417 Unzip patch using grid user (27468957) ----Appyied patch using ROOT user. reviewed the redme file ...

OPatch utility version 12.1.0.1.7 or later to apply this patch. Grid Patch:---------------------------------------------------------------------------------------------------------------- From Oracle Home as oracle user:- /o001/home/oracle/product/12.1.0/db_1/OPatch/opatch lsinventory -detail -oh /o001/home/oracle/product/12.1.0/db_1 From Grid Home as grid user:- /o001/home/12.1.0/grid/OPatch/opatch lsinventory -detail -oh /o001/home/12.1.0/grid As root user:- /o001/home/12.1.0/grid/OPatch/opatchauto apply /o002/Oct_PSU_Patch/26635815 -analyze export PATH=/o001/home/12.1.0/grid/OPatch:$PATH opatchauto apply <UNZIPPED_PATCH_LOCATION>/27010872 Check Oracle permission $ORACLE_HOME/lib/libsqlplus.so --- Should be 644 From both oracle and grid users:- opatch lsinventory col ACTION_TIME for a30 col BUNDLE_SERIES for a15 select ACTION_TIME,PATCH_ID,PATCH_UID,VERSION,ACTION,STATUS,BUNDLE_SERIES,BUNDLE_ID from dba_registry_sqlpatch; ###################################Amar Jadhav ######...

How to perform PSU /CPU Patch Analysis: Step1: Login to My Oracle support and enter your credentials. Step 2:  Select  Below option " Oracle Critical Patch update (Month & Year) . Every quaterly oracle will release patch. Click on below option. Step :  Select below option. "Oracle Technology Network: http://www.oracle.com/SecurityAlerts " Step :  This will show below screen . You can choose PSU for the Month of April/Oct/Jan/July Step : Click on database to open release document.