ASM -(Sector Disk Drives)

This post is about ASM’s attribute deep knowledge. Before going ahead we must have an idea about the topic. Let’s some line must explain about  ASM -(Sector Disk Drives). The database and Oracle’s Automatic Storage Management (ASM) volume manager explicitly understood 4k devices. In this and subsequent versions of ASM, disk groups created on native mode […]

Read More

Applying JVM Patch In Oracle 12c RAC

This article explains the steps for applying the jvm patch on RAC. In the last post of mine. I have gone through the Patches and its types. 1. check for conflict https://www.linkedin.com/in/dbaanuradhamudgalcd /softdump/patch/JVM/22139226 opatch prereq CheckConflictAgainstOHWithDetail -ph ./ Oracle Interim Patch Installer version 12.1.0.1.10 Copyright (c) 2016, Oracle Corporation. All rights reserved. PREREQ session Oracle […]

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

Data Dictionary views ( Oracle 12c)

This article is about data dictionary views in Oracle 12c. It is little bit different one from the last one due to its USB which is the cloud. We all know what is Data Dictionary and its importance? In 12c we have four types of static views which are like this USER, ALL,  DBA,  CDB.  Object Categories:- X$:-  It provides information […]

Read More

MAX_STRING_SIZE Parameter In Oracle 12c

This parameter was introduced in Oracle 12c. MAX_STRING_SIZE controls the maximum size of string size in Oracle database. Either we can set it to STANDARD or.EXTENDED The default value is STANDARD MAX_STRING_SIZE = STANDARD means the maximum size of strings is 4000 bytes for VARCHAR2 and NVARCHAR2 MAX_STRING_SIZE = EXTENDED means maximum size can be upto 32767 byte . We can change the value of MAX_STRING_SIZE from STANDARD to EXTENDED. But not from EXTENDED to STANDARD. With MAX_STRING_SIZE set to STANDARD , […]

Read More

How to encrypt the data using Oracle Wallet

Introduction:- Today we are going to learn about encryption in Oracle. Oracle database has the unique feature to secure data from the data loss. As we get a hint from the word encryption that means the process of converting information or data into code, especially to prevent unauthorized access. Rising security threats, expanding compliance requirements, consolidation, and cloud […]

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

Oracle ASMLIB v/s Oracle ASM Filter Driver (ASMFD)

Oracle ASM Filter Driver (Oracle ASMFD) is installed with an Oracle Grid Infrastructure installation. If you have an existing Oracle ASM library driver (Oracle ASMLIB) configuration, then depending on whether you want to use Oracle ASMLIB or Oracle ASMFD, consider the following scenarios: If you use Oracle ASMLIB to manage your Oracle ASM devices and […]

Read More

Converting Standard to Flex ASM

Today we are going to have a look on converting a standard cluster to flex cluster. I wish this information is useful for you.Oracle Flex Clusters contribute a platform for Oracle Real Application Clusters databases with stupendous numbers of nodes, to support massive parallel query operations. Oracle Flex Clusters also provide a platform for other […]

Read More