Oracle RAC Online Training Course Content

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 workstation
  • Start and Shut of OS
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
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
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
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
Environment file :

  • Configure cluster ware environment
  • configure ASM environment
  • configure RDBMS environment
  • Verify environment
Listener :
  • Login to RDBMS environment
  • Execute netca tool
  • Listener configuration on all nodes
  • Verify Listener service
ASM instance and Disk group:

  • Login to ASM environment
  • Configure ASM instance
  • DBCA
  • Configure disk group
  • Verify ASM service
  • Verify ASM disk group
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
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


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
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
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
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
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