How To Move AUD$ Table To Another Tablespace Using DBMS_AUDIT_MGMT

If your AUD$ table is in SYSTEM and SYSTEM tablespace, Then it is advised to move the AUD$ to a dedicated tablespace.   Use steps to move AUD$. select owner,segment_name,segment_type,tablespace_name,bytes/1024/1024 from dba_segments where segment_name=’AUD$’ OWNER SEGMENT_NAME SEGMENT_TYPE TABLESPACE_NAME BYTES/1024/1024 ——- ————- —————— —————————— ————— SYS AUD$ TABLE SYSTEM 16 Use the dbms_audit_mgmt to move the […]

Read More

ENABLE_DDL_LOGGING In Oracle 12c

This  ENABLE_DDL_LOGGING parameter has been introduced in Oracle 12c. If this ENABLE_DDL_LOGGING is enabled, then DDL records are written to the ADR. All DDL operations like alter/create/drop/truncate objects. Only drop user will be logged, But create user will not be. Enable the parameter: SQL> show parameter enable_ddl_logging NAME TYPE VALUE ———————————— ———– —————————— enable_ddl_logging boolean FALSE SQL> alter system […]

Read More

Unified Audit Trail In Oracle 12c

This post is about Unified Audit Trail In Oracle 12c . Few starting lines give the overview of ” Unified Audit Trail ” .   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 […]

Read More

raccli update databasepassword

The update databasepassword subcommand of the raccli utility updates the password in the keystore (wallet) and optionally updates the password of the SYS and SYSTEM users.

If you are executing this command following an update to the cloud tooling from release 17.2.1 or earlier, you must execute the command with the –saveonly option on […]

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

Migrating Oracle ASM Disk Groups without OCR or Voting Files

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:

List the associated disks:

Check if Oracle ASM is active:

Stop the […]

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

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

Read More