Database Administration & Monitoring ODA migration challenges: Non-OMF to OMF + 11.2.0.3 to 11.2.0.4 27.02.2018 by David Hueber To do some application and performances tests, I had to copy a database from a third party Linux server to an ODA X7-2M. Looks pretty simple on the paper, but 2 small challenges came into the game. The first was(…)
Oracle ODA Lite: What is this ‘odacli’ repository? 23.02.2018 by Oracle Team By Franck Pachot . When ODA Lite was introduced, with ODA X6-2 S/M/L, and now with ODA x7-2 S/M, a new 'odacli' was there to manage it. It will probably replace the oakcli for ODA HA as well in the(…)
Database Administration & Monitoring, Hardware & Storage ODA – manually resetting a CPU alert using Fault Manager 23.02.2018 by David Hueber While supporting since several years ODAs of different generations and versions, we faced time to time some hardware alerts sent back by the ILOM. However all of them are not related to real hardware issues and are false positive. To(…)
Database Administration & Monitoring, Hardware & Storage ODA 12.2.1.2.0: Some curious password management rules 22.02.2018 by David Hueber While deploying an ODA based on the DCS stack (odacli), it is mandatory to provide a "master" password at appliance creation. The web GUI provides for that a small tooltip which describes the rules applied on password management. However it(…)
Database Administration & Monitoring, Hardware & Storage ODA X7-2S/M 12.2.1.2.0: update-repository fails after re-image 21.02.2018 by David Hueber While playing with a brand new ODA X7-2M, I faced a strange behaviour after re-imaging the ODA with the latest version 12.2.1.2.0. Basically after re-imaging and doing the configure-firstnet the next step is to import the GI clone in the(…)
Database Administration & Monitoring One command database upgrade on ODA 20.02.2018 by Jérôme Dubar 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(…)
Database Administration & Monitoring ODA 12.2.1.2.0 – VLAN Management 20.02.2018 by David Hueber Virtual Local Area Network (VLAN) have become since several years a standard in enterprise class networks. Most enterprises are now segregating their network, especially for security reasons, between server and user or prod and test or applications and backup and(…)
Oracle ODA X6 2S 2M 2L HA: Small Medium Large and High Availability 14.08.2017 by Oracle Team By Franck Pachot . There are 4 models of Oracle Database Appliance with the new ODA X6 which is for the moment the latest ODA hardware version. One is similar to the(…)
Database Administration & Monitoring, Database management, Hardware & Storage, Oracle Recommended DB Parameters on the Oracle Database Appliance (ODA) 18.07.2017 by Clemens Bleile 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(…)
Oracle ODA X6 installation: re-image 28.06.2017 by Oracle Team By Franck Pachot . The Oracle Database Appliance is shipped with a bare-metal installation which may not be the latest version. You may want to have it virtualized, or get the latest version to avoid further upgrade, or install an(…)