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