Converting Standard to Flex Cluster

Introduction Oracle Real Application Cluster (RAC) is a well-known product among Oracle’s solutions to maintain high availability of your business data. Oracle RAC allows the work load to be shared among all the cluster nodes, with N-1 tolerance configuration in case of node failures, where N is the total number of nodes. Oracle RAC is […]

Read More

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

Read More

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

Read More

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

Read More

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

Read More

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

Read More

Convert non partitioned table to partitioned online Oracle 12.2

This is one of the new feature of oracle 12.2 release . Non-partitioned tables can be converted to partitioned table online without any downtime to the application , i.e no impact to the DML activities. Till now for this activity, we were using dbms_redef methods. But in Oracle 12.2 release this has been simplified much. […]

Read More

Datapump New features in Oracle 12.2

A lot of enhancements has been done in Oracle 12.2 Release.  In this article We will explain the new features of datapump utility in oracle 12.2 Release. 1.Parfile content  written to logfile: Till now, log file of expdp or impdp, doesn’t store the content of parfile, The log file used to look as below.

So […]

Read More

Lock account automatically with INACTIVE_ACCOUNT_TIME

In Oracle 12.2 Release We can use the INACTIVE_ACCOUNT_TIME resource parameter in profile to automatically lock the account of a database user who has not logged in to the database instance in a specified number of days. 1. By default, it is set to UNLIMITED. 2. The minimum setting is 15 and the maximum is […]

Read More

Move table online in Oracle 12.2

In previous Releases, To move a table to a different tablespace or segment, we need to take downtime for this activity And after moving the table, we have to rebuild/recreate the indexes. Now with Oracle 12.2, We can move the table online to a different segment or tablespace, without impacting the DML activities and without […]

Read More