Oracle Scripts
open-menucloseme
Home
All Oracle Scripts
Scripts & Commands
Links icon
Oracle Database Documentation Oracle Enterprise Manager
About
Contact Us
Privacy Satement
🌐
English Português
rss

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

    calendar Jan 28, 2024 · 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 · 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 …


    Read More

  • Starting and Stopping Oracle Database Instances with SRVCTL

    calendar Jan 26, 2024 · 3 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 …


    Read More

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

    calendar Jan 25, 2024 · 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> Sample Oracle Output: 1 2no rows selected 3SQL> Description of the Oracle Database SQL code: …


    Read More

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

    calendar Jan 22, 2024 · 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 SQL Code Start ASM 1srvctl start asm -n <node name> Stop ASM 1srvctl stop asm -n <node name> Sample Oracle Output: 1 2no rows selected 3SQL> Description of the Oracle Database SQL code: Demystifying Start/Stop ASM with srvctl in Oracle Database …


    Read More

  • Controlling Node Level Applications in Oracle Clusterware with srvctl

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

    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 More

  • Managing Oracle Clusterware (CRS)

    calendar Jan 16, 2024 · 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 Database SQL Scripts
Read More

Recent Posts

  • Identifying Oracle Database Hot Blocks using Oracle table v$system_event: A Comprehensive Guide
  • Analyzing Oracle 'Data Block' Waits with v$waitstat
  • Analyzing Oracle 'Buffer Busy Waits' with v$session_wait
  • Analyzing Oracle Performance Statistics with v$statname and v$sysstat
  • Oracle Segment Waits In-Depth Code Analysis and Insights using v$segment_statistics
  • Oracle Performance Tuning Analyzing Latch Contention with Time Waited for Latches Using Oracle Tables v$system_event and v$sysstat
  • Top 10 Hottest Objects in Oracle by Touch Count using tables x$bh obj$ and user$
  • Identify Waits by Datafile in Oracle using tables v$datafile and x$kcbfwait

Categories

SCRIPTS 111 ORACLE ADMINISTRATION RAC 12 ORACLE STRUCTURE TABLESPACE 11 ORACLE STRUCTURE FILES 10 ORACLE STRUCTURE OBJECTS 10 ORACLE ADMINISTRATION SESSION 9 ORACLE PERFORMANCE GENERAL 8 ORACLE PERFORMANCE WAITS 8 ORACLE ADMINISTRATION ASM 7 ORACLE ADMINISTRATION STATUS 7 ORACLE STRUCTURE CONSTRAINTS 7 ORACLE ADMINISTRATION USER 5 ORACLE PERFORMANCE LOCKS DML 4 ORACLE STRUCTURE UNDO 4 ORACLE ADMINISTRATION INIT PARAMETERS 3
All Categories
ORACLE ADMINISTRATION ASM7 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 WAITS8 ORACLE STRUCTURE CONSTRAINTS7 ORACLE STRUCTURE FILES10 ORACLE STRUCTURE INDEXES2 ORACLE STRUCTURE OBJECTS10 ORACLE STRUCTURE REDO LOGS3 ORACLE STRUCTURE TABLESPACE11 ORACLE STRUCTURE UNDO4 SCRIPTS111 SQL1
[A~Z][0~9]

Series

ADMIN GUIDE 111

Tags

