Oracle

Oracle RAC DBA Online Training

Oracle RAC DBA Online Training:

Oracle RAC DBA experts at Cheyat Technologies leverage their extensive experience to offer ORACLE RAC DBA Online Training to students and working professionals. These experts have designed the course structure adhering to the standards of IT industry. After completion of ORACLE RAC DBA Online Training, candidates will be able to perform roles as a RAC DBA by formulating strategies to design and develop databases, monitor and maintain them without any security issues. We will provide Placement assistance also. 

Along with Oracle RAC DBA Online Training, We undertake On job Supports also. 

Oracle RAC DBA Online Training Course Content : 

     1. Infrastructure setup

  • Installation of Virtual workstation
  • Installation of Open Filer
  • Configuration of Open Filer
  • Physical volumes
  • Logical volumes
  • Network permission
  • Luns
  • IQN Publish
  • Installation of OEL Operating system
  • OEL Oracle Enterprise Linux
  • Disk Druid configuration
  • Manual partitions
  • Assigning  static ip to Ethernet
  • Time zone selection
  • Root user password configuration
  • Packages selection
  • Post installation configuration
  • Login to the OS
  • Installing Virtual tools
  • Sharing of Folders from host OS to virtual OS
  • Cloning of OS in virtual workstatioStart and Shut of OS

     2.   Pre requisite

  • IP addressing design to RAC environment
  • ping testing connectivity
  • Adding luns from  OS to san box
  • configuring iscsi
  • Mac address generation in virtual box
  • configure ethernet static
  • configure default gateway
  • Resolve  host to ip
  • restarting service
  • Installing RPMS on OS
  • Creating partition on san box
  • OCR,VD and Data partition
  • Execute part probe
  • Conversion of block to raw
  • Permission on raw
  • creation of groups
  • creation of user
  • password setting
  • configure Trust relationship between nodes
  • Time synchronization
  • Verify run cluvfy

    3.  Installing cluster ware

  • unzip the cluster ware
  • Execute run Installer
  • Installing all the nodes at same time
  • selection of VD partition
  • selection of OCR Partition
  • Execute scripts on all nodes
  • verify crsctl crs

     4.  Installing ASM Binaries

  • unzip the binaries
  • configure Kernel parameter
  • Execute run Installer
  • Installing all the nodes at same time
  • configure ASM home location
  • Execute scripts on all nodes
  • verify ASM home location

    5.  Installing RDBMS Binaries

  • unzip the binaries
  • configure Kernel parameter
  • Execute run Installer
  • Installing all the nodes at same time
  • configure RDBMS home location
  • Execute scripts on all nodes
  • verify RDBMS home location

    6.  Environment file

  • Configure cluster ware environment
  • configure ASM environment
  • configure RDBMS environment
  • Verify environment

    7.  Listener

  • Login to RDBMS environment
  • Execute netca tool
  • Listener configuration on all nodes
  • Verify Listener service

    8.  ASM instance and Disk group

  • Login to ASM environment
  • Configure ASM instance
  • DBCA
  • Configure disk group
  • Verify ASM service
  • Verify ASM disk group

    9.  RDBMS instance and Database

  • Login to RDBMS environment
  • Configure Database
  • DBCA tool
  • Assign db name
  • Select disk group to create db
  • Verify database and instance service

    10.  RAC  Services

  • View RAC services
  • Learn how to stop and start services
  • Srvctl stop database service
  • Srvctl stop instance service
  • Srvctl stop ASM service
  • Srvctl stop listener service
  • Srvctl stop nodeapps service
  • Srvctl start nodeapps service
  • Srvctl start listener service
  • Srvctl start ASM service
  • Srvctl start instance service
  • Srvctl start database service
  • Crs stop all service
  • crs start all service

   11.  Adding a New node to RAC

  • Add new node network access in san box
  • Os preparation
  • Ip addressing design to new node
  • ping testing connectivity
  • Adding luns from  OS to san box
  • configuring iscsi
  • Mac address generation in virtual box
  • configure ethernet static
  • configure default gateway
  • Resolve  host to ip
  • restarting service
  • Installing RPMS on OS
  • Execute part probe
  • Conversion of block to raw
  • Permission on raw
  • creation of groups
  • creation of user
  • password setting
  • configure Trust relationship between  existing RAC nodes
  • Time synchronization
  • Installing and Add cluster ware to existing RAC
  • Installing and Add ASM to existing RAC
  • Installing and Add RDBMS to existing RAC
  • Environment file configure
  • Listener configuration
  • Add RDBMS instance to existing database
  • Verify new node services

   12.  Removing a existing node from RAC

  • Stop and Remove RDBMS instance
  • stop and remove ASM instance
  • stop and remove listener
  • stop and remove nodeapps
  • delete ora Inventory
  • update global inventory
  • uninstall RDBMS binary
  • Uninstall ASM binary
  • Remove crs daemon
  • Uninstall Clusterware
  • Verify

  13.  Load Balancing

  • Server load balancing
  • Preference configuration
  • dbca configuration
  • Manual configuration
  • Adding and Deleting
  • Client Load balancing
  • configure tns
  • Edit Tns names
  • Verify client load balance

  14.  Cloning

  • RMAN Cloning
  • Enable archive mode in RAC
  • Configure FRA
  • Perform RMAN Backup
  • configure tns
  • configure directory structure
  • create parameter file
  • create password file
  • start instance in nomount
  • connect by RMAN
  • Perform duplicate database
  • verify the clone database

   15.  Patches

  • Patch set
  • unzip patch set
  • Apply patch set for crs
  • verify crs version
  • stop relevant services
  • Apply patch set for ASM
  • Apply patch set for RDBMS
  • start relevant services
  • Execute scripts
  • Verify the version
  • OPATCH
  • Stop relevant services
  • unzip opatch
  • Apply opatch
  • verify optach

 

Demo Video: