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 […]
Category: ORACLE 12CR2
File Group in a Flex Disk Group
I must thank my fellow DBA Franky Weber Faust for his publication in his blog. In the goal here is to know a bit more about the Flex Disk Group. Let’s see here what a File Group is. In a Flex Disk Group we can separate our databases, be they PDBs, CDBs or non-CDBs, in different File Group. Each […]
Storing a PDB in a Flex Disk Group
I must thank my fellow DBA Franky Weber Faust for his publication in his blog. In this post I board a little more about the Flex Disk Group. In the previous post we had started this subject, if you did not see check there The purpose here is to show how to store a PDB in a Flex Disk Group. In […]
Creating a Disk Group with Flex Redundancy
I must thank my fellow DBA Franky Weber Faust for his publication in his blog. The goal here is to introduce how to create a disk group with one of the new features of Oracle ASM in version 12.2.0.1, the Flex Redundancy or Flex Disk Group. This new type of Disk Group redundancy in ASM […]
Upgrade to Oracle 12.2 with dbupgrade utility
Oracle Database 12c release 1 (12.1) introduced the Parallel Upgrade Utility, catctl.pl. This utility reduces the total amount of time it takes to perform an upgrade by loading the database dictionary in parallel, and by using multiple SQL processes to upgrade the database. Performing parallel upgrades of components enables you to take advantage of your […]
Top 10 new Features of Oracle 12c Release 2
Hello Everyone, As I was going to Oracle through Oracle 12c release 2 documentation, I came across following important new features. This is not the complete list, there are many more new features came out with Oracle release 12c release 2. Multi-Instance Redo Apply : With Oracle 12c Release 2, you can apply redo logs to […]
Creating diskgroup via asmcmd
I must thank my fellow DBA Franky Weber Faust for his publication in his blog. Introduction: – This article is about creating disk-group via asm cmd. Being an Oracle DBA we have knowledge of ASM. Automatic Storage Management (ASM) is Oracle’s logical volume manager, it uses OMF (Oracle Managed Files) to name and locate the database files. […]
Applying the first RU for Oracle Grid Infrastructure 12.2.0.1
The first RU (Release Update) for Oracle 12.2 is available on most platforms since July 18, 2017. And of course I started applying the first RU for Oracle Grid 12.2.0.1 as soon as it got released. Download the RU 12.2.0.1.170718 for Linux First of all I downloaded the Database RU 12.2.0.1.170718 Patch 26133434 for Linux […]
RU and RUR patches for Oracle 12.2
The first RU (Release Update) for Oracle Database 12.2.0.1 has been released. And Oracle Support provides some very helpful documents to explain the implication of the new RU (Release Update) and RUR (Release Update Revision) patches. As of July 2017, Oracle is modifying the Proactive Patch program for Database and Grid Infrastructure release 12.2 and […]
PDB Lockdown Profiles in Oracle 12.2
Use the ALTER LOCKDOWN PROFILE statement to alter a PDB lockdown profile. You can use PDB lockdown profiles in a multitenant environment to restrict user operations in pluggable databases (PDBs). Pluggable databases bring a new separation of database administrator roles. The DBA administers the container database, the CDB, but can then delegate the administration of […]