Infrastructure at your Service

All Posts By

Nicolas Penot

Nicolas Penot

Ansible Custom Interactive Dynamic Inventory

By | Cloud, Development & Performance, Entreprise content management | No Comments

When working with an Ansible dynamic inventory, you may want to update it from your playbook on the fly. For instance, you may want to create a server and then install an application on it without calling a second playbook or developing specific code to create a runtime group (e.g. “add_host” module). Or you may want to update the inventory on the fly without having to wait for an asynchronous mechanism to be triggered. This…

Read More
Nicolas Penot

Git collaboration: quick start

By | Development & Performance | No Comments

Git collaboration: quick start If you want to keep the git repository of your project clean and predictive (which is highly recommendable), here is a simple workflow to follow. For the sake of this article, we are going to join the MongoDB project. First step: work safely on your branch When joining the project, the first step to get a local copy in your laptop: $ cd my_working_directory $ git clone [email protected]:nico/mongo.git Once you do…

Read More
Nicolas Penot

Sparse OVM virtual disks on appliances

By | Database Administration & Monitoring | No Comments

For some reason, you may need to sparse OVM virtual disks in an Oracle appliances. Even though that feature is present trough the OVM Manager, most of the Oracle appliances doesn’t have any OVM Manager deployed on it. Therefore if you un-sparse your virtual disk by mistake, you are on your own. This is a note on how to sparse virtual disks which are un-sparse. Stop I/Os on the virtual disk First, ensure the VM…

Read More
Nicolas Penot

Red Hat 8 Server in 9 minutes into the Google Cloud

By | Database Administration & Monitoring | No Comments

Do you have 9 minutes to learn how to quick start with the Google Cloud? Here is a simple copy/past procedure to successfully deploy a Red Hat 8 compute server into the Cloud. Installation of the Google command client Download first the client and uncompress it: $ curl -O https://dl.google.com/dl/cloudsdk/channels/rapid/downloads/google-cloud-sdk-255.0.0-linux-x86_64.tar.gz $ tar zxvf google-cloud-sdk-255.0.0-linux-x86_64.tar.gz Optionally configure the PATH for your comfort: $ ./google-cloud-sdk/install.sh That command will connect your local environment with your cloud. Just follow…

Read More
Nicolas Penot

Understand Oracle Text at a glance

By | Application integration & Middleware, Oracle | No Comments

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…

Read More
Nicolas Penot

Foglight: Monitoring solution for databases [Part 02]

By | Database Administration & Monitoring | No Comments

Foglight is a powerful and all in one monitoring solution to monitor various IT infrastructure assets like databases, servers, applications and so on. Whenever you need to monitor a special assets like an Oracle database, a Windows server, a Tomcat server or any other component you can do so by adding a Cartridges. A Cartridges is like a plugin for a specific technology. As we already seen how to install Foglight in a previous article…

Read More
Nicolas Penot

Foglight: Monitoring solution for databases [Part 01]

By | Database Administration & Monitoring | No Comments

What is Foglight? Foglight is a solution from Quest which promises to provide visibility into issues affecting the application and end user experience. The solution also helps you to find quickly the root cause in application, database, infrastructure, or network to resolve issues by providing “Intuitive workflows” Let’s give it a try! Preparing the installation Requirements for installing Foglight are: A machine to host the Management Server. Ideally dedicated Administrator or root access to all…

Read More
Nicolas Penot

[Oracle 18c new feature] Quick win to improve queries with Memoptimized Rowstore

By | Uncategorized | One Comment

With its 18th release Oracle comes with many improvements. Some of them are obvious and some of them more discrete. This is the case of the new buffer area (memory area) called the Memoptimize pool. This new area, part of the SGA, is used to store the data and metadata of standard Oracle tables (heap-organized tables) to improve significantly the performance of queries having filter on PKs. This new MEMPTIMIZE POOL memory area is split…

Read More