Facts about Instance

Today we are going to have look at some more interesting facts about  “Oracle Technology”.  This post about is the  “ASM Instance and Database Instance”. Being an Oracle DBA our  Oracle journey starts with Database Instance. As we go into the deep knowledge of Oracle we get new terms of Oracle technology. We are going to learn about ASM instance and […]

Read More

Changing password securely in Oracle

I must thank my fellow DBA Franky Weber Faust for his publication in his blog. Introduction: – We are living in the world of username and password life. We all have countless password due to technology’s development. Password plays an important role in our life. Oracle Database leads the industry in security. To maximize the security […]

Read More

Shutdown mode in Oracle ASM Instance

Being an Oracle DBA we have learned about the db instance in Oracle database. As we know db instance has shutdown mode. In this post, we are going to have look at Oracle ASM Instance. The ASM shutdown process is initiated when you run the SHUTDOWN command in SQL*Plus. While running this command we must ensure […]

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> asmcmd –inst +ASM2 2.Move ASM password […]

Read More

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

Read More

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

Read More

New Background Processes in Oracle 12c

List of New Background Processes in Oracle 12c Name Expanded Name Short Description Long Description External Properties AQPC AQ Process Coordinator Per instance AQ global coordinator AQPC is responsible for performing administrative tasks for AQ Master Class Processes including commands like starting, stopping, and other administrative tasks. This process is automatically started on instance startup. […]

Read More

Background Processes in Oracle ASM

Once the ASM instance is started, all the basic background processes, as well as some that are specific to the operation of ASM, are started. Notice that all the ASM processes begin with asm, whereas the RDBMS instance processes begin with ora. On Unix, the ASM processes can be listed using the following command: ps […]

Read More

Migrating Oracle ASM Disk Groups without OCR or Voting Files

To migrate Oracle ASM disk groups without Oracle Cluster Registry (OCR) or voting files to Oracle ASMFD: Log in as the Oracle Grid Infrastructure owner on any node to run the commands in this procedure. List the existing disk groups: $ $ORACLE_HOME/bin/asmcmd lsdg List the associated disks: $ $ORACLE_HOME/bin/asmcmd lsdsk -G diskgroup Check if Oracle […]

Read More

RAC : 11gR2 Clusterware Startup Sequence

Here is the brief explanation that how the clusterware brings up step by step . 1. When a node of an Oracle Clusterware cluster start/restarts, OHASD is started by platform-specific means. OHASD is the root for bringing up Oracle Clusterware. OHASD has access to the OLR (Oracle Local Registry) stored on the local file system. […]

Read More