When we synchronize tables through Oracle GoldenGate, it can either stop the extract of the source from writing trail files to the target in the tables, or stop the replicat of the target from applying the trail files. So for any… read more
How can we get email whenever synchronization between databases is lost in Oracle Data Guard
In this article we will see how we make a mechanism that will inform us by email when some of the standby databases that synchronize with the primary have fallen behind in the sequence number of the logs or because... read more
How to improve a previously run query on an Oracle database (SQL Tuning Advisor with AWR Snapshots)
In a previous article we analyzed how to improve a query in Oracle using the SQL Tuning Advisor. But in order to run the SQL Tuning Advisor, the query must still be in the Shared Pool, i.e. in memory... read more
What do I do when Oracle Grid Cluster Services (CRS) won't start as system file permissions have been lost
In this article we will see what to do when one of the Oracle Cluster servers/nodes shows an error and the Cluster Services (CRS) do not start. The symptom When we go to start Cluster Services (CRS): It shows us the… read more
Useful commands to manage Oracle Grid Infrastructure / RAC (crsctl / srvctl)
In this article we will see some useful commands to manage databases installed on Oracle Grid Infrastructure. We manage Oracle Cluster Resources (CRS) through the CRSCTL tool and Oracle Database , Listener and… read more
How to install Enterprise Manager Cloud Control for Oracle database monitoring and administration
In this article we will see how to install Oracle Enterprise Manager Cloud Control on Oracle Linux / Red Hat Linux step by step. This tool provides the ability to manage Oracle databases through… read more
How to install an Oracle Real Application Cluster (RAC) on Linux using Direct NFS
In this article we will see step by step how to install an Oracle Database belonging to a Real Application Cluster (RAC) on a Linux operating system (Oracle Linux 7.7) with shared NFS disks without using Oracle ASM (Automatic Storage... read more
How to enable Oracle Direct NFS for increased performance between Oracle Database and NFS Shares
In this article we will see how to enable Direct NFS for Oracle Database connectivity with NFS Servers. When we enable it the communication between Oracle Database and NFS Servers is done directly, without involving the kernel of… read more
How do we set up a Windows Server as an NFS Server to have shared NFS disks on Unix
In this article how we can have shared disks between Microsoft Windows Server and Unix through NFS protocol. We will see step by step how to create a Microsoft Windows NFS Server and how to mount the disks in... read more
