Network Security Internet Technology Development Database Servers Mobile Phone Android Software Apple Software Computer Software News IT Information

In addition to Weibo, there is also WeChat

Please pay attention

WeChat public account

Shulou

Detailed description of Oracle RAC implementation-check after installation 06

2025-04-05 Update From: SLTechnology News&Howtos shulou NAV: SLTechnology News&Howtos > Database >

Share

Shulou(Shulou.com)06/01 Report--

Detailed description of Oracle RAC implementation-check after installation 06

View database version

SQL > select * from v$version

View cluster name

[root@rac01 bin] #. / cemutlo-help

[root@rac01 bin] #. / cemutlo-n

Rac-cluster

[root@rac01 bin] #. / cemutlo-w

2:1:

View cluster status

[root@rac01 ~] # cd / u01/app/11.2.0/grid/bin/

[root@rac01 bin] #. / crsctl check cluster-all

* * *

Rac01:

CRS-4537: Cluster Ready Services is online

CRS-4529: Cluster Synchronization Services is online

CRS-4533: Event Manager is online

* * *

Rac02:

CRS-4537: Cluster Ready Services is online

CRS-4529: Cluster Synchronization Services is online

CRS-4533: Event Manager is online

* * *

View resource status

[root@rac01 bin] #. / crsctl stat res-t

View CRS status

[root@rac01 bin] #. / crsctl check crs

CRS-4638: Oracle High Availability Services is online

CRS-4537: Cluster Ready Services is online

CRS-4529: Cluster Synchronization Services is online

CRS-4533: Event Manager is online

View OHASD status

[root@rac01 bin] #. / crsctl check has

CRS-4638: Oracle High Availability Services is online

Disable crs self-startup

[root@rac01 bin] #. / crsctl disable crs

CRS-4621: Oracle High Availability Services autostart is disabled.

[root@rac02 bin] #. / crsctl disable crs

CRS-4621: Oracle High Availability Services autostart is disabled.

View node information

[root@rac01 bin] #. / olsnodes-help

[root@rac01 bin] #. / olsnodes

Rac01

Rac02

[root@rac01 bin] #. / olsnodes-c

Rac-cluster

View network interface information

[root@rac01 bin] #. / oifcfg-help

[root@rac01 bin] #. / oifcfg getif

Eth0 192.168.31.0 global public

Eth2 10.10.10.0 global cluster_interconnect

View OCR information

[root@rac01 bin] #. / ocrcheck-config

Oracle Cluster Registry configuration is:

Device/File Name: + OCR

[root@rac01 bin] #. / ocrcheck

View olr information

[root@rac01 bin] #. / ocrcheck-local

Check OCR integrity

[grid@rac01] $cluvfy comp ocr-n all-verbose

View votedisk information

[root@rac01 bin] #. / crsctl query css votedisk

View database information

[root@rac01 bin] #. / srvctl config database

Cjcdb

[root@rac01 bin] #. / srvctl config database-d cjcdb-a

[root@rac01 bin] #. / srvctl status database-d cjcdb

Instance cjcdb1 is running on node rac01

Instance cjcdb2 is running on node rac02

[root@rac01 bin] #. / srvctl status database-d cjcdb-v

Instance cjcdb1 is running on node rac01. Instance status: Open.

Instance cjcdb2 is running on node rac02. Instance status: Open.

View SCAN configuration

[root@rac01 bin] #. / srvctl config scan

SCAN name: rac-scan.cjc.com, Network: 1/192.168.31.0/255.255.255.0/eth0

SCAN VIP name: scan1, IP: / rac-scan.cjc.com/192.168.31.60

SCAN VIP name: scan2, IP: / rac-scan.cjc.com/192.168.31.70

SCAN VIP name: scan3, IP: / rac-scan.cjc.com/192.168.31.50

View DNS parsing

[root@rac01 bin] # nslookup rac-scan.cjc.com

Server: 192.168.31.90

Address: 192.168.31.90#53

Name: rac-scan.cjc.com

Address: 192.168.31.70

Name: rac-scan.cjc.com

Address: 192.168.31.50

Name: rac-scan.cjc.com

Address: 192.168.31.60

View SCAN VIP status

[root@rac01 bin] #. / srvctl status scan

SCAN VIP scan1 is enabled

SCAN VIP scan1 is running on node rac02

SCAN VIP scan2 is enabled

SCAN VIP scan2 is running on node rac01

SCAN VIP scan3 is enabled

SCAN VIP scan3 is running on node rac01

Displays the status of the SCAN listener

[root@rac01 bin] #. / srvctl status scan_listener

SCAN Listener LISTENER_SCAN1 is enabled

SCAN listener LISTENER_SCAN1 is running on node rac02

SCAN Listener LISTENER_SCAN2 is enabled

SCAN listener LISTENER_SCAN2 is running on node rac01

SCAN Listener LISTENER_SCAN3 is enabled

SCAN listener LISTENER_SCAN3 is running on node rac01

View server IP

[root@rac01 bin] # ifconfig

View ASM configuration

[root@rac01 bin] #. / srvctl config asm

ASM home: / u01/app/11.2.0/grid

ASM listener: LISTENER

View monitoring configuration

[root@rac01 bin] #. / srvctl config listener

Name: LISTENER

Network: 1, Owner: grid

Home:

End points: TCP:1521

View node status

[root@rac01 bin] #. / srvctl status nodeapps-n rac01

VIP rac01-vip is enabled

VIP rac01-vip is running on node: rac01

Network is enabled

Network is running on node: rac01

GSD is disabled

GSD is not running on node: rac01

ONS is enabled

ONS daemon is running on node: rac01

[root@rac01 bin] #. / srvctl status nodeapps-n rac02

VIP rac02-vip is enabled

VIP rac02-vip is running on node: rac02

Network is enabled

Network is running on node: rac02

GSD is disabled

GSD is not running on node: rac02

ONS is enabled

ONS daemon is running on node: rac02

Welcome to follow my Wechat official account "IT Little Chen" and learn and grow together!

Welcome to subscribe "Shulou Technology Information " to get latest news, interesting things and hot topics in the IT industry, and controls the hottest and latest Internet news, technology news and IT industry trends.

Views: 0

*The comments in the above article only represent the author's personal views and do not represent the views and positions of this website. If you have more insights, please feel free to contribute and share.

Share To

Database

Wechat

© 2024 shulou.com SLNews company. All rights reserved.

12
Report