Connecting PDB in Oracle 12c

To connect as sys or other elevated local users, use the same methods as below, but use ‘as sysdba‘ where necessary Method 1:

Method 2:For other methods, you need to know the service-name for the PDB: Get the service name for the PDB:

or by doing “lsnrctl services LISTENER” and locating service for […]

Read More

OGG-00665 OCI Error Describe For Query

In this post, we are going to have look at OGG-00665 OCI Error Describe For Query. Following steps mention about the steps which we use to solve OGG-00665. Problem:    In goldengate version 12, while starting the extract,it may abend with below error. 2016-04-11 12:31:10  ERROR   OGG-00665  OCI Error describe for query (status = 942-ORA-00942: table […]

Read More

OGG-01031 There Is A Problem In Network Communication

While starting the data pump in golden gate version 12.2.0, you may get an error. We are going to learn the steps which are used to solve this issue.   2016-04-14 15:14:39  ERROR   OGG-01031  There is a problem in network communication, a remote file problem, encryption keys for target and source do not match (if using ENCRYPT) […]

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

Purge AUD$ Table Using DBMS_AUDIT_MGMT

  Introduction:- Oracle 11gR2 introduced DBMS_AUDIT_MGMT for managing audit trails.  The growth of AUD$ can impact the performance of the database. So purging it regularly is the best practice followed by DBA’s and DBMS_AUDIT_MGMT makes it easier. Follow below steps for purging aud$ table. 1. Make sure AUD$ table is not in SYSTEM table tablespace.   […]

Read More