Build oracle11g RAC 64 cluster environment based on CentOS and VMWARESTATION10:3. Installing Oracle RAC-3.6. Cluster Management commands

3.6. Cluster Management Command 3.6.1. Startup and shutdown of RAC

Oracle RAC is powered on by default and can be used with the following commands if maintenance is required:

Shut down: crsctl Stop cluster Stopping this node Cluster service crsctl Stop Cluster–all all node services Open: crsctl start cluster turn on this node Cluster service crsctl Stop Cluster–all turn on all node services Note: The above command needs to be executed as root user

3.6.2.RAC Check Health

Run as a grid user

[Email protected] ~]$ crsctl Check cluster Crs-4537:cluster Ready Services are online Crs-4529:cluster Synchronization Services is online Crs-4533:event Manager is online

3.6.3. Disable database startup, stop database

Run as a grid user:prod the global service name defined for the installation

[Email protected] ~]$ srvctl disable database-d prod [Email protected] ~]$ srvctl stop database-d prod

3.6.4. Prohibit listner from starting, stop all nodes listener

Run as a grid user

[Email protected] ~]$ srvctl Disable Listener [Email protected] ~]$ srvctl Stop Listener

3.6.5.Database Check Case Status

Run as a grid user

[Email protected] ~]$ srvctl status database-d prod Instance Prod1 is running on node LINUXRAC1 Instance prod2 is running on node LINUXRAC2

3.6.6. Checking node application status and configuration

Run as Oracle user

[Email protected] ~]$ srvctl status Nodeapps VIP LINUXRAC1-VIP is enabled VIP Linuxrac1-vip is running on NODE:LINUXRAC1 VIP LINUXRAC2-VIP is enabled VIP Linuxrac2-vip is running on NODE:LINUXRAC2 Network is enabled Network is running on NODE:LINUXRAC1 Network is running on NODE:LINUXRAC2 GSD is disabled GSD isn't running on NODE:LINUXRAC1 GSD isn't running on NODE:LINUXRAC2 ONS is enabled ONS Daemon is running on NODE:LINUXRAC1 ONS Daemon is running on NODE:LINUXRAC2 EONS is enabled EONS Daemon is running on NODE:LINUXRAC1 EONS Daemon is running on NODE:LINUXRAC2 [Email protected] ~]$ srvctl config nodeapps-a-g-s-l -l option has been deprecated and would be ignored. VIP EXISTS.:LINUXRAC1 VIP exists.:/linuxrac1-vip/10.10.97.181/255.255.255.0/eth0 VIP EXISTS.:LINUXRAC2 VIP exists.:/linuxrac2-vip/10.10.97.183/255.255.255.0/eth0 GSD exists. ONS Daemon exists. Local Port 6100, remote port 6200 Name:listener Network:1, Owner:grid Home: <crs home> /u01/app/11.2.0/grid on node (s) linuxrac2,linuxrac1 End points:tcp:1521

3.6.7. Viewing the database configuration

Run as Oracle user

[[email protected] ~]$ srvctl config database-d prod -A Database Unique Name:prod Database Name:prod Oracle Home:/u01/app/oracle/product/11.2.0/db_1 Oracle user:oracle Spfile: +data/prod/spfileprod.ora Domain: Start Options:open Stop options:immediate Database role:primary Management policy:automatic Server Pools:prod Database INSTANCES:PROD1,PROD2 Disk Groups:data,fra Services: Database is enabled Database is administrator managed

3.6.8. Checking ASM Status and configuration

Run as Oracle user

[Email protected] ~]$ srvctl status asm ASM is running on LINUXRAC1,LINUXRAC2 [Email protected] ~]$ srvctl config asm-a ASM Home:/u01/app/11.2.0/grid ASM Listener:listener ASM is enabled.

3.6.9. Checking the status and configuration of TNS

[[email protected] ~]$ srvctl status listener listener Listener is enabled listener Listener was running on node (s): Linuxrac1,linuxrac2 [[email protected] ~]$ srvctl config listener-a name:listener network:1, Owner:grid  /u01/app/11.2.0/grid on node (s) linuxrac2,linuxrac1 end points:tcp:1521

3.6.10. Checking the status and configuration of the SCAN

run

[[email protected] ~]$ scan VIP scan1 was enabled scan VIP Scan1 is running on node Linuxrac1 [email  protected] ~]$ srvctl config scan < Span style= "FONT-SIZE:14PX;" >scan Name:linuxrac-scan, Network:1/10.10.97.0/255.255.255.0/eth0 scan VIP name:scan1, IP:/linuxrac-scan/10.10.97.193

3.6.11. Checking the status and configuration of VIPs

Run as Oracle user

