Oracle

Oracle RAC DBA Online Training

Oracle RAC DBA Online Training:

Demo Video:

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