Multiplex Controlfile In Oracle RAC

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 […]

Read More

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 […]

Read More

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 […]

Read More

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 […]

Read More

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 […]

Read More

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 […]

Read More

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, […]

Read More

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>

2.Move ASM password file using pwmove: […]

Read More

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 […]

Read More

ORA-28007: the password cannot be reused

Scenario: Trying to reset to the existing password throws following error.

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 so set to a higher value or to UNLIMITED […]

Read More