Infrastructure at your Service

All Posts By

Mouhamadou Diaw

Mouhamadou Diaw

Oracle Grid Infrastructure on Windows With 2 Nodes

By | Database Administration & Monitoring, Oracle | No Comments

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

Duplicate Database on ODA X4

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

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 these backups are backep up by Netback on tape. The goal was just to validate that the backups done by Netback can be used to restore if needed. So the backup teams restored the backups…

Read More
Mouhamadou Diaw

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

By | Database Administration & Monitoring, Database management, Oracle | One Comment

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 fast-start failover callout scripts (new feature in Oracle 20c) Before Oracle 20c, there was no default location for these files. Starting with Oracle 20c, now we can define a default location for all these files by setting an environment…

Read More
Mouhamadou Diaw

Reimaging an ODA to 19.8 Part II

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

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 System Version ————— 19.8.0.0.0 Component Installed Version Available Version —————————————- ——————– ——————– OAK 19.8.0.0.0 up-to-date GI 19.8.0.0.200714 up-to-date DCSAGENT 19.8.0.0.0 up-to-date ILOM 4.0.4.38.a.r132148 4.0.4.51.r134837 BIOS 52020500 52021300 OS 7.8 up-to-date FIRMWARECONTROLLER VDV1RL02 VDV1RL04 FIRMWAREDISK 1120 1102 HMP The patch was…

Read More
Mouhamadou Diaw

Reimaging an ODA to 19.8 Part I

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

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 from Oracle support website -Patch 30403643: Oracle Database Appliance 19.8.0.0.0 OS ISO IMAGE for all platforms -Patch 30403673: Oracle Database Appliance GI Clone for ODACLI/DCS stack (and -Patch 30403662: Oracle Database Appliance RDBMS Clone for…

Read More
Mouhamadou Diaw

Oracle Data Guard RedoRoutes : What is Priority 8 ?

By | Database Administration & Monitoring, Oracle | One Comment

When dealing with cascading or far sync in a Data Guard environment, it is important to understand how to configure the RedoRoutes property. By default, a primary database sends redo to each transport destination that is configured in the destination. We can create more complex transport topology, depending of our environment, using the RedoRoutes property. Basically the RedoRoutes property has this format (redo_routing_rule_1) [(redo_routing_rule_n)] Where each routing rule contains a redo source field and a…

Read More
Mouhamadou Diaw

Oracle 20c : Create a Far Sync Instance Is Now Easy

By | Database Administration & Monitoring, Oracle | No Comments

A far sync instance is like a standby instance as it can receive redo from the primary database and can ship that redo to other members of the Data Guard configuration. But unlike a physical standby instance, a far sync instance does not contain any datafiles and then can not be open for access. A far sync instance just manages a controlfile. A far sync instance cannot be converted to a primary instance or any…

Read More
Mouhamadou Diaw

Patching Oracle Database Appliance From 18.8 to 19.6

By | Database Administration & Monitoring, Operation systems, Oracle | 7 Comments

The ODA software 19.6 is released and people are starting to patch. A direct patch to version 19.6 is possible from version 18.8. Before patching your deployment to Oracle Database Appliance release 19.6, you must upgrade the operating system to Oracle Linux 7. In this blog I am describing the steps I follow when patching an ODA from 18.8 to 19.6. I am using an ODA X7-2 (one node) The first step is of course…

Read More