Running Oracle on Docker

I must thank my fellow DBA Franky Weber Faust for his publication in his blog. If you want to know about Basic about Docker in the Oracle Hi everyone, here in a very brief post I will show you how to upload Oracle in a Docker container. Following the DevOps wave, this week I’m doing a course and knowing […]

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

Restore the spfile while using the FRA & not using Recovery Catalog

Today we are going to learn about recovery with rman for loss of spfile. As we know that RMAN can be used either with or without a recovery catalog. A recovery catalog is a schema stored in a database that tracks backups and stores scripts for use in RMAN backup and recovery situations. Generally, a skillful DBA […]

Read More

Oracle 11g Architecture Diagram with Explanation

Oracle 11g Architecture Diagram with Explanation. In below flash video, you can get all Dynamics Views, Background Components and Background Processes. For Flash Video: 11g Interactive in Flash To Download in PDF : 11g Architecture in PDF Soon I will upload for Oracle 12c also. Cheers !!!!  

Read More

Background Processes in Oracle RAC

Oracle RAC Background Processes Image Source The GCS and GES processes, and the GRD collaborate to enable Cache Fusion. The Oracle RAC processes and their identifiers are as follows: 1. ACMS: Atomic Controlfile to Memory Service (ACMS) In an Oracle RAC environment, the ACMS per-instance process is an agent that contributes to ensuring a distributed […]

Read More

Startup And Shutdown Modes Of An Oracle Database

An oracle database can be started in various modes. Each mode is used by the DBA’s to perform some specific operation in the database. Nomount State:  We can bring database to nomount state from shutdown state. When we start an oracle database in nomount state then oracle will create the oracle instance. The instance is […]

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

Back Up & Restore an Oracle ASM Password File with pwget Command

In this article we are showing how to backup and restore password file of Oracle ASM with pwget command. pwget Purpose Returns the location of the password file for the Oracle ASM or database instance. pwcopy Purpose Copies an Oracle ASM or database instance password file to the specified location. pwset Purpose Sets the location […]

Read More

Different ways to find spfile location in Oracle RAC

1. By using SqlPlus

2. By using ASMCMD find command

3. By using spget command

4. By using crsctl command

5. By using gpnp tool Note: mostly used when ASM is not up.

6. From alert.log

Read More

Use spget and spmove command in Oracle ASM

Starting with ASM version 11.2, the ASM spfile can be stored in an ASM disk group. Indeed, during a new ASM installation, the Oracle Universal Installer (OUI) will place the ASM spfile in the disk group that gets created during the installation. New ASMCMD commands To support this feature, new ASMCMD commands were introduced to […]

Read More