Infrastructure at your Service

Category

Database management

Stéphane Haby

First steps on Kusto Query Language (KQL)

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

Do you know this query language?  No, it’s time to explain you and see what it is.   “A Kusto query is a read-only request to process data and return results.” dixit Microsoft Documentation here The KQL is very simple to understand and use. I can do it then you can also do it! 😛 The first thing to know is how to call the information on a table. In this case you  need to…

Read More
Mouhamadou Diaw

Oracle 21c : Two nodes Grid Infrastructure Installation

By | Database Administration & Monitoring, Database management, Oracle | 2 Comments

Oracle 21c is actually released in the cloud, and I did some tests to setup a Grid infrastructure cluster with two nodes. I used following two VM servers to test racp1vm1 racp1vm2 Below the addresses I am using. Note that a dns server is setup 192.168.0.101 racp1vm1.dbi.lab racp1vm1 –public network 192.168.0.103 racp1vm2.dbi.lab racp1vm2 –public network 192.168.0.102 racp1vm1-vip.dbi.lab racp1vm1-vip –vitual network 192.168.0.104 racp1vm2-vip.dbi.lab racp1vm2-vip –virtual network 10.1.1.1 racp1vm1-priv.dbi.lab racp1vm1-priv –private network 10.1.1.2 racp1vm2-priv.dbi.lab racp1vm2-priv –private network…

Read More
Mouhamadou Diaw

PostgreSQL High Availability: Patroni, Ectd , HAProxy , Keepalived

By | Database Administration & Monitoring, Database management, Postgres | No Comments

Patroni is one the most famous tool that can be used to setup a high avalaibilty for PostgreSQL. In this blog I am describing a test I did. Below the environment we will use The etcd cluster will contains 3 servers etcd-server1: 192.168.56.100 etcd-server2: 192.168.56.101 etcd-server3: 192.168.56.106 HAProxy and Keepalived will be configured in this 2 servers. haproxy-server1: 192.168.56.102 haproxy-server2: 192.168.56.103 A VIP will be configured haproxyvip 192.168.56.108 We have 2 databases servers pgserver1: 192.168.56.104…

Read More
Jérôme Dubar

How long does it take to redeploy an ODA X8-2M?

By | Database Administration & Monitoring, Database management, Hardware & Storage, Operation systems, Oracle | No Comments

Introduction One of the advantage of Oracle Database Appliance is its fast deployment. Most often, the initial setup of a lite ODA (with a reimaging) only takes half a day, from unboxing until a first test database is available. Trust me, it’s hard to do better. For some reason, for example if you need to patch to the latest release and you have some intermediate patch to apply before, or if you plan to change…

Read More
Christian Weinfurtner

Oracle 21c: Blockchain Tables

By | Database Administration & Monitoring, Database management, Entreprise content management, Oracle | No Comments

Oracle Blockchain Tables With Oracle Database 20c/21c the new feature Oracle Blockchain Tables has been introduced. Blockchain Tables enable Oracle Database users to create tamper-resistant data management without distributing a ledger across multiple parties. Database security can be improved by using Blockchain Tables to avoid user fraud and administrator fraud as well. One of the main characteristics of Oracle Blockchain Tables is that you can only append data. Table rows are chained using a cryptographic…

Read More
Frank Bléger

How to quickly download the new bunch of 21c Oracle Database documentation?

By | Database Administration & Monitoring, Database management, Oracle | No Comments

Last month, Oracle released its new 21c version of the database documentation. At that time, I was looking for a quick mean to get all the books of this so-called 21c Innovation Release. I could remember I used a script to get them all in one run. Quick look at google, remembered me I used the one from Christian Antognini which hasn’t been refreshed for a while. In this blog, I will provide you the…

Read More
Mouhamadou Diaw

Oracle 21c Security : Mandatory Profile

By | Database Administration & Monitoring, Database management, Oracle, Security | No Comments

With Oracle 21c, it is now possible to enforce a password policy (length, number of digits…) for all pluggable databases or for specific pluggable databases via profiles. This is done by creating a mandatory profile in the root CDB and this profile will be attached to corresponding PDBs. The mandatory profile is a generic profile that can only have a single parameter, the PASSWORD_VERIFY_FUNCTION. The password complexity verification function of the mandatory profile is checked…

Read More
Mouhamadou Diaw

Oracle 21c Security : Gradual Database Password Rollover

By | Database Administration & Monitoring, Database management, Oracle, Security | 5 Comments

Starting with Oracle 21c, a password of an application can be changed without having to schedule a downtime. This can be done by using the new profile parameter PASSWORD_ROLLOVER_TIME This will set a rollover period of time where the application can log in using either the old password or the new password. With this enhancement, an administrator does not need any more to take the application down when the application database password is being rotated….

Read More
Mouhamadou Diaw

Oracle 21c Security : ORA_STIG_PROFILE and ORA_CIS_PROFILE

By | Database Administration & Monitoring, Database management, Oracle, Security | No Comments

In my previous blog I was testing the creation of a new Oracle 21c database. In this blog I am talking about two changes about the security. In each new release Oracle strengthens security. That’s why since Oracle 12.2, to meet Security Technical Implementation Guides (STIG) compliance, Oracle Database provided the profile ORA_STIG_PROFILE With Oracle 21c the profile ORA_STIG_PROFILE was updated and Oracle has provided a new profile to meet CIS standard : the profile…

Read More
Mouhamadou Diaw

Oracle 21c : Create a New Database

By | Database Administration & Monitoring, Database management, Oracle | No Comments

Oracle 21c is now released on the cloud. And in this blog I am just testing my first database creation . As earlier release dbca is still present. Just launch it [[email protected] admin]$ dbca After The creation some query to verify SQL> select comp_name,version,status from dba_registry; COMP_NAME VERSION STATUS —————————————- ———- ———- Oracle Database Catalog Views 21.0.0.0.0 VALID Oracle Database Packages and Types 21.0.0.0.0 VALID Oracle Real Application Clusters 21.0.0.0.0 OPTION OFF JServer JAVA Virtual…

Read More