Oracle Scripts
open-menu closeme
Home
All Oracle Scripts
Scripts & Commands
Links icon
Oracle Database Documentation Oracle Enterprise Manager
About
Contact Us
Privacy Satement
🌐
English Português
rss
  • Maintaining Cluster Health with ocrcheck in Oracle Clusterware

    calendar Feb 10, 2024 / Aug 25, 2025 · 2 min read · oracle database cluster administration Oracle CRS Oracle Clusterware Managing oracheck  ·
    Share on: twitter facebook linkedin copy

    Overview Of ocrcheck Command The ocrcheck command is a valuable tool for managing the Oracle Cluster Registry (OCR) within Oracle Clusterware Retrive OCR (Oracle Cluster Registry) information Sample SQL Command 1ocrcheck Purpose: ocrcheck is a command-line utility used to verify the health and consistency of the Oracle …


    Read More
  • Clarifying oifcfg getif Identifying Your Oracle Cluster Interconnect Subnet

    calendar Feb 8, 2024 / Aug 25, 2025 · 2 min read · oracle database cluster administration Oracle CRS Oracle Clusterware managing oifcfg  ·
    Share on: twitter facebook linkedin copy

    Understanding oifcfg getif for Oracle Cluster Interconnect Subnet Change The Oracle Clustware command oifcfg getif is a crucial utility for managing Oracle Clusterware and its private interconnect subnet. Below is breakdown of its purpose, usage, and key points: Change the private interconnect subnet. First find the …


    Read More
  • Modifying VIP Address, Subnet Mask, or Interface in Oracle Clusterware

    calendar Jan 28, 2024 / Aug 25, 2025 · 3 min read · start stop modify srvctl administration Oracle CRS Oracle Clusterware Oracle Managing RAC  ·
    Share on: twitter facebook linkedin copy

    Modifying VIP Address, Subnet Mask, or Interface in Oracle Clusterware Learn how to change the Virtual IP (VIP) address, subnet mask, or network interface for clustered nodes in an Oracle environment. This step-by-step guide includes commands, explanations, and key points to ensure a smooth and successful configuration …


    Read More
  • Understanding the srvctl config nodeapps Command in Oracle Clusterware

    calendar Jan 27, 2024 / Aug 25, 2025 · 3 min read · srvctl start stop administration Oracle CRS Oracle Clusterware Oracle Managing RAC  ·
    Share on: twitter facebook linkedin copy

    Understanding the srvctl config nodeapps Command in Oracle Clusterware Check the VIP config 1srvctl config nodeapps -n <node> -a -g -s -l Sample Oracle Output 1 2no rows selected 3SQL> Description of the Oracle Database SQL code Purpose: The srvctl config nodeapps -n <node> -a -g -s -l command is not directly related …


    Read More
  • Starting and Stopping Oracle Database Instances with SRVCTL

    calendar Jan 26, 2024 / Aug 25, 2025 · 2 min read · srvctl start stop administration Oracle CRS Oracle Clusterware Oracle Managing RAC  ·
    Share on: twitter facebook linkedin copy

    Start and stops a specific Oracle Database instance with the Server Control Utility (SRVCTL) SQL Code Start Database (Specific Node or Instance) 1srvctl start instance -d <database name> -i <instance name> Stop Database (Specific Node or Instance) 1srvctl stop instance -d <database name> -i <instance name> Sample …


    Read More
  • Controlling Database Operations Starting and Stopping Databases with srvctl in Oracle Clusterware

    calendar Jan 25, 2024 / Aug 25, 2025 · 2 min read · start stop administration Oracle CRS Oracle Clusterware Oracle Managing RAC  ·
    Share on: twitter facebook linkedin copy

    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 …


    Read More
  • Managing the ASM Instance in Oracle Clusterware srvctl start asm and srvctl stop asm Explained

    calendar Jan 22, 2024 / Aug 25, 2025 · 2 min read · administration Oracle CRS Oracle Clusterware Oracle Managing RAC  ·
    Share on: twitter facebook linkedin copy

    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 …


    Read More
  • Controlling Node Level Applications in Oracle Clusterware with srvctl

    calendar Jan 19, 2024 / Aug 25, 2025 · 2 min read · administration Oracle CRS Oracle Clusterware Oracle Managing RAC  ·
    Share on: twitter facebook linkedin copy

    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 …


    Read More
  • Managing Oracle Clusterware CRS

    calendar Jan 16, 2024 / Aug 25, 2025 · 2 min read · Oracle CRS Oracle Clusterware Oracle Managing RAC  ·
    Share on: twitter facebook linkedin copy

    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 …


    Read More

