We are going to have look on the steps which we use for Multiplex Controlfile In Oracle RAC. The control file is the most important file in Oracle database. These few lines explain about the technical definition of the control file. A control file is a small binary file that is part of an Oracle database. The […]
Monthly Archives: October 2017
ORA-15073: Diskgroup Mounted By Another Instance
We know that in the database each and every “Error “has its own reasons. Let’s have look on Error ORA-15073: Diskgroup Mounted By Another Instance. This article explains the cause and action for this error. Cause: An attempt was made to drop a diskgroup that is still mounted somewhere in the cluster by another instance. Action: dismount the […]
How To Rename ASM Diskgroup With RAC Database
Below are the steps for renaming an ASM diskgroup with database files present inside for a running database. EXAMPLE: In this article we will rename the diskgroup +DATATST to +NEWTST. The database present inside the diskgroup is TESTDB2 . 1. Check configuration of the database: srvctl config database -d TESTDB2 srvctl config database -d […]
Steps for Copy ASM File From One Server To Another Server
In the world of Technology, we all know COPY and PASTE how much helpful for making any business operations. But in the field of Database, it is not same as in another area. Some different steps we have to use. Let’s have look on those steps which we use for Copy ASM File From One Server To Another Server. Copying file between […]
Move Datafile From File System To ASM Disk In 11g
Today, we are going to learn about those steps which use to move Datafile from file system to ASM disk in Oracle 11g.Being an Oracle DBA we have deep knowledge of Datafiles. We know there importance of Datafiles in the database. Somes lines explain about the technical definition. A data file is a file that is […]
Steps for Install Grid Infrastructure 12c On Standalone Server
Today, we are going to have look on the steps which is used for Install Grid Infrastructure 12c On Standalone Server. Grid installation on the standalone database server is also known as Oracle Restart. This is required if you wish you use ASM file system with Oracle restart feature. Oracle Restart Means, During any accidental Hardware or software […]
RMAN Active Cloning From RAC TO RAC
Being an Oracle DBA we know that what is cloning? This technical definition gives you a correct idea of the cloning. RMAN has the ability to duplicate, or clone, a database from a backup or from an active database. It is possible to create a duplicate database on a remote server with the same file structure, […]
Asmcmd New Features In Oracle 12c
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 […]
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 […]
ORA-28007: the password cannot be reused
Scenario: Trying to reset to the existing password throws following error. ERROR at line 1: ORA-28007: the password cannot be reused Solution: Check the user profile set for the user. Check for the existence of a password verify function in the profile. Set the password_verify_function to NULL Another reason could be that the PASSWORD_REUSE_MAX limit has reached. If […]