[Email protected] ~]$ srvctl status vip-n linuxrac1 VIP LINUXRAC1-VIP is enabled VIP Linuxrac1-vip is running on NODE:LINUXRAC1 [Email protected] ~]$ srvctl status vip-n linuxrac2 VIP LINUXRAC2-VIP is enabled VIP Linuxrac2-vip is running on NODE:LINUXRAC2 [Email protected] ~]$ srvctl config vip-n linuxrac1 VIP EXISTS.:LINUXRAC1 VIP exists.:/linuxrac1-vip/10.10.97.181/255.255.255.0/eth0 [Email protected] ~]$ srvctl config vip-n linuxrac2 VIP EXISTS.:LINUXRAC2 VIP exists.:/linuxrac2-vip/10.10.97.183/255.255.255.0/eth0

Build oracle11g RAC 64 cluster environment based on CentOS and VmwareStation10 all links:

Build oracle11g RAC 64 cluster environment based on CentOS and VMWARESTATION10:1. Resource preparation
Http://www.cnblogs.com/HondaHsu/p/4046352.html

Build oracle11g RAC 64 cluster environment based on CentOS and VMWARESTATION10:2. Build the environment-2.1 Create a virtual machine
Http://www.cnblogs.com/HondaHsu/p/4046378.html

Build oracle11g RAC 64 cluster environment based on CentOS and VMWARESTATION10:2. Build the environment-2.2 Install the operating system CentOS5.4
Http://www.cnblogs.com/HondaHsu/p/4046384.html

Build oracle11g RAC 64 cluster environment based on CentOS and VMWARESTATION10:2. Build environment-2.3 Configure shared disks
Http://www.cnblogs.com/HondaHsu/p/4046389.html

Build oracle11g RAC 64 cluster environment based on CentOS and VMWARESTATION10:2. Build environment-2.4. Installing the JDK
Http://www.cnblogs.com/HondaHsu/p/4046430.html

Build oracle11g RAC 64 cluster environment based on CentOS and VMWARESTATION10:2. Build environment-2.5. Configure the Network
Http://www.cnblogs.com/HondaHsu/p/4046443.html

Build oracle11g RAC 64 cluster environment based on CentOS and VMWARESTATION10:2. Build environment-2.6. Install the necessary packages that Oracle relies on
Http://www.cnblogs.com/HondaHsu/p/4054216.html

Build oracle11g RAC 64 cluster environment based on CentOS and VMWARESTATION10:2. Build environment-2.7. Configuring Resources and Parameters
Http://www.cnblogs.com/HondaHsu/p/4054238.html

Build oracle11g RAC 64 cluster environment based on CentOS and VMWARESTATION10:2. Build environment-2.8. Configuring the User Environment
Http://www.cnblogs.com/HondaHsu/p/4054259.html

Build oracle11g RAC 64 cluster environment based on CentOS and VMWARESTATION10:2. Build Environment-2.9. Configure user equivalence (optional)
Http://www.cnblogs.com/HondaHsu/p/4054277.html

Build oracle11g RAC 64 cluster environment based on CentOS and VMWARESTATION10:2. Build the environment-2.10. Configure User ntf Services
Http://www.cnblogs.com/HondaHsu/p/4054333.html

Build oracle11g RAC 64 cluster environment based on CentOS and VMWARESTATION10:3. Install Oracle RAC-3.1. Install and configure ASM drivers
Http://www.cnblogs.com/HondaHsu/p/4054367.html

Build oracle11g RAC 64 cluster environment based on CentOS and VMWARESTATION10:3. Install the Oracle RAC-3.2. Install the Cvuqdisk package
Http://www.cnblogs.com/HondaHsu/p/4054395.html

Build oracle11g RAC 64 cluster environment based on CentOS and VMWARESTATION10:3. Install Oracle RAC-3.3. Pre-installation Check
Http://www.cnblogs.com/HondaHsu/p/4054481.html

Build oracle11g RAC 64 cluster environment based on CentOS and VMWARESTATION10:3. Install the Oracle RAC-3.4. Install the grid Infrastructure
Http://www.cnblogs.com/HondaHsu/p/4054518.html

Build oracle11g RAC 64 cluster environment based on CentOS and VMWARESTATION10:3. Install Oracle RAC-3.5. Install ORACLE11GR2 database software and create databases
Http://www.cnblogs.com/HondaHsu/p/4054586.html

Build oracle11g RAC 64 cluster environment based on CentOS and VMWARESTATION10:3. Installing Oracle RAC-3.6. Cluster Management commands
Http://www.cnblogs.com/HondaHsu/p/4054635.html

Build oracle11g RAC 64 cluster environment based on CentOS and VMWARESTATION10:3. Installing Oracle RAC-3.6. Cluster Management commands