BE SHARING

Engineered system

ODA database been stuck in deleting status

14.08.2018 by Marc Wagner

Facing an internal inconsistency in the ODA derby database is very painful (see https://www.dbi-services.com/blog/oda-lite-what-is-this-odacli-repository/ for more info about the derby database). I have recently faced a case where the database deletion was failing and the database remained then in "Deleting"(…)

Database Administration & Monitoring

ODA, network interface and configure-firstnet

27.07.2018 by Marc Wagner

Deploying new Bare Metal ODA X7-2S or 2M, I have been curious how configure-firstnet would interact with the fiber and copper ethernet network interfaces. Reading documentation on the web, I could not clearly understand if it is mandatory to have(…)

Database Administration & Monitoring

ODA – Reducing number of cores : Getting error DCS-10045

04.03.2018 by Marc Wagner

To perform some tests in order to determine the accurate number of cores to be used by the database application, I had to increase and decrease the number of CPU cores on an ODA using the DCS stack. When increasing(…)

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(…)

Database Administration & Monitoring

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

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

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 – 32GB template but got a database with 16GB SGA???

06.03.2017 by David Hueber

I got an interesting question today from a customer which created a database on ODA. He selected the template odb-04 which shows 32GB Memory but got a database with a 16GB SGA… Is it due to the PGA size, a(…)