Oracle Rac Tutorial

ORACLE RAC Online Training Course Overview :
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 OSPre requisite: ORACLE RAC Online Training

 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: ORACLE RAC Tutorial

 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

Up gradation

 upgrade cluster ware
 upgrade ASM binary
 Upgrade RDBMS binary
 Execute upgrade scripts
 Verify new version

More about

Oracle RAC tutorial