Oracle ASM Filter Driver (Oracle ASMFD) is installed with an Oracle Grid Infrastructure installation. If you have an existing Oracle ASM library driver (Oracle ASMLIB) configuration, then depending on whether you want to use Oracle ASMLIB or Oracle ASMFD, consider the following scenarios: If you use Oracle ASMLIB to manage your Oracle ASM devices and […]
Category: ORACLE 12C
Converting Standard to Flex ASM
Today we are going to have a look on converting a standard cluster to flex cluster. I wish this information is useful for you.Oracle Flex Clusters contribute a platform for Oracle Real Application Clusters databases with stupendous numbers of nodes, to support massive parallel query operations. Oracle Flex Clusters also provide a platform for other […]
Configure Data Redaction on Oracle
In previous article we provide the brief introduction about Data Redaction on Oracle. Now in this post, we are going to configure different type of Data Redaction in Oracle 12c. Full Data Redaction Partial Data Redaction Random Data Redaction Data Redaction with REGEXP For the demonstration on this I have a table that holds credit […]
Oracle Data Redaction
Oracle Data Redaction enables you to mask (redact) data that is returned from queries issued by applications. You can redact column data by using one of the following methods: Full redaction. You redact all of the contents of the column data. The redacted value returned to the querying application user depends on the data type of […]
Procedure for authorizing and disallowing users in Oracle Database Vault Realm
I must thank my fellow DBA Franky Weber Faust for his publication in his blog. Introduction: – In this article, we have look at the document the procedure required to authorize a user as a participant in the Oracle Database Vault Realm and then disallow it. All this procedure is possible through Enterprise Manager, but as it is […]
Introduction to Oracle AWR
I must thank my fellow DBA Franky Weber Faust for his publication in his blog. Today let’s talk a little about a fantastic feature we have in Oracle Database that helps us in performance analysis: the AWR. What is AWR? AWR stands for Automatic Workload Repository, ie it is a repository of information about the […]
Unified Auditing, one of the new features in Oracle Database 12c
I must thank my fellow DBA Franky Weber Faust for his publication in his blog. Introduction: – In this article, we are going to know about some other new features of Oracle 12c. Unified Auditing is a new feature in Oracle 12c. In Oracle 12c, a new database auditing Foundation has been introduced. Oracle Unified Auditing […]
Separating OCR and Voting Disk in Oracle Clusterware 12c
I must thank my fellow DBA Franky Weber Faust for his publication in his blog. Objective: Describe the advantages of separating OCR and RV and also present the process needed to do this. NOTE: Although the procedure was performed in version 11gR2, the steps are the same for version 12c. In this article, we will […]
Rman Backup In Multitenant Database Oracle 12c
Introduction: – As a DBA we all familiar with the backup commands. In the latest database of Oracle, we find some different commands we must keep it in mind how to take backup. In this article, we are going to know about the Rman Backup In Multitenant Database Oracle 12c.With multitenant feature introduced in oracle 12c, […]
Views_as_tables Parameter In Datapump Of Oracle 12c
VIEWS_AS_TABLES parameter has been introduced in datapump of 12c. With this, we can export a view from a source database and import as a table in a target database. Create a view: SQL> create view dba_view( emp_number) as select emp from dbatool;SQL> create view dba_view( emp_number) as select emp from dbatool; View created. SQL> select owner,object_name,object_type from dba_objects […]