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