Infrastructure at your Service

Mehdi Bada

Managing Oracle Big Data Cloud – CE with REST API

By | Big Data, Cloud, Oracle | 2 Comments
 

 In this blog post, we will see how to manage Oracle Public Cloud Big Data service Compute Edition with REST API. Scheduling the start/stop/restart of a metered PaaS in the Oracle Cloud can be interesting for managing efficiently the consumption of your cloud credits. We should first have a look at the official documentation so as to understand what the API is composed of. https://docs.oracle.com/en/cloud/paas/big-data-compute-cloud/csbdp/QuickStart.html  Use the following URL composition to get access to REST endpoint: https://region-prefix.oraclecloud.com/resource-path According…

Read More
Stephane Biehler

Documentum: IndexAgent uninstalled continues to queue requests

By | Application integration & Middleware | No Comments
 

 We had a strange behavior by a customer regarding the indexing queue. We used to have two IA configured and we uninstalled one. I figured out that we still had indexing queue requests for the old index agent while it was totally uninstalled. I checked the following objects to see if the agent was still configured somewhere: dm_fulltext_index, dm_ftengine_config, dm_ftindex_agent_config. But the old IA was not declared anymore. The main problem is that it continued…

Read More
Eric Simbozel

SQL Server Management Studio 17.3 New Features

By | Database Administration & Monitoring | No Comments
 

 Regularly, Microsoft SQL Server comes up with its new features, and in particular SSMS 2017 17.3 in this post, i present you a new feature : Import flat files Wizard How does it works : Open SSMS, and right click on a selected database Choose Import Flat File   Click Next   Tip the Path of your file to import and the new target table’s name this is a preview of the file content Click Next…

Read More
Franck Pachot

Oracle Database Multilingual Engine (MLE)

By | Oracle | No Comments
 

 My ODC appreciation blog post was about Javascript in the database running in the beta of the Oracle Database Multilingual Engine (MLE). Here I’ll detail my first test which is a comparison, in performance, between a package written in Javascript, running in the MLE, and one written and running in PL/SQL.

Read More
Daniel Westermann

Changing the LOCALE in CentOS/RedHat 7

By | Database Administration & Monitoring | No Comments
 

 What I really don’t like is this: Someone wants me to work on a Linux system for whatever purpose and then I get messages like this: postgres@pgbox:/home/postgres/ [pg960final] cat /proc/sysrq-trigger cat: /proc/sysrq-trigger: Permission non accordée or: postgres@pgbox:/home/postgres/ [pg960final] cat /proc/sysrq-trigger cat: /proc/sysrq-trigger: Permiso denegado It is not that I don’t like French or Spanish but usually (well, not in that simple case) I am not able to translate that without the help from others. So…

Read More
Daniel Westermann

udev rules for ASM devices on RHEL 7

By | Database Administration & Monitoring | 2 Comments
 

 Preparing the storage devices for use with ASM is one of the first tasks you should do. When you do not want to use ASMLib then udev is what you should use for this. As the order/naming of the devices in the device tree is not guaranteed (e.g. dm-1 is not guaranteed to be the same device after a reboot of the system) you need a way to fix this and that is what udev…

Read More
Daniel Westermann

Going from SLES12 SP2 to SLES12 SP3, online

By | Database Administration & Monitoring | No Comments
 

 SLES 12 SP3 was released some time ago and as we have customers running on that I thought it might be a good idea to test the upgrade from SP2 to SP3. Actually it turned out this is quite easy and can be done online. The supported methods for doing this is either by using YaST or Zypper directly. As I wanted to stay on the command line I’ll use Zypper for the scope of…

Read More
Franck Pachot

ODA X7

By | Oracle | 7 Comments
 

 ODA X6-2 So, the ODA X6 End of Life seems to be planned for October, and be careful, as far as I know, this concerns also the storage expansion. The main feedback from the X6-2 series were: not enough cores when consolidating multiple databases in M, L and HA not enough storage on HA when compared with X5-2 Standard Edition on HA would be great for cheaper RAC The position of the ‘Large’ version of…

Read More
Stéphane Haby

SQL Server 2017 RTM is available: time to try!

By | Database Administration & Monitoring, Database management, SQL Server | No Comments
 

 Now SQL Server 2017 RTM  is available. The first step is to go to the Evaluation Center here After completing the registration with your contact information, you download the file “SQL Server 2017-SSEI-Eval.exe” Run SQL Server 2017-SSEI-Eval.exe and now it begins! A first screen gives me 3 choices to install SQL Server Basic: easy and fast to download and install SQL Server 2017 Custom: Download the setup package and launch the SQL Installation Center Download…

Read More