11G RAC 简单命令
来源:互联网 发布:php程序员面试宝典 编辑:程序博客网 时间:2024/06/17 23:44
1、查看集群状态:
[root@rac1 ~]# su - grid
[grid@rac1 ~]$ crsctl checkcluster
CRS-4537: Cluster Ready Services isonline
CRS-4529: Cluster Synchronization Services is online
CRS-4533: Event Manager is online
2、数据库实例状态:
[grid@rac1 ~]$ srvctl status database -dyoon
Instance yoon1 is running on node rac1
Instance yoon2 is running on node rac2
3、单实例状态:
[grid@rac1 ~]$ srvctl status instance -dyoon -i yoon1
Instance yoon1 is running on node rac1
[grid@rac1 ~]$ srvctl status instance -dyoon -i yoon2
Instance yoon2 is running on noderac2
4、node应用程序状态:
[grid@rac1 ~]$ srvctl statusnodeapps
VIP rac1-vip is enabled
VIP rac1-vip is running on node: rac1
VIP rac2-vip is enabled
VIP rac2-vip is running on node: rac2
Network is enabled
Network is running on node: rac1
Network is running on node: rac2
GSD is disabled
GSD is not running on node: rac1
GSD is not running on node: rac2
ONS is enabled
ONS daemon is running on node: rac1
ONS daemon is running on node: rac2
5、所有的配置数据库:
[grid@rac1 ~]$ srvctl configdatabase
yoon
7、数据库配置信息:
[grid@rac1 ~]$ srvctl config database -dyoon -a
Database unique name: yoon
Database name: yoon
Oracle home: /u01/app/oracle/11.2.0/db_1
Oracle user: oracle
Spfile: +DATA/yoon/spfileyoon.ora
Domain:
Start options: open
Stop options: immediate
Database role: PRIMARY
Management policy: AUTOMATIC
Server pools: yoon
Database instances: yoon1,yoon2
Disk Groups: DATA,FLUSH
Mount point paths:
Services:
Type: RAC
Database is enabled
Database is administrator managed
8、ASM状态:
[grid@rac1 ~]$ srvctl statusasm
ASM is running on rac2,rac1
9、ASM配置信息:
[grid@rac1 ~]$ srvctl config asm-a
ASM home: /u01/app/grid/11.2.0
ASM listener: LISTENER
ASM is enabled.
10、监听状态:
[grid@rac1 ~]$ srvctl statuslistener
Listener LISTENER is enabled
Listener LISTENER is running on node(s): rac2,rac1
11、监听配置信息:
[grid@rac1 ~]$ srvctl config listener-a
Name: LISTENER
Network: 1, Owner: grid
Home:
End points: TCP:1521
12、SCAN状态:
[grid@rac1 ~]$ srvctl statusscan
SCAN VIP scan1 is enabled
SCAN VIP scan1 is running on node rac2
13、SCAN配置信息:
[grid@rac1 ~]$ srvctl configscan
SCAN name: rac-scan, Network:1/192.168.1.0/255.255.255.0/eth0
SCAN VIP name: scan1, IP: /rac-scan/192.168.1.10
14、节点VIP状态:
[grid@rac1 ~]$ srvctl status vip -nrac1
VIP rac1-vip is enabled
VIP rac1-vip is running on node: rac1
[grid@rac1 ~]$ srvctl status vip -nrac2
VIP rac2-vip is enabled
VIP rac2-vip is running on node: rac2
15、VIP配置信息:
[grid@rac1 ~]$ srvctl config vip -nrac1
VIP exists:/rac1-vip/192.168.1.18/192.168.1.0/255.255.255.0/eth0, hosting noderac1
[grid@rac1 ~]$ srvctl config vip -nrac2
VIP exists: /rac2-vip/192.168.1.19/192.168.1.0/255.255.255.0/eth0,hosting node rac2
16、节点应用程序配置系信息:
[grid@rac1 ~]$ srvctl
Network exists: 1/192.168.1.0/255.255.255.0/eth0, type static
VIP exists: /rac1-vip/192.168.1.18/192.168.1.0/255.255.255.0/eth0,hosting node rac1
VIP exists: /rac2-vip/192.168.1.19/192.168.1.0/255.255.255.0/eth0,hosting node rac2
GSD exists
ONS exists: Local port 6100, remote port 6200, EM port 2016
Name: LISTENER
Network: 1, Owner: grid
Home:
End points: TCP:1521
17、启动和停止集群:
[root@rac1 ~]#/u01/app/grid/11.2.0/bin/crsctl stop cluster-all
[root@rac1 ~]#/u01/app/grid/11.2.0/bin/crsctl start cluster-all
[root@rac1 ~]#srvctlstop database -d yoon
[root@rac1 ~]#srvctlstart database -d yoon
- 11G RAC 简单命令
- oracle 11g rac 修改字符集
- 迁移11g Rac中OCR和VOTEDISK
- racle 10G rac集群碰到…
- Oracle 11g Password Features
- oracle 11g 分区表
- oracle 11g 新参数 MEMORY_TARGET
- oracle 11g jdbc 驱动链接
- linux oracle 11g 安装
- CentOS6 下Oracle 11 g数据库
- ORACLE 11G 配置DG&nbsp…
- oracle 11g 添加控制文件
- 11g: TNS-12532 / …
- LOB segment and LOB index(11g R2…
- jdbc 连接 oracle rac
- 10g RAC库用rman 的方式备份并恢复…
- Oracle RAC Cache Fusion 机制详解
- g++ error : decla…
- ORA-00054
- ORA-00845
- ORA-14404
- Vbox安装oracle-linux报错:VT-x&n…
- 使用RxJava来改进用户体验
- 11G RAC 简单命令
- ORACLE-12C-RAC INSTALL
- oracle-12c-rac 报:ORA-01078
- 这是回音你懂吗
- oracle11g RAC添加节点
- uninstall 11.2.0.3.0 g…
- [INS-41112] Specified …
- Android源码下载同步指导
- Oracle ClusterwarePRCT-1011…