Infrastructure at your Service

All Posts By

Mouhamadou Diaw

Mouhamadou Diaw

Dbvisit 10 on Oracle Database Appliance

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

Dbvisit Standby can also be installed on Oracle Database Appliance (ODA). The installation is the same that on any other Linux box. I did an install of Dbvist 10 on an ODA 19.12 for a customer and in this blog I am describing the on an ODA steps. The configuration is below -The primary server is oda-prod-01 -The standby server is oda-dev-01 -The database name is ORCL Dbvisit should be installed on both servers (primary…

Read More
Mouhamadou Diaw

Install Enterprise Manager 13c R5: Check the db edition Failed

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

A few days ago, I was setting an Enterprise Manager 13c R5 for a client. The configuration used is the following -The EM binaries are installed in a separate server than the database -The database of the repository is an Oracle pluggable database 19.12 The server for the EM binaries has following OS [[email protected]:/opt/oracle]$ cat /etc/os-release NAME=”Red Hat Enterprise Linux” VERSION=”8.4 (Ootpa)” ID=”rhel” ID_LIKE=”fedora” VERSION_ID=”8.4″ PLATFORM_ID=”platform:el8″ PRETTY_NAME=”Red Hat Enterprise Linux 8.4 (Ootpa)” ANSI_COLOR=”0;31″ CPE_NAME=”cpe:/o:redhat:enterprise_linux:8.4:GA” HOME_URL=”https://www.redhat.com/”…

Read More
Mouhamadou Diaw

Configuring ODBC : SQLServer Access From Oracle

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

Sometimes you need to access to your SQLServer from your Oracle database. There is many ways and tools to do this. In this blog I am describing how to perform this task using ODBC. The configuration is below -Oracle Linux server : serverora 192.168.56.41 with Oracle 19 database orcl -Windows server : winrac1 192.168.56.100 with SQLServer Express On my Windows server, I have a database named testdb and a table named article. The first step…

Read More
Mouhamadou Diaw

Oracle Database Appliance KVM Virtual Instance on ODA 19.12

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

KVM virtualization uses a kernel-based virtual machine (KVM) to create a virtualized environment for your Linux applications.In this blog I want to share some tasks I did at a client. The client is using ODA 19.12. The databases are created on the bare metal and for the applications, we decide to create virtual machines. What do I need for a VM creation? -VMstorage for the creation of vdisks -Vdisks will be attached to the VMs…

Read More
Mouhamadou Diaw

Oracle Database Appliance 19.12 Deployment

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

In this blog I am describing the deployment of an ODA with the version 19.12 Following patches will be needed -Patch 30403643: Oracle Database Appliance ISO Image -Patch 30403673: Oracle Database Appliance Grid Infrastructure Clone for ODACLI/DCS stack -Patch 33152232: Oracle Database Appliance Server Patch for ODACLI/DCS Stack -Patch 30403662: Oracle Database Appliance Database Clone 19.12.0.0.210720 for ODACLI/DCS stack The first step I did is image the server with the latest 19.12 image available. Once…

Read More
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 | One Comment

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