Infrastructure at your Service

Category

Oracle

Jérôme Dubar

How to configure additional listeners on ODA

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

Introduction Oracle Database Appliance has quite a lot of nice features, but when looking into the documentation, at least one thing is missing. How to configure multiple listeners? Odacli apparently doesn’t know what’s a listener. Let’s find out how to add new ones. odacli Everything should be done using odacli on ODA, but unfortunately odacli has no commands for configuring listeners: odacli -h | grep listener nothing! The wrong way to configure a listener One…

Read More
Franck Pachot

Delphix: a glossary to get started

By | Oracle | No Comments

By Franck Pachot . dbi-services is partner of Delphix – a data virtualization platform for easy cloning of databases. I’m sharing a little glossary to get started if you are not familiar with the terms you see in doc, console or logs. Setup console The setup console is the first interface you will access when installing Delphix engine (“Dynamic Data Platform”). You import the .ova and start it. If you are on a network with…

Read More
Clemens Bleile

Oracle Blockchain Tables: COMMIT-Time

By | Oracle | No Comments

Oracle Blockchain Tables are available now with Oracle 19.10. (see Connor’s Blog on it), they are part of all editions and do not need any specific license. I.e. whenever we need to store data in a table, which should never be updated anymore and we have to ensure data cannot be tampererd, then blockchain tables should be considered as an option. As Oracle writes in the documentation that blockchain tables could e.g. be used for…

Read More
Jérôme Dubar

Oracle Database Appliance: what have you missed since X3/X4/X5?

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

Introduction ODA started to become popular with X3-2 and X4-2 in 2013/2014. These 2 ODAs were very similar. The X5-2 from 2015 was different with 3.5 inches disks instead of 2.5 inches and additional SSDs for small databases (FLASH diskgroup). All these 3 ODAs were running 11gR2 and 12cR1 databases and were managed by the oakcli binary. If you’re still using these old machines, you should know that there is a lot of differences compared…

Read More
Franck Pachot

Oracle Rolling Invalidate Window Exceeded(3)

By | Oracle | No Comments

By Franck Pachot . This extends a previous post (Rolling Invalidate Window Exceeded) where, in summary, the ideas were: When you gather statistics, you want the new executions to take into account the new statistics, which means that the old execution plans (child cursors) should be invalidated You don’t want all child cursors to be immediately invalidated, to avoid an hard parse storm, and this is why this invalidation is rolling: a 5 hour window…

Read More
Mouhamadou Diaw

Oracle 21c : Two nodes Grid Infrastructure Installation

By | Database Administration & Monitoring, Database management, Oracle | 2 Comments

Oracle 21c is actually released in the cloud, and I did some tests to setup a Grid infrastructure cluster with two nodes. I used following two VM servers to test racp1vm1 racp1vm2 Below the addresses I am using. Note that a dns server is setup 192.168.0.101 racp1vm1.dbi.lab racp1vm1 –public network 192.168.0.103 racp1vm2.dbi.lab racp1vm2 –public network 192.168.0.102 racp1vm1-vip.dbi.lab racp1vm1-vip –vitual network 192.168.0.104 racp1vm2-vip.dbi.lab racp1vm2-vip –virtual network 10.1.1.1 racp1vm1-priv.dbi.lab racp1vm1-priv –private network 10.1.1.2 racp1vm2-priv.dbi.lab racp1vm2-priv –private network…

Read More
Clemens Bleile

Oracle autoupgrade on Windows and plugin to a Container DB with virtual accounts

By | Oracle | No Comments

In a project I recently had to upgrade an Oracle 12.2.-DB to 19.9. and at the same time migrate from the non-container architecture to the container architecture. The interesting part here is to do this on Windows. Actually both steps (upgrade and plugin) are possible using the autoupgrade tool , which is the preferred tool to do Oracle upgrades today. Before doing the upgrade at the customer, I performed 2 tests in my personal environment:…

Read More
Franck Pachot

Learn ODA on Oracle Cloud

By | Oracle | No Comments

By Franck Pachot . You want to learn and practice your ODA command line and GUI without having an ODA at home? It should be possible to run the ODA image on VirtualBox but that’s probably a hard work as it is tied to the hardware. About the configuration, you can run the Oracle Appliance Manager Configurator on your laptop but I think it is not compatible with the latest odacli. However, for a long…

Read More
Franck Pachot

19c serverless logon trigger

By | Oracle | No Comments

By Franck Pachot . I thought I already blogged about this but can’t find it. So here it is, with a funny title. I like to rename oracle features by their user point of view (they are usually named from the oracle development point of view). This is about setting session parameters for Oracle connections, directly from the connection string, especially when it cannot be set in the application (code) or in the DB server…

Read More