Infrastructure at your Service

All Posts By

Mouhamadou Diaw

Mouhamadou Diaw

Patching ODA HA from 19.8 to 19.10

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

In this blog I am describing the steps to patch an ODA HA from the version 19.8 to version 19.10. The patching was done with a customer. Thanks to Pierre. The name of the servers were changed The ODA is an X8-HA with following nodes -server-aa -server-ab Before starting the patches, be sure that you have enough space on / /u01 and /opt filesystems. Below the state of our filesystems [[email protected] Downloads]# df -h /…

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
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
Mouhamadou Diaw

Oracle Grid Infrastructure on Windows With 2 Nodes

By | Database Administration & Monitoring, Oracle | One Comment

Oracle Grid Infrastructure can be also installed on Windows server. In this blog I am explaining how this installation can be done. I am going to install an environment with to nodes. Oracle 19c is being used. We have two servers winrac1 : winrac2 : with the same characteristics I would like to note that it is just a test environment on virtual machines on VirtualBox. I did not have any dns server and I…

Read More
Mouhamadou Diaw

Oracle 19c Grid Infrastructure for a cluster

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

In this previous blog , we deal with Oracle Restart and ACFS. We saw that using ACFS with Oracle Restart will require some manual tasks. The solution is to install a Grid Infrastructure for a cluster, even if we are only using one node. I am using the same configuration -Oracle 19c -Oracle Linux Server 7.6 -Kernel 4.14.35-1902.2.0.el7uek.x86_64 As we are going to install a GI for a cluster, we will need -Public IP: 192.168.2.21…

Read More
Mouhamadou Diaw

Oracle Restart 19c and ACFS

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

In this blog we are going to install an Oracle Restart 19c with ASM Filter Driver (AFD). I am using following configuration -Oracle 19c -Oracle Linux Server 7.6 -Kernel 4.14.35-1902.2.0.el7uek.x86_64 Once the Oracle Restart installed, I will create an ACFS filesystem We will have to configure following disks for AFD -/dev/sdc -/dev/sdd The Oracle downloaded software was unzipped to the GRID_HOME [[email protected] u01]$ unzip -d /u01/app/19.0.0.0/grid LINUX.X64_193000_grid_home.zip After setting the variables ORACLE_HOME and ORACLE_BASE, we…

Read More