Shulou(Shulou.com)05/31 Report--

This article mainly introduces "what are the common commands in Oracle Rac". In daily operation, I believe many people have doubts about the common commands in Oracle Rac. The editor consulted all kinds of materials and sorted out simple and easy-to-use methods of operation. I hope it will be helpful for you to answer the doubts about "what are the common commands in Oracle Rac?" Next, please follow the editor to study!

-(cd $ORACLE_HOME/bin/)

-- query

-- query nodes

Olsnodes-s

-- View the cluster name

Cemutlo-n

-- query cluster status

-- you can also add-all to query all nodes

Crsctl check cluster

-- check crs status

Crsctl check crs

-- check the status of resources in the cluster

-- crs_* command oracle is no longer recommended by officials

Crsctl stat res-t

Crs_stat-t

-- query node application status

Srvctl status nodeapps

-- Node application configuration (VIP, GSD, ONS, listener)

Srvctl config nodeapps

-- ASM query

Srvctl status asm

Srvctl status asm-a

-- View asm configuration

Srvctl config asm-a

-- Monitoring and viewing

-- check the monitoring status

Srvctl status listener

-- View the monitoring configuration

Srvctl config listener-a

-- View the status of the scan listener

Srvctl status scan_listener

-- View scan network configuration

Srvctl config scan

-- View the vip network

Srvctl status vip-n hking1

Srvctl config vip-n hking2

-- Database view

-- Database name

Srvctl config database

-- Database status

Srvctl status database-d hking

Srvctl status database-d hking-f-v

-- check the status of the specified instance

Srvctl status instance-d hking-I hking1

-- View database configuration

Srvctl config database-d hking-a

-- Administrative commands

-- RAC cluster management command

-- stop & start the node cluster service as a root user

-- crs_start command

-- start

Crs_start-all

-- View

Crs_start-t

-- close

Crs_stop-all

-- crsctl command

-- start

Crsctl start crs-wait

-- View

Crsctl stat res-t

-- close

Crsctl stop crs-wait

-- stop all node cluster services

Crsctl stop cluster-all

-- stop the cluster service of this node

Crsctl stop cluster

-- self-startup settings

-- query status

Crsctl config crs

-(query results)

CRS-4622: Oracle High Availability Services autostart is enabled.

-- if the status checked above is disable, you can enable it with the following command

Crsctl enable crs

-- close database

Srvctl stop database-d hking

Srvctl status database-d hking

-- Delete existing databases from OCR

Srvctl remove database-d hking

-- add an instance of a database to OCR

Srvctl add instance-d-I-n

-- manage a node's rac through the srvctl command

Srvctl start | stop | status nodeapps-n node1

-- View Node 1 status

Srvctl status nodeapps-n hking1

-- ORACLE database management command

-- start/stop/check all instances through the SRVCTL command

Srvctl start | stop | status database-d db_name

Srvctl status database-d hking

-- start/stop/check the specified instance through the SRVCTL command

Srvctl start | stop | status instance-d-I

-- query instance 1 status

Srvctl status instance-d hking-I hking1

-- ASM management command

-- ensure that css and has services are started before startup

-- start the ASM instance

Sqlplus / as sysasm

Startup

Select instance_name,status from v$instance

-- enter ASM

Asmcmd-p

-- restart RAC database

-- shutdown order: close PDB-- > close database-- > shut down cluster service (shut down PDB before shutting down database instance, otherwise smon will have an automatic recovery process)

-- Boot sequence: boot the cluster service to check whether the cluster server is normal-- > Open database-- > start PDB (default is in mount state)

At this point, the study of "what are the common commands in Oracle Rac" is over. I hope to be able to solve your doubts. The collocation of theory and practice can better help you learn, go and try it! If you want to continue to learn more related knowledge, please continue to follow the website, the editor will continue to work hard to bring you more practical articles!

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.