All articles

Error starting D2 4.5 on Tomcat 8 No class found: JSAFE_SecureRandom

When installing D2 and launching the tomcat server you can have an error on a missing lib: JSAFE_SecureRandom. Here’s the trace you can have: 2018-01-17 17:32:19 [DEBUG] [localhost-startStop-1] - c.e.c.d.contents.D2FileCleaningTracker : Init D2FileCleaningTracker with /pkgs/dms-tomcat/D2_TOMCAT_HOME/temp/D2FileCleaningTracker_D2.ser 2018-01-17 17:32:20 [ERROR](…)

18c dbms_xplan note about failed SQL Plan Baseline

By Franck Pachot . SQL Plan Baselines is a great feature for plan stability: you capture the plans that you accept. However, if the data model changes and the accepted plans cannot reproduce, the optimizer will come with a new(…)

ODA migration challenges: Non-OMF to OMF + 11.2.0.3 to 11.2.0.4

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

ORA-12547 TNS lost contact on SLES12 and oracle 11.2.0.x

On a client’s site, I have migrated successfully Oracle 12c databases from RedHat to SLES12 without any problem. I encountered a problem doing the same work with Oracle 11.2.0.3 and oracle 11.2.0.4 on SLES 12. Once I have moved the(…)

18c, Cloud First and Cloud Only features: think differently

By Franck Pachot . Remember the times when the Oracle Software features were the same on all platforms? Where Oracle databases could be ported to any relevant platform? Where we were able to try any feature, freely, by downloading the(…)

A free persistent Google Cloud service with Oracle XE

By Franck Pachot . In a previous post I've listed several free online services which run an Oracle XE so that you can test your SQL easily. You may want use Oracle XE further, with full(…)

PDB upgrade from 12c to 18c

By Franck Pachot . Oracle 18c is out, in the Oracle Cloud, and the first thing I do with a new version is testing how long it takes to upgrade a previous version PDB by unplug/plug. Faster upgrade should be(…)

Configuring huge pages for your PostgreSQL instance, Debian version

In the last post we had a look at how you can configure huge pages on RedHat and CentOS systems. For Debian and Debian based systems the procedure is different as Debian does not come with(…)

Configuring huge pages for your PostgreSQL instance, RedHat/CentOS version

Almost every PostgreSQL I get in touch with is not configured to use huge pages, which is quite a surprise as it can give you a performance boost. Actually it is not the PostgreSQL instance you need(…)

ODA Lite: What is this ‘odacli’ repository?

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