In addition to Weibo, there is also WeChat
Please pay attention
WeChat public account
Shulou
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.
Continue with the installation of the previous hadoop.First, install zookooper1. Decompress zookoope
"Every 5-10 years, there's a rare product, a really special, very unusual product that's the most un
© 2024 shulou.com SLNews company. All rights reserved.