Enable DDL Replication In Goldengate

In this below tutorial, we will enable DDL replication for a table, which is already part of goldengate replication and currently, only DML transactions are getting replicated. TABLE_NAME = APPLIANCE.CLASSTAB1 To enable DDL replication, We need to run few SQL scripts(provided under $GG_HOME)  on the source database. and update the extract parameter file. 1. Run role_setup.sql where […]

Read More

Obey Command In Goldengate

Like we execute .sql file against SQL, we can write multiple golden gate commands inside a .oby file and execute it against GGSCI prompt using OBEY command. Use OBEY to process a file that contains a list of Oracle GoldenGate commands. OBEY is useful for executing commands that are frequently used in sequence. EXAMPLE: In the below […]

Read More

Defgen Utility In Oracle Goldengate

Let’s have look at the Defgen Utility In Oracle Goldengate.  If the source and target table structures are different from source has then we need to use definition file in replicate file. Example: Here we will generate definition file of a table DBACLASS.EMPLOYEE from the source database and use it in target db.   1. Create defgen […]

Read More

ASM – (ACFS commands for multiple environments)

Overview of ACFS:- Oracle ACFS is designed as a general-purpose, single-node and cluster-wide file system that delivers support for customer file system application data maintained outside of Oracle Database. Users and applications can access and manage Oracle ACFS using native operating system file system application programming interfaces (APIs) and command-line interface (CLI) tools. Users can also […]

Read More

ASM Clients

Being an Oracle DBA we have learned about ASM and its qualities. Today we are going to learn about ASM Clients.  We all are aware that Oracle ASM is a volume manager and file system for Oracle database files. Let’s start to have knowledge of ASM Client. Clients that connect directly to ASM. Oracle Database:-  This is […]

Read More

Open Wallet Automatically After Starting The Database

This article about Open Wallet Automatically After Starting The Database.  If encryption wallet is enabled, then every time we start the database, we have to open the wallet manually. So to avoid this, we can create one trigger which will open the wallet automatically, once you start the database. Below is the trigger: CREATE or replace […]

Read More

How To Use DBMS_PRIVILEGE_CAPTURE To Capture Privs In Oracle 12c

Introduction:- Oracle 12c introduced the DBMS_PRIVILEGE_CAPTURE package, which helps us in doing privilege analyze and find a report on used and unused privileges.In order to use the DBMS_PRIVILEGE_CAPTURE package, you must be granted the CAPTURE_ADMIN role. One of the most important Security Principals while maintaining your Enterprise Database Landscape is implementing the “least privilege” principle. The […]

Read More

Transparent Data Encryption (TDE) In Oracle 12c

Today we are going to talk about Transparent Data Encryption (TDE) In Oracle 12c. First, have look at the introduction of TDE.  After the introduction, we have steps to configure TDE. Transparent Data Encryption (TDE) was introduced in Oracle Database 10g Release 2 as an OUT-OF place mechanism to encrypt data at the storage (media) level. TDE […]

Read More

Disable TDE In Oracle 12c

This post is about Disable TDE In Oracle 12c . Let’s hav look on the steps. Find the encrypted table columns and modify them: SQL> select owner,table_name,column_name,encryption_alg from dba_encrypted_columns;SQL> select owner,table_name,column_name,encryption_alg from dba_encrypted_columns; OWNER TABLE_NAME   COLUMN_NAME ENCRYPTION_ALG—– ———— ———— —————————–RAJ   EMPLOYEE    SALARY AES 192 bits key  SQL> alter table raj.employee modify( salary decrypt); Table altered. SQL> select owner,table_name,column_name,encryption_alg from dba_encrypted_columns; No […]

Read More

How To Move AUD$ Table To Another Tablespace Using DBMS_AUDIT_MGMT

Auditing is always about accountability, and is frequently done to protect and preserve privacy for the information stored in databases. Concern about privacy policies and practices has been rising steadily with the ubiquitous use of databases in businesses and on the Internet. Oracle Database provides a depth of auditing that readily enables system administrators to […]

Read More