BE SHARING

Mouhamadou Diaw

Oracle 21c Security : Gradual Database Password Rollover

10.12.2020 by Mouhamadou Diaw

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(…)

Database Administration & Monitoring

Oracle 21c Security : ORA_STIG_PROFILE and ORA_CIS_PROFILE

10.12.2020 by Mouhamadou Diaw

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(…)

Database Administration & Monitoring

Oracle 21c : Create a New Database

09.12.2020 by Mouhamadou Diaw

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(…)

Database Administration & Monitoring

Oracle Grid Infrastructure on Windows With 2 Nodes

11.11.2020 by Mouhamadou Diaw

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(…)

Database Administration & Monitoring

Oracle 19c Grid Infrastructure for a cluster

30.10.2020 by Mouhamadou Diaw

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,(…)

Database Administration & Monitoring

Oracle Restart 19c and ACFS

27.10.2020 by Mouhamadou Diaw

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(…)

Database Administration & Monitoring

Duplicate Database on ODA X4

18.09.2020 by Mouhamadou Diaw

The ODA X4 is still in use for some customers. The last time I was asked to validate the backups . Let me explain the context. Actually the backups are done via RMAN on local in a NFS share. After(…)

Database Administration & Monitoring

Oracle 20c Data Guard : Standardization of Client-Side Broker Files

11.09.2020 by Mouhamadou Diaw

In an Oracle 20c Data Guard environment with a broker configured we can have following files called client-side broker files -The observer configuration file : observer.ora -The observer log file -The observer runtime datafile: fsfo.dat -The(…)

Database Administration & Monitoring

Reimaging an ODA to 19.8 Part II

28.08.2020 by Mouhamadou Diaw

In my previous blog, I described the steps to deploy an ODA 19.8 by reimaging. The ODA was reimaged with the latest available version 19.8 but some components were not up-to-dated. [[email protected] ~]# odacli describe-component(…)

Database Administration & Monitoring

Reimaging an ODA to 19.8 Part I

28.08.2020 by Mouhamadou Diaw

Recently I was deploying some ODA X8-2M. To install the 19.8 software, I decide to reimage the server with the 19.8 image. In this blog I describe the main steps I did. First, we will need to download following patches(…)