We are going to have look at the ASM Dynamic Performance Views. In the database, we have learned about views. Here we are going to focus on ASM Dynamic Performance Views. As we know An ASM instance does not have a data dictionary. The information relating to its configuration and operation is available by querying a set of […]
Monthly Archives: November 2017
Oracle RAC 12c Setup Using Virtual Box
In this article, I have described each and every step required for setting up a 2 node RAC12c database using virtual box for testing purpose. Softwares Required: 1. Virtual box : 2. Linux 3. Oracle 12c home: 4. Oracle 12c Grid: Virtual Machine setup: Here we have to set up 2 nodes inside virtual box. […]
How To Change RAC Database Name
This article explains the steps which DBA must use to Change RAC Database Name. Before we must start the steps to change database name. Every DBA must know the condition in which have to change the name of a database. When cloning the database on the same server. When we need to refresh the data. […]
How To Convert A Non ASM Instance To ASM Instance
Let’s have fun with instance today. Being an Oracle DBA we are well known for Instance. DBA’s life starts from Instance. In early days of DBA training, we introduced with Instance. When we enter to the new part of Oracle. we notice new teams. Now I am going to focus on ASM instance. Some starting lines remind the […]
How To Move Voting Disk To Another ASM Disk
This article explains the steps which we use to move VOTING DISK to another ASM DISK. In first few lines remind us about the definition of VOTING DISK and ASM DISK. After complete, we have mentioned the way to add a voting disk to another ASM. What is VOTING DISK? The Voting Disk File is a […]
How To Find The Cluster Name In Oracle RAC
This article is short and simple. It explains the ways to find the cluster name in Oracle RAC. First few lines explain about the cluster. A cluster comprises multiple co-ordinated computers or servers that appear as if they are one server to end users and applications. Oracle RAC enables you to cluster Oracle databases. Oracle RAC uses […]
PRVF-5424 : Clock Time Offset Check Failed
We are going to have look on the steps which use to solve RAC database installation INFO: PRVF-9652 : Cluster Time Synchronization Services check failed. While installing Oracle RDBMS home on Oracle Grid, you may get an error as below. ERROR: Clock Synchronization – This test checks the Oracle Cluster Time Synchronization Services across the cluster nodes. Error: […]
Prepare standby and configure primary database for far sync
This depend on distance between primary and standby and network bandwidth. So this feature that came with 12c resolve this situation. We are preparing a database one more. This database take archive–log primary database and then send this archive–log to standby. Primary and far sync standby database are sync, whereas far sync standby database and physical standby database are async. Let’s begin with creating the physical standby with FAR SYNC instance in place. First of […]
Enable Archive Log Mode In Oracle RAC
Today we are going to have look on the steps which we use for “Enable Archive Log Mode In Oracle RAC”. Being Oracle DBA we all know the importance of Archive Log Mode. This few line explains the technical definition for the quick review of Archive Log Mode. Most of the High Availability features of Oracle require you to […]
Applying JVM Patch In Oracle 12c RAC
This article explains the steps for applying the jvm patch on RAC. In the last post of mine. I have gone through the Patches and its types. 1. check for conflict https://www.linkedin.com/in/dbaanuradhamudgalcd /softdump/patch/JVM/22139226 opatch prereq CheckConflictAgainstOHWithDetail -ph ./ Oracle Interim Patch Installer version 12.1.0.1.10 Copyright (c) 2016, Oracle Corporation. All rights reserved. PREREQ session Oracle […]