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' 4/ Or with multiple fail groups... SQL Code 1create diskgroup data3 …
Read MoreVisualizing Disk Groups in Oracle ASM with SQL
Jan 6, 2024 / · 2 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 ·Visualizing Disk Groups in Oracle ASM with SQL Note: A group number of zero his indicates that a disk is available but hasn't yet been assigned to a disk group. SQL Code 1set lines 100 2col name format a10 3col path format a30 4select name 5, group_number 6, disk_number 7, mount_status 8, state 9, path 10from …
Read More