April 2022 - ASRblogger

Cassandra Commands

cassandra -f [start commads] ./nodetool status [checking status] ./nodetool ring [depicts of the state of nodes] ./nodetool -h 192.168.0.101 clean [cleanup of keys that no longer belong to a particular…

asrblogger April 26, 2022No Comments

Oracle

ORA-00020: maximum number of processes (3000) exceeded

PROCESSES specifies the maximum number of operating system user processes that can simultaneously connect to Oracle. Its value should allow for all background processes such as locks, job queue processes, and…

asrblogger April 20, 2022No Comments

ASM Oracle

ASM Day to Day Life Scripts

To identify the number of diskgroup ,status from below query. select group_number,name from v$asm_diskgroup; select group_number, name, state, type from v$asm_diskgroup; Size of ASM Diskgroup SELECT NAME, STATE, TYPE, ROUND(TOTAL_MB…

asrblogger April 7, 2022No Comments

DataGuard Interview Questions

Important Parameters in Data Guard

DB_NAME On a primary database, specify the name used when the database was created. On a physical standby database, use the DB_NAME of the primary database. DB_UNIQUE_NAME Specify a unique…

asrblogger April 6, 2022No Comments

Oracle

Connect To Hung Database In Oracle

Oracle hangs only when he is waiting for a resource. It might be a software resource (a latch or lock), or you could be hung waiting for server resources (CPU,…