OracleScripts.com

Your Source for Oracle SQL Scripts
Read More

Recent Posts

  • Oracle SQL Performance Analysis Query - Monitor SQL Execution Statistics
  • Oracle SQL Hash Lookup Query - Retrieving SQL Text from V$SQLAREA
  • Oracle Database: Find Query Hash Value Using V$SQLAREA
  • Oracle Database EXPLAIN PLAN: Complete Guide to SQL Performance Analysis
  • Oracle Database Autotrace Commands: Complete Guide to SQL Execution Plan Analysis
  • Oracle Database Query to Find Tables with Outdated Statistics - Monitor Analyze Progress
  • Show a Count of Analyzed Tables by Schema in Oracle Database
  • Oracle PLAN_TABLE Setup and EXPLAIN PLAN Usage Guide

Categories

SCRIPTS 126 ORACLE ADMINISTRATION RAC 12 ORACLE STRUCTURE TABLESPACE 11 ORACLE STRUCTURE FILES 10 ORACLE STRUCTURE OBJECTS 10 ORACLE ADMINISTRATION SESSION 9 ORACLE ADMINISTRATION ASM 8 ORACLE PERFORMANCE GENERAL 8 ORACLE PERFORMANCE STATISTICS 8 ORACLE PERFORMANCE WAITS 8 ORACLE ADMINISTRATION STATUS 7 ORACLE STRUCTURE CONSTRAINTS 7 ORACLE PERFORMANCE QUERY TUNING 6 ORACLE ADMINISTRATION USER 5
All Categories
ORACLE ADMINISTRATION ASM8 ORACLE ADMINISTRATION INIT PARAMETERS3 ORACLE ADMINISTRATION RAC12 ORACLE ADMINISTRATION SESSION9 ORACLE ADMINISTRATION STATUS7 ORACLE ADMINISTRATION USER5 ORACLE PERFORMANCE GENERAL8 ORACLE PERFORMANCE LOCKS DML4 ORACLE PERFORMANCE QUERY TUNING6 ORACLE PERFORMANCE STATISTICS8 ORACLE PERFORMANCE WAITS8 ORACLE STRUCTURE CONSTRAINTS7 ORACLE STRUCTURE FILES10 ORACLE STRUCTURE INDEXES2 ORACLE STRUCTURE OBJECTS10 ORACLE STRUCTURE REDO LOGS3 ORACLE STRUCTURE TABLESPACE11 ORACLE STRUCTURE UNDO4 SCRIPTS126
[A~Z][0~9]

Series

ADMIN GUIDE 126

Tags

