1. 首页
  2. IT资讯

Oracle 11g RAC 检查各部分运行状态

检查RAC运行状况

[grid@rac1 ~]$ crsctl check cluster

CRS-4537: Cluster Ready Services is online

CRS-4529: Cluster Synchronization Services is online

CRS-4533: Event Manager is online

检查Database实例例状态 [oracle@rac1 ~]$ srvctl status database -d prod

Instance rac1 is running on node rac1

Instance rac2 is running on node rac2

检查节点应用状态及配置 [oracle@rac1 ~]$ srvctl status nodeapps

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

eONS is enabled

eONS daemon is running on node: rac1

eONS daemon is running on node: rac2

[oracle@rac1 ~]$ srvctl config nodeapps -a -g -s -l

-l option has been deprecated and will be ignored.

VIP exists.:rac1

VIP exists.: /rac1-vip/182.168.8.53/255.255.255.0/eth0

VIP exists.:rac2

VIP exists.: /rac2-vip/182.168.8.54/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) rac2,rac1

End points: TCP:1521

查看数据库配置 [oracle@rac1 ~]$ 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

检查 ASM状态及配置 [oracle@rac1 ~]$ srvctl status asm

ASM is running on rac1,rac2

[oracle@rac1 ~]$ srvctl status asm

ASM is running on rac1,rac2

[oracle@rac1 ~]$ srvctl config asm -a

ASM home: /u01/app/11.2.0/grid

ASM listener: LISTENER

ASM is enabled.

检查 TNS的状态及配置 [oracle@rac1 ~]$ srvctl status listener

Listener LISTENER is enabled

Listener LISTENER is running on node(s): rac1,rac2

[oracle@rac1 ~]$ srvctl status listener

Listener LISTENER is enabled

Listener LISTENER is running on node(s): rac1,rac2

[oracle@rac1 ~]$ srvctl config listener -a

Name: LISTENER

Network: 1, Owner: grid

Home: <CRS home>

/u01/app/11.2.0/grid on node(s) rac2,rac1

End points: TCP:1521

检查 SCAN 的状态及配置 [oracle@rac1 ~]$ srvctl status scan

SCAN VIP scan1 is enabled

SCAN VIP scan1 is running on node rac1

[oracle@rac1 ~]$ srvctl config scan

SCAN name: rac-scan, Network: 1/182.168.8.0/255.255.255.0/eth0

SCAN VIP name: scan1, IP: /rac-scan.xl.com/182.168.8.55

检查 VIP的状态及配置 [oracle@rac1 ~]$ srvctl status vip -n rac1

VIP rac1-vip is enabled

VIP rac1-vip is running on node: rac1

[oracle@rac1 ~]$ srvctl status vip -n rac2

VIP rac2-vip is enabled

VIP rac2-vip is running on node: rac2

[oracle@rac1 ~]$ srvctl config vip -n rac1

VIP exists.:rac1

VIP exists.: /rac1-vip/182.168.8.53/255.255.255.0/eth0

[oracle@rac1 ~]$ srvctl config vip -n rac2

VIP exists.:rac2

VIP exists.: /rac2-vip/182.168.8.54/255.255.255.0/eth0

来自 “ ITPUB博客 ” ,链接:http://blog.itpub.net/29578568/viewspace-2140481/,如需转载,请注明出处,否则将追究法律责任。

主题测试文章,只做测试使用。发布者:布吉卡,转转请注明出处:http://www.cxybcw.com/195450.html

联系我们

13687733322

在线咨询:点击这里给我发消息

邮件:1877088071@qq.com

工作时间:周一至周五,9:30-18:30,节假日休息

QR code