Controlling Node Level Applications in Oracle Clusterware with srvctl
Master the srvctl start nodeapps and srvctl stop nodeapps commands to effectively manage node-level applications within your Oracle Clusterware environment. Gain insights into their purpose, breakdown, key points, and practical considerations SQL Code Start Nodeapps 1srvctl start nodeapps -n <node name> Stop …
Read MoreEssential commands for starting, stopping, checking, and monitoring CRS services. Note: Start/stop need to be run as root from the CRS home. SQL Code Start CRS 1crsctl start crs Stop CRS 1crsctl stop crs Check CRS's status 1crsctl check crs See the status of the various services 1crs_stat -t Sample Oracle Output: 1 2no …
Read MoreChecking All Disks in Diskgroup Data
This SQL code instructs Oracle to perform a thorough check of all disks within the diskgroup named data1. Check the internal consistency of a diskgroup SQL Code 1alter diskgroup data1 check all 2/ Sample Oracle Output: 1 2no rows selected 3SQL> Description of the Oracle Database SQL code: Purpose: To initiate a …
Read MoreMonitoring ASM Operations in Oracle Database, Using the
v$asm_operation
ViewJan 14, 2024 · 2 min read · Oracle ASM Oracle Disk Information Storage Management diskgroup v$asm_operation ·Monitoring ASM Operations in Oracle Database, Using the v$asm_operation View SQL Code 1select * 2from v$asm_operation 3/ Mount/dismount disk groups 1alter diskgroup all mount 2/ 1alter diskgroup data1 mount 2/ 1alter diskgroup all dismount 2/ 1alter diskgroup data1 dismount 2/ Sample Oracle Output: 1 2no rows selected …
Read MoreRemoving a Disk Group Permanently in Oracle Database, The
drop diskgroup
CommandRemoving a Disk Group Permanently in Oracle Database, The drop diskgroup Command SQL Code 1drop diskgroup '<name>' 2/ Sample Oracle Output: 1 2no rows selected 3SQL> Description of the Oracle Database SQL code: Purpose: The primary purpose of this SQL code is to permanently remove an entire disk group, …
Read MoreExpanding Storage Capacity in Oracle Database, Adding a Disk to Diskgroup Data1
Expanding Storage Capacity in Oracle Database, Adding a Disk to Diskgroup Data1 SQL Code Note: Wildcards can be used for raw device names (eg. raw* 1alter diskgroup data1 2add disk '/dev/raw/raw4' 3/ Sample Oracle Output: 1 2no rows selected 3SQL> Description of the Oracle Database SQL code: Purpose: The …
Read MoreCreating 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 …
Read MoreQuerying ASM Disk Information in Oracle SQL Code 1select name 2, group_number 3, disk_number 4, total_mb 5, free_mb 6from v$asm_disk 7order by group_number 8/ Sample Oracle Output: 1 2no rows selected 3SQL> Purpose: Retrieves and displays key information about Automatic Storage Management (ASM) disks within the …
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 ·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 MoreExamining Role Table Privileges in Oracle SQL Code 1select owner || '.' || table_name "TABLE" 2, column_name 3, privilege 4, grantable 5from role_tab_privs 6where role like '&role' 7/ Sample Oracle Output: 1 2no rows selected 3SQL> Purpose: This code retrieves detailed information about …
Read More