Blog
Oracle enterprise manager (OEM) is monitoring tool for Oracle database server. Oracle enterprise manager monitor to Oracle database, Oracle database server, agent, listener and all the targets which are registered with the Oracle enterprise manager. Oracle enterprise manager tool is provided by the Oracle itself and having more demand for the Oracle database administration. Following […]
# Create SparkSession from builder Spark submit spark-submit –jars C:UsersAcerDownloadsaws-java-sdk-1.7.4.jar, C:UsersAcerDownloadshadoop-aws-2.7.7.jar C:UsersAcerPycharmProjectsDecHadoopBatchreadS3.py
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 […]
Restore RAC Database from RMAN Backup Set First of all, make sure the clusterware is Up and Running. Restore Cluster Database 1. Make a Directory in Disk Group Make sure that we have a backup set of the database. 2. Detach Database from Clusterware Since we only use one node to do the entire recovery, […]
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. […]
How to change database name using NID Utility Follow below steps for changing the oracle database name using nid utility. 1. Mount the database SQL>2. Run the NID utility SYNTAX – nid sys/password@CURRENT_DBNAME DBNAME=NEW_DBNAME 3. change the db_name parameter in the parameter file. 4. Rename the spfile to new db name
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 […]
