Uncategorized

ORACLE ENTERPRISE LINUX (OEL 7.9 ) INSTALLATION Download Virtual box : Download & Install Latest virtual box on windows machine. Download LINUX 7.9 iso files. Install Linux 7.9 1. Download Virtual box : Download & Install Latest virtual box on windows machine.   2. Download LINUX 7.9 iso files Goto google.com -> edelivery.oracle.com Click on […]

Patching Process In Oracle Create a folder for patch 2 . By Winscp move the patch zip file to /data/patch this location. 3. Now check the current opatch version. #if the opatch version is old , then you have to replace it with the latest version. here it is 12.2.0.1.17. so let’s upgrade it. Now […]

How to create a swap partition in Linux ? 1. Run the following command to create a file of 1 GB, for example: 2. Run the following command to modify the file permissions : 3.Run the following command to configure the file as swap space: 4.Run the following command to activate the swap file: 5. […]

Create, Delete and Modify Services in Oracle RAC 1.Creating Service in Oracle RAC : Here we have created service named myservice with preferred instance orcl1 and available instance orcl2. To check all available parameters of service creation : check the status of service : check service configuration : Modifying service : Now lets, check the […]

Voting Disks In RAC Voting Disks : Oracle Clusterware uses voting disk files to determine which nodes are members of a cluster. You can configure voting disks on Oracle ASM, or you can configure voting disks on shared storage. If you configure voting disks on Oracle ASM, then you do not need to manually configure […]

Active Session History (ASH) Reports 1. Overview ASH is Helpful to identify performance issues in old sessions. ASH Collects samples of active sessions every second (waiting for non-idle events, or on the CPU working) from v$sessions (inactive sessions are not captured). Sampled data collected to circular buffer in SGA and the same can be accessed […]

How to generate ADDM report Automatic Database Diagnostic Monitor(ADDM) can analyze performance issues during a particular period and provide suggestion. An ADDM analysis is performed on a set of awr snapshots. addmrpt.sql script is used to generate addm report. Generate ADDM report: It will ask for begin snap_id and end snap_id To get snap id Execute […]

In this Blog, we will see how to delete a node from multi node grid infrastructure setup. Current GRID NODES : Node 1, Node 2, Node 3 Node tobe deleted : node3. Grid Version : 19c. STEPS OVERVIEW: 1. Precheck. 2.Delete Oracle Instance from node3 using DBCA. 3.Deinstall the Oracle Database home from node3. 4.Deinstall […]

Add a Node In Oracle RAC 19C In this blog, we will add new node node3 to the existing cluster. ( where grid is already running) Grid_Home :/u01/app/19c/grid Oracle_home : /u01/app/oracle/product/19C/db_home. Steps to Add a node to Cluster : 1. 1. Run gridsetup.sh script from existing node. Run root.sh script from the new node node2. […]

Syntax : The possible values have the following effects: SKIP leaves the table as is and moves on to the next object. This is not a valid option if the CONTENT parameter is set to DATA_ONLY. APPEND loads rows from the source and leaves existing rows unchanged. TRUNCATE deletes existing rows and then loads rows […]