ORACLE 12C

SQLPlus History In Oracle 12.2 New feature

In Oracle 12.2, SQL*Plus can keep the history of the commands executed. You can enable or disable the HISTORY command in the current SQL*Plus session by using the SET HISTORY command. The history feature is not enabled by default, so after you start SQL*Plus, you need to enable history by running “set hist[ory] on”

[…]

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

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

RMAN active cloning from RAC TO RAC

Below are the steps for doing RMAN from RAC to RAC. Steps will be same from NON RAC TO RAC . For standalone database  – Rman active cloning for standalone 12c database SOURCE DB RAC NODE- prodb1-host,prodb2-host DBNAME – PRODB : Oracle 12.1.0.2 INSTANCE NAMES – PRODB1,PRODB2 Oracle 12.1.0.2 TARGET DB RAC NODE – clonedb1-host,clonedb2-host DBNAME […]

Upgrade database from 12.1.0.2 to 12.2.0.1

Oracle database version 12.2.0.1 is recently released.  I searched the database software for Solaris platform, Found it in oracle edelivery.     I downloaded the software from edelivery and did an installation and upgrade on a  test box. SEE ALSO: Upgrade database from 11g to 12cR1 using manual method Upgrade database from 11g to 12cR1 […]

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

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

Unified audit trail in Oracle 12c

OVERVIEW:                 With oracle 12c, unified auditing has been introduced. It consolidates all audit trails into a single audit trail table. It will capture audit records from below sources. SYS audit records ( which was written to os trail in traditional method, will now be written to db […]

Partitioning New features in Oracle 12c

Below are the partitioning enhancements that has been introduced in Oracle 12c version. 1. Online partition move: From oracle 12c, we can move partitions online without blocking the DML statements during that time.

— To maintain global indexes

— Moving to another tablespace:

2. Adding multiple partitions with One command:

3. […]

RMAN active cloning in oracle 12C

            RMAN active is one of cloning method used to clone a database on target host without taking backup of the source database.  Make sure that source database is in archivelog mode. Below are the steps. NOTE: In 11g, RMAN active cloning is done during image copy( which includes unused […]

Page 3 of 612345...Last »
Skip to toolbar