Infrastructure at your Service

Oracle 12c Archives - Blog dbi services

Mouhamadou Diaw

Using Oratcptest

By | Database Administration & Monitoring | No Comments

Last day I did some tests with Oratcptest. This a command line tool which can be used to measure network bandwidth and network latency between client and server. In this blog I am going to show how to use this tool in a DataGuard environment. I am using a DataGuard environment with following configuration. Configuration – PROD Protection Mode: MaxAvailability Members: PROD_SITE1 – Primary database PROD_SITE2 – Physical standby database PROD_SITE3 – Physical standby database…

 
Read More
Petre Radut

New features and known issues with RMAN tool on Oracle database 12.1.0.2

By | Database Administration & Monitoring, Oracle | 3 Comments

Oracle Database 12c has new enhancements and additions in Recovery Manager (RMAN). The RMAN tool continues to enhance and extend the reliability, efficiency, and availability of Oracle Database Backup and Recovery. Below, I will mention couple of new features for the RMAN duplicate command, but also how to avoid issues that can happen on the creation of the temporary files. FEATURES: <INFO>Using BACKUPSET clause : In previous releases, active duplicates were performed using implicit image…

 
Read More
Mouhamadou Diaw

Database Vault : Rules, Rule Sets and Command Rules

By | Database Administration & Monitoring | No Comments

In a previous blog I talked about protecting data using Realms. With Database Vault we can also protect our database against some SQL statements. These statements can include SELECT, ALTER SYSTEM, database definition language (DDL), and data manipulation language (DML) statements. We can do this with Command Rules. In this blog I am demonstrating how we can use a Command Rule to prevent SYS from creating a new pluggable database in a multitenant environment. Before…

 
Read More
Jérôme Dubar

One command database upgrade on ODA

By | Database Administration & Monitoring | No Comments

The 12.2 finally arrived on ODA and is now available on all generations. Modern ODAs are now supporting 11.2.0.4, 12.1.0.2 and 12.2.0.1 database engines, and these 3 versions can work together without any problem. You probably plan to upgrade some old databases to the latest engine, at least those still running on 11.2. As you may know, 11.2  is no more supported with premier support since January 2015: it’s time to think about an upgrade….

 
Read More
Franck Pachot

Multitenant, PDB, ‘save state’, services and standby databases

By | Oracle | No Comments

By Franck Pachot . Creating – and using – your own services has always been the recommendation. You can connect to a database without a service name, though the instance SID, but this is not what you should do. Each database registers its db_unique_name as a service, and you can use it to connect, but it is always better to create your own application service(s). In multitenant, each PDB registers its name as a service,…

 
Read More
Franck Pachot

Unplug an Encrypted PDB (ORA-46680: master keys of the container database must be exported)

By | Oracle | No Comments

By Franck Pachot . In the Oracle Database Cloud DBaaS you provision a multitenant database where tablespaces are encrypted. This means that when you unplug/plug the pluggable databases, you also need to export /import the encryption keys. You cannot just copy the wallet because the wallet contains all CDB keys. Usually, you can be guided by the error messages, but this one needs a little explanation and an example.  

 
Read More
Marc Wagner

ORACLE 11g to 12c RMAN catalog migration

By | Database management, Oracle | 2 Comments

This is a small migration demo of a 11g catalog (RCAT11G) to a new 12c catalog (RCAT12c). Demo databases environments have been easily managed thanks to DBI DMK tool. oracle@vmreforadg01:/home/oracle/ [RCAT11G] sqh SQL*Plus: Release 11.2.0.4.0 oracle@vmtestoradg1:/home/oracle/ [RCAT12C] sqh SQL*Plus: Release 12.2.0.1.0   Current configuration Displaying the list of databases registered in the RCAT11g catalog. SQL> select instance_name from v$instance; INSTANCE_NAME —————- RCAT11G SQL> select * from rcat.rc_database;     DB_KEY  DBINC_KEY       DBID NAME     RESETLOGS_CHANGE# RESETLOGS ———-…

 
Read More
Mouhamadou Diaw

Automatic Data Optimization Part I : Compression Tiering

By | Database Administration & Monitoring | No Comments

Nowadays data are increasing more and more. And some challenges we can face can be how to reduce storage costs and how to improve performance. With Oracle 12c, the feature Automatic Data Optimization (ADO) can help us. In this first blog we will see how we can use ADO to compress data under predefined conditions. ADO is part of Information Lifecycle Management (ILM). Note that ADO requires Advanced Compression Option. In this article we are…

 
Read More
Franck Pachot

Keep your orapw password file secure

By | Oracle | 2 Comments

By Franck Pachot . This is a small demo I did when I’ve found a database password file (orapw) lying around in /tmp with -rw-rw-rw- permissions, to show how this is a bad idea. People think that the orapw file only contains hashes to validate a password given, and forget that it can be used to connect to a remote database without password.  

 
Read More