下载文档原格式
Oracle11g RAC环境下public IP、VIP、scan-IP、private IP的修改方法一、修改方法1.环境操作系统版本：AIX 6.1Oracle版本：11.2.0.3修改前IP配置：192.168.101.61 host1192.168.101.62 host210.10.11.61 host1-priv10.10.11.62 host2-priv192.168.101.63 host1-vip192.168.101.64 host2-vip192.168.101.65 host-scan修改前网卡配置：en0:192.168.101.61en1:10.10.11.61修改后IP配置：192.168.102.61 host1192.168.102.62 host210.10.12.61 host1-priv10.10.12.62 host2-priv192.168.102.63 host1-vip192.168.102.64 host2-vip192.168.102.65 host-scan修改前网卡配置：en0:192.168.102.61en1:10.10.12.612.停止CRS相关资源的自启动2.1停止监听资源srvctl disable listenersrvctl stop listener2.2停止数据库资源srvctl disable database -d yxdbsrvctl stop database -d yxdb -o immediate2.3停止VIP资源srvctl disable vip -ihost1-vipsrvctl stop vip -n host1srvctl disable vip -ihost2-vipsrvctl stop vip -n host22.4停止scan_listener资源srvctl disable scan_listenersrvctl stop scan_listener2.5停止scan资源srvctl disable scansrvctl stop scan2.6停止crs服务（两个节点都要执行）crsctl stop crs3.修改Public IP、VIP、Scan IP、Private IP3.1修改Public IP网卡地址参考命令：smittcpip-> Minimum Configuration & Startup->en0备注：此处只修改Public IP的网卡配置，不修改Private IP的网卡配置，否则CRS 服务将无法启动。
最详细的oracle rac日常基本维护命令以下是一些使用Oracle RAC进行日常基本维护的常用命令：1. CRSCTL命令：- crsctl check crs：检查集群资源状态。
- crsctl start crs：启动整个集群资源服务。
- crsctl stop crs：停止整个集群资源服务。
- crsctl disable crs：禁用整个集群资源服务。
- crsctl enable crs：启用整个集群资源服务。
2. SRVCTL命令：- srvctl start instance -db <database_name> -instance<instance_name>：启动指定的实例。
- srvctl stop instance -db <database_name> -instance<instance_name>：停止指定的实例。
- srvctl status instance -db <database_name> -instance<instance_name>：检查指定实例的状态。
- srvctl start service -db <database_name> -service <service_name>：启动指定的服务。
- srvctl stop service -db <database_name> -service <service_name>：停止指定的服务。
- srvctl status service -db <database_name> -service<service_name>：检查指定服务的状态。
3. SQL*Plus命令：- sqlplus / as sysdba：以SYS用户身份登录数据库。
- startup：启动数据库实例。
Oracle常⽤命令⼤全（很有⽤，做笔记）⼀、ORACLE的启动和关闭1、在单机环境下要想启动或关闭ORACLE系统必须⾸先切换到ORACLE⽤户，如下su - oraclea、启动ORACLE系统oracle>svrmgrlSVRMGR>connect internalSVRMGR>startupSVRMGR>quitb、关闭ORACLE系统oracle>svrmgrlSVRMGR>connect internalSVRMGR>shutdownSVRMGR>quit启动oracle9i数据库命令：$ sqlplus /nologSQL*Plus: Release 9.2.0.1.0 - Production on Fri Oct 31 13:53:53 2003Copyright (c) 1982, 2002, Oracle Corporation. All rights reserved.SQL> connect / as sysdbaConnected to an idle instance.SQL> startup^CSQL> startupORACLE instance started.2、在双机环境下要想启动或关闭ORACLE系统必须⾸先切换到root⽤户，如下su － roota、启动ORACLE系统hareg －y oracleb、关闭ORACLE系统hareg －n oracleOracle数据库有哪⼏种启动⽅式说明：有以下⼏种启动⽅式：1、startup nomount⾮安装启动，这种⽅式启动下可执⾏：重建控制⽂件、重建数据库读取init.ora⽂件，启动instance，即启动SGA和后台进程，这种启动只需要init.ora⽂件。
2、startup mount dbname安装启动，这种⽅式启动下可执⾏：数据库⽇志归档、数据库介质恢复、使数据⽂件联机或脱机，重新定位数据⽂件、重做⽇志⽂件。
oracle11gRAC启动和停止操作说明（ORACLE）查看集群中的数据库运行状态，最后接着是RAC名，不是实例的名称。
srvctl status database -d taxoracle@svrtrpc001:~> srvctl status database -d taxInstance tax1 is running on node svrtrpc001Instance tax2 is running on node svrtrpc002Instance tax3 is running on node svrtrpc003-----------------------------------------------------(ORACLE)查看数据库的运行状态，最后接着是RAC名，不是实例的名称。
srvctl status database -d tax -voracle@svrtrpc001:~> srvctl status database -d tax -vInstance tax1 is running on node svrtrpc001. Instance status: Open.Instance tax2 is running on node svrtrpc002. Instance status: Open.Instance tax3 is running on node svrtrpc003. Instance status: Open.-----------------------------------------(ORACLE)查看实例运行状态，最后接着节点名srvctl status instance -d tax -i tax1oracle@svrtrpc001:~> srvctl status instance -d tax -i tax1Instance tax1 is running on node svrtrpc001---------------------------------------------------（ORACLE）查看集群的配置情况srvctl config -p tax -n taxoracle@svrtrpc001:~> srvctl config -p tax -n taxDatabase unique name: taxDatabase name: taxOracle home: /u01/app/oracle/product/11.2.0Oracle user: oracleSpfile: +DATADG/tax/spfiletax.oraDomain:Start options: openStop options: immediateDatabase role: PRIMARYManagement policy: AUTOMATICServer pools: taxDatabase instances: tax1,tax2,tax3Disk Groups: DATADGMount point paths:Services:Type: RACDatabase is administrator managed-----------------------------------------------启动2.3 srvctl startI think maybe it's one of the most frequently used commands as well as 'srvctl stop'.Available options: database|instance|service|nodeapps|asm# Start databasesrvctl start database -d orcl -o nomountsrvctl start database -d orcl -o mountsrvctl start database -d orcl -o open# Grammar for start instancesrvctl start instance -d [db_name] -i [instance_name]-o [start_option] -c [connect_str] -q# Start all instances on the all nodessrvctl start instance -d orcl -i orcl1,orcl2,...# Start ASM instancesrvctl start ASM -n [node_name] -i asm1 -o open# Start all apps in one nodesrvctl start nodeapps -n [node_name]# New: srvctl can manage listener's startup in DB 10.2srvctl start listener -n-------------------------------------------------关闭2.4 srvctl stopI think maybe it's also one of the most frequently used commands as well as 'srvctl start'.Available options: database|instance|service|nodeapps|asm# Stop databasesrvctl stop database -d orcl -o normalsrvctl stop database -d orcl -o immediatesrvctl stop database -d orcl -o abort# Grammar for start instancesrvctl stop instance -d [db_name] -i [instance_name]-o [start_option] -c--------------------------1、检查集群状态：[grid@rac02 ~]$ crsctl check clusterCRS-4537: Cluster Ready Services is onlineCRS-4529: Cluster Synchronization Services is online CRS-4533: Event Manager is online2、所有 Oracle 实例—（数据库状态）:[grid@rac02 ~]$ srvctl status database -d racdb Instance racdb1 is running on node rac01Instance racdb2 is running on node rac023、检查单个实例状态：[grid@rac02 ~]$ srvctl status instance -d racdb -i racdb1 Instance racdb1 is running on node rac014、节点应用程序状态：[grid@rac02 ~]$ srvctl status nodeappsVIP rac01-vip is enabledVIP rac01-vip is running on node: rac01VIP rac02-vip is enabledVIP rac02-vip is running on node: rac02Network is enabledNetwork is running on node: rac01Network is running on node: rac02GSD is disabledGSD is not running on node: rac01GSD is not running on node: rac02ONS is enabledONS daemon is running on node: rac01ONS daemon is running on node: rac02eONS is enabledeONS daemon is running on node: rac01eONS daemon is running on node: rac025、列出所有的配置数据库：[grid@rac02 ~]$ srvctl config databaseracdb6、数据库配置：[grid@rac02 ~]$ srvctl config database -d racdb -a Database unique name: racdbDatabase name: racdbOracle home: /u01/app/oracle/product/11.2.0/dbhome_1 Oracle user: oracleSpfile: +RACDB_DATA/racdb/spfileracdb.ora Domain: /doc/b02033077.html, Start options: openStop options: immediateDatabase role: PRIMARYManagement policy: AUTOMATICServer pools: racdbDatabase instances: racdb1,racdb2Disk Groups: RACDB_DATA,FRAServices:Database is enabledDatabase is administrator managed7、ASM状态以及ASM配置：[grid@rac02 ~]$ srvctl status asmASM is running on rac01,rac02[grid@rac02 ~]$ srvctl config asm -aASM home: /u01/app/11.2.0/gridASM listener: LISTENERASM is enabled.8、TNS监听器状态以及配置：[grid@rac02 ~]$ srvctl status listenerListener LISTENER is enabledListener LISTENER is running on node(s): rac01,rac02[grid@rac02 ~]$ srvctl config listener -aName: LISTENERNetwork: 1, Owner: gridHome:/u01/app/11.2.0/grid on node(s) rac02,rac01End points: TCP:15219、SCAN状态以及配置：[grid@rac02 ~]$ srvctl status scanSCAN VIP scan1 is enabledSCAN VIP scan1 is running on node rac02[grid@rac02 ~]$ srvctl config scanSCAN name: /doc/b02033077.html,, Network: 1/192.168.1.0/255.255.255.0/eth0SCAN VIP name: scan1, IP: //doc/b02033077.html,/192.168.1.5510、VIP各个节点的状态以及配置：[grid@rac02 ~]$ srvctl status vip -n rac01VIP rac01-vip is enabledVIP rac01-vip is running on node: rac01[grid@rac02 ~]$ srvctl status vip -n rac02VIP rac02-vip is enabledVIP rac02-vip is running on node: rac02[grid@rac02 ~]$ srvctl config vip -n rac01VIP exists.:rac01VIP exists.: /rac01-vip/192.168.1.53/255.255.255.0/eth0 [grid@rac02 ~]$ srvctl config vip -n rac02VIP exists.:rac02VIP exists.: /rac02-vip/192.168.1.54/255.255.255.0/eth011、节点应用程序配置—（VIP、GSD、ONS、监听器）[grid@rac02 ~]$ srvctl config nodeapps -a -g -s -l-l option has been deprecated and will be ignored. VIP exists.:rac01VIP exists.: /rac01-vip/192.168.1.53/255.255.255.0/eth0 VIP exists.:rac02VIP exists.: /rac02-vip/192.168.1.54/255.255.255.0/eth0 GSD exists.ONS daemon exists. Local port 6100, remote port 6200 Name: LISTENERNetwork: 1, Owner: gridHome:/u01/app/11.2.0/grid on node(s) rac02,rac01End points: TCP:152112、验证所有集群节点间的时钟同步:[grid@rac02 ~]$ cluvfy comp clocksync -verboseVerifying Clock Synchronization across the cluster nodesChecking if Clusterware is installed on all nodes...Check of Clusterware install passedChecking if CTSS Resource is running on all nodes...Check: CTSS Resource running on all nodesNode Name Status------------------------------------ ------------------------rac02 passedResult: CTSS resource check passedQuerying CTSS for time offset on all nodes...Result: Query of CTSS for time offset passedCheck CTSS state started...Check: CTSS stateNode Name State------------------------------------ ------------------------rac02 ActiveCTSS is in Active state. Proceeding with check of clock time offsets on all nodes...Reference Time Offset Limit: 1000.0 msecsCheck: Reference Time OffsetNode Name Time Offset Status------------ ------------------------ ------------------------rac02 0.0 passedTime offset is within the specified limits on the following set of nodes:"[rac02]"Result: Check of clock time offsets passedOracle Cluster Time Synchronization Services check passed Verification of Clock Synchronization across the clusternodes was successful.13、集群中所有正在运行的实例— (SQL):SELECT inst_id , instance_number inst_no , instance_name inst_name , parallel , status , database_status db_status , active_state state , host_name host FROM gv$instance ORDER BY inst_id;14、所有数据库文件及它们所在的 ASM 磁盘组— (SQL):15、ASM 磁盘卷:16、启动和停止集群：以下操作需用root用户执行。
rac 常用命令在Linux系统中，`rac`（也可以称为RAC）是一个常用的命令。
`rac`命令是Red Hat Cluster Suite（RHEL集群套件）的一部分，是用于设置和管理高可用性集群的工具。
它提供了许多功能和选项，可以帮助系统管理员轻松管理集群环境。
本文将详细介绍`rac`命令的常用功能和用法。
1. 查看集群状态`rac status`命令可以显示当前集群的状态信息。
它将显示集群中每个节点的状态，包括节点的健康状况、状态、软件版本以及集群服务的运行状态等。
这对于诊断集群故障以及监控集群运行状态非常有用。
可以通过以下命令来查看集群状态：```rac status```2. 启动和停止集群服务使用`rac`命令可以方便地启动和停止集群中的服务。
例如，可以使用以下命令来启动集群服务：```rac service start```同样，可以使用以下命令来停止集群服务：```rac service stop```通过这些命令，可以在需要时方便地启动和停止集群服务，以满足系统管理员的要求。
3. 创建和删除资源组资源组是集群中的一个重要概念，它代表着一组相关的服务或应用程序。
使用`rac`命令可以创建和删除资源组。
以下是创建资源组的命令示例：```rac group create [group_name]```在上述命令中，`[group_name]`表示要创建的资源组的名称。
类似地，可以使用以下命令删除资源组：```rac group delete [group_name]```使用这些命令，系统管理员可以轻松地管理集群中的资源组。
4. 移动资源组通过`rac`命令，可以将资源组从一个节点移动到另一个节点。
这对于负载均衡和高可用性至关重要。
以下是将资源组从一个节点移动到另一个节点的命令示例：```rac group move [group_name] [destination_node]```在上述命令中，`[group_name]`表示要移动的资源组的名称，`[destination_node]`表示要移动到的目标节点。
一．Window下关闭Oracle 11g正常在Windows下安全关闭Oracle数据库系统的步骤如下：1.从命令行下找到oracle的BIN目录，然后输入isqlplusctl stop命令停止isqlplus进程。
2.同样在BIN目录下，emctl stop dbconsole停止企业管理器的控制台进程。
3.同样在BIN目录下，lsnrctl stop停止监听进程。
4.在命令行下输入sqlplus /nolog , 然后conn / as sysdba连接到数据库shutdown immediate;====================================================================== select username,password from dba_users; --查看用户信息select username,account_status from dba_users; --查看用户是否解锁alter user scott account unlock; --解锁scott用户alter user scott account lock;--锁scott用户alter user scott identified by tiger; --为scott用户修改密码为tiger创建用户以及给表赋予权限：创建用户create user user_name identified by password;grant dba to user_name；查询表的权限grant select on gecs_law to user_name;select file_name from dba_data_files; --查看数据文件路径select name from v$controlfile; --查看控制文件路径select member from v$logfile; --查看日志文件路径====================================================================== Oracle关于shutdown、startup几个参数：shutdown有四个参数：normal、transactional、immediate、abort。
ORACLERAC日常管理概述一、Oracle RAC简介：Oracle RAC 支持Oracle 数据库在集群上运行真正的应用程序。
此处的真正应用是指RAC 能够支持所有类型的主流商业应用程序。
这包含流行的封装产品，如SAP、PeopleSoft 与Oracle E*Business Suite 等，与自主研发的应用程序，其中包含OLTP 与DSS，与Oracle 有效支持混合OLTP/DSS 环境的独有能力。
Oracle 是唯一提供具备这一功能的开放系统数据库的厂商。
Oracle RAC 运行于集群之上，为Oracle 数据库提供了最高级别的可用性、可伸缩性与低成本计算能力。
假如集群内的一个节点发生故障，Oracle 将能够继续在其余的节点上运行。
假如需要更高的处理能力，新的节点可轻松添加至集群。
为了保持低成本，即使最高端的系统也能够从使用标准化商用组件的小型低成本集群开始逐步构建而成。
Oracle 的要紧创新是一项称之高速缓存合并的技术，它最初是针对Oracle9i 真正应用集群开发的。
高速缓存合并使得集群中的节点能够通过高速集群互联高效地同步其内存高速缓存，从而最大限度地低降低磁盘I/O。
高速缓存最重要的优势在于它能够使集群中所有节点的磁盘共享对所有数据的访问。
数据无需在节点间进行分区。
Oracle 是唯一提供具备这一能力的开放系统数据库的厂商。
其它声称能够运行在集群上的数据库软件需要对数据库数据进行分区。
这关于拥有复杂的数据结构的真正应用程序而言，显得不切实际。
而且也不可能对集群系统进行统一变更。
假如您添加或者删除节点或者存储资源，数据则需要完全重新分区。
二、ORACLE RAC工作原理在一个应用环境当中，所有的服务器使用与管理同一个数据库，目的是为了分散每一台服务器的工作量，硬件上至少需要两台以上的服务器，而且还需要一个共享存储设备。
同时还需要两类软件，一个是集群软件，另外一个就是Oracle数据库中的RAC组件。
RAC常见命令检查状态1.2.1 检查集群状态[grid@rac1 ~]$ crsctl check clusterCRS-4537: Cluster Ready Services is onlineCRS-4529: Cluster Synchronization Servicesis online CRS-4533: Event Manager is online1.2.2 所有Oracle实例（数据库状态）[grid@rac1 ~]$ srvctl status database -dsdd Instance sdd1 is running on node rac1Instance sdd2 is running on node rac21.2.3 检查单个实例状态[grid@rac1 ~]$ srvctl status instance -dsdd -i sdd1 Instance sdd1 is running on node rac1[grid@rac1 ~]$1.2.4节点应用程序状态[grid@rac1 ~]$ srvctl status nodeappsVIP rac1-vip is enabledVIP rac1-vip is running on node: rac1VIP rac2-vip is enabledVIP rac2-vip is running on node: rac2Network is enabledNetwork is running on node: rac1Network is running on node: rac2GSD is disabledGSD is not running on node: rac1GSD is not running on node: rac2ONS is enabledONS daemon is running on node: rac1ONS daemon is running on node: rac21.2.5 列出所有的配置数据库[grid@rac1 ~]$ srvctl config databasesdd1.2.6 数据库配置[grid@rac1 ~]$ srvctl config database -dsdd -a Database unique name: sddDatabase name: sddOracle home: /u01/app/oracle/11.2.0/db_1 Oracle user: oracleSpfile: +DATA/sdd/spfilesdd.oraDomain:Start options: openStop options: immediateDatabase role: PRIMARYManagement policy: AUTOMATICServer pools: sddDatabase instances: sdd1,sdd2Disk Groups: DATA,FRAMount point paths:Services:Type: RACDatabase is enabledDatabase is administrator managed1.2.7 ASM状态以及ASM配置[grid@rac1 ~]$ srvctl status asmASM is running on rac2,rac1[grid@rac1 ~]$ srvctl status asm -aASM is running on rac2,rac1ASM is enabled.1.2.8 TNS监听器状态以及配置[grid@rac1 ~]$ srvctl status listenerListener LISTENER is enabledListener LISTENER is running on node(s):rac2,rac1[grid@rac1 ~]$ srvctl config listener -aName: LISTENERNetwork: 1, Owner: gridHome:/u01/app/grid/11.2.0 on node(s) rac2,rac1End points: TCP:15211.2.9 SCAN状态以及配置[grid@rac1 ~]$ srvctl status scanSCAN VIP scan1 is enabledSCAN VIP scan1 is running on node rac1[grid@rac1 ~]$ srvctl config scanSCAN name: rac-scan, Network:1/192.168.16.0/255.255.255.0/eth0 SCAN VIP name: scan1, IP:/rac-scan/192.168.16.2071.2.10 VIP各个节点的状态以及配置[grid@rac1 ~]$ srvctl status vip -n rac1VIP rac1-vip is enabledVIP rac1-vip is running on node: rac1[grid@rac1 ~]$ srvctl status vip -n rac2VIP rac2-vip is enabledVIP rac2-vip is running on node: rac2[grid@rac1 ~]$ srvctl config vip -n rac1VIP exists: /rac1-vip/192.168.16.201/192.168.16.0/255.255.255.0/eth0,hosting node rac1[grid@rac1 ~]$ srvctl config vip -n rac2VIP exists:/rac2-vip/192.168.16.203/192.168.16.0/255.255.255.0/eth0, hosting node rac2 [grid@rac1 ~]$1.2.11 节点应用程序配置（VIP、GSD、ONS、监听器）[grid@rac1 ~]$ srvctl config nodeapps -a -g-s -lWarning:-l option has been deprecated andwill be ignored.Network exists:1/192.168.16.0/255.255.255.0/eth0, type staticVIP exists:/rac1-vip/192.168.16.201/192.168.16.0/255.255.255.0/eth0, hosting node rac1 VIP exists:/rac2-vip/192.168.16.203/192.168.16.0/255.255.255.0/eth0, hosting node rac2 GSD existsONS exists: Local port 6100, remote port6200, EM port 2016Name: LISTENERNetwork: 1, Owner: gridHome:/u01/app/grid/11.2.0 on node(s) rac2,rac1End points: TCP:15211.3 语法简汇1.3.1 数据库与实例srvctl config database # 列出安装的数据库srvctl config database -d rac -a # 检查数据库相关的信息srvctlstatus database -d RAC # 检查数据库的状态srvctl status instance -d RAC -i rac1 # 检查指定实例的状态srvctl config asm -a # ASM配置srvctl status asm # ASM的状态srvctl start database -d rac # 启动数据库srvctl stop database -d rac # 关闭数据库srvctl start instance -d rac -i rac1 # 启动指定的实例srvctl stop instance -d rac -i rac2 # 关闭指定实例1.3.2 网络相关的命令srvctl status listener # 检查TNS listener的状态srvctl config scan # SCAN的配置srvctl status scan # SCAN listener状态, 包含当前运行节点的信息# 检查VIP的配置及状态srvctl status vip -n rac1srvctl config vip -n rac11.3.3 查看各资源状态(nodeapps节点应用程序，ASM实例，数据库等)[root@db02 u01]# crs_stat -tName Type Target State Host------------------------------------------------------------ora.DATA.dg ora....up.type ONLINE ONLINE db02ora.FRA.dg ora....up.type ONLINE ONLINE db02ora....ER.lsnr ora....er.type ONLINE ONLINE db02ora....N1.lsnr ora....er.type ONLINE ONLINE db02ora....N2.lsnr ora....er.type ONLINE ONLINE db02ora....N3.lsnr ora....er.type ONLINE ONLINE db02ora.OCR.dg ora....up.type ONLINE ONLINE db02ora.asm ora.asm.type ONLINE ONLINE db02ora....-01.vip ora....t1.type ONLINE ONLINE db02ora....SM2.asm application ONLINE ONLINE db02ora....02.lsnr application ONLINE ONLINE db02ora....-02.gsd application OFFLINE OFFLINEora....-02.ons application ONLINE ONLINE db02ora....-02.vip ora....t1.type ONLINE ONLINE db02ora.cvu ora.cvu.type ONLINE ONLINE db02ora.gsd ora.gsd.type OFFLINE OFFLINEwork ora....rk.type ONLINE ONLINE db02ora.oc4j ora.oc4j.type ONLINE ONLINE db02ora.ons ora.ons.type ONLINE ONLINE db02ora.orcl.db ora....se.type ONLINE ONLINE db02ora....taf.svc ora....ce.type ONLINE ONLINE db02ora.scan1.vip ora....ip.type ONLINE ONLINE db02ora.scan2.vip ora....ip.type ONLINE ONLINE db02ora.scan3.vip ora....ip.type ONLINE ONLINE db02在11g R2中，默认oc4j和gsd资源是disable的；oc4j 是用于WLM 的一个资源, WLM在11.2.0.2 才可用；gsd是CRS 用于跟9i RAC 进行通信的一个模块,是为了向后兼容才保留的，不影响性能；建议不要刪除, 也不要尝试开启他们, 忽略即可。
1)、检查集群状态：[grid@rac02 ~]$ crsctl check clusterCRS-4537: Cluster Ready Services is onlineCRS-4529: Cluster Synchronization Services is onlineCRS-4533: Event Manager is online2)、所有Oracle实例—（数据库状态）:[grid@rac02 ~]$ srvctl status database -d racdbInstance racdb1 is running on node rac01Instance racdb2 is running on node rac023)、检查单个实例状态：[grid@rac02 ~]$ srvctl status instance -d racdb -i racdb1 Instance racdb1 is running on node rac014)、节点应用程序状态：[grid@rac02 ~]$ srvctl status nodeappsVIP rac01-vip is enabledVIP rac01-vip is running on node: rac01VIP rac02-vip is enabledVIP rac02-vip is running on node: rac02Network is enabledNetwork is running on node: rac01Network is running on node: rac02GSD is disabledGSD is not running on node: rac01GSD is not running on node: rac02ONS is enabledONS daemon is running on node: rac01ONS daemon is running on node: rac02eONS is enabledeONS daemon is running on node: rac01eONS daemon is running on node: rac025)、列出所有的配置数据库：[grid@rac02 ~]$ srvctl config databaseracdb6)、数据库配置：[grid@rac02 ~]$ srvctl config database -d racdb -aDatabase unique name: racdbDatabase name: racdbOracle home: /u01/app/oracle/product/11.2.0/dbhome_1 Oracle user: oracleSpfile: +RACDB_DATA/racdb/spfileracdb.oraDomain: Start options: openStop options: immediateDatabase role: PRIMARYManagement policy: AUTOMATICServer pools: racdbDatabase instances: racdb1,racdb2Disk Groups: RACDB_DATA,FRAServices:Database is enabledDatabase is administrator managed7)、ASM状态以及ASM配置：[grid@rac02 ~]$ srvctl status asmASM is running on rac01,rac02[grid@rac02 ~]$ srvctl config asm -aASM home: /u01/app/11.2.0/gridASM listener: LISTENERASM is enabled.8)、TNS监听器状态以及配置：[grid@rac02 ~]$ srvctl status listenerListener LISTENER is enabledListener LISTENER is running on node(s): rac01,rac02[grid@rac02 ~]$ srvctl config listener -aName: LISTENERNetwork: 1, Owner: gridHome: <CRS home>/u01/app/11.2.0/grid on node(s) rac02,rac01End points: TCP:15219)、SCAN状态以及配置：[grid@rac02 ~]$ srvctl status scanSCAN VIP scan1 is enabledSCAN VIP scan1 is running on node rac02[grid@rac02 ~]$ srvctl config scanSCAN name: , Network: 1/192.168.1.0/255.255.255.0/eth0 SCAN VIP name: scan1, IP: //192.168.1.5510)、VIP各个节点的状态以及配置：[grid@rac02 ~]$ srvctl status vip -n rac01VIP rac01-vip is enabledVIP rac01-vip is running on node: rac01[grid@rac02 ~]$ srvctl status vip -n rac02VIP rac02-vip is enabledVIP rac02-vip is running on node: rac02[grid@rac02 ~]$ srvctl config vip -n rac01VIP exists.:rac01VIP exists.: /rac01-vip/192.168.1.53/255.255.255.0/eth0[grid@rac02 ~]$ srvctl config vip -n rac02VIP exists.:rac02VIP exists.: /rac02-vip/192.168.1.54/255.255.255.0/eth011)、节点应用程序配置—（VIP、GSD、ONS、监听器）[grid@rac02 ~]$ srvctl config nodeapps -a -g -s -l-l option has been deprecated and will be ignored.VIP exists.:rac01VIP exists.: /rac01-vip/192.168.1.53/255.255.255.0/eth0 VIP exists.:rac02VIP exists.: /rac02-vip/192.168.1.54/255.255.255.0/eth0 GSD exists.ONS daemon exists. Local port 6100, remote port 6200 Name: LISTENERNetwork: 1, Owner: gridHome: <CRS home>/u01/app/11.2.0/grid on node(s) rac02,rac01End points: TCP:152112)、验证所有集群节点间的时钟同步:[grid@rac02 ~]$ cluvfy comp clocksync -verboseVerifying Clock Synchronization across the cluster nodes Checking if Clusterware is installed on all nodes...Check of Clusterware install passedChecking if CTSS Resource is running on all nodes...Check: CTSS Resource running on all nodesNode Name Status------------------------------------ ------------------------rac02 passedResult: CTSS resource check passedQuerying CTSS for time offset on all nodes...Result: Query of CTSS for time offset passedCheck CTSS state started...Check: CTSS stateNode Name State------------------------------------ ------------------------rac02 ActiveCTSS is in Active state. Proceeding with check of clock time offsets on all nodes...Reference Time Offset Limit: 1000.0 msecsCheck: Reference Time OffsetNode Name Time Offset Status------------ ------------------------ ------------------------rac02 0.0 passedTime offset is within the specified limits on the following set of nodes:"[rac02]"Result: Check of clock time offsets passedOracle Cluster Time Synchronization Services check passedVerification of Clock Synchronization across the cluster nodes was successful.13)、集群中所有正在运行的实例— (SQL):SELECT inst_id , instance_number inst_no , instance_name inst_name , parallel , status , database_status db_status , active_state state , host_name host FROM gv$instance ORDER BY inst_id;14)、所有数据库文件及它们所在的ASM 磁盘组— (SQL):15)、ASM 磁盘卷:16)、启动和停止集群：以下操作需用root用户执行。