ORACLE 103 DATABASE 53 SQL 40 ADMINISTRATION 30 PERFORMANCE 25 DATABASE ADMINISTRATION 20 OPTIMIZATION 17 DBA 15 V$SESSION 12 ORACLE CLUSTERWARE 11 TROUBLESHOOTING 11 MANAGING 10 PERFORMANCE TUNING 10 TABLESPACE 10
All Tags
$DATAFILE1 ACCOUNT1 ADMINISTRATION30 ALL_OBJECTS1 ALTER SESSION1 ANALYZE1 ASM2 ASM DISK UTILIZATION1 AUTOTRACE1 BACKUP1 CHARACTER-SET1 CLUSTER5 CLUSTER MANAGEMENT1 CONNECTED-USERS3 CONSTRAINTS3 DATA INTEGRITY3 DATA-MANAGEMENT8 DATABASE53 DATABASE ADMINISTRATION20 DATABASE MANAGEMENT2 DATABASE OPTIMIZATION1 DATABASE SIZE1 DATABASE START-UP1 DATABASE TUNING1 DATAFILES5 DBA15 DBA TOOLS1 DBA_CONS_COLUMNS1 DBA_CONSTRAINTS6 DBA_DATA_FILES5 DBA_ERRORS1 DBA_EXTENTS1 DBA_FEATURE_USAGE_STATISTICS1 DBA_FREE_SPACE2 DBA_INDEXES1 DBA_LOCK1 DBA_OBJECTS7 DBA_ROLES1 DBA_ROLLBACK_SEGS1 DBA_SEGMENTS9 DBA_SOURCE1 DBA_TAB_COLUMNS1 DBA_TABLES2 DBA_TABLESPACES1 DBA_TEMP_FILES2 DBA_TS_QUOTAS1 DBA_UNDO_EXTENTS1 DBA_USERS1 DBMS_METADATA1 DBMS_STATS5 DBMS_STATS.GATHER_DATABASE_STATS1 DBMS_STATS.GATHER_SCHEMA_STATS1 DDL1 DEVELOPMENT1 DISK GROUP CREATION1 DISK INFORMATION5 DISK SPACE ANALYSIS1 DISKGROUP4 EXECUTION PLAN1 EXPLAIN-PLAN2 EXPORT1 EXTERNAL REDUNDANCY1 FEATURES1 FREE SPACE1 GATHER_SYSTEM_STATS1 HASH1 HOT-BACKUP1 I/O1 IMPORT1 INDEX1 INSTALLED3 JAVA1 LAST-ACTIVITY1 LATCH1 LATCH CONTENTION1 MAINTENANCE1 MANAGEMENT8 MANAGING10 MODIFY1 MONITORING7 NLS_DATABASE_PARAMETERS1 OBJ$1 OBJECTS6 OIFCFG1 OPTIMIZATION17 ORACHECK1 ORACLE103 ORACLE - DATABASE ADMINISTRATION - SQL - DBA_CONSTRAINTS1 ORACLE ADMINISTRATION1 ORACLE ASM6 ORACLE CLUSTERWARE11 ORACLE CRS9 ORACLE DATABASE9 ORACLE DBA1 OSUSER1 PARAMETERS2 PEFORMANCE1 PERFORMANCE25 PERFORMANCE ANALYSIS1 PERFORMANCE OPTIMIZATION3 PERFORMANCE TUNING10 PERFORMANCE-MONITORING5 PL SQL1 PLSQL1 PRIVILEGES1 PROCEDURE2 QUERY1 QUERY ANALYSIS1 QUERY OPTIMIZATION3 QUERY-TUNING2 QUOTAS1 RAC7 RECOVERY3 RESOURCE OPTIMIZATION3 ROLE PRIVILEGES1 ROLE_SYS_PRIVS1 ROLE_TAB_PRIVS1 SCHEMA SPACE USED1 SCRIPTING1 SCRIPTS3 SECURITY1 SEGMENTS3 SESSION-PID1 SESSIONS1 SESSIONS-SORTED1 SHOW2 SHOW ROLES1 SHOW_TABLE_ROLE_PRIVILEGES1 SHOW-USER-SQL5 SPACE USAGE1 SPACE USED1 SPFILE1 SQL40 SQL COMMANDS1 SQL OPTIMIZATION1 SQL PERFORMANCE2 SQL SCRIPTS1 SQL STATISTICS1 SQL TUTORIAL1 SQL-QUERIES1 SRVCTL3 START4 START-UP TIME1 STATISTICS3 STATISTICS MANAGEMENT2 STOP4 STORAGE2 STORAGE CAPACITY MONITORING1 STORAGE MANAGEMENT5 TABLE1 TABLESPACE10 TEMP2 TRACING2 TRANSACTIONS1 TROUBLESHOOTING11 TUNING4 UNDO_RETENTION1 USAGE2 USED SPACE1 USER4 USER SPACE1 USER$1 USERS2 UTLXPLS1 V$ASM_OPERATION1 V$BACKUP1 V$CONTROLFILE3 V$DATAFILE7 V$DB_CACHE_ADVICE1 V$FILESTAT1 V$INSTANCE1 V$LOCK2 V$LOCKED_OBJECT1 V$LOG3 V$LOGFILE4 V$PARAMETER2 V$PROCESS2 V$SEGMENT_STATISTICS1 V$SESSION12 V$SESSION_LONGOPS1 V$SESSION_WAIT1 V$SESSTAT1 V$SQLAREA8 V$STATNAME2 V$SYSSTAT2 V$SYSTEM_EVENT2 V$TEMPFILE3 V$TRANSACTION1 V$WAITSTAT1 VDATAFILE2 X$BH1 X$KCBFWAITV1
[A~Z][0~9]
OracleScripts.com

Copyright  ORACLESCRIPTS.COM. All Rights Reserved

to-top