Database Administration & Monitoring ACFS 12.1.0.2 on Oracle Linux 7.1 10.07.2015 by Daniel Westermann Recently we wanted to create an ACFS filesystem on a brand new 12.1.0.2 GI installation on Oracle Linux 7.1. According to the documentation this should not be an issue as “Oracle Linux 7 with the Unbreakable Enterprise kernel:(…)
Application integration & Middleware Kerberos SSO with Liferay 6.1 v2 07.07.2015 by Morgan Patou A little bit less than one year ago, I wrote a blog about how to setup the Kerberos SSO on Liferay using Apache httpd as a front-end, Tomcat as a back-end and with auth_mod_kerb and mod_jk to transfer the(…)
Database management, Oracle RESULT_CACHE hint expiration options 05.07.2015 by Oracle Team By Franck Pachot . The result cache is very nice when base tables are static: get the result without any buffer get, without any join or sorts. But as soon as any DML occurs on one of the tables(…)
Database Administration & Monitoring Testing the just released PostgreSQL 9.5 Alpha in a docker container 03.07.2015 by Daniel Westermann On the 2cnd of July the PostgreSQL Global Development Group released an alpha version of the upcoming PostgreSQL 9.5. The same day, Josh Berkus, another of those PostgreSQL core team members released a docker image for(…)
Database management, Oracle Multitenant vs. schema based consolidation 30.06.2015 by Oracle Team By Franck Pachot . If you want to install multiple instances of a software, for example you host the ERP for several companies or subsidiaries, you have 3 solutions: have one database and multiple schema have multiple databases have(…)
Hardware & Storage ODA – VMs possibilities & performances 30.06.2015 by David Hueber As you know it is possible to install the ODA in a virtualized mode and to take avantages from all cores not licensed with Enterprise Edition for additional VMs. The question is what could we do with it and(…)
Database Administration & Monitoring Indexing for like/similarity operations 29.06.2015 by Daniel Westermann Indexing queries for like/similarity conditions is not that easy with the usual index types. The only option you have with btree indexes (especially if the wild-card is at the beginning of the filter) is to create a partial(…)
Database management, Oracle Oracle Log Writer and Write-Ahead-Logging 28.06.2015 by Oracle Team By Franck Pachot . I posted a tweet with a link to a very old document – 20 years old – about ‘internals of recovery’. It’s a gem. All the complexity of the ACID mecanisms of Oracle are(…)
Database management, Oracle Oracle Database Cloud Service – My first trial 27.06.2015 by Oracle Team By Franck Pachot . The cloud has been annouced, I want to try. From the cloud.oracle.com/database website, there is Trial only for the ‘Database Schema Service’ so I asked fot it, received an e-mail with connection info and it(…)
Database Administration & Monitoring Quickly create a hundred databases and users 26.06.2015 by Daniel Westermann Do you need a hundred databases and users for training etc. in PostgreSQL? Just a few lines of code: [postgres8@oel7 data]$ cat create_databases.sh #!/bin/bash NUMOFDBS=100 for i in `seq ${NUMOFDBS}`; do psql -q -c "create user u${i}(…)