ASM
Sample tnsnames.ora Dedicated Server Entry (with ASM)
May 1, 2026 / · 5 min read · Oracle Database SQL*Net tnsnames.ora Oracle Net Oracle DBA Database Connectivity ASM TNS ·Sample tnsnames.ora Dedicated Server Entry (with ASM) Purpose The tnsnames.ora file is the client-side address book for Oracle Net. Each entry maps a short alias (SCR9) to a full network address — protocol, host, port, and target service. Without a working tnsnames.ora entry, sqlplus, rman, and any application using …
Read MoreOracle ASM: Create a Disk Group with External Redundancy
Creating an ASM Disk Group with External Redundancy in Oracle SQL Code 1create diskgroup data1 2external redundancy 3disk '/dev/raw/raw1' 4/ Or with multiple raw partitions SQL Code 1create diskgroup data1 2external redundancy 3disk '/dev/raw/raw1', '/dev/raw/raw2' 4/ Or with multiple fail groups... SQL Code 1create …
Read MoreVisualizing Disk Groups in Oracle ASM with SQL
Jan 6, 2024 / · 5 min read · disk space analysis oracle storage capacity monitoring asm disk utilization asm v$asm_disk v$asm_diskgroup v$asm_file v$asm_operation v$asm_disk_stat ·Visualizing Disk Groups in Oracle ASM with SQL Purpose V$ASM_DISK is the view that lists every disk the Oracle ASM instance finds, including disks that are not part of any disk group. The query below reads six of its columns and sorts the rows by disk group number. The result is a plain text listing in SQL*Plus, one …
Read More