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 […]
Monthly Archives: July 2017
Creating diskgroup via asmcmd
I must thank my fellow DBA Franky Weber Faust for his publication in his blog. Introduction: – This article is about creating disk-group via asm cmd. Being an Oracle DBA we have knowledge of ASM. Automatic Storage Management (ASM) is Oracle’s logical volume manager, it uses OMF (Oracle Managed Files) to name and locate the database files. […]
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 […]
LOGTIME=ALL Parameter In Datapump Of Oracle 12c
Introduction: – As Oracle user, we are learning Oracle export/import from 9i still changes are going on. 12c has introduced LOGTIME=ALL Parameter In Datapump. We are going to know about LOGTIME=ALL Parameter In Datapump in 12c. Data Pump Export is a utility for unloading data and metadata into a set of operating system files called a dump file […]
Common User Vs Local User In 12c Multitenant
Introduction: –Database users are the one who really uses and takes the benefits of the database. There will be different types of users depending on their need and way of accessing the database. Application Programmers – They are the developers who concur with the database by means of DML queries. These DML queries are written in […]
How To Setup Listener For PDBS In Multitenant Database.
Introduction: – We all know that The Oracle Listener is a process listening for incoming database connections. This process is only needed on the database server side. The listener is controlled via the lsnrctl utility. Configuration is done via the listener.ora file.In this article, we are going to setup listener for PDBS in Multitenant Database. If you wish to setup […]
IN-MEMORY In Oracle 12c
Introduction :- Oracle 12c has lots of characteristics In-Memory is one of the most important features. It enables tables, partitions, materialized views be stored in memory using column format, which delivers fast SQL processing for the Analytical purpose. Oracle Database In-Memory proffers an idiosyncratic dual-format architecture that legalizes tables to be concurrently represented in memory using standard row […]
Applying the first RU for Oracle Grid Infrastructure 12.2.0.1
The first RU (Release Update) for Oracle 12.2 is available on most platforms since July 18, 2017. And of course I started applying the first RU for Oracle Grid 12.2.0.1 as soon as it got released. Download the RU 12.2.0.1.170718 for Linux First of all I downloaded the Database RU 12.2.0.1.170718 Patch 26133434 for Linux […]
RU and RUR patches for Oracle 12.2
The first RU (Release Update) for Oracle Database 12.2.0.1 has been released. And Oracle Support provides some very helpful documents to explain the implication of the new RU (Release Update) and RUR (Release Update Revision) patches. As of July 2017, Oracle is modifying the Proactive Patch program for Database and Grid Infrastructure release 12.2 and […]