Friday, 30 May 2025

Oracle RAC DBA Online Training - 7th June 2025

 

 Dear All,

Those who want to learn Oracle 19C RAC DBA online training from starting to Expert level follow the below course content.

Course Duration:  7 weekends ( Sat & Sun)  3 hours / per day ( 42 hours )

 

Staring the training from  7th June 2025 to 20th Jul 2025 (Total 7 weekends)

Weekend sessions: Saturday: 8:00 AM to 11 AM IST , 10:30 PM to 1:30AM ET

                                     Sunday:  8:00 AM to 11 AM IST , 10:30 PM to 1:30AM ET

 

Demo Session :   Oracle RAC DBA Demo session Weekend batch

Time: 7th June 2025 08:00 AM IST

Join Zoom Meeting :: will share on request those who are interested to join Oracle RAC DBA online training .

 

Course Content:

 

WhatsApp group:

https://chat.whatsapp.com/JTC9OhT5Aq1ETTuByC3MEr

 

Contact no:  +91 9392634440 ( whatsapp) , mail id :  racsinfotech@gmail.com

Registration Form :: https://docs.google.com/forms/d/1L8gWNTCP3WvOlklR62oag3XGXCPqd_CBjbDl2AtsK1s/viewform

  RacsinfoTech Website: https://racsinfotech.com/

 

RAC Course Contents:

1. Introduction to Oracle Custer ware / Cluster ware Architecture

>> Standalone Vs RAC

>> What is Oracle Cluster ware

>> Oracle Cluster ware Architecture and Cluster Services

>> RAC One Node Vs RAC database

>> Online Relocation

>> Networking in Cluster ware

>> Cluster ware services Start-up and shutdown Sequences

>> what are OCR and Voting disk

 

2. Linux Installation and Configuration step by step on Oracle VM.

>> Oracle Virtual box 7 version setup on windows.

>> Installation of Linux OS (7.x)

>> OS Post Installation checks and Tasks

>> Node1 VM to Node2 VM Clone .

 

3. Network Setting and Configuration setup.

>> Public IP, Private IP , VIP and Scan IP Configuration

>> DNS Server Configuration

>> VM Shared Disk Creation process

>> how to create ASM Disks using VM shared disk's.

 

4. Cluster Installation and Configuration steps.

>> Custer Pre-installation Tasks

   > System requirements Checks

   > Kernel parameters checks

   > Create required directory ,groups and users for grid & db install

   > Execute the ./runcluvfy from any one of the nodes using below command

     ex: ./runcluvfy.sh stage -pre crsinst -n racnode1,racnode2 -verbose)

>> ssh user password less /equivalence configuration on cluster nodes.

>> Start the Oracle Cluster Installation and Configuration steps using ./gridSetup.sh

>> Cluster Post Installation checks

ex:: ./cluvfy stage -post crsinst -n racnode1,racnode2 -verbose

 

5. Oracle RAC DB Installation and Configuration steps

>> Pre-installation tasks

   > System requirements Checks

   > Kernel parameters checks

   > Create required directory ,groups and users for db install

   > ssh user password less connection  setup / equivalence configuration

>> Installation and Configuration RAC DB.

>> RAC DB software Post Installation Tasks

 

6. Create Oracle ASM Disk groups >> +OCR,+DATA & +ARCH etc disk groups.

 

7. Oracle RAC Database Creation and Configuration

>> Pre-installation for Oracle RAC DB Configuration

./cluvfy stage -pre dbcfg -n racnode1,racnode2 -d Oracle_home -verbose

