Infrastructure at your Service


Oracle database appliance Archives - Page 4 of 4 - Blog dbi services

Jérôme Dubar

How to patch your ODA lite to

By | Database Administration & Monitoring, Database management, Hardware & Storage, Oracle | 11 Comments

Even you don’t need 18c, or you’re not ready for this release, this patch will also update your 11gR2, 12cR1 and 12cR2 databases to the latest PSU available on ODA, it means for example the patchset from last July if you’re using 12cR1. Here is how to apply this latest patch for your ODA lite. In this example, the patch was applied on an X6-2S ODA running on previous release: 1) Download the patch…

Read More
Clemens Bleile

Recommended DB Parameters on the Oracle Database Appliance (ODA)

By | Database Administration & Monitoring, Database management, Hardware & Storage, Oracle | No Comments

When creating a DB on the ODA using # oakcli create database -db <db-name> a template is used to set a couple of DB parameters like e.g. _datafile_write_errors_crash_instance=FALSE _db_writer_coalesce_area_size=16777216 _disable_interface_checking=TRUE _ENABLE_NUMA_SUPPORT=FALSE _FILE_SIZE_INCREASE_INCREMENT=2143289344 _gc_policy_time=0 _gc_undo_affinity=FALSE db_block_checking=’FULL’ db_block_checksum=’FULL’ db_lost_write_protect=’TYPICAL’ filesystemio_options=’setall’ parallel_adaptive_multi_user=FALSE parallel_execution_message_size=16384 parallel_threads_per_cpu=2 use_large_pages=’ONLY’ In recent projects I saw a couple of DBs running on ODA, which did not have (all) those parameters set, because the DBs were migrated from a non-ODA-platform and the customer took over…

Read More
David Hueber

ODA 12.1.X.X.X – add a multiplexed control file under ACFS

By | Database management | 6 Comments

Since version 12, ODA stores databases on ACFS volumes instead of ASM directly. This slightly changed the way the files are managed and administer. This articles presents how to multiplex your control files on ACFS. At first database creation, ODA set up 3 ACFS volumes to store all non-CDB databases (CDB are managed on dedicated volumes): /dev/asm/datastore-386 62G 5.2G 57G 9% /u01/app/oracle/oradata/datastore /dev/asm/datastore-286 1.7T 871G 836G 52% /u02/app/oracle/oradata/datastore /dev/asm/datastore-360 2.2T 5.6G 2.2T 1% /u01/app/oracle/fast_recovery_area/datastore These…

Read More
Grégory Steulet

All you need to know about Oracle Database licensing with VMware

By | Hardware & Storage | 81 Comments

You are running Oracle on VMware and are not 100% sure that you are compliant with the Oracle licensing rules? This article is for you! As I have been confronted several times with Oracle License reviews with VMware installations, I decided to write this article in order to provide answers to the most frequent questions I have received from customers. Introduction Licensing is not an easy topic to address and this difficulty is not specific…

Read More
Oracle Team

Oracle Database Appliance: new ODA X3-2 architecture

By | Operation systems | No Comments

A few weeks ago, I posted an article about Oracle Database Appliance, focusing on ODA version However, a new update of ODA, version, was released by Oracle on 5 March. This posting will focus on the new ODA release, which leads to a new hardware architecture. So, what’s new with this new ODA version? According to the Release Notes, ODA now supports the new X3-2 architecture which allows additional hardware and storage capabilities. Physical…

Read More
Oracle Team

Oracle Database Appliance (ODA) – an overview

By | Operation systems | One Comment

Last february, I had the chance to attend an Oracle presentation about ODA: Oracle Database Appliance. I found it interessant to share what I have learned about this technology. Which, I confess, convinced me. Summary Before developing the software and hardware components, here is a small overview of ODA. ODA is an all in one solution providing Hardware, Operating System, and database components. It comes in a 4U rack server form, composed of two distinct…

Read More