Infrastructure at your Service
During the last DockerCon EU in Barcelona, I heard a lot about Helm with K8s architectures. It was also a good opportunity to write about it after attending to this conference. In a nutshell, Helm is a package manager for K8s and you may think of it like the other ones available on the Linux side with apt, yum or zypper to cite few of them. Helm charts are a key component of the Helm architecture and…
You may have heard that : Red Hat Enterprise Linux 8 is available for downloading in beta version since few weeks… You want to download it ? Click here. A significant change coming with this new version is the way the applications packages are provided. As you know, up to RHEL7 packages were downloaded via repositories listed in .repo files located by default under /etc/yum.repos.d/. This is still the same with RHEL8, but two new…
What is Oracle Text? Oracle Text provides indexing, word and theme searching, and viewing capabilities for text in query applications and document classification applications. Oracle text activation for a user create user ORATXT identified by oratxt ; grant ctxapp to ORATXT ; grant execute on ctxsys.ctx_cls to ORATXT ; grant execute on ctxsys.ctx_ddl to ORATXT ; grant execute on ctxsys.ctx_doc to ORATXT ; grant execute on ctxsys.ctx_output to ORATXT ; grant execute on ctxsys.ctx_query to…
As encryption solution in SQL Server, Transparent Data Encryption (TDE) is simple and quick to set up. That’s why this is a common encryption mechanism. TDE encrypts data with a certificate at the page level, before SQL Server writes on the disk. It is supposed to protect your environment from some scenarios, where SQL Server files (backups or data) are stolen. By default the certificate used for encryption is stored in the master database. But…
As many Oracle Database Administrators, I am a regular user of Oracle Enterprise Manager in order to monitor or administer my client’s databases. I am lucky because most of them have the diagnostic pack and the tuning pack :=). But we always have to be curious and discover new products. As described by my colleague Nicolas Penot, I installed Foglight: https://blog.dbi-services.com/foglight-monitoring-solution-for-databases-part-01/ https://blog.dbi-services.com/foglight-monitoring-solution-for-databases-part-02/ The installation was successful and very quick to realize, remember when you have…
In short, a very interesting event for both Devs and Ops. Every day was organized around workshops, hands-on-labs sessions and Hallway tracks. My colleague Mehdi Bada and I tried to attend as much sessions as possible but obviously it was difficult to cover all the topics. Anyway, workshops and hands-on-labs were very interesting especially if you like to mix theory and practice. But I had to admit sometimes we got in trouble to keep up…
I was looking for a build-in function to get the hostname of the server hosting my PostgreSQL cluster. But seems that there is no build-in function. Looking in the extensions, I find the extension hostname which can allow to get the database server host name. In this this blog I am explaining how to install and how to use it. The installation is very easy. The first step is to download it here . After…
PostgreSQL 12 is under development but tests can be done. Steps to install this version can be found in this dbi blog . Many thanks to Daniel. While reading the documentation I found that there is a new parameter for pg_upgrade. This new parameter is –socketdir. Why this parameter? In fact the path name of a UNIX socket is allowed to be maximally 108 chars long. Before PostgreSQL 12, the default directory for the sockets…
Wednesday was the last day of the DockerCon18 Europe. Like the previous day, we started the journey by a keynote of 2 hours, more oriented “Docker Community”, the core message of the keynote, the community is one of the pillars of open source technologies and Docker Inc want to push more and more the community aspect. The community is growing very fast and competitive. They take the opportunity to award the community leader of the year and a…
Tuesday was the second day in Barcelona for the DockerCon18. We attend the first general session in the morning. It was a mix of presentations, live demos and the participation of Docker big customer in EMEA such as Société Général in France, who present us the impact of Docker in their daily business. The main message of the first part of the keynote was: “How Docker can help you to make the digital transformation of your business”….
Introduction I am currently setting up a new “Base Image” virtual machine (Red Hat Enterprise Linux 7.6) which will be used to create 6 brand new Oracle database servers requested by a customer. Besides installing and configuring the OS, I also have to install 3 Oracle Homes and one Cloud Control Agent 13c. An OMS13c server already exists including an Agent patched with the EM-AGENT Bundle Patch 13.2.0.0.181031 (28680866) : oracle@oms13c:/home/oracle/ [agent13c] opatch lsinventory |…
Today I was onsite at my customer and he told me: I can no longer create databases on my ODA X7-2HA, every time I try to use odacli create-database it fails, please help. Ok, let’s check what happens, the customer shares the Oracle Homes, he wants to create a 11.2.0.4 database: [root@robucnoroda020 ~]# odacli list-dbhomes ID Name DB Version Home Location Status —————————————- ——————– —————————————- ——————————————— ———- 157bfdf4-4430-4fb1-878e-2fb803ee54bd OraDB11204_home1 11.2.0.4.180417 (27441052, 27338049) /u01/app/oracle/product/11.2.0.4/dbhome_1 Configured 2aaba0e6-4482-4c9f-8d98-4a9d72fdb96e…