./cluvfy stage -pre dbinst -n node_list [-r {11gR1 | 11gR2 | 12cR1 | 12cR2}]  [-osdba osdba_group] [-d Oracle_home] [-fixup [-fixupdir fixup_dir] [-verbose]

 

>> Oracle RAC Database Creation and Configuration using dbca / command line using response file.

>> Post Installation Tasks for Oracle RAC DB Configuration

 

8. Oracle ASM Introduction & Architecture

>> Oracle ASM Storage Components.

>> what is Mirroring and Stripping in ASM.

>> what are the ASM instance parameters.

>> Oracle ASM Administration process / steps.

 

9. Oracle ASM Disk Groups Administering

>> How to Administering Oracle ASM Disk Groups.

>> How to Preform Adding Disk to Disk group and Dropping Disks from disk groups.

>> How to Preform Disk group Rebalance and Rebalance Power limit in ASM.

 

10. RAC Database Administration and Oracle Cluster ware Administration

 

##Oracle Cluster ware Administration

>> What are OCR and Voting Disks in Cluster.

>> What are the Cluster Resource and Services

>> What are crsctl vs srvctl utilities / tools.

>> How to Restarting Oracle Cluster ware and Services.

>> How to Restarting Oracle Cluster Databases.

>> How to Rebooting Cluster Nodes.

>> what is VIP, SCAN IP , Private and Public IP In RAC.

 

11. RAC Database Administration

>> Oracle RAC specific parameters In Init/spfile.

>> Difference between pfile and spfile in RAC database

>> Use of password file for RAC database

>> How to manage the Redo Log Files and Control file.

>> UNDO & TEMP Tablespaces use cases.

 

12. Backup and Recovery in Oracle RAC Database

>> Backup strategy Understanding in RAC.

>> Types of Backups in RAC.

>> Recoveries scenarios in RAC.

 

13. Networking setup in RAC ( Listeners in Cluster ware / Local )

>> Grid / ASM Listeners.

>> Remote / SCAN Listeners (Remote Listeners).

>> Local Database Listeners (Local Listeners).

 

14. RAC Database Multitenant Architecture vs Non Multitenant Architecture

>> Oracle Multitenant Architecture In-detail.

>> what are CDB and PDB databases.

>> How to Install the Pluggable database(PDB).

>> How to Clone Pluggable Database(PDB).

 

15. ASM Cluster Filesystem (ACFS) Configuration and Administration

>> How to Configure ACFS in Linux.

>> How to Administering & Managing ACFS.

 

16. Patching Oracle RAC and RAC Databases

>> What are the OPatch Vs opatchauto utilities.

>> How to Patch Oracle Cluster ware.

>> How to Patch RAC Oracle Home.

>> How to Patch RAC Databases.

>> what is Datapatch.

 

17. Oracle Cluster/Grid and Database Upgradation from lower version to Higher

>> Pre-Upgrade steps.

>> How many ways we can perform db and grid  upgrade.

>> Post-upgrade steps.

 

18. How to perform Node Addition and Deletion in RAC

>> Pre-requisites for node addition.

>> Node addition steps

>> post node addition steps.

>> Pre-requisites for node deletion.

>> Node deletion steps

>> post node deletion steps.

 

19. How to Convert the Single Instance to RAC using DBCA / OEM / RCONFIG etc.

 

**20. Interview Preparation Tips and Mock Interviews to crack Realtime Interviews.

**21. Resume / CV Preparation Tips and suggestions.


Thanks,

Srini

How to Start and Stop Oracle 13C OEM services including OEM database Serivces

 Hi All,

In this post i am going to share how to start and stop the Oracle OEM 13C services manually .


Database version : 19.27.0.0 

OEM version : 13.5C

OEL Version  : 7


Manual Method to stop OEM services :

Stop MS :

  - export OMS_HOME=/u01/app/oracle/middleware

  - /u01/app/oracle/middleware/bin/emctl stop oms -all

 


Stop Agent :

 -   export AGENT_HOME=/u01/app/oracle/agent/agent_inst

  - /u01/app/oracle/agent/agent_inst/bin/emctl stop agent

 


Stop database : 

 - sqlplus / as sysdba > shut immediate;

 - stop listener :: lsnrctl stop OEMDB



Manual Method to start OEM services :

Start Database : 

 - sqlplus / as sysdba > startup;




 - start listener :: lsnrctl start OEMDB




Start MS :

  - export OMS_HOME=/u01/app/oracle/middleware

  - /u01/app/oracle/middleware/bin/emctl start oms






Start Agent :

   - /u01/app/oracle/agent/agent_inst/bin/emctl start agent




>>> check in detailed OMS status

$OMS_HOME/bin/emctl status oms -details



>>> check repository details

$OMS_HOME/bin/emctl config oms -list_repos_details



>>>  get list of targets monitored by agent

$AGENT_HOME/bin/emctl config agent listtargets




Thanks,

Srini



Tuesday, 6 May 2025

How to Apply APR-2025 RU patches in Oracle 19C Database step by step

 Dear All,

In this post i am sharing you Apply Apr-2025 RU patch step by step on Oracle 19C Database .

Apr-2025 RU patch Number :  

Patch 37641958: GI RELEASE UPDATE 19.27.0.0.0

 




Click on download patch option and read the readme file to check pre and post checks .

readme file : 

https://updates.oracle.com/Orion/Services/download?type=readme&aru=27123474

click on download patch :







Note : 
  • Document 19202504.9 Oracle Database 19c RU/RUR Apr 2025 Known Issues

After this download the latest opatch version - 6880880



copy the both opatch - patch 6880880 and Apr-2025 patch to database server and unzip it.



opatch readme file : https://updates.oracle.com/Orion/Services/download?type=readme&aru=27122750

>> First upgrade the opatch version .



After opatch upgrade : 






Download and unzip main patch on your database server 

[root@oemdb RU_19_27-GI]# unzip p37641958_190000_Linux-x86-64.zip -d /u01/software/



check inventory good :



check patch conflicts 





check invalids , take db full backup , take oracle home and customizations if anything backup before apply the main patches ..


SQL> select count(*) from dba_objects where status='INVALID';

  COUNT(*)
----------
         0

SQL> select name,open_mode from v$database;

NAME      OPEN_MODE
--------- --------------------
OEMDB     READ WRITE




Stop the database listener and database services 



export path ... 



Go to the patch location and apply the patch

Main APR-2025 RU patch ::

 $opatch apply 







apply second patch >> OCW patch 





Start up database and listener services 



Check the latest patch level ... 



Run datapatch verbose 



[oracle@oemdb OPatch]$ ./datapatch -verbose
SQL Patching tool version 19.27.0.0.0 Production on Wed May  7 01:47:58 2025
Copyright (c) 2012, 2025, Oracle.  All rights reserved.

Log file for this invocation: /u01/app/oracle/cfgtoollogs/sqlpatch/sqlpatch_17547_2025_05_07_01_47_58/sqlpatch_invocation.log

Connecting to database...OK
Gathering database info...done
Bootstrapping registry and package to current versions...done
Determining current state...done

Current state of interim SQL patches:
  No interim patches found

Current state of release update SQL patches:
  Binary registry:
    19.27.0.0.0 Release_Update 250406131139: Installed
  SQL registry:
    Applied 19.3.0.0.0 Release_Update 190410122720 successfully on 07-MAY-25 12.43.26.306463 AM

Adding patches to installation queue and performing prereq checks...done
Installation queue:
  No interim patches need to be rolled back
  Patch 37642901 (Database Release Update : 19.27.0.0.250415 (37642901)):
    Apply from 19.3.0.0.0 Release_Update 190410122720 to 19.27.0.0.0 Release_Update 250406131139
  No interim patches need to be applied

Installing patches...
Patch installation complete.  Total patches installed: 1

Validating logfiles...done
Patch 37642901 apply: SUCCESS
  logfile: /u01/app/oracle/cfgtoollogs/sqlpatch/37642901/27123174/37642901_apply_OEMDB_2025May07_01_49_39.log (no errors)
SQL Patching tool complete on Wed May  7 02:04:35 2025
[oracle@oemdb OPatch]$




Thanks,
Srini