Oracle Scripts

Demystifying Database Start/Stop in Oracle Clusterware with srvctl SQL Code Start Database (All Nodes) 1srvctl start database -d <database name> Stop Database (All Nodes) 1srvctl stop database -d <database name> Demystifying Database Start/Stop in Oracle Clusterware with srvctl These commands, srvctl start database and …

Demystifying Start/Stop ASM with srvctl in Oracle Database These commands, specifically srvctl start asm and srvctl stop asm, play a crucial role in managing the Oracle Automatic Storage Management (ASM) instance within your Oracle Clusterware environment. Let's dive into their purpose, breakdown, and key points. SQL …

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 …

Essential 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 …

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 1no rows selected 2SQL> Description of the Oracle Database SQL code Purpose: To initiate a …

Monitoring ASM Operations in Oracle Database, Using thev$asm_operationView 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/ Description of the Oracle Database SQL code …

Removing a Disk Group Permanently in Oracle Database, The drop diskgroup Command SQL Code 1drop diskgroup '<name>' 2/ Description of the Oracle Database SQL code Purpose: The primary purpose of this SQL code is to permanently remove an entire disk group, identified by its name, from the Oracle database environment. …

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 1no rows selected 2SQL> Description of the Oracle Database SQL code Purpose: The primary purpose of …

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 …

Querying 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 1no rows selected 2SQL> Purpose: Retrieves and displays key information about Automatic Storage Management (ASM) disks within the database. …