Let’s have look on New Features in Oracle 12c of ASMCMD. Below are the new features of Oracle 12c version. 1. Connecting to ASM instance of remote node: Now we can connect to asmcmd prompt(asm instance) of remote node from local node. SYNTAX – asmcmd –inst < REMOTE ASM INSTANCE NAME> asmcmd –inst +ASM2 2.Move ASM password […]
Category: ORACLE RAC
Steps for Create RAC Database Manually
Manual Creation of Database is a big task for DBA. This is the initial steps for setup the IT project. We know that we can create the database in two ways one is DBCA and another is Manual. Creation of Database in RAC environment different from the Standalone database. In this post we are going have look on […]
OLSNODES command in RAC
The olsnodes command provides the list of nodes and other information for all nodes participating in the cluster. You can use this command to quickly check that your cluster is operational, and all nodes are registered as members of the cluster. This command also provides an easy method for obtaining the node numbers. oracle@vgeb07hr:/dev/mapper [+ASM1]# […]
RAC Useful Srvctl Commands
Use the Server Control (SRVCTL) utility to manage various components and applications in your cluster. This appendix contains reference information for Server Control commands, including utility usage information and a comprehensive listing of the SRVCTL commands. SRVCTL is installed on each node in a cluster by default. To use SRVCTL, log in to the operating […]
RAC Useful CRSCTL Commands
CRSCTL is an interface between you and Oracle Clusterware, parsing and calling Oracle Clusterware APIs for Oracle Clusterware objects. Oracle Clusterware 11g release 2 (11.2) introduces cluster-aware commands with which you can perform check, start, and stop operations on the cluster. You can run these commands from any node in the cluster on another node […]
Multiplex Redolog In Oracle RAC
Being an Oracle DBA in the initial year of our we work on the standalone database. In the world of backup, we work on multiplexing of the redo log. But as in single instance database is different from RAC environment. Multiplexing means to keep multiple copies of redo log in different diskgroup. It is similar to […]
Steps to add diskgroup in ASM
We know what is ASM in Oracle. Today we have look on diskgroups. In this article we have discussed the technical definition on ASM diskgroup in first two paragraphs after that we have the steps which we use to add ASM diskgroup The main components of ASM are diskgroups, each of which comprises of several physical […]
Oracleasm Utility For ASMLIB
In this article, we are going to have look on Oracleasm Utility For ASMLIB.These lines explain the technical definition of Oracleasm The oracleasm command utility is part of the Oracle ASMLib, and you only use oracleasm commands when you want Oracle ASMLib to be able to access your ASM disks. Oracle notes that the ASMLib is an […]
Drop a Oracle RAC Database
I am demonstrating how we can drop the database in RAC environment manually in Oracle12c(12.1.0.2.0) version. I have two node RAC and the database name is TEST. The instance names are TEST1 & TEST2. Verify the instance [oracle@host01 ~]$ srvctl status database -d TEST Instance TEST1 is running on node host01 Instance TEST2 is running […]
Multiplex control file in 11gR2 RAC ASM
After creating 11gR2 RAC database, we wanted to enable multiplexing for the control files. Oracle recommends multiplexing the control files . We are using ASM for the storage of control files. At the time of creating the database by dbca we can do multiplexing or we can also do later manually as described below. Goal:- […]