Oracle Real Application clusters (RAC) allows multiple instances to access a single Oracle database. These instances often run on multiple nodes. The Component Diagram with explanation shows all the components that inter-relate to each other and together make up THE “Oracle RAC architecture“. RAC is the principal component for the Oracle Grid Architecture. It’s […]
Category: RAC
ASMSNMP password change user/ reset default Oracle 12c
Download Brave : Secure, Fast & Private Browser with Adblocker The ASMSNMP user is an Oracle ASM user with privileges to monitor Oracle ASM instances. The ASMSNMP user password is required. How can I change the password of the Oracle user ASMSNMP? Objective is authentication for accessing Oracle ASM Instances. For example to register an […]
Resource is in UNKNOWN state and srvctl Cannot Start/Stop the Resource
An Oracle RAC Service is in UNKNOWN state on instance 1 and it is impossible to stop or start it with srvctl. crs_stat -u ora.DBName.My-ServiceName.DBName1.srv NAME=ora.DBName.My-ServiceName.DBName1.srv TYPE=application TARGET=ONLINE STATE=UNKNOWN on Host1 Solution: The UNKNOWN state can often be resolved by bringing the resource offline using crs_stop. If the resource is not in Unknown state: Use […]
Useful Oracle RAC Commands
Download Brave : Secure, Fast & Private Browser with Adblocker Here is a FAQ and examples of useful Oracle RAC Commands I use for the administration of Oracle 19c, 18c and 12c Reak Application Cluster: 1- Shutdown and Start sequence steps of Oracle RAC components 2- Manage low level cluster resources: CRS, HAS, cluster 3- […]