oracle 11g R AC管理常用命令

 　　1)、检查集群状态： [[email protected] ~]$ crsctl check cluster CRS-4537: Cluster Ready Services is online CRS-4529: Cluster Synchronization Services is online CRS-4533: Event Manager is online 2)、所有 Oracle 实例 —(数据库状态): [[email protected] ~]

　　1)、检查集群状态：

　　[[email protected] ~]$ crsctl check cluster

　　CRS-4537: Cluster Ready Services is online

　　CRS-4529: Cluster Synchronization Services is online

　　CRS-4533: Event Manager is online

　　2)、所有 Oracle 实例 —(数据库状态):

　　[[email protected] ~]$ srvctl status database -d racdb

　　Instance racdb1 is running on node rac01

　　Instance racdb2 is running on node rac02

　　3)、检查单个实例状态：

　　[[email protected] ~]$ srvctl status instance -d racdb -i racdb1

　　Instance racdb1 is running on node rac01

　　4)、节点应用程序状态：

　　[[email protected] ~]$ srvctl status nodeapps

　　VIP rac01-vip is enabled

　　VIP rac01-vip is running on node: rac01

　　VIP rac02-vip is enabled

　　VIP rac02-vip is running on node: rac02

　　Network is enabled

　　Network is running on node: rac01

　　Network is running on node: rac02

　　GSD is disabled

　　GSD is not running on node: rac01

　　GSD is not running on node: rac02

　　ONS is enabled

　　ONS daemon is running on node: rac01

　　ONS daemon is running on node: rac02

　　eONS is enabled

　　eONS daemon is running on node: rac01

　　eONS daemon is running on node: rac02

　　5)、列出所有的配置数据库：

　　[[email protected] ~]$ srvctl config database

　　racdb

　　6)、数据库配置：

　　[[email protected] ~]$ srvctl config database -d racdb -a

　　Database unique name: racdb

　　Database name: racdb

　　Oracle home: /u01/app/oracle/product/11.2.0/dbhome_1

　　Oracle user: oracle

　　Spfile: +RACDB_DATA/racdb/spfileracdb.ora

　　Domain: xzxj.edu.cn

　　Start options: open

　　Stop options: immediate

　　Database role: PRIMARY

　　Management policy: AUTOMATIC

　　Server pools: racdb

　　Database instances: racdb1,racdb2

　　Disk Groups: RACDB_DATA,FRA

　　Services:

　　Database is enabled

　　Database is administrator managed

　　7)、ASM状态以及ASM配置：

　　[[email protected] ~]$ srvctl status asm

　　ASM is running on rac01,rac02

　　[[email protected] ~]$ srvctl config asm -a

　　ASM home: /u01/app/11.2.0/grid

　　ASM listener: LISTENER

　　ASM is enabled.

　　8)、TNS监听器状态以及配置：

　　[[email protected] ~]$ srvctl status listener

　　Listener LISTENER is enabled

　　Listener LISTENER is running on node(s): rac01,rac02

　　[[email protected] ~]$ srvctl config listener -a

　　Name: LISTENER

　　Network: 1, Owner: grid