ORACLE 94 DATABASE 47 SQL 34 ADMINISTRATION 27 DATABASE-ADMINISTRATION 20 PERFORMANCE 20 OPTIMIZATION 15 DBA 11 MANAGING 10 ORACLE CLUSTERWARE 10 TROUBLESHOOTING 10 V$SESSION 10 ORACLE CRS 9 MANAGEMENT 8 PERFORMANCE TUNING 8
All Tags
$DATAFILE1 ACCOUNT1 ADMINISTRATION27 ALTER SESSION1 ASM2 ASM DISK UTILIZATION1 BACKUP1 CHARACTER-SET1 CLUSTER5 CONNECTED USERS3 CONSTRAINTS3 DATA INTEGRITY3 DATA MANAGEMENT7 DATABASE47 DATABASE SIZE1 DATABASE START-UP1 DATABASE-ADMINISTRATION20 DATAFILES5 DBA11 DBA_CONS_COLUMNS1 DBA_CONSTRAINTS7 DBA_DATA_FILES5 DBA_ERRORS1 DBA_EXTENTS1 DBA_FREE_SPACE1 DBA_IND_COLUMNS1 DBA_INDEXES1 DBA_LOCK1 DBA_OBJECTS5 DBA_ROLES1 DBA_ROLLBACK_SEGS1 DBA_SEGMENTS6 DBA_SOURCE1 DBA_TAB_COLUMNS1 DBA_TABLESPACES1 DBA_TEMP_FILES1 DBA_TS_QUOTAS1 DBA_USERS1 DBMS_METADATA1 DDL1 DEVELOPMENT1 DISK GROUP CREATION1 DISK INFORMATION5 DISK SPACE ANALYSIS1 DISKGROUP4 EXTERNAL REDUNDANCY1 FEATURES1 FREE SPACE1 HOT BACKUP1 I/O1 INDEXING1 INSTALLED3 JAVA1 LAST ACTIVITY1 LATCH1 LATCH CONTENTION1 MAINTENANCE1 MANAGEMENT8 MANAGING10 MODIFY1 MONITORING4 OBJ$1 OBJECTS6 OIFCFG1 OPTIMIZATION15 ORACHECK1 ORACLE94 ORACLE ASM6 ORACLE CLUSTERWARE10 ORACLE CRS9 ORACLE DATABASE6 OSUSER1 PARAMETERS2 PEFORMANCE1 PERFORMANCE20 PERFORMANCE MONITORING3 PERFORMANCE OPTIMIZATION1 PERFORMANCE TUNING8 PL SQL1 PLSQL1 PROCEDURE2 QUERY1 QUOTAS1 RAC7 RECOVERY3 RESOURCE OPTIMIZATION2 ROLE_SYS_PRIVS1 ROLE_TAB_PRIVS1 SCHEMA SPACE USED1 SCRIPTING1 SCRIPTS1 SECURITY1 SEGMENTS3 SESSION PID1 SESSIONS1 SESSIONS SORTED1 SHOW ROLES1 SHOW TABLE ROLE PRIVLEDGES1 SHOW USER PRIVLEGES1 SHOW USER SQL6 SPACE USAGE1 SPACE USED1 SPFILE1 SQL34 SQL COMMANDS1 SQL TUTORIAL1 SQL-QUERIES1 SRVCTL3 START4 START-UP TIME1 STOP4 STORAGE2 STORAGE CAPACITY MONITORING1 STORAGE MANAGEMENT5 TABLESAPCE5 TABLESPACE4 TEMP2 TRACING2 TRANSACTIONS1 TROUBLESHOOTING10 TUNING1 UNDO_RETENTION1 USAGE1 USED SPACE1 USER2 USER SPACE1 USER$1 USERS2 V$ASM_OPERATION1 V$BACKUP1 V$CONTROLFILE3 V$DATAFILE8 V$DB_CACHE_ADVICE1 V$FILESTAT1 V$LOCK2 V$LOCKED_OBJECT1 V$LOG2 V$LOGFILE4 V$PARAMETER2 V$PROCESS1 V$SEGMENT_STATISTICS1 V$SESSION10 V$SESSION_LONGOPS1 V$SESSION_WAIT`1 V$SESSTAT1 V$SQLAREA5 V$STATNAME2 V$SYSSTAT2 V$SYSTEM_EVENT2 V$TEMPFILE2 V$TRANSACTION1 V$WAITSTAT1 X$BH1 X$KCBFWAITV1
[A~Z][0~9]
OracleScripts.com

Copyright 2003-  ORACLESCRIPTS.COM. All Rights Reserved

